Import Cost Data from Google

Import Cost Data from Google

Urchin 6.5+

Use CPC Source schedule and Global CPC Source Update to automatically download your CPC data. For more information, read CPC Data Import Utilities and CPC Sources.

Versions prior to Urchin 6.5

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).

  1. On adwords.google.com, log in to your Google AdWords account.

  2. In the Reports tab, click Create Report.
  3. Select URL Performance in Report Type section. Then, in the Settings section, make the following selections:

    • View (Unit of Time) - check the Daily in 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 tagging keywords and ending with yesterday's date.
      • 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.
    • Campaigns and Ad Groups - select All campaigns and all their ad groups radio button
    • Click the "Add or Remove Columns" link in the Advanced Settings (Optional) section:

      • In "Level of Detail":
        • Check Keyword
        • Check Campaign
        • Check Ad Group
        • Check Destination URL
      • In "Performance Statistics":
        • Check Impressions
        • Check Clicks
        • Check CTR
        • Check Avg CPC
        • Check Cost
        • Check Avg Position
      • In "Conversions Columns":
        • (Optional. Check Conversions, Conversion Rate, Cost/Conversion if you have enabled conversion tracking on your Google Adwords account. If you do not have conversion tracking enabled, skip this step.)
    • In the Templates, Scheduling, and Email section,

      • Name Your Report - 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.