Import Paid Search metrics using Data Sources
For many marketing organizations, paid search is one of the most valuable and reliable ways both to reach new customers and to retain existing ones. The Data Sources capability in Adobe Analytics makes it easy to import advanced paid search data from digital advertising platforms like Google AdWords. You can integrate it with the rest of your marketing data, alongside on-site behavioral and customer attribute data, to allow you better insights into your organization’s paid search efforts.
These steps show you how to configure an integration with AdWords to import keyword data as well as metrics such as impressions, clicks, cost per click, and more.
The steps explain how to set up a one-time import of pay-per-click data. However, Data Sources allows for the ongoing import of data using the file format described here. Depending on your paid search platform, you may be able to schedule periodic exports (daily, monthly, etc.), set up automated processes for transforming those exports into the file format that Adobe Analytics requires, and upload these files into Adobe Analytics for going paid search integration reporting.
Prerequisites
- You have implemented paid search detection.
- You are capturing tracking code data.
- You have unique tracking codes for each Ad Group.
Configure Success Events
Our first step is to prepare Adobe Analytics to receive the metrics. To do this, you need to set up some success events.
Success events are actions that can be tracked. You determine what a success event is. For our purposes of tracking paid search metrics, we want to set up success events around clicks, impressions, total cost and enabletracking codes.
-
Go to Adobe Analytics > Admin > Report Suites.
-
Select a report suite.
-
Click Edit Settings > Conversion > Success Events.
-
Under Custom Success Events, use Add New to create 3 custom success events: Clicks (Counter), Impressions (Counter) and Total Cost (Currency).
-
Click Save.
You should receive a message that your saves were approved. -
Navigate to Admin > Report Suites > Edit Settings > Conversion > Conversion Variables.
-
Enable tracking codes by selecting the checkbox next to Tracking Code under Campaign > Campaign Variable.
Set up Data Sources
Data Sources allow you to share non-clickstream data with Adobe Analytics. In this case we use Adobe Analytics to track paid search metrics. We use the tracking code as our key to tie the two pieces of data - paid search metrics and Adobe Analytics metrics - together.
-
Navigate to Adobe Analytics > Admin > All admin > Data sources.
-
Select the Create tab to start activating new data sources.
-
Under Select Category, select Ad Campaign.
-
Under Select Type, select Generic Pay-Per-Click Service.
-
Click Activate.
The Data Source Activation Wizard displays: -
Click Next and name your data source. This name appears in the Data Source Manager.
-
Accept the service agreement and click Next.
-
Select the three standard metrics: Impressions, Clicks and Total Cost and click Next.
-
Now “map” this new data source to the custom events we created in Success events.
-
Choose data dimensions
Check the box next to Tracking Codes and click Next. -
Map data Dimensions.
Map the imported data dimension (attribute) to the Adobe Analytics attribute that you want to store it in. This may be a standard dimension or an eVar. After you click Next, the resulting mappings are shown in the summary: -
Click Save.
-
Click Download to download the template file for this data source.
The file name corresponds to the data source type you initially specified - in this case, “Generic Pay-Per-Click Service template.txt”. -
Open the template in your favorite text editor.
The file is already populated with the metrics and dimensions and their mappings.
Export PPC data and upload it to Analytics
Steps similar to these work for Google Adwords, MSN, Yahoo, and other PPC accounts.
Export data
- Log in to your PPC Account and create a new report or export.
Ensure that the export includes the following fields: date, destination URL (landing page), impressions, clicks, and cost. The export can include other fields, but you will delete them the steps below. - If possible, save the report as a
.csv
or tab-delimited file. This will make it easier to work with in the following steps. - Open the file in Microsoft Excel.
Edit the file in Microsoft Excel
- In Microsoft Excel, delete all columns other than those mentioned above.
- Delete any extra rows on top.
- To isolate the tracking codes from the destination URLs:
a. Copy and paste data from all columns.
b. Click Data > Text to Columns.
c. In Step 1 of the wizard, make sure that Delimited is selected and click Next.
d. In Step 2 of the wizard, specify the delimiter depending on how you have created your URLs (either ? or &) and click Next.
e. In Step 3 of the wizard, preview your data and ensure that one of the columns is “trackingcodename=trackingcode”. If you have additional variables, repeat these steps (using & as the delimiter).
f. Delete all columns except for tracking codes, impressions, clicks and cost. Add a new column called Date and organize your columns in the following order: Date :: Tracking code :: Impressions :: Clicks :: Cost. - Add this data to the template you downloaded in the “Set up Data Sources” section above.
Now you are ready to upload the file.
Upload the file to Adobe Analytics via FTP
Go back to the Data Source wizard for instructions and upload the file via FTP:
Create Calculated Metrics
Adding calculated metrics will be helpful when making pay-per-click decisions.
For example, you could add these calculated metrics:
Configure and run reports
The final step is to add the data source metrics and any calculated metrics to the Tracking Code report and drill down into a campaign to get an immediate view of how each Ad Group is performing.
- In Adobe Analytics > Reports, select the report suite into which you have imported data sources.
- Navigate to Reports > Campaigns > Tracking Code > Tracking Code.
- Select the date range.
- Click Metrics > Add and add your data source metrics (Clicks, Impressions, Total Cost) from the list of Standard Metrics.
- Do the same for any calculated metrics you may have added. The report will update as you add metrics.