SQL query sample for retrieving call tracking data from Google BigQuery

NEW documentation: This article covers setup for OWOX BI. For the latest guides on setting up FREE connectors and Data Marts, visit the new OWOX Data Marts documentation.

To set up the call tracking data collection, you need to enable integration with OWOX BI in your call tracking service. Once it is done, the call tracking events will be automatically sent to the OWOX BI access point and recorded into the streaming table in Google BigQuery. In 24 hours, the data will also be available in the owoxbi_sessions table.

To check it, run the SQL query below.

SELECT userPhone,
  eventInfo.eventCategory,
  eventInfo.eventAction,
  eventInfo.eventLabel,
  eventInfo.eventValue
  FROM `ProjectName.DatasetName.streaming_YYYYMMDD`
  WHERE userPhone is not NULL
  Group by
  userPhone,
  eventInfo.eventCategory,
  eventInfo.eventAction,
  eventInfo.eventLabel,
  eventInfo.eventValue

In the query sample above, define the following parameters with your values:

• the name of your Google BigQuery project instead of ProjectName;
• the name of your Google BigQuery dataset instead of DatasetName;
• the full date instead of YYYYMMDD.

As a result, you should get a table listed below: