OWOX, a #Google Analytics 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:
Create a Cost data schema on GA
Download the schema (Excel template) as guidance. A typical format is:
Export cost data from Facebook Ads
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)
Copy and past FB cost data into Google Sheet making sure that it matches columns of the GA schema (point 2)
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).
Paolo Margarihttps://www.paolomargari.it/wp-content/uploads/2018/04/paolo-margari-1.pngPaolo Margari2015-06-22 12:27:472018-04-12 01:50:38Upload campaign cost data into Google Analytics: a new free tool available