Many Bing advertisers in the UK are guilty of setting up their campaigns and then neglecting them. Part of the problem is that many of us use Google Analytics, which can be easily setup to automatically import cost data from AdWords. You can manually tag your Bing campaigns so that you see conversions and revenue but you can't view any cost data.This article shows you how to upload cost data for non-Google paid campaigns, such as Bing, to leverage the Google Analytics platform to perform ROI analysis and compare campaign performance for all online advertising and marketing investments.
Create a data set in Google Analytics
To upload your Bing Ads cost data you must create a Data Set. This enables you to match different types of data from other sources so they can be integrated into Google Analytics.
- In Google Analytics go into the Admin section and then select "Data Import"
- Click the New Data Set button
- You will not see a list of "Data set type" templates. As we are importing cost data into GA select the Cost Data for the type and click Next Step.
- Name your data set then select the views that will use your cost data in the GA reports. Select Next Step.
- Go through the list of Dimensions and Metrics and select the ones that apply to your data. In this case we want clicks, cost impressions.
- Select "Summation" from the Import Behaviour. You can learn more about behaviours here: Cost Data Summation vs Overwrite. Select Save.
Create your Bing Ads Keyword Report
- Log into your Bing Ads account and select “Reports”. Click on the “keyword” text link to create a keyword report.
- Select “Day” as the unit of time. You must have this because you want to view these stats on a daily basis within Google Analytics.
- Select only the metrics you require.
- Select download to get your report
Prepare your CSV file
- Delete the general information in the header.
- Delete the footer that reads Ã‚Â©2015 Microsoft Corporation. All rights reserved.
- Change to date format to YYYYMMDD. You can do this in Excel by using custom formatting.
- Insert two extra columns. In the source column populate this with "bing". Fill the medium column with "cpc".
- Rename all of your columns so they match the data set that you created in Google Analytics:ga:datega:mediumga:sourcega:adClicksga:adCostga:impressionsga:campaignga:adGroupga:keyword
- Your headers should now look like this:
Save your Excel spreadsheet as a CSV (MsDos).
Upload you CSV file into Google Analytics
- Click on the Data import tab and select “Manage update” for the data set you wish to add an import file.
- Select the blue “Upload file” button.
- Choose the file you with to upload and press “Upload”.
- If there are errors with your upload click on the “view errors” link so you can start debugging.
To view your data create a custom report.Click on the link to automatically set up a custom report to view your bing Ads data: https://www.google.com/analytics/web/template?uid=hc1gNDBCSk64zVGHVI9eQA