Data and accesses you need to start working with OWOX BI

OWOX BI can help you with: 

• importing the cost data to Google Analytics
• importing the cost data to Google BigQuery
• tracking customers behavior on a website
• creating attribution models
• creating and assessing marketing reports 

To start using OWOX BI, you need to complete the preliminary steps. Let’s look at this in more detail.

Importing cost data to Google Analytics

Preliminary steps:

• Grant OWOX BI access to the cost data in your Ad Service account or other ad sources.
• Assign your Google account the Edit permission in Google Analytics at a property level.
• Create at least one data set in Google Analytics.

More information can be found here.

Importing cost data to Google BigQuery

Preliminary steps:

1. For Google Analytics —> Google BigQuery export

• Set up the cost data export to Google Analytics following the instructions above.
• Connect your Google Analytics and Google Ads accounts to import the cost data of Google Campaigns.
• Assign your Google account the BigQuery Data Editor and BigQuery User roles in the Google BigQuery project.

2. For Ad Services —> Google BigQuery export

• Grant OWOX BI access to the cost data in your Ad Service account.
• Assign your Google account the BigQuery Data Editor and BigQuery User roles in the Google BigQuery project.

Read this article for the details.

Collecting user behavior data into Google BigQuery

Preliminary steps:

• Grant OWOX BI access to a View associated with the required property in your Google Analytics account. Make sure your Google account has the Edit rights at a View level. 
• Grant OWOX BI access to Google BigQuery. Ensure that you assign your Google account the BigQuery Data Editor and BigQuery User roles in the Google Cloud Platform service.

Read more about user behavior data collection here.

Building funnel-based attribution models

Preliminary steps (depends on the attribution model type):

• Set up user behavior data uploading from Google Analytics to BigQuery via OWOX BI Pipeline or via BigQuery Export for Google Analytics 360. Additionally, you should add the Enhanced Ecommerce data in accordance with these requirements.
• Upload the Custom event data into your Google BigQuery project.
• Set up the online ad cost import into Google BigQuery via OWOX BI Pipeline.
• Add CRM transaction data into your Google BigQuery project.

Read more about the data you need to start working with OWOX BI Attribution. 

The full guide can be found in the BI Attribution section of our docs.

Creating Smart Data reports

Preliminary steps:

• Create at least one OWOX BI Attribution model or connect your Google BigQuery data source.
• Grant OWOX BI access to the data sources you are using for the report creation.

Depending on your marketing goals and the data you have, you can create the following reports:

• User behavior reports based on the data uploaded from Google Analytics to Google BigQuery via OWOX BI Pipeline or BigQuery Export for Google Analytics 360.
• User behavior reports based on the data from a call tracking system connected to the Google Analytics User Behavior Data→Google BigQuery pipeline via the OWOX BI call tracking systems integration.
• Conversion reports based on the СRM data uploaded to Google BigQuery (e.g. online, offline, ROPO: research online purchase offline).

For more details, check out our Smart Data guide.