Checking for broken links is one of the boring tasks every digital marketer should do on a regular basis so his/her budget is not wasted on people landing to broken pages. The common question I’ve been getting is: “How can we check for broken links in Google Sheets on regular basis?” Well, today, I’m releasing […]
Bad Placement Cleaner – Google Ads Mega Script
Thanks to this change on Google’s side in June 2021, the script is no longer working. You can say “thank you” to Google. One thing where Google Ads excel is taking away your money by driving shitty traffic through its Display Network. What’s more Google makes it increasingly difficult to get rid of this garbage. […]
Master Switcher Script for Google Ads
A new script is out again! This is an easy but quite powerful one. The script lets you pause (and then activate) all your currently active campaigns by changing a cell value in a Google Sheet. If you frequently need to pause or activate entire account for your client (e. g. due to lead overflow), […]
Below First Page Bid Checker Script for Google Ads
A new script is out! Do you find it difficult to monitor your top keyword bids so you always stay above the first page bid? This new script is here to help you. What does it do? It pulls all keywords with impressions from your account (not MCC level!). It finds the top X keywords. […]
How to Get Google Ads Lead Forms to Google Sheets and Get Notified via Email?
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** ***In 2022-01, Integromat released several new Google Ads apps. One of the apps is Google Ads Lead Forms which significantly simplifies the configuration process.*** AFTER 2022-02: Integromat is now capable of automatically registering a webhook URL […]
How to Get Facebook Ads Data to Google Sheets?
So you’ve been running your Facebook campaign for a while and now it’s time to make a simple dashboard in Google Sheets. The main question is: How can I download Facebook Ads data to Google Sheets? The answer is Supermetrics for Google Sheets. The Process First of all, you need to install Supermetrics for Google […]
Persistent User Defined Functions Now Supported in BigQuery!
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?
How to Get Facebook Leads to Google Sheets and Get Notified via Email?
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** 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 […]
Supermetrics for Google Data Studio: a Biased Review from a Power BI Fan
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, […]
FREE No-DAX Calendar for Power BI – No More Copying!
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.