Power Query for PPC Explained

Power Query is a free Microsoft Excel extension/built-in feature. This tool was mainly built for business intelligence industry. However, if you know few tips & tricks you can turn Power Query into a very powerful PPC search tool which will help you solve your long term pains (copy & pasting, freezing Excel, repetitive operations…).

***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.***

For those of of you familiar with BI terminology – Power Query is a tool for data ETL (extraction, transformation & load). In other words, it is primarily a tool for building cool reports from various sources.

This is how Power Query looks in Excel:

Step 0 - Power Query in Excel
Power Query in Excel (varies based on the version)

This is how it look when you open Power Query interface:

Step 0 - Power Query
Power Query Interface (varies based on the version)

With Power Query:

  1. You can join data from various sources (XLSXs, CSVs, Google Drive files, Facebook, BI Cubes, Teradata, tables on a website…). There is infinite number of combinations. Common use case for PPC is a 1-click refreshable report based on Google & Bing csv data.
  2. You can also generate rows of data based on various rules. And that’s what we need for building our campaigns, right?

Here is a little teaser of what Power Query can actually do for your PPC search campaigns:

I highly recommend you spend 10 minutes watching the video. You may save hundreds of work hours in future.

You will see than you can dynamically build keyword lists (KWs in all match types in all regions/segments…), ad group names, campaigns, ads, sitelinks, and callouts  with 1 click after you setup your queries. The example with keyword build up on the video took me 30 minutes to build.

On this blog, I will be showing campaign build up from scratch with all the elements (keywords, ad groups, ads, campaigns, sitelinks, callouts). At the end, you will be able to dynamically generate new KWs and ad groups with one click.

Stay tuned for more posts, grab your Power Query installation here for Excel 2013. Excel 2016 has Power Query built-in under Data>Get & Transform.

Let me know if you want me to build more tutorials in the comment section below.

Thanks for reading!

***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.***

One thought on “Power Query for PPC Explained

Leave a Reply to John Cancel reply

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