Upload campaign cost data into Google Analytics: a new free tool available

By | June 2015

Import cost data into Google Analytics

Importing click and cost data for non-Google search engines and campaigns into  allows to compare performance data for Google and non-Google campaigns.

OWOX, a Partner, has created a free add-on that helps you quickly and easily import data from Google Sheets into Google Analytics. It is not the first tool for this scope, but it’s worth mentioning because it is free and easy-to-use.

Here are few simple steps to take to see your non-Google campaign cost data (for example Facebook Ads, Twitter, Linkedin or Bing Ads) into GA Views.

Here is a step-by-step guide:

  1. Create a Cost data schema on GA
  2. Download the schema (Excel template) as guidance. A typical format is:
    ga:date ga:medium ga:source ga:impressions ga:adClicks ga:adCost
     ga:campaign  ga:adGroup  ga:adContent
  3. Export cost data from Facebook Ads
  4. Install the Google Chrome Add-On, it will be available on Google Sheet (you need to access with a Google account that has been granted GA editing rights)
  5. Copy and past FB cost data into Google Sheet making sure that it matches columns of the GA schema (point 2)
  6. Start the Add-On from the menu and upload

Once done, cost data will be visible under GA / Acquisition / Cost Data enabling interesting business metrics.

Two final notes:

If something goes wrong data can be re-uploaded, they will be overwritten.

The cost data has to be daily, and the format of its first column (date) needs to be yyyymmdd.

Last but not least, a perfect correspondence between Facebook Ads URL parameters (medium, source, campaign and content) and the cost data spreadsheet is needed to match data on Google Analytics. Differently, you will find a mismatch between uploaded metrics and Sessions. Ideally, you can add two columns for medium and source while for the others, it’s advised to use the same name both in the URL parameters and in the FB Ads level (for example Adgroup matching Ad set).