Finally, BigQuery users have option to save their custom functions so they can be re-used across the project. Up until now, you could only create a UDF function within a query but you could not save the query as a view for example. Luckily, the times are changing now. But why should you care?
Have you ever wondered how to get Facebook Leads into Google Sheets and also send the leads via email immediately after the lead is recorded by FB? In this article, I will show you one of the many options to solve the problem within 30-45 minutes.
If you are a frequent visitor of this blog, you probably already know by now that I’m a big Power BI fan thanks to its endless customization options, especially in the Power Query editor. However, I will take a step back today. Not everybody needs to have an advanced and super-customized reports. In this article, […]
Have you ever imagined how nice it would be if you did not have to create your Power BI calendars in DAX or in Power Query? Here is the solution. FREE Always updated calendars in Google Sheets for everybody.
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]