SQL query sample for retrieving call tracking data from Google BigQuery

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.

NoteThe call tracking data pipeline will not appear in the List of pipelines in your OWOX BI.

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: