Import Cost Data from Google

Importing cost data from Google is easy. Just perform the following steps:

• Download your Google AdWord spending into a log file.
  Download your spending data on a daily or weekly basis, prior to the regularly scheduled run of your profile (or before manually runnning the profile).



• Modify your profile to read the log file.
  You will only need to modify your profile once, as part of your initial setup.

Download Google AdWord spending into a log file

1. On adwords.google.com, log in to your Google AdWords account.
2. In the Reports tab, click Custom Report.
3. Fill out the URL Report fields and click Create Report.



• View - check the Daily Metrics pulldown menu.
• Date Range -
  
  If this is the first time you are downloading data for campaign tracking, enter a date range beginning with the date you started tracking campaign data and ending with yesterday's date. (The date you started tracking campaign data is the date you completed implementing the instructions in the article Campaign Tracking Module-->Step 1: Track Campaign Data.)
  
  If you have already downloaded historical data, enter a date range beginning with the day after your previous download end-date, and ending with yesterday's date.
  
  For daily downloads (recommended), enter a date range beginning with yesterday's date and ending with yesterday's date.
  
  
• Detail Level - click Show options.
  • Check Keyword names and Include all keywords.
    
  • Check Campaign names and select All Campaigns.
    
  • Check Ad Group names and select All Ad Groups.
    
• Values-
  
• Ad Text-
  Check Destination URL.



• Conversions- (Optional. Check the following if you have enabled conversion tracking on your Google Adwords account. If you do not have conversion tracking enabled, skip this step.)
  



• Report name - Enter a report name.
• Scheduling - Checkmarking this box means that you will not have to define this report again. The report format will be saved and will be automatically run each day, week, or month (according to your selection).
• Email - Checkmarking this box tells Google to email you when the report has run.



4. Click the "Create Report" button
5. Once you have manually run the report, or once it has been automatically scheduled and run by Google, the report will appear in the Download Center. (Click the Download Center link at the top of the page.) Select the report for the day or week you want and download it as a .tsv file.

Modify your profile to read the log file

You will only need to modify your profile once, as part of your initial setup.

1. In the Urchin Admin interface, click Configuration, and then Urchin Profiles-- >Profiles.
2. Click the Edit icon for your campaign profile.
   Your campaign profile is the profile that you configured as part of Step 2:Configure Urchin-->Define a Conversion Goal.
3. On the Profile Settings tab, make sure that Profile Type is Campaign with E- Commerce Website.
4. On the Reporting tab, under Campaign Options, make sure that Primary Goal Match and a Primary Goal Field are filled in. If they are not, read Step 2:Configure Urchin-->Define a Conversion Goal.
5. On the Profile Filters tab, make sure that the following filters are applied:
   • Decode UTM Campaign Content
   • Decode UTM Campaign Name
   • Decode UTM Campaign Source (Medium)
   • Decode UTM Campaign Source (Medium) Term
   • Decode UTM Campaign Term
     
     If these filters are not applied, click Add.
     The Filter Wizard appears.
     Select Pre-Configured Filter radio button and press Next. Select the filters listed above in the Available Filters area, move them to the Applied Filters area, and click Finish. On the Profile Filters tab, click Update.
     
     
6. On the Log Sources tab, click Add.
   The Log Source Wizard appears.
   
7. Select Pre-Configured Log Source and click Next.
8. In the Available Log Sources area, select a log source that contains your Google AdWords spending data, move it to the Log Sources to Process area, and click Finish.
9. On the Log Sources tab, click Update.