How to set up OWOX BI — A detailed guide

In this article, you’ll find step-by-step instructions on how to set up advanced analytics with OWOX BI to get the most out of your data.

OWOX BI services help you:

• Improve the quality and speed of testing marketing hypotheses
• Increase the revenue and ROAS of your advertising campaigns and audiences
• Improve the profitability of audience segments

In 18 years of working with large e-commerce projects, we’ve seen how important data is and how companies can grow when they use it correctly. We created OWOX BI to help our customers find insights and grow 22% faster than the market average. Our goal is to improve the quality of data-based business decisions.

Today, OWOX BI is a trusted solution used by 27,000 users in 130 countries. We’re one of the top three marketing analytics solutions in the world according to G2 Crowd.

OWOX BI provides quality data to analysts, application reports to marketers, and insights for fast growth to business.

OWOX BI Pipeline

• Delivers your data from marketing sources to Google Analytics and Google BigQuery.
• Collects raw, unsampled data from your website in a structure familiar to most analysts.
• Ensures the relevance and high granularity of data.
• Combines, cleans, stabilizes, and monitors the quality of data.

OWOX BI ML Funnel Based Attribution

• Creates a funnel that takes into account the user’s path to conversion for your business.
• Determines the value of each session and user.
• Calculates the objective contribution of each advertising campaign to ROPO sales.

OWOX BI Smart Data

• Creates a single cross-device profile for each user.
• Combines data into the structure needed to build reports for your business model.
• Builds reports without SQL in several clicks.

Log in to OWOX BI using your Google account and adjust your settings to take advantage of these features.

You’ll benefit from this functionality if:

• You manually collect statistics for paid ads
• You’re tired of building reports that your colleagues constantly break in Excel or Google Sheets
• You don’t want to go to several different services to understand which advertising campaign works better

With OWOX BI Pipeline, you can:

• Free yourself from manual work by automatically receiving information about cost data in Google Analytics
• Compare campaign ROAS to keyword accuracy in the Google Analytics interface
• Understand how much you spend attracting a specific user (works in conjunction with collecting raw data from your website)

1. First of all, make sure your advertising links have the correct UTM tags.
2. After that, create a dataset in Google Analytics into which advertising costs will be downloaded.
3. Then create a pipeline in OWOX BI and start automatically importing data by activating access to the advertising service you’ll be pulling data from. For more information on how to import cost data, see our article on how to get started with OWOX BI.

Cost data will appear in Google Analytics within 36 hours of creating a pipeline.

If OWOX BI doesn’t have a direct integration with the advertising service you need to import data from or if you want to upload SEO costs to Google Analytics, set up a manual ad cost data import pipeline or write to contact@owox.com and we’ll create a custom integration for you.

OWOX BI provides high data granularity. For sources with an API, we collect cost data with up to 5 UTM parameters, and for some sources (Facebook, LinkedIn) we transfer up to 200 parameters to Google BigQuery.

To import raw data from an advertising service to Google BigQuery, you need to:

1. Create a Google BigQuery account (if you don’t already have one)
2. In OWOX BI, create a pipeline from Facebook or LinkedIn to Google BigQuery

Information for the previous day will appear in the table in the specified dataset. Also, all data uploaded to BigQuery will be updated if the information in the advertising service changes retrospectively within a period of 21 days. This means that for 21 days after importing data, the numbers in Google BigQuery will automatically be updated to correspond to the numbers in the advertising service.

As a result, you can build dashboards similar to this one:

Low-quality data is the first reason for poor decisions, due to which businesses lose time and money. To address this problem, we created a Data Monitoring service that allows us to track the completeness and relevance of data uploaded to Google Analytics from advertising services. You can access a visual report at any time showing all your project pipelines and data download statuses for each day:

By clicking on a cell, you can see status details: the exact percentage of discrepancies in data and the exact time when OWOX BI last updated the data in Google Analytics.

You can also go to the Pipeline page in OWOX BI and view the details of the data. If an error occurs during import, you’ll see it in the description (as well as the cause of the error).

• What data does OWOX BI send to Google Analytics?
• Where is imported data displayed in Google Analytics?
• Can I import individual campaign costs?

You’ll want to use this functionality if:

• Data in your reports is sampled and you can’t trust your reports 100%
• You exceed the limit of 10 million hits a month and not all hits are included in your Google Analytics reports
• You need more than the 20 custom metrics and dimensions available in Google Analytics
• You want your data to be available for analysis at once, not in 24 hours

