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.
You’ll need admin permissions in your Google Workspace domain or get in touch with your Google Workspace Admin to follow through with these instructions.
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.comservice account Editor access
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
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
Frequently asked questions
Why do I need to enable billing in Google Cloud?
Why do I need to enable billing in Google Cloud?
BigQuery requires billing to be enabled to store and process logs. However, you will only be billed for the queries you perform. You can always monitor your usage and adjust your queries to optimize costs according to your needs.
How long does it take for the data to appear in my dashboard?
How long does it take for the data to appear in my dashboard?
Once everything is set up, logs are processed daily. This means that agent performance metrics will be available in your dashboard the day after the email activity occurred.
Isn't there another alternative to get these metrics?
Isn't there another alternative to get these metrics?
No, BigQuery logs are the only way to get events performed by specific users inside delegated mailboxes when the “Send on Behalf” feature is disabled.