SEMGURU – A Web 2.0 Blog

Adwords New Interface Thursday: Introducing spreadsheet editing

Posted on: July 14, 2009

Many advertisers use spreadsheets when managing their AdWords campaigns to streamline tasks such as changing bids, creating keyword lists, and adjusting destination URLs. As a result, we decided to work on a way for you to use spreadsheets directly in your account, and today this feature is available in the new AdWords interface.

Google AdWords lets you specify a unique cost-per-click (CPC) amount or destination URL for each keyword in a keyword-targeted Ad Group. You also can specify a unique cost-per-impression (CPM) amount or destination URL for each site in a placement-targeted campaign.

You can edit these settings individually or update batches of keywords and sites all at once. Batch updating is a convenient shortcut for advertisers with multiple Ad Groups, campaigns, or lengthy keyword lists.

Editing existing CPCs and URLs in a keyword-targeted campaign

To edit your keyword CPC or destination URL values individually:

  1. Log in to your AdWords account.
  2. Click the campaign containing the Ad Group keywords you want to change.
  3. Click the appropriate Ad Group.
  4. Select the checkbox(es) next to the keyword(s) you’d like to edit within the Ad Group table.
  5. Click ‘Edit CPCs/URLs’ at the top of the Ad Group table.
  6. To change the default CPC that will apply to all keywords, enter a new value in the Default Ad Group CPC field. To assign a unique CPC to a keyword, enter the amount in the Max CPC column beside the appropriate keyword(s). This maximum CPC will override the default Ad Group CPC.
  7. If you want to track a specific keyword separately, enter a URL in the Destination URL column beside that keyword.
  8. Click ‘Save Changes’ at the top or bottom of the page.

Please note that you can leave any field blank if you’re satisfied with it. The system will default to the maximum CPC or destination URL you set when you first created the Ad Group.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

July 2009
« Jun   Sep »


Error: Twitter did not respond. Please wait a few minutes and refresh this page.



View Lalit Wason ('s profile on LinkedIn


Add to Technorati Favorites

Monthly Traffic Reports

  • 23,109 hits


Real Time Web Analytics Clicky

Get every new post delivered to your Inbox.

%d bloggers like this: