This article describes potential use cases of Google Big Query for automating management of your Google Ads accounts. It’s based on 4 months of personal intensive experience. I don’t know everything but I know enough to share some thoughts and basic directions. Before deep diving into Big Query, you have to know SQL If you […]
Category: Tools
Send Google Sheet File as Attachment in Scheduled Email with Supermetrics
Are you wondering how to send Google Sheet files as attachments in scheduled emails? If you are a coder, you can code your own GoogleApps script. However, not everyone is a coder right? (yet). So what about dummies like me who cannot really code? Well, there might be an easy to use solution for you. […]
Excel N-Gram Analyzer for PPC Search Terms
Search term report is a useful source of information – based on search terms, you can add new positive KWs into your account or you can add new negatives. We all know that. There is one more thing you can do with your search terms (or keywords). You can create “N-Gram” report to see how […]
How to Process Auction Insights Data from AdWords in Bulk
Analyzing Auction Insights data from AdWords is painful because you cannot segment the data by campaign. At the same time, the data is not accessible by API. So what if you want to analyze Auction Insights for X campaigns at once? Power Query is here to help. In today’s article, I will provide you with […]
Supermetrics for Google Sheets & PowerBI: The Ultimate PPC Reporting Combo
Everyone is currently playing with Google Data Studio. However, there is also an alternative reporting combination which no one is using: Supermetrics for Google Sheets & PowerBI from Microsoft. So let’s have a look on this solution. In this article, I will cover some advantages and disadvantages of this combination and I will walk you […]
How to Connect Excel to AdWords with Power Query
Have you been dreaming of how smooth it would be to have Excel connected to AdWords? There might be a reliable workaround solution for you. This article is for more advanced users but don’t be scared – why don’t you just become advanced user by trying all of this stuff? You don’t have to be a […]
Using Google Sheets as Data Source in Power Query
Google Sheets have replaced Excel in a lot of companies so how do Google Sheets get along with Power Query? Actually pretty well. Sample scenario: You store reference sheets via Google Sheets files where multiple people can work at the same time. You would like to use this reference sheet as data source in Power […]
Free 404 URL Checker
Frequently, we are building PPC search campaigns pointing to many different URLs. How cool would it be to be able to check our dataset for 404 pages BEFORE we upload to AdWords, to Bing, or to Sklik? Read more to find out! ***Tip: Have a question? Ask in the comment section below or in this Facebook […]
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 […]