Documentation
Looker Studio and Google Sheets
Put a client's measured numbers in a Looker Studio report, through a Google Sheet, with a read only link.
Each client can have its own feed link: a CSV of the numbers on that client's report, which a Google Sheet pulls and Looker Studio reads. Google now calls Looker Studio Data Studio; the steps are the same.
Set it up
- 1With the client selected, open Connections and create a feed link under Looker Studio. It takes an admin seat. Copy the link when it appears: it is shown once.
- 2In a Google Sheet, click cell A1 and type =IMPORTDATA("your link"), with the link inside the quotes. The sheet fills with one row per number.
- 3In Looker Studio, click Create, then Data source, and choose the Google Sheets connector. Pick the sheet and the worksheet, keep Use first row as headers on, and click Connect.
- 4Build the report on that data source. Every client you report on gets its own link and its own sheet, or its own tab in one sheet.
Google Sheets refreshes an IMPORTDATA formula about once an hour, and Looker Studio checks the sheet for changes each time the report runs a query.
What the feed holds
| Column | What it is |
|---|---|
| client | The client's name. |
| section | visibility for a rate, fixes for a count of fixes. |
| platform, platform_id | All apps people use for the headline, otherwise one AI platform. |
| surface | apps people use, or developer API. A developer API is never pooled into the headline. |
| metric, metric_label | cited is Answers that link your site, named is Answers that name you. |
| count, of | The answers that did it, out of the answers measured. |
| rate | count divided by of, as a fraction of one (0.25 is 25 percent). Blank under 8 answers, where the counts are the honest form. |
| range_low, range_high | The likely range, as fractions of one. |
| window_from, window_to | The first and last day those answers were measured. |
They are the numbers the client's report prints, read from the same place, so a deck and a report never disagree. It is a share of answers, never a rank.
Keeping it safe
- A feed link reads one client's numbers and nothing else, and it cannot change anything.
- Anyone holding the link can read those numbers, so share the sheet the way you would share the report.
- Revoke a link from Connections at any time. A sheet pulling it then shows an import error.
- Each link has its own hourly read limit, far above what an hourly refresh needs.
Feed links are part of API access, which starts on the Monitor plan. A link keeps working after a plan change; creating a new one needs the plan.