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

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:datega:mediumga:sourcega:impressionsga:adClicksga: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).

 

 

Commenta

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.