Looker API integration
Import your KPIs or metrics into DoubleLoop to see actions and outcomes in one place. It's the best way to align a team around an initiative.
How to setup the Looker API Key
Important note: to setup the Looker integration, you may need to be a Looker admin.
If you haven't already, create your DoubleLoop account.
In Looker, go to the "Users" screen in the admin section.
Choose or create a User that you'd like to give API access. We recommend creating a user specifically for DoubleLoop. Once you've chosen, click on that User.
On the User page, click the
Edit Keys
button next to the API Keys label which will open the users API Key manager.Add a new API Key and make note of the Client ID and Client Secret as we will need those to configure the Integration in DoubleLoop.
This is also a great time to grab the Looker API Host URL we'll need as well if you don't know if already. It can be find in the Looker Admin area under
Platform -> API
.
Setting up the DoubleLoop Integration
Go to the DoubleLoop Integrations Page and click
+ Add Integration
.In the popover choose Looker API and hit
Next
.Fill in the details in the popover, we suggest giving your integration an easy to remember name to help keep track of the integration.
In the API endpoint field, use the Looker API Host URL mentioned above making sure to add
/api/4.0
on the end to match the placeholder text.Finally, use the
Test credentials
button to test that it's all setup correctly and hitSave
to finish setting up the integration.
How to configure a metric with the Looker API Integration
Create a Metric in DoubleLoop and click on the
Source
tab.Click on the Source dropdown and choose the Integration we created above.
Select your Look, which will then fetch the fields from that Look and show a list of available fields for the Date and Value for DoubleLoop to parse. Optionally, pick an Import time if the default does not work for you.
Finally, save the changes. An automatic historical import will be started and new daily metric data should begin to flow into DoubleLoop.
If you need to update your Looker configuration in DoubleLoop, click on the
Source
tab, then theEdit
button, and finally make any necessary edits.
Last updated
Was this helpful?