Using BigQuery logs to track Delegated Mailboxes
Track agent performance in delegated mailboxes without the “send on behalf of” permission
Tracking individual agent performance inside a Delegated Mailbox can be vital for understanding team performance and ensuring accountability.
Email Meter provides a simple solution for capturing detailed metrics about each agent’s actions in Delegated Mailboxes if the send on behalf of
permission is enabled.
If you’d like to get agent performance metrics without turning on the Send on Behalf setting, the only alternative is enabling BigQuery logs for your Google Workspace domain, and giving access to Email Meter to those logs to capture that information.
Requirements
- A supported Google Workspace edition:
- Enterprise Standard or Plus
- Education Standard or Plus
- Frontline Standard
- Enterprise Essentials Plus
- A Google Cloud Platform project with billing enabled
- BigQuery logs export configured for your domain
- Granting Email Meter access to those logs
Steps
Set up BigQuery
First, you’ll need to set up a BigQuery project to store your Google Workspace logs:
- Create or open a project in Google Cloud Console
- Add a Google Workspace admin account as Project Editor
- Grant the
gapps-reports@system.gserviceaccount.com
service account Editor access
For detailed instructions, follow Google’s documentation on setting up a BigQuery project for reporting logs.
Enable logs export
Then, you need to configure the export of Google Workspace logs to BigQuery:
- Sign in to the Google Admin console
- Go to Menu > Reporting > Data Integrations
- Enable Google Workspace data export to BigQuery
- Specify a dataset name where the logs will be stored
For detailed instructions, follow Google’s documentation on setting up service log exports.
Share access with Email Meter
After completing the previous steps, contact your Customer Success Manager. They will provide you with:
- SQL code to create a BigQuery Table Function in your dataset
- Instructions to share this view with Email Meter securely
We’ll notify you when the data is ready in your dashboard.