OWOX BI collects data into Google BigQuery directly from your website without the limitations of Google Analytics, allowing you to build reports without sampling and according to any parameters. With OWOX BI Pipeline, you can:

• Get raw and unsampled data from your website in Google BigQuery
• Send an unlimited number of custom metrics and dimensions to Google BigQuery
• Collect data about user behavior in almost real time (with a delay of up to 5 minutes)
• Collect personal data (IP addresses, emails, phone numbers) and use it for analysis

To collect raw, unsampled data from your website, you need a Google BigQuery account. If you don’t have one, you can register and receive $300 to store and process your data as a new user.

OWOX BI collects raw, unsampled user behavior data on your website at the level of hits and sessions. Hit data is uploaded to Google BigQuery tables in real time. Session data appears in BigQuery the next day. How you create your pipeline will depend on how Google Analytics tracking is implemented on your website.

If you’ve implemented Google Analytics on your website through Google Tag Manager, then you need to:

1. Create a data pipeline based on hits from your website
2. Implement an OWOX BI tracking code on your website through Google Tag Manager
3. Set up session data collection

If you have Google Analytics tracking embedded through JavaScript code, then you need to:

1. Set up a hit data pipeline
2. Embed a code snippet on each page of your website
3. Configure session data collection

Note that data will not be available until the day after the pipeline is created.

• Hits data scheme (data available in Google BigQuery in 5 minutes)
• Session data scheme (data collected based on the OWOX BI algorithm)

1. How are unique users counted in OWOX BI?
2. How does OWOX BI streaming differ from the standard Google Analytics 360 integration with Google BigQuery?
3. What restrictions are there on data collection in OWOX BI?

By collecting information in Google BigQuery from mobile applications, you can:

• Get a full picture of user behavior at each stage of the sales funnel
• Learn how traffic sources bringing users to your website and mobile application are interconnected
• Make your applications more effective: increase user involvement, reduce the cost of client involvement, make your interface friendlier

If you use the AppsFlyer analytics system, you can upload mobile traffic data into BigQuery using OWOX BI:

• Set up a pipeline and data schema for an Android app.
• Set up a pipeline and data schema for an iOS app.

• Collect data from an Android app into Google BigQuery in real time using Google Firebase.
• Configure data collection from an iOS application into BigQuery using the OWOX BI Streaming plugin or Google Firebase.

After combining all the necessary data in Google BigQuery, you can significantly improve your marketing using OWOX BI functionality.

What OWOX BI does for you:

• Automatically generates a cross-device profile for each user and updates it retrospectively
• Provides ready-made algorithms for predicting audience conversions and value using machine learning
• Gives you unlimited opportunities for user segmentation (for example, excluding an audience that won’t buy)
• Lets you automatically deliver data to advertising services
• Provides you with a ready-made tool to improve the profitability of your audience segments

You’ll need this functionality if you want to:

• Increase the relevance of your ads
• Increase the number of re-purchases
• Increase the percentage of returning users
• Increase the lifetime value (LTV) of users

The Google BigQuery → Google Analytics pipeline helps you personalize ads as much as possible and offer users what they really need.

For example, say you have a CRM system that stores all information about registered users or those who have made a purchase: car ownership, number of children, date of birth, job title, interests, etc. It’s time to start using this information.

By uploading information from your CRM into BigQuery and from there to Google Analytics, you can get additional user settings in Google Analytics. Then you can create audiences based on those settings and transfer those audiences to Google Ads.

1. First, upload data from your CRM into BigQuery. To do this, you can use the direct Salesforce integration in OWOX BI, use ready-made libraries and applications, or write to contact@owox. com and we’ll create a custom integration for you.
2. In Google Analytics, create custom user-level settings. Then create a new dataset to import information from BigQuery. Read more about Google Analytics settings in our article on how to set up Google Analytics.
3. Prepare a SQL query. This query should select the key-value data you need. For example, say user 2346 is a machine. Save the query in your OWOX BI project so you can simply specify it when you set up your pipeline. You can also import RFM results from BigQuery into Google Analytics.
4. Create a pipeline from Google BigQuery into Google Analytics.

By downloading data from your CRM into BigQuery, you can:

• Combine information about transactions, online user activity, and advertising expenses
• Evaluate the effectiveness of advertising campaigns based on real revenue and order fulfillment data stored in your CRM
• Assess the impact of all marketing efforts, both online and offline, on business performance

Integrating your CRM system with Google BigQuery occurs on the client side. To set up automatic integration, you’ll need a technician or an outsourced specialist if your team doesn’t have one.

