Thursday, July 09, 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.
You can access spreadsheet edit mode from the Keywords tab in any ad group. You'll find it under the More actions menu.
In the past, you might have used power posting to enter your keywords with bids and destination URLs. Now, with spreadsheet editing, you can accomplish the same tasks from a spreadsheet view. Even if you use another spreadsheet application, it's very easy to transfer your work into AdWords - simply copy and paste directly from your spreadsheet into your account.
Like in a spreadsheet, you can use formulas to edit your keywords and bids. For example, if you want your ad to show on the first page, but your bid is lower than the first page bid, you can set up a formula to address this.
Here, I've set my Max CPC to be 120% of the first page bid (Cell G2). To apply this to all of my keywords, I can just copy and paste. Keep in mind that only the values are saved back into AdWords, not the formulas.
Questions? Attend a new interface webinar tomorrow
We'll be holding another free webinar about the new AdWords interface tomorrow, July 10th at 11a.m. PDT. If you're looking to get up to speed quickly, it's a great way to spend an hour on Friday. If you can't make it tomorrow, we have one on Thursday, July 16th at 10a.m. PDT as well. You can register for either webinar on the New Interface Webinars site.