Check out the video below, it’s less than 2 minutes. I am using a real XML feed (sample from W3Schools):

Once you build the query for the first time, you can refresh it anytime you want. Again…and again…and again…For example, every time new products appear in your XML feed, you refresh the query, get an updated “campaign snapshot” and simply import it to AdWords Editor. All it takes is just one click on the refresh button. Power Query will then go, download the new updated XML feed and perform the same steps as before on all the items in the XML feed. You can apply similar logic for ads building as well.

Of course, all the rules can be defined based on the business needs (naming convention, ad group grouping etc.). Same applies to the created keyword variations, I just created few samples of them.

2 thoughts on “How to Build Search Campaigns Directly from XML Feed”

Excelent tetorial – thank you!
Question – is it posible to create an entire compain in one file?
Right now I create two separate files, one for keywords and onother is for ads.
Is it posible that keywords and ads were on separate lines so I can load this csv to adwords manager?