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, 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.
- Second, with automated campaign tagging, imported Facebook Cost Data will now properly map Facebook campaign cost, impressions and clicks with Google Analytics session data. As a result, importing cost data into Google Analytics provides a complete picture of campaign performance.
- Third, [if you have a large enough data set] you can get cross channel performance insights leveraging Google Analytics attribution and multi channel funnel reports.
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.
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 to automate the Google Analytics data import process.
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.
On the Google Analytics Data Import page create a new ‘Cost Data’ data set to hold your imported data.
Select Cost Data as your data set type and click Continue
Give the data set a Name and connect your desired View then click Continue
Define your Data Set schema as follows:
Under the columns where at least one must be provided add:
Under the columns that may be provided add:
- Ad Content
Your Data Set schema should look like this:
Important: Set the import behavior to overwrite and click save.
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.