Try out all OWOX BI features with a trial period Start for free

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:

calltracking_sql_results.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.