Help with Email counts by date command

18 views
Skip to first unread message

Stephen Belk

unread,
Jul 1, 2024, 5:20:42 PM (2 days ago) Jul 1
to GAM for Google Workspace
I've been running the following command for that past couple of weeks.  This week it will only show 2 days on the Google sheet up to a week ago.  Before this week, it would show up to a day ago, sometimes two depending on lag.  Is there an extended lag issue that anyone knows about?  Command below(account name and file id removed):

gam report users select users [account name] fields gmail:num_emails_received,gmail:num_emails_sent range -8d -0d aggregatebydate todrive tdfileid [file id] tdtimeformat %Y-%m-%d tdretaintitle true

Any insight would be appreciated!!!

This electronic mail (including any attachments) may contain information that is proprietary, confidential, and/or otherwise protected from disclosure to anyone other than its intended recipient(s). Any dissemination or use of this electronic email or its contents (including any attachments) by persons other than the intended recipient(s) is strictly prohibited. If you have received this message in error, please notify us immediately by reply email (or cont...@diamondc.com) so that we may correct our internal records. Please then delete the original message (including any attachments) in its entirety. Thank you.

Ross Scroggs

unread,
Jul 1, 2024, 5:45:51 PM (2 days ago) Jul 1
to google-ap...@googlegroups.com
Send me a Meet/Zoom invitation and I'll look into this with you.

Ross
----
Ross Scroggs



--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/25fe4bf9-e649-4faa-a516-23e8689842den%40googlegroups.com.

Stephen Belk

unread,
Jul 1, 2024, 5:54:30 PM (2 days ago) Jul 1
to google-ap...@googlegroups.com
Hey Ross,

I appreciate the response.  After a little more digging, I found this data in a user report in Google Admin.  It takes a little more time to aggregate, but it's there.  BUT, when attempting to pull the report from the same missing dates as the GAM report, I got an error in Google admin that it can't pull the data.  This tells me that it's a Google issue.  Looks like I'll have to contact them, or wait out the error.

Thank you and have a great day,

Stephen

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/24032B71-49BF-4CD8-8873-7675D3A088B8%40gmail.com.


--

Stephen Belk

Help Desk & Support Manager

step...@diamondc.com

Diamond C Trailers

Telephone 903.572.2834

Do Work. Love Strong.

Ross Scroggs

unread,
Jul 1, 2024, 5:56:05 PM (2 days ago) Jul 1
to google-ap...@googlegroups.com
There may be a GAM issue as well, send me a Meet/Zoom indication if you can.

Ross
----
Ross Scroggs


Ross Scroggs

unread,
Jul 1, 2024, 6:21:20 PM (2 days ago) Jul 1
to google-ap...@googlegroups.com
Stephen,

I'm seeing the Googe issue, bit in GAM the is an issue as  well; do thi: range -8d -2d

Ross
----
Ross Scroggs



Ross Scroggs

unread,
Jul 2, 2024, 4:29:58 PM (17 hours ago) Jul 2
to google-ap...@googlegroups.com
Stephen,

I'm getting cleaner data from Google today, i.e., no days with no reported data.

Ross
----
Ross Scroggs


Stephen Belk

unread,
Jul 2, 2024, 4:34:43 PM (17 hours ago) Jul 2
to google-ap...@googlegroups.com
Hey man, 

Thanks for getting back with me.  I did notice that I was able to get up to the 2 day lag but was still missing the 25-26th.  I'll run it again and see if that cleaned up as well.


To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/59D14481-C798-4154-B465-33EA59273FA7%40gmail.com.
Reply all
Reply to author
Forward
0 new messages