OWOX BI is a tool for combining data from different systems: Google Analytics, CRM, and others. OWOX collects data, sends it to Google BigQuery, and allows in-depth analysis.
Ringostat service is a link between advertising channels and phone orders. Thanks to integration with the OWOX platform and their product OWOX BI Streaming, data from Ringostat and Google Analytics can be aggregated in Google BigQuery, which is designed specifically for collecting, storing, and analyzing large amounts of information.
With the integration of Ringostat and OWOX BI, you can:
Link call data with order performance metrics
Optimize advertising channel expenditures based on complete data
Obtain data with hit-level accuracy
Build reports of any complexity and structure for KPI monitoring
How to set up and enable
To configure the OWOX integration with Ringostat, you need to:
In the Ringostat personal account, go to the Integrations section → OWOX BI → Activate:
2. Then click the Enable Integration toggle and Save
How to create the Ringostat stream in OWOX
Now you need to create the Ringostat stream in the Owox admin panel:
In the OWOX personal account, make sure that the Google Analytics → Google BigQuery stream is created and active.
If the stream is not created, then you need to set it up according to these instructions.
Note! Without this stream, the integration with Ringostat will not be available! |
Make sure the "Session Data Collection" option is enabled in the stream settings.
2. Next, create a new data pipeline by selecting Ringostat as the source.
3. Click Done.
4. Install the OWOX tracking code on your website.
You can learn about tracking via Google Tag Manager, analytics.js, Measurement Protocol, Tealium IQ, AMP page tracking, and Android/iOS app tracking in the description of integration methods.
Checking the integration
After enabling the integration on the Ringostat side and installing the OWOX tracking code on your site, check in the console whether hits are being sent successfully.
To do this, open the Console using one of the following options:
Press F12; Press Ctrl+Shift+I; Right-click on a page element → Inspect; Press Cmd+Opt+J (for macOS). |
2. In the Console, open the Network tab (1), select display of all requests (2), enter owox in the filter field (3), and reload the page.
If hits are sent successfully, you’ll see a 200 OK response.
If you get an error response:
check the correctness of the OWOX script installation;
make sure you have the required permissions and roles listed in this article;
also check if your Google Analytics stream is blocked.
If the error persists – we recommend contacting OWOX technical support
Data transferred from Ringostat to BigQuery
Transferred Data | Parameter | Description | BigQuery Column |
Client’s Number | &tel | User’s phone number | userPhone
|
Event Category | &ec | Call status: PROPER, ANSWERED, NO ANSWER, BUSY, REPEATED or FAILED | eventInfo.eventCategory
|
Action | &ea | User’s phone number | eventInfo.eventAction |
Event Label | &el | Call duration | eventInfo.eventLabel
|
To check whether data is collected, run this query in Google BigQuery:
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
Where:
ProjectName – your Google BigQuery project name;
DatasetName – your Google BigQuery dataset name;
YYYYMMDD – the date from the name of the required data table with hits.
As a result, you’ll receive the requested data:
IMPORTANT!From the moment the integration is enabled, events from Ringostat will automatically be transferred to the OWOX BI endpoint and recorded in the hit-streaming table in Google BigQuery. After 24 hours, the data will also appear in the owoxbi_sessions table. |