Send reports to Google Sheets, BigQuery and Looker Studio
Push a saved report's data to a Google Sheets tab or a BigQuery table on its schedule, and build Looker Studio dashboards on top.
Send to your tools on the Reports page pushes a saved report's data to your own Google Sheets or BigQuery. Each push carries one line per day, campaign and channel with every metric, the same lines as the data CSV.
Connect a tool
An account owner or admin connects tools.
- Google Sheets: press Connect Google Sheets and sign in with Google. Geofy asks only for the files it creates, so it can't open your other spreadsheets.
- BigQuery: in Google Cloud, create a service account, give it BigQuery Data Editor on the dataset, then Keys, Add key, JSON. Press Connect BigQuery and paste the whole file. The key is stored encrypted.
Add an export
- Save the report you want under Saved reports and give it a schedule (every hour, day, week or month).
- Under Send to your tools, press Add an export.
- Pick the saved report and the tool.
- Google Sheets: name the Tab and pick Add the new days or Replace the tab. The first push creates a spreadsheet named after the report; Open sheet opens it.
- BigQuery: name an existing Dataset, and a Table if you want (the first push creates it, partitioned by day).
Exports go out on the saved report's schedule, after its email. Push now sends one straight away.
- Add the new days adds each whole period once: a daily report of yesterday adds yesterday's lines every morning. A period that isn't over yet is skipped, so for today's numbers every hour pick Replace the tab.
- BigQuery always adds lines, never twice for the same day, campaign and channel. Each line also has the currency and when it was pushed.
Looker Studio
Looker Studio reads both:
- From Google Sheets: in Looker Studio, Create, Data source, Google Sheets, then pick the spreadsheet and the tab. It refreshes as the export adds days.
- From BigQuery: Create, Data source, BigQuery, then your project, the dataset and the table. Use the day column as the date range dimension.
- Without either: the public API's /stats/data.csv returns the same lines for any period with an API token (Settings > API access). Looker Studio has no built-in CSV link, so load it through a partner connector that reads a CSV URL, or through a script that writes it to Sheets.
Until the site's exports are switched on, the page shows Preview and each push is recorded with the number of lines, without sending anything.
Related
- Saved and emailed reportsSave a view, open it again in one tap, or have it emailed as a PDF or CSV every hour, day, week or month, with a data CSV of every row.
- ReportsDelivery, spend and results across every campaign, compared with the period before.
- Connect your systems with the APICreate a token in Settings > API access to pull statistics and run campaigns from your own tools.