I've created an automatic daily unsampled report on my Google Analytics 360.
I want to send the report to my BigQuery project and the only option I have for getting the report is via mail with a link.
Is there any way I can send the report automatically to BigQuery?
The report contains a list of one custom dimension values, count of users and count of sessions - in a segment that uses the user bucket dimension.
Thank you.
You can export data automatically from Analytics 360 to BigQuery with the BigQuery Export: https://support.google.com/analytics/answer/3437719?hl=en
But you cannot send a custom report from Google Analytics to BigQuery.
Anyway you can write data to BQ programmatically using BigQuery API: https://cloud.google.com/bigquery/docs/reference/rest In other words, you can use the Google Analytics API (Reporting or Unsampled API) to replicate the query of your report and the BigQuery API to write the result in a table.
You can use Google Apps Script which has an integrated system with APIs and makes your work easier.