With Coefficient's Looker integration, you can easily and securely connect your Looker account and import your data to Google Sheets/Excel. Selecting a Look report or dashboard for your import is quick and simple. You can also use a Looker Explore URL to import data for more in-depth and detailed data analysis.
Creating a Client ID and Secret (For Looker Admins)
Import from Dashboards & Looks
Schedule your Import, Snapshots, and Add Automations
Creating a Client ID and Secret (For Looker Admins)
A Client ID and Secret are required to connect Coefficient to your Looker instance. These credentials can only be created by a Looker Admin. Please share these steps with your Looker Admin to generate your own Client ID and Secret.
1. From the Looker home page, click "Admin" and scroll down to "Users."
2. Click on the user's profile account (anywhere in the highlighted section below).
3. Locate the "API Keys" field and click "Edit Keys.
4. Click the "New API Key" button to generate a new Client ID and Secret for the user selected (Step #2).
5. After the new Client ID and Secret have been generated, share these new credentials with the requestor so they may proceed with their Coefficient connection with Looker.
ℹ️ NOTE: The API credentials (Client ID and Secret) are tied to a particular Looker user and inherit the roles and permissions for that Looker user. If you want to set custom roles and permissions for a user with Coefficient/Looker, you will need to create a new user in your Looker instance as a “service account”.
Connecting to Looker
When you begin a Looker import for the first time, you will need to go through a few steps to connect Looker as a data source for Coefficient. The Looker Admin will need to generate credentials for you.
Refer to this article for additional information: Looker Admin Instructions to Create Credentials
ℹ️ NOTE: Coefficient will need the following information: Client ID, Client Secret, and Connection URL to set up your Looker connection.
If your Database is behind a firewall/private network, you will need to whitelist our (3) IP addresses:
- 34.217.184.131
- 44.234.233.60
-
52.32.132.51
|
1. Open the Coefficient Sidebar and click the Menu. |
2. Select “Connected Sources”. |
3. Select “Add Connection” at the bottom and then “Connect” to Looker. |
|
4. Enter your Base URL, Client ID, and Client Secret, then hit "Connect". For help, click the How to find your Client ID & Secret link.
|
5. Coefficient allows sharing certain data source connections with your team (same domain). ℹ️ NOTE: The Client Secret will not be shared or visible to the team when sharing the data connection in Coefficient. |
Import from Looker
ℹ️ NOTE: When setting up a new Looker import, it may take a few moments to load the data depending on your Looker report(s) size.
Import from Models & Explores
|
1. Open the Coefficient Sidebar and click the “Import from…” button. |
2. Select “Looker” from the list. |
3. Select "Models & Explores". |
|
4. Select the Model you wish to import from. |
5. Choose an "Explore" from the available options. |
6. The Import Preview window will appear, presenting two options for importing your data: "Pivot" (default) and "Table".
Pivot: This option is set as the default. Here, you can configure fields, columns, and values according to your desired groupings. Add any necessary filters or row limits. Once finished, click on Import.
Table: This allows you to present the data as rows/columns. Customize this import by selecting fields and adding sorts/filters. Once finished, click on Import.
7. Congratulations on successfully importing from Models & Explores! Here's how the import will appear using the Pivot (default) option. 🎉
Import from Dashboards & Looks
|
1. Open the Coefficient Sidebar and click the “Import from…” button. |
2. Select “Looker” from the list. |
3. Click "Dashboards & Looks" from the options. |
4. The "Import from Looker" window opens, allowing you to select the Looker report you need. If you are importing from a Looker Dashboard, select a tile/dashboard item and then hit "Import".
5. Congratulations on your successful import from a Look/Dashboard! 🎉
Import using Explore URL
|
1. Open the Coefficient Sidebar and click the “Import from…” button. |
2. Select “Looker” from the list. |
|
3. Click "Explore URL" from the options. |
4. Copy the Explore URL from your Looker UI, paste it into the provided box, then click Next. |
ℹ️ NOTE: Coefficient supports the following forms of looker_explore_url right now:
https://{acct}.looker.com/explore/activity/login?qid={qid_slug}&{other_query_params} and https://{acct}.looker.com/x/{qid_slug}.
5. Congratulations on your successful import from a Looker Explore URL! 🎉 (The tab's name will default to "Looker Explore"; you are welcome to change the name of the tab/import as needed.)
Schedule your Import, Snapshots, and Add Automations
Once you have pulled your data into your spreadsheet using Coefficient, you can set up the following:
|
|
FAQs for Looker Integration
Does Coefficient integrate with Looker Studio?
Coefficient integrates with Looker (not Looker Studio/formerly Google Data Studio). You can use the steps here to connect Looker Studio to Google Sheets.
Do you accept Explore URLs that have a qid parameter?
YES! Coefficient does accept Explore URLs that have a qid parameter. Navigate to a URL in Looker and choose any dimensions or fields; the URL will automatically be assigned a qid parameter. Copy/paste the URL into Coefficient. It will import the data you would see in the Looker UI.
Are there data import limitations (permissions) with Coefficient's Looker integration?
Looker allows Admins to set limit permissions in the Looker UI. (The standard limit is 5000 rows of data.) If you want to download the entire set of underlying data, your Looker admin would need to set the permission for you. Coefficient allows up to 100,000 rows of data to be imported from a Looker report.
How do I get the most current data from Looker from a Look (Looker Report)?
When refreshing a Looker report in Coefficient, the data is pulled from the last refresh in Looker; it does not update data beyond Looker. To force run a report in Looker, click on the link in the Coefficient sidebar/Log into the Looker UI, go to the Looker Report, and refresh it there.
I have custom formatting (e.g., "$#,##0.00") configured on some data fields within Looker. How does Coefficient format this data when imported into Google Sheets/Excel?
By default, Coefficient will import your data as it appears in Looker, applying all your custom formatting. In some (uncommon) cases, you might want to import unformatted data from Looker instead. For instance, you might have a custom date or currency formatting configured in Looker, which is not recognized correctly by Google Sheets/Excel, or you might want more decimal precision for a numeric value that is getting truncated by your Looker’s custom formatting. You can disable custom value formatting on a Coefficient Looker import by enabling the “Disable model-specified value formatting” under Advanced Settings.
My company uses Looker with an on-premise Looker server. Can I use Coefficient to import from our Looker instance?
Coefficient supports on-premise Looker instances, provided that it is hosted at a URL that our servers can access. This may require you to whitelist all (3) of our IP Addresses. Additionally, you may want to confirm that your Looker instance has an API version of 3.1+. Contact your Looker Admin for assistance and to confirm your API version.
Coefficient IP Addresses:
- 34.217.184.131
- 44.234.233.60
- 52.32.132.51
I am getting a "Limit Exceeded" error on my Looker import(s). What does this mean? How can I fix this?
This error message appears due to one of your Looker reports exceeding the limitation of 30K rows when filling down a formula/date value. This error will persist until the source report is updated. To resolve this, remove/update this field from the source report and then run your Looker/Coefficient import(s) again. (For more information, click here.)