Sooner or later, everyone needs to match data from one table to another based on a common key. In standard Excel, VLOOKUP function would be used. In Power Query, “Merge” function needs to be used. So how does “Merge” in Power Query work? Simpler than you think. It is actually simpler than then writing VLOOKUP […]
Autoclassify Keywords into Ad Groups with 1 Click – Try Now!
Everyone has gone through this: You just got hundreds and hundreds of new KWs which are supposed to be allocated into ad groups. You can do it either manually. Or as always… you can use some Power Query magic to help you out. ***Tip: Have a question? Ask in the comment section below or in […]
Free PPC Ad Copy Test Evaluator – Try Now!
Evaluating ads in all ad groups at once can be pain. Especially, when you have thousands of ad groups to go through and no tools to do it automatically for you. Lucky you! Here is a simple Power Query tool which can help you. The tool iterates through all the ad groups & all ads and […]
Generate Keywords Like a Boss!
Ever tried to build a massive KW list consisting of thousands and thousands of KWs by copying and pasting? Not fun, right?! There might a better way to do it. As you can see in the video below, it is relatively easy to build a custom refreshable & expandable KW generator in Excel which avoids […]
How To Build Excel Refreshable Reports in 5 Minutes Without Macros
In today’s post, we will look at building simple Excel refreshable reports WITHOUT using any macros. Typical scenario: You get files with performance data on a regular basis (daily, weekly). E. g. CSVs, TXTs, XLSs, XLSXs… You just want to take these files, drop them into a folder and refresh your pivots without copying & pasting […]
Excel & Power Query Campaign Builder for Paid Search: Step By Step Demo
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 […]
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 […]
Commonly Used Excel & Google Sheets Functions in PPC Industry
The attached file in this article lists all the handy functions used in the PPC industry. The functions are separated into 5 categories: Logic + Text functions Date functions Sum + Count functions LookUp functions Query function Grab a FREE working copy of the file here: https://goo.gl/DiOe4p Drop your comments below if you want to see […]
FREE Email Generator
Trying to create X combinations of possible email addresses when you know names & domains? Generate email combinations with one click! ***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 […]
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: […]