Let’s get to Power BI basics today. You might be wondering, what’s the difference between “Merge” and “Append” button in Power BI‘s Power Query Editor. This article will explain that. The short story is that: The Merge button is an equivalent of JOIN in SQL. It’s also similar to LOOKUP function in Excel, but behavior […]
Working with Arrays in BigQuery SQL to Manipulate Text
Proper knowledge of array manipulation in SQL is a must have for every data analyst (or marketer). This article will cover how to manipulate text strings in arrays along with error handling. Task 1: Creating an Array Creating an array is a quite easy process. Imagine you want to create an array of 2 text […]
Free Google Ads Script for Monitoring Big Drops in Account Cost Day over Day
Voila, a new script is out! Have you ever noticed super late after your client’s account stopped running? E. g. due to all ads being disapproved, client’s card could not be charged etc.? “Account Spend Watcher” script will notify you if there is big drop in account’s cost when looking at yesterday vs yesterday minus […]
Free Google Ads Script for Monitoring Campaigns Running Over Budget
I have written a new script which can be used in every Google Ads account. What’s the rule #1 in PPC campaigns? You should never hit your daily budgets. Either you should decrease your CPCs if your CPA is too high OR you should increase your campaign budget to get more conversions. The new script […]
Supermetrics for BigQuery: Step by Step Guide
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 […]
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 […]
Announcement: BigQuery Uploader for Google Sheets
In cooperation with our partner project www.MythicalReports.com, we are launching our first ever product for the masses: a free add-on for Google Sheets called “BigQuery Uploader for Google Sheets”. If you work a lot with Google BigQuery, you probably know by now that it is a bit cumbersome to get multiple sheets from one Google Spreadsheet […]
Having Troubles with Setting Up Your PPC Reporting Architecture?
Many 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 no […]
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 […]