Looker Studio (beta)
Last updated
Was this helpful?
Last updated
Was this helpful?
To connect Google Data Studio to Select Star, you will need...
Access to Google Workspace admin console
Access to Google Cloud project for BigQuery exports
For the best outcome, we strongly recommend you follow the steps below using an new incognito window to sign into Looker Studio.
Google Data Studio does not currently provide APIs that are necessary for the functioning of Select Star. For this reason, Select Star is forced to intercept the user account.
To provide access to Google Data Studio, we recommend to for Select Star that serves as a service account. However, it is not necessary and not required, especially during the trial and evaluation stage.
1. Open "Incognito Mode" in your web browser. Perform this step even if you are currently logged in to the desired user account to obtain its cookies correctly.
2. Sign to a Google user account with access to Google Data Studio.
3. Open in Google Chrome.
4. Open Developer console in Google. To open the developer console in Google Chrome, open the Chrome Menu in the upper-right-hand corner of the browser window and select More Tools > Developer Tools. You can also use Option + ⌘ + J (on macOS), or Shift + CTRL + J (on Windows/Linux).
5. Select tab "Network" in the Developer console. Refresh the browser tab to fill the "Network" tab with data. Search for request to "datastudio.google.com".
6. Find a successful request that is sent to lookerstudio.google.com, then open context menu and select Copy as cURL
7. Keep this value safe as you will need it to create integrations in final steps.
The curl request should look like the one below
To set up a BigQuery Export configuration, you first need to set up a BigQuery project in the Google Cloud console. To analyze activity, including calculating the popularity of individual reports, it is necessary to provide Select Star access to audit logs and usage reports for Google Data Studio by exporting them to Google BigQuery.
Note that the export only contains logs from its setup until it is disabled. Exporting them to BigQuery may take Google up to 48 hours, and then Select Star should ingest them within 24 hours.
Next create a service account with the permissions to read the project with exports:
BigQuery Data Viewer
BigQuery Job User
This service account will be later used for reading the activity logs.
1. Go to the Select Star Settings. Click Data in the sidebar, then + Add to create a new Data Source.
2. Fill form in the required information:
3. Proceed to next step and select Skip Activity Source if you don't want to use popularity feature in Select Star.
Pages in Looker Studio can contain one or multiple charts. Looker Studio offers a canvas on which to place those charts, but there is no way to assign a text field to a given chart.
Select Star will figure out automatically the chart titles by looking at text fields that are positioned immediately before a given chart.
To ensure your Looker Studio connection to Select Star properly ingests the names for all the Charts in your Pages, please make sure that you add a text box with the title of the chart above it.
Find an example in the images below of the layout that Select Star expects.
To set up a BigQuery Export configuration, follow Google Workspace documentation about "".
CURL command with cookies: CURL with cookies that you extracted in of the instructions.
4. Proceed to next step and select Add Activity Source dropdown and fill Activity Log Source together with supplying BQ service account json with credentials that you created in .
Looker Studio has limitations that prevent automatic data refreshing. But we have ways to work around that, if you need automatic refresh, please get in touch with . If you want to learn more about this integration we can show quickly you around, just shoot us an .
