#Excel format for adwords editor full
#Excel format for adwords editor download
#Excel format for adwords editor free

We easily signed in to our AdWords account and loaded our data into the program if you have multiple accounts, it's easy to sign into all of them and then select the one you want to work with from a drop-down menu. The program's interface is plain and utilitarian, with its major features arranged in tabs. There's no guarantee that it will improve the success of your ad campaign, but it can at least make the whole thing a little easier to deal with. Google AdWords Editor is a simple tool that lets AdWords users manage their campaigns on their desktop.

Hopefully, you never need this help because you don’t have a ton of disapproved ads at the same time, but if you do, then this should help save you a good amount of time.Google AdWords can be a powerful form of advertising, placing ads for your business right next to related Google search results-if you do it right.

#Excel format for adwords editor download

If you’re a hard-core Excel person then you can download a spreadsheet of the affected ads from either the interface (once you’ve selected all the ads, click “Edit” again and notice the option to “Download spreadsheet”) or from AdWords Editor (where you can actually select all the ads and copy/paste them into an Excel sheet). AdWords Editorīasically, you do the same thing as above, but in AdWords Editor where you can more easily edit multiple ads at the same time. This will work great for destination URLs that need updated or mass typos that might have been made during an upload (guilty as charged, in the past of course). You can select a bunch of ads and then click “Edit”, select “Change ads” and then use “Find and replace”.

#Excel format for adwords editor free

The number of screenshots to illustrate each in depth would make for a huge post, so feel free to reach out to me on Twitter if you have questions, but here is the idea: AdWords Interfaceīelieve it or not, the interface has find/replace functionality. There are a couple of different ways to approach this, so I’ll explain each briefly. With this information, we can start to deal with them in bulk. With this column selected you can now see the specific policy that each ad is violating:Īs you can see above, issues range from capitalization to 404 pages. In the “Attributes” section click on the “Policy details” column and arrange it according to your tastes. Click on the “Columns” button and select “Customize columns”. In order to get the specific policy violation listed in the viewable table, we need to add a very specific column called “Policy details”. That works okay for one or two ads, but we need to handle lots of disapproved ads.

#Excel format for adwords editor full

Now your view should be full of disapproved ads, but to see the reason you need to mouse over the dialogue box.

What we want to look at is “Approval status” and then make sure that “Disapproved” is the only box checked: Once there navigate to the Ads tab and then we’ll need to enable a filter. That could be the entire account or a specific campaign/ad group. To find your disapproved ads you first navigate to the desired location in the interface. So here is your cheat sheet if you find yourself in such a scenario. Now imagine it’s not just an old paused ad group that got randomly reviewed, but it’s hundreds or thousands of ads.Ī colleague recently had this very problem during a new product launch and I was surprised at how difficult it was to effectively handle this at scale. Imagine you’re in charge of managing an AdWords account and you get one of those dreaded emails about disapproved ads.