Integrating CallTrackingMetrics with Google Data Studio

Google Data Studio Connectors

This integration permits Data Studio to access data from your CTM account. Connecting with Google Data Studio allows you to build and share custom reports. CTM offer two different types of connectors to determine 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

  • Navigate to Activity Reports (Reports → Activity Reports).
  • 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.
  • To export the saved filter select the Export dropdown in the right-hand corner for Data Studio.

Image_1_-_Help-Data-Studio-Start-Activity-Report-Connector-e1554836451261.png

  • A pop-up window will appear showing a list of saved filters that can be applied to the connector in Data Studio.  Select your filter and choose Connect.Image_2_-_Help-Data-Studio-Activity-Reports-Connector-Filter.png
  • 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.
  • 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.

Image_3_-_Help-Data-Studio-Authentication-Token.png

  • A Data Studio tab will open for the dimension and filter.
  • Next name the Connector.  
    • At the top of the page, you will see “Untitled Data Source.”  Rename the connector.
  • In the Account Credentials section enter your account ID.

Image_4_-_Help-Data-Studio-Activity-Reports-Connector-Setup-768x525.png

  • 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

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)

In the Community Connectors section select the Call Log Connector.

  Image_5_-_Help-Data-Studio-Community-Connectors.png

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.

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.

Image_6_-_Help-Data-Studio-Authentication-Token.png

  • 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 on the Parent/Agency Settings page.

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

In the Account Credentials section enter your account ID.  Your CallTrackingMetrics account ID can be found in your Settings menu.

Image_7_-_Help-Data-Studio-Call-Log-Connector-Setup-768x466.png

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

For templates go to → Templates and select the one you would like to include.

Select → Connect.

The next page will show details of the connector you’ve created.  Go to → Create Report to start a new report with this connector.

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

Comments

0 comments

Article is closed for comments.