You can extend user behavior data collected by the Google Analytics→Google BigQuery pipeline with the data from the call tracking system Ringostat about the calls, chats, and request forms. It is useful when you need to analyze your customers’ interactions via the tracked phone numbers, and include the call interactions as a touchpoint in your business sales funnel.
OWOX BI integration with Ringostat is set up on the call-tracking service side. Read the details below.
Set up data collection from Ringostat to your Google Analytics→Google BigQuery pipeline
Step 1. In Ringostat, go to App Marketplace and find among the integrations - OWOX BI Pipeline and activate it.
Step 2. Enable the integration: hit the switcher and then click the 'Save' button.
Ringostat data schema
The Ringostat integration collects data with the following parameter values:
- Event category: call status (
PROPER, ANSWERED, NO ANSWER, BUSY, REPEATEDor
- Event action: phone number of a caller.
- Event label: call duration in seconds.
About the integration in Ringostat knowledge base.
Question 1: How can I collect phone numbers?
Phone numbers will be collected to BigQuery tables only since it's restricted to collect any personal ID data in Google Analytics.
Question 2: What period of time is needed to generate session data with actual call data?
The call data is sent via Measurement Protocol to Google Analytics and OWOX BI simultaneously. The call data sent with a delay will always get to the hit data tables if they contain a
&qt (queueTime) parameter. The data will get to the session data tables only the hit was sent within 48 hours after the end of the day the event happened according to the timezone set in the Google Analytics view. The 48 hours period is the time needed to form a consistent session table.
Question 3: Where in the interface can I find the pipeline from Ringostat?
The call tracking data pipeline will not appear in the List of pipelines in your OWOX BI. Once you enable the integration, 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 this SQL query.