In April 2019, Supermetrics team announced their new product called Supermetrics for BigQuery. So let’s have a look on what this thing does and why it could be useful for you – especially when you run massive accounts. Here some of the questions you might be asking: Why the hell should I care? I am […]
Category: Tools
Free Google Ads Script for Building Negative Keyword List to Negate Bad Search Terms
I have just scored 200th subscriber for this website and it’s time to celebrate with a free Google Ads script. I wrote a script for building negative keyword list which is free to use by anybody. Here is what the script does: It creates a new shared negative keyword list (if the list does not […]
Generate PPC Keyword Lists with SQL in BigQuery
If you run massive search accounts with millions of keywords created based on templates, it can get really tricky to regularly generate such keyword lists on scale on daily basis for example. You can: Write your keywords manually. Good luck with that. Do some copying and pasting in Excel/Google Sheets. Good luck with making no […]
Having Troubles with Setting Up Your PPC Reporting Architecture?
Many of of us are trying to solve the same problem: How do I get world class PPC reporting which is reliable. relatively cheap and is not complicated to manage? Well, I have been through this as well. Where did I end up? Read more to find out. Stage 0: No reporting Basically, you have […]
Google BigQuery: Automation Powerhouse for Google Ads
This article describes potential use cases of Google BigQuery 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 BigQuery, you have to know SQL If you don’t know […]
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
Update on 2019-04-30: Recent Excel updates caused the version 1 of the tool stop to work. I uploaded a new version here but I am not sure if it’s going to work for everybody. I recommend you use Excel 2016 on Windows and install all the updates. If you still experience issues, let me know and […]
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 […]