Blog

A blog about data-driven marketing.

EasyAutoTagging – Built to Automate Campaign Tagging & Tracking at Scale

Learn More

Google Analytics Data Import for Facebook Cost Data [How To]

The Google Analytics Data Import feature is great for importing advertising data from non-google platforms such as Facebook.

Having the ability to analyze Facebook Cost Data for your direct response traffic campaigns in Google Analytics can provide multiple benefits:

  • First of all, it allows you to look at all of your Facebook Cost Data and Site Visitor Behavior aggregated in a single place. This makes reporting easier. Whether analyzing data inside of Google Analytics, pulling data into a spreadsheet via Supermetrics, or using a third-party reporting platform.
  • With automated campaign tagging, your imported Facebook Cost Data will now properly map Facebook campaign click with Google Analytics session data. As a result, importing cost data into Google Analytics provides a complete picture of campaign performance.
  • You get more insights into campaign effectiveness with campaign attribution using the Google Analytics available attribution models.

For example, take the Cost Analysis Report below. This default report, available in Google Analytics, displays ongoing cost, impression, click and conversion data for both Facebook and Google Ads.

 

facebook cost data sets in google analytics

 

In this post, I will go over using Google Analytics Data Import for setting up Facebook Cost Data. You can then manually upload a .csv file or access the Data Set in Easyautotagging and automate the Google Analytics data import process.

But first…

 

What is a Data Set in Google Analytics?

 

A Data Set in Google Analytics is a container that holds different types of information you can then import into Google Analytics. Google supports uploading these types of data:

  • Refund Data
  • User Data
  • Campaign Data
  • Geographical Data
  • Content Data
  • Product Data
  • Custom Data
  • Salesforce Sale Cloud Data

Next, let’s go ahead and set up our Cost Data Sets to import Facebook data into Google Analytics.

 

Google Analytics Data Import for Facebook Cost Data Sets

 

Sign in to Google Analytics.

Select the Admin tab and click Data Import.

Note: Data Sets are defined on the property level. Make sure that you have the correct Google Analytics property for your Facebook Cost Data upload selected. You will be able to select the view when you are creating the data set.

 

pasted image 0 35

 

On the Google Analytics Data Import page create a new ‘Cost Data’ data set to hold your imported data.

 

pasted image 0 30

 

Select Cost Data as your data set type and click Continue

 

pasted image 0 32

 

Give the data set a Name and connect your desired View then click Continue

 

pasted image 0 31

 

Define your Data Set schema as follows:

Under the columns where at least one must be provided add:

  • Clicks
  • Cost
  • Impressions

Under the columns that may be provided add:

  • Ad Content
  • Campaign

Your Data Set schema should look like this:

 

pasted image 0 34

 

Important: Set the import behavior to overwrite and click save.

 

pasted image 0 29

 

You are all set up with the Google Analytics data import!

If you head over to EasyAutoTagging you can now see your Facebook Cost Data set as an option in the drop-down as long as you have Tag Campaigns & Import Cost Data selected.

 

google analytics data import - EasyAutoTagging Dashboard

Leave a comment

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

You can automatically import data from Facebook Ads to Google Analytics using special tool, for example, this one – https://www.owox.com/products/bi/pipeline/facebook-to-google-analytics/ It even free for a small number of accounts.

Reply

Yes, that is true but the mentioned tool does not automate URL Parameters for Facebook Ads and automatically map cost data in Google Analytics. However, if you are only looking to import cost data OWOX can work.

Reply