Be sure to apply to my favorite affiliate network, AzoogleAds.

10thJuly

Download and Re-Upload A CSV (Excel) Adwords Campaign

For the longest time I loathed Google Adwords Editor for one main reason...

I would want to download a campaign to a CSV and edit it within excel (because that is soooo much easier than editing it in the actual editor). When I would go to upload the campaign, I would realize that the only way you can upload the campaign via the Adwords Editor is through the encrypted .AEA files.

For a long time I searched on how to make this work and saw that some people use macros and external programs to get this to work and well... I didn't want to do that.

After thinking about how the adwords Editor works... I figured a way to do it fairly efficiently and with very little extra work.

Basically, because the adwords editor checks for incorrect values and such, you can utilize this for your advantage!!!

So, let's go through the whole process...

Download a CSV campaign using the Adwords Editor

  • First, you'll need Adwords Editor.
  • Next, right click on a campaign and click export to CSV.
  • Edit campaign in excel.

Upload A CSV Campaign to Adwords using the Adwords Editor

  • First Select ALL (Ctrl+A) and Copy (Ctrl+C)
  • Go into Adwords Editor and click on the keywords tab. Click Make multiple changes -> Add / Update Multiple Keywords.
  • Click my campaign information below includes column information...
  • Paste the entire campaign into the box and hit ok.
  • You'll notice that Adwords Editor filters out the ads as incorrect formats. Sweet.
  • Now, click the ad tab, add multiple ads and again paste the entire campaign.
  • Now you'll need to go through and if this is a new campaign (or renamed), you will need to set adgroup bids and enter the remaining campaign information on the tabs.

Editing campaigns in this format really saves me a lot of time and I hope that it can save you a lot of time too... :)

No related posts.


Related Posts:

    No related posts.


Rate This Post:

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 4.67 out of 5)
Loading ... Loading ...

5 Comments

Wes Mahler says 10th July @ 1:22

Ack thats still kinda confusing lol, following the steps

If you want, next-time on the prosper202 it has export202, and if you upload it to export202 it will give it in the format you need to reupload it to adwords editior, its a csv type file which u can easily get it..

basically its

1)download
2)export202 (to .csv format)
3)now edit csv
4)reupload

Wes Mahler says 10th July @ 1:23

what a pain they make it’ you’d think they have download and then upload, or, but they are probably trying to prevent people from copying/pasting campaigns.

Mary Green says 10th July @ 6:48

Actually they let you easily copy and paste campaigns, but maybe Im not sure exactly what you want to do. I appreciate this post, a bit more informational than all the contests lately. They were nice I just like reading your real meat and potatoes kind of posts like this. Thanks Mr. Volk

Godaddy Coupons and Promo Codes says 17th July @ 18:36

Thanks for sharing. This could save tons of time

adwords-marketing-tool.com says 14th August @ 6:01

There is a website using the aea file (adwords editor archive) to automatically generate adwords campaigns. You supply your ad text, landing page and keywords, and it generates a campaign for you. All you need to do is import the aea file into Adwords Editor and post your changes. Campaign generation is easy, fast and saves you hours of manual labor.

Here is the campaign generator in action…
http://www.adwords-marketing-tool.com/Campaign-Creator.aspx

Here is the url for the actual tool…
http://www.adwords-marketing-tool.com/toolbox/Campaign.aspx

Comments