API Community Support CTM Home
New Left Nav
Mobile
Activities
Activity Logs
Contacts
Flows
Automation
Chats
Forms
Routing
Release Videos
Release Notes
COVID-19
Integrations
Drift
ABTasty
Acquisio
AMP
Bing
Bizible
Cake
Facebook
Gong i.o
Google Ads
Google Analytics
Google Data Studio
Google Marketing Platform
Hubspot
Instapage
Kenshoo
Kissmetrics
Mailchimp
Marin Software
Marketo
Microsoft Dynamics
Optimizely
Oracle Maxymiser
Salesforce
SendGrid
Slack
SnapChat
Stripe
SugarCRM
Symplify
Unbounce
VWO
Webhooks
Wix.com
WordPress
Zapier
ZenDesk
ZOHO
General
Help Center
Numbers
Management
Dynamic Numbers
Reports
Analytics
Contact Center
Reports Delete
Usage
Report Settings
Settings
Account Management
Current Account
Contact Management
Parent/Agency
Configuration
Users
Softphone
Texts
Text Settings
Recorded Training
CTM Academy
On-Demand Videos
Upcoming Topical Webinars
Menu +

Integrating CallTrackingMetrics with Google Data Studio

Google Data Studio Connectors

This integration permits Data Studio to access data from your CTM account. By connecting with Google Data Studio allows you to build and share custom reports. CTM offer two different types of connectors to determines what you can do with that information in Data Studio.

  • Activity Report Connector – is a setup connector that allows you to build Data Studio reports using dimensions with your existing Activity Reports in CTM.  This connector allow will allow the transfer of information from the Activity Reports page into Data Studio.
  • Call Log Connector – provides advanced reports using the data from your call log.  The call log fields reflect the API names which can be updated in the reports. All  the call log data is unaggregated and it’s recommended to build your report templates using a small date range to ensure call data loads quickly.

For help with using Data Studio’s interface to build reports, please refer to Google’s support resources.

Activity Reports Connector

The Activity Reports Connector is a tool to import your reports into Data Studio.  For example, the default view shows calls for the last 30 days broken down by tracking source.  The Activity report data will be duplicated in the Data Studio.  The Activity Reports Connector is one dimension by:  Agent, day of the week, tags, and you are able to apply filters to narrow down which calls are included in the report.  Each connector you create is a different Activity Report view. Data imported using the Activity Reports Connector will be pre-aggregated by CTM before it is sent to Google.

Connector Setup

  1. Navigate to Activity Reports (Reports → Activity Reports).
  2. Choose the dimension to apply saved filters.
    • Important note: only saved filters can be used with the Data Studio connector.  To save a filter select the filter options and Save.  You’ll be prompted to name the filter and Save Filter to confirm.
  3. To export the saved filter select the Export dropdown in the right hand corner for Data Studio.  

  4. A pop-up window will appear show a list of saved filters which can be applied to the connector in Data Studio.  Select you filter and choose Connect.

  5. Next you will be directed to Google Data Studio.  If this is the first time you have used a CTM Data Studio Connector the system will prompt you to grant permission for Google to access data from your CTM account.
  6. Enter the Basic Authentication Token for the account.  On the Data Studio settings page, select the API Integration to display the authentication token.  Copy and paste the Token into the field in Data Studio.

  7. A Data Studio tab will open for the dimension and filter.
  8. Next name the Connector.  
    • At the top of the page, you will see “Untitled Data Source.”  Rename the connector.
  9. In the Account Credentials section enter your account ID.
  10. For templates go to → Templates and select the one you would like to include.

Call Log Connector

The Call Log Connector allows you to build advanced reports using data from the call log.  Nearly all fields in the logs are available to be used as a Dimension.  The fields imported into Data Studio are named using the API labels.  Labels can be changed in the reports that are built. It is recommended to build your report template using a small date range to ensure call data loads quickly.  Note:  call log data is unaggregated when sent to Google which means aggregation will be done by Data Studio.

Connector Setup

  1. Navigate to Settings → Integrations → Data Studio.
    • If you wish to include a saved Activity filter in your connector begin the setup from the Manage Filters page.  Next locate the saved filter you wish to use and select Call Log in the Data Studio column. 
      • To save a filter open the Filters panel in the call log. 
      • Select the filters Save Filter.  
        • You’ll be prompted to name the filter to Save.   (If you are using this option, skip step 2 and proceed to step 3)
  2. In the Community Connectors section select the Call Log Connector.

  3. Once selected you will be directed to Data Studio.  For first time users of Data Studio Connector you will be asked to grant permission for Google to access data from your CTM account.
  4. Enter the Basic Authentication Token for your account.  On the Data Studio settings page, select API Integration to show the authentication token.  Copy and paste the Token into the field in Data Studio and select continue.

    • If you wish to view data from all of your sub accounts in the same connector make sure to use the agency’s authentication token.  This token can be found the Parent/Agency Settings page.
  5. Next, give the connector a name.  At the top of the page under “Untitled Data Source”  Rename the connector (Use the name of the account or the name of the report you are building).
  6. In the Account Credentials section enter your account ID.  Your CallTrackingMetrics account ID can be found in your Settings menu.

    • If you set up the connector using your agency’s authentication token then use your agency ID instead and check the box labeled Agency Token.
  7. For templates go to → Templates and select the one you would like to include.
  8. Select Connect.
  9. The next page will show details of the connector you’ve created.  Go to Create Report to start a new report with this connector.
X