Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Count how many calendar events happen per day with Big Query

I am trying to get a count for how many meetings (specifically calendar events) are happening per day within our domain. We currently have Big Query exports enabled and, when fully remote, this can be counted through the Usage table -> Customer Usage Metrics -> Meet -> num_meetings_X_calls. However, when hybrid work picks up (split in office/remote) and not all meetings are taking place over Meet, we still want to keep track of how many meetings are happening even if all participants are physically together (ie a Meet link might have been generated on the calendar event but since the link wasn't clicked, no conference_id is made to track it). The Usage table for Calendar only provides num_Xday_active_users which is too general. The Activity table for Calendar  has an event event created where you can count the event_id. However, this isn't exactly tracking how many happened on a certain. Any help would be appreciated.

1 2 2,024
2 REPLIES 2