If you want OWOX BI to develop a custom integration for your CRM system, please email contact@owox.com.

You can upload data from your CRM into Google BigQuery in several ways:

1. Download files in CSV or JSON format through the Google BigQuery interface or by using the bq command-line tool.
2. Use a set of Python scripts from OWOX to automatically import data into Google BigQuery using Google Cloud Functions.
3. Use the SDK for. NET, Java, PHP, or Python.
4. Use ready ETL applications.
5. Use the ODBC driver from CDATA.
6. Download data from Google Sheets using the OWOX BI BigQuery Reports add-on.

We recommend using the first method: downloading files through the BigQuery interface. To do this, open the Google BigQuery interface and follow these step-by-step instructions.

You need funnel based attribution if:

• More than 40% of your users visit your website more than twice before buying
• You don’t know how optimizing paid campaigns will affect sales on other channels
• You invest in web channels, but customers also order in applications and offline stores
• Users interact with your company through different points (stores, call centers, chat rooms)
• You have a complex and inconsistent sales funnel or a long purchase cycle
• You have differences between transaction data in your CRM and Google Analytics
• You want to evaluate the contribution of media ads using views from DoubleClick

With OWOX BI Attribution, you can:

1. Get a quality assessment. The OWOX model is trained on data from tens of thousands of projects and is resistant to noisy data.
2. Evaluate each funnel step taken by the user.

3. Distribute your advertising budget as recommended in reports. Add attribution metrics to reports and find growth zones in campaigns.
4. Use attribution calculations to automatically manage rates based on the contributions of keywords to sales.
5. Evaluate channels based on user behavior in different cohorts: user type, region, device type, etc.
6. Clearly see the contribution of an advertising campaign to sales on your website, sales in your application, and ROPO sales.
7. Provide input and expertise in the calculation using a user-friendly interface.
8. Get transparent and understandable results for each transaction.

1. Information about users’ interactions with your website
2. Data on online advertising costs
3. Transaction data from your ERP/CRM, call centers, and other internal systems

1. Create an attribution model in your OWOX BI project.
2. Configure the appropriate attribution options.
3. Configure the transfer of session value by traffic source.
4. Adjust funnel steps that suit your project.
5. Set up the attribution of custom events (data from your CRM, call tracking systems, etc.).
6. Consider transaction data from your CRM.
7. Adjust the funnel conversion step.
8. Add media ad impressions from DoubleClick and Campaign Manager to the conversion funnel.

1. Get finished reports in OWOX BI Smart Data.
2. Build reports by yourself in your usual visualization services using calculation tables.
3. Download results to the Google Ads automatic bid management systems.
4. Segment users depending on which stage of the funnel they’re in and send these segments to advertising services.

You can benefit from the OWOX BI Smart Data service if:

• You have to wait hours or even days for a new report when you need it here and now.
• Your main attribution models remain Last Click and associated conversions, but you know that these models don’t provide an objective assessment.
• Gigabytes of user data are available to you daily, but you aren’t using this data to increase revenue.
• Your business loses time and money since you can’t use your data here and now.

OWOX BI Smart Data helps you improve the quality and speed of hypothesis testing. With OWOX BI Smart Data, you can quickly:

• Build reports without SQL based on your business model
• Evaluate the effectiveness of advertising channels
• Analyze the quality of merchandise promotion
• Match plans to actual sales

1. Each report in OWOX BI Smart Data is based on your business model.
2. Once you connect data to your business model, you can invest the rest of your time in analysis and decision-making.

3. OWOX BI provides data for your reports when you need it and doesn’t limit you to pre-built dashboards.
4. With OWOX BI, you get a cross-device portrait of your customers from dozens of cookies.
5. OWOX BI lets you focus on your business, not your data sources and their structure.

In Smart Data, you can build any reports based on data you’ve collected in your Google BigQuery project.

Learn more:

1. How to build a report in Smart Data
2. How to connect data to Smart Data
3. How to select data sources for Smart Data reports in Google BigQuery and how to download your data to BigQuery
4. How to import transaction data into Google BigQuery

Data source schemes:

1. Data on custom events
2. Information from your CRM
3. Email campaign data

Export ready reports from Smart Data

If you’re used to working with data in Google Sheets or Data Studio, you can easily export a finished report from OWOX BI Smart Data and use it in these services. You can also save a finished report as a CSV file.

Get a ready SQL query

You can copy a SQL query from a report generated by Smart Data. You can then modify it or use it to automate a report in Google Sheets built on BigQuery data.