topic Re: Report of users who opened a specific email in Peer-Peer Topics

Report of users who opened a specific email

alexgrutza — Mon, 20 May 2024 18:29:26 GMT

Is there an easy way to get a nice layout (as easy as email address, and status of opening the email) for us to generate/pull to indicate who opened an email?

We'll be sending an email to employees in regards to cyber security training, and need to report on who opened it.

I understand opening doesn't mean reading the email, and I know that even google doesn't state that sending with a read-receipt indicates opening it, so just wondering the easiest way to get a list of email's and if possible the status/opening status of the email.

Re: Report of users who opened a specific email

ddelboccio — Mon, 20 May 2024 18:39:23 GMT

Do you have a version of Google Workspace that includes the investigation tool?

I was just able to create a simple search of an "All staff" email I sent out using the exact subject line and the "label is inbox" conditions.

To me, it looks like a message is read if the label does not have the "unread" label associated with it.

Run the above query without the "label" condition and you'll see label statuses of "inbox" or "inbox, unread".

From here, it is easy to download the results to a Google sheet.

Re: Report of users who opened a specific email

alexgrutza — Mon, 20 May 2024 18:40:33 GMT

I always forget to state we use EDU Fund. and do not.

I'm wondering if this gam command ran on a specific date (per Administration) would work. Perhaps change unread to read

gam all users print messages query "rfc822msgid:<Message ID>" matchlabel unread todrive

Re: Report of users who opened a specific email

alexgrutza — Mon, 20 May 2024 18:56:26 GMT

I believe this gam command will work for our needs. I can probably also add the "subject:" in there as well

Re: Report of users who opened a specific email

Kim_Nilsson — Tue, 21 May 2024 10:57:29 GMT

That command worked like a charm, thanks.