Google Looker Studio integration

Google Looker Studio (formerly known as Data Studio) allows you to create custom dashboards and reports for data visualization. Using CallRail’s integration with Google Looker Studio, you can use the contents of your Call Attribution report to infuse your custom dashboard with your call data. 

Getting started

Your integration with Google Looker Studio is available at the company or agency level. By setting up this integration, you agree to our Terms of Service and Privacy Policy.

Four CallRail connectors are available for sending your data and can be used simultaneously. Use the links below to navigate directly to one or more of these within Google Looker Studio's gallery.

- The Call Time Series connector shows call data over a selected time period.

- The Call Summary connector shows summary call data grouped by various metrics.

- The Call Details connector shows full, detailed data for individual calls.

- The Form Summary connector shows summary form data grouped by various metrics.

The Call Summary and Form Summary connectors can provide the following fields as "Group By" categories within Google Looker Studio:

- Source.

- Keyword.

- Campaign.

- Referrer.

- Landing Page.

- Company.

Adding your call data to Google Looker Studio

After selecting one or more connectors as described in the previous section, follow the steps below to customize your report. If you are using multiple connectors, you will need to complete the following steps for each connector you choose. 

Note: Before adding a connecter, make sure you've logged out of CallRail completely.

  1. Select Authorize to implement the use of this Community Connector for both CallRail and Google Looker Studio. 

    Authorize Looker Studio.png
  2. You'll reach a screen where you can configure your custom report. For any data connector you choose, select your Account from the dropdown. Configure the other fields as they are listed for your chosen connector to begin the setup of your report. 

    gds_connector.png
  3. If you'd like to pull data only from a specific company, select that company from the drop-down menu in the second field. If no company is chosen, Looker Studio will pull all calls from your account at the agency level (calls meeting the criteria you select here from every company in your account).

  4. After you've set your dimensions in Looker Studio to your personal preferences, click Connect at the top of the page.

    screenshot_704.png

  5. You'll be taken to a page where you can add additional configurations for your report. Click Add to Report when you're ready to finish your report setup.

    screenshot_748.png

    Tip (optional): If you've selected Average Duration as one of your data points, Google recommends changing the "Type" on this page to "Duration (sec.)" within the Numeric section of the drop-down.

    screenshot_751.png
  6. Click Create Report at the top of the page when finished.

    screenshot_752.png
  7. You'll be redirected to a new screen where your report will be built. Click Add to Report to add your data source.

    screenshot_753.png
  8. Customize your report by choosing the graphs, colors, layout, and themes you'd like to apply to your report. 

    screenshot_757.png
  9. When finished, click View at the top of the page to see your report. 

    screenshot_758.png

Deactivating your Google Looker Studio integration

The Google looker Studio connection is configured at the user-level within your CallRail account. If this connection needs to be removed within CallRail, the user that configured the integration should log in to deactivate it.

  1. Click the Settings icon on the left navigation bar.

  2. Choose the company where you'd like to deactivate Google Looker Studio.

  3. Click Integrations at the top of the page.

  4. Choose My Applications from the Data Access header on the left.

  5. Click on Google Looker Studio.

  6. Click the Revoke Access icon for Google Looker Studio to remove the integration.

Unlinking Google Looker Studio from CallRail

If you'd like to remove CallRail's access to Google Looker Studio, you can do so from your Google account management settings.

  1. Log into the Google Looker Studio account you'd like to unlink from CallRail.

  2. Select your account drop-down in the upper-right corner of the page, then click Manage Account.

    screenshot_771.png

  3. In the Security tab, locate the Third party-apps with account access section and click Manage third-party access.

    third-party_apps.png
  4. Scroll down to the Google apps section and click Google Looker Studio, then Remove Access.

    Remove Looker Studio.png

FAQs

Can I use the Google Looker Studio integration on my white label account?
At this time, Google Looker Studio isn't available for white-labeled accounts. 

I've set up my Google Looker Studio integration but it doesn't show as active
Don't worry! Your integration is active. Due to the authorization Google Looker Studio uses, we can't mark the integration icon as active.

Why I don't see any calls in the "Opportunity Tagged Calls" in the Calls Details template?
Our report template for Call Details includes a table with call data. We added a filter to that table to demonstrate setting up a report filter in Google Looker Studio. However, the filter may cause you not to see any data in the table, especially if none of the calls are tagged with “Opportunity.”

To remove the filter, you can click on the table, which will open the edit pane for the table. On the Data tab, there is a Filter section. You can click on the pencil icon next to the filet to edit the filter, and hovering over the filter gives you the option to delete it.

The accounts dropdown in Looker Studio doesn't show the accounts I'm expecting
The accounts in the dropdown are linked to the user you logged into CallRail with the first time you authorized the connector. If you have multiple CallRail logins and you think you logged in with a user who doesn’t have access to the desired accounts, you’ll need to revoke connector access in CallRail using the user who originally authorized the connection.

If you aren’t sure which CallRail user authorized the connection, you can compare the accounts in the Looker Studio dropdown with accounts the user has access to in CallRail.

Follow the instructions below to change the user associated with the connector:

  1. Click Settings.
  2. Click Integrations at the top of the page.
  3. Choose My Applications from the Integrations header.

    My applications - GDS.png
    - Please note: If you’re logged in as a user that hasn’t authorized the connector, you won’t see My applications. This means you’ll need to try again with a different user.
  4. Choose Google Looker Studio.
  5. Click the Revoke Access button.

    revoke access.png
  6. Log out of CallRail completely.
  7. Navigate to your Looker Studio report. You’ll get an error message since you revoked access and Google will prompt you to authorize CallRail again. 
  8. Log in with the user that has access to the desired accounts.
Was this article helpful?
2 out of 9 found this helpful

Articles in this section

Ask the Community
Find best practices, post, and learn from CallRail users.
CallRail Support Hours
Weekdays 9:00am - 9:00pm EST