When you work with a lot of advertising services, you eventually come to a situation when you need to measure and compare their effectiveness. But here’s the problem — non-Google services (like Instagram, Facebook Ads, Bing, LinkedIn Ads, and others) don’t have a native integration with the Google Analytics. As a result, if you want to control the costs of your advertising and evaluate the success of the advertising campaigns, you have to collect data about campaigns in different ad services, and then try to somehow analyze them.

In fact, to work successfully and respond quickly to any marketing changes, you need to get data about campaign efficiency stored in one place. Since Google Analytics remains the most popular and convenient service to work with, let’s see what we can do to build reports based on full data from any advertising service within it.

So it’s less than simple — all you need is data, all your cost data from your advertising services. You can either do this manually (g.e. using CSV. files), or you can set up automated data import and save you time, money, and nerves.

We recommend using the OWOX BI connector to automatically collect and merge all ad data. The service is a free alternative to such expensive tools as Supermetrics or Funnel.io and it’s free until the end of 2020.

Unique advantages of OWOX BI data import

The service was created based on the requirements of analysts and marketers that’s why it has a number of unique benefits.

1. The cost data format is the same. The most common error in processing data is a different currency in the advertising service and in the Google Analytics view. However, OWOX BI automatically converts the currency and deducts VAT if necessary.
2. Data accuracy and quality. OWOX BI processes dynamic parameters, checks existing UTM tags in your campaigns, and reports possible errors with the help of the OWOX BI Data Monitoring tool.
3. Updates and historical data. Within 21 days, OWOX automatically updates the data if it has changed in the advertising service. Moreover, you can download the last 2–6 months from the ad service and evaluate your past campaigns.

Image courtesy of the author

In short, the OWOX BI service helps you to avoid constant manual work on making marketing reports based on full unsampled data.

We’ve picked up 7 most popular questions about the service so that you can see it’s ready for any challenges.

#advertising #google-analytics #connector #owox-bi #data #data analysis