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 can send data to Google Looker Studio. 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 (listed above), follow the steps below to customize your report. If you are using multiple connectors, you must complete the following steps for each connector you choose.
Note: Before adding a connecter, make sure you've logged out of CallRail completely.
- Select Authorize to implement the use of this Community Connector for both CallRail and Google Looker Studio.
- 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 setting up your report.
- 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).
- Please note: If you select unique phone numbers rather than a company, you can only select thirty (30) phone numbers in one report. Selecting a company will include all potential numbers by default.
- After you've set your dimensions in Looker Studio to your personal preferences, select Connect at the top of the page.
- You'll be taken to a page where you can add additional configurations for your report. Select Add to Report when you're ready to finish your report setup.
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. - Select Create Report at the top of the page when finished.
- You'll be redirected to a new screen where your report will be built. Select Add to Report to add your data source.
- Customize your report by choosing the graphs, colors, layout, and themes you'd like to apply to your report.
- When finished, select View at the top of the page to see your report.
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 who configured the integration should log in to deactivate it.
- Select the Settings icon on the left navigation bar.
- Choose the company where you'd like to deactivate Google Looker Studio.
- Select Integrations at the top of the page.
- Choose My Applications from the Data Access header on the left.
- Select on Google Looker Studio.
- Select Revoke Access for Google Looker Studio to remove the integration.
Unlinking Google Looker Studio from CallRail
You can remove CallRail's access to Google Looker Studio from your Google account management settings.
- Log into the Google Looker Studio account you want to unlink from CallRail.
- Select your account drop-down in the upper-right corner of the page, then choose Manage Account.
- In the Security tab, locate the Third party-apps with account access section and select Manage third-party access.
- Scroll down to the Google apps section and select Google Looker Studio, then choose Remove Access.
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, select the table itself, which will open the edit pane for the table. On the Data tab, there is a Filter section. You can then select 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:
- Select Settings.
- Select Integrations at the top of the page.
- Choose My Applications from the Integrations header.
- Please note: If you’re logged in as a user who hasn’t authorized the connector, you won’t see My Applications. This means you’ll need to try again with a different user. - Choose Google Looker Studio.
- Select Revoke Access.
- Log out of CallRail completely.
- 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.
- Log in with the user that has access to the desired accounts.