How to Build Search Campaigns Directly from XML Feed

In today’s post, we will have a quick look at XML feeds & eshops.

Assuming you are able to get XML feed from your eshop, you can easily build PPC search campaigns on the fly in Excel without a single copy & paste operation. Wait, what…? No copy & paste?

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.***

***Do you feel like you need more help? We can help you with PPC Automation and/or with your reporting under our new project MythicalReports.com here.***

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.

The sample feed used in the video is here:
http://www.w3schools.com/xml/cd_catalog.xml

The sample Excel file with the working query is here:
https://goo.gl/9Bimdg  (download by clicking on the arrow in the top right corner)

To access Power Query features in Excel:

  • Excel 2016: Data>Get & Transform>Show Queries>Doubleclick any query in the right hand pane
  • Excel 2013: You need to install Power Query as a separate Excel extension. You can grab it here. After the successful installation, Power Query will be added as a new ribbon to your Excel.

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.***

***Do you feel like you need more help? We can help you with PPC Automation and/or with your reporting under our new project MythicalReports.com here.***

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

  1. 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?

Leave a Reply

Your email address will not be published. Required fields are marked *