Report of users who opened a specific email

[alexgrutza]

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.

[ddelboccio]

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.

[alexgrutza · Accepted solution]

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

[alexgrutza]

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

[Kim_Nilsson]

That command worked like a charm, thanks.