Looker

Section header image mobile

With Coefficient's Looker integration, you can easily and securely connect your Looker account and import your data to Google Sheets. 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) 

Connecting to Looker

Import from Looker

Import from a Look/Report or Dashboard

Import using a URL

Schedule your Import, Snapshots, and Add Automations

FAQs for Looker Integration

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."

Screenshot 2024-03-07 at 10.44.28 PM.png Screenshot 2024-03-07 at 10.45.01 PM.png

2. Click on the user's profile account (anywhere in the highlighted section below).Screenshot 2024-03-08 at 1.25.12 AM copy.png

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. Screenshot 2024-03-08 at 1.33.49 AM.png

ℹ️  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.

Menu_Icon.png

2. Select “Connected Sources”.

ConnectedSourcesUpdated.png

3. Select “Add Connection at the bottom and then “Connect” to Looker.

ConnecttoLooker.png

4. Enter your Base URL, Client ID, and Client Secret, then hit "Connect". Click How to find your Client ID & Secret link for help.

EnterCredentialsLooker.png

 

5. Coefficient allows the sharing of certain data source connections with your team (same domain). 

LookerEnableSharing.png

ℹ️ 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 a Look/Report or Dashboard

1. Open the Coefficient Sidebar and click the “Import from…” button.

ImportFrom.png

2. Select “Looker” from the list.

ImportfromLooker.png

3. 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".ImportfromLookerWindow.png

4. Congratulations on your successful import from a Look/Dashboard (Dashboard Element)! 🎉ImportfromLook:DashboardResults.png

Import using a URL

1. Open the Coefficient Sidebar and click on the “Import from…” button.

ImportFrom.png

2. Select “Looker” from the list.

ImportfromLooker.png

3. On the "Explore URL" tab, paste the full URL and then hit "Import".ExploreURL.png

 ℹ️  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}

4. Congratulations on your successful import from Looker Explore! 🎉 (The tab's name will default to "Looker explore" - you are welcome to change the name of the tab/import as needed. ImportfromExploreURLSuccess.png

Schedule your Import, Snapshots, and Add Automations

Once you have pulled your data into Sheets using Coefficient, you can set up the following:

1. Schedule your ImportScheduled_Refreshes.png

2. Turn on SnapshotsSnapshot.png

3. Set Up Automations

AutomationswithGPT.png

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 does allow 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 ensure 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, you need to 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 it gets imported into Google Sheets?

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, 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. 

Screenshot 2023-10-18 at 6.17.21 PM.png

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?

Screenshot 2024-02-06 at 11.26.44 PM.png

This error message is appearing 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, you will need to remove/update this field from the source report and then run your Looker/Coefficient import(s) again. (For more information click here.)

 

 

Was this article helpful? 0 out of 0 found this helpful