In today’s post, we will have a look at a step by step demo of Power Query campaign builder. Watch the 4 minute video below showing how the campaign builder is built from nothing to full campaign setup.
As you could see, all you needed is 6 sample tables to start with, then the entire logic is built in Power Query in the background. Of course, logic is 100% adjustable (e. g. custom KW variations, ad group + campaign names etc.).
It took approx. 1 hour to build the entire tool.
Getting Power Query for Excel:
- Power Query for Excel 2013 is here.
- Power Query for Excel 2016 is built-in under Data>Get & Transform