As BigQuery becomes more popular many of you are asking a simple question: How does a person get data from BigQuery to Google Sheets on a regular basis? There are a couple options so let’s look at them on by one. Native Connector from Google If you are running “Enterprise Plus” or “G Suite Enterprise […]
Google Sheets to Google Ads Uploader
Have you been dreaming of how nice it would be to be able to upload new ad groups, keywords, or ads directly to Google Ads from a Google Sheet? Dream no further. Here is a solution. I am introducing a new Google Ads script which allows you to upload new ad groups, keywords, and expanded […]
How to Quickly Negate Exact Keywords in Broad Campaigns? With a Script!
Many of us run 2 types of search campaigns – campaigns containing exact keywords and campaigns containing broad keywords. It’s usually a good idea to add your keywords from your exact campaign as negative keywords into the related broad campaign. If you frequently add new keywords into your exact match campaign, the process of updating […]
How to Upload Customers from Google Sheets to Facebook Custom Audiences?
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** Pushing your existing customer contact details such as email and phone number may be a crucial part of your prospecting (for lookalikes) and remarketing strategy. As always, this can be done manually by uploading CSV files […]
Supermetrics: Which Product Is Right for You?
In today’s article, we’ll look at Supermetrics product portfolio. I will try to answer the basic question – which of the products is right for you? I still remember days when there was just Supermetrics for Google Sheets. Well, those days are gone and the product portfolio has grown quite a bit. The current list […]
Sneaky Google Ads Tricks to Put Money from Your Pocket into Google’s Pocket
Times are changing. PPC professionals are becoming just executioners of Google’s will. And it will get worse. This article covers sneaky Google Ads tactics which try to maximize your ad spend (and sometimes your true performance). I’ll try to maintain this accurate and every time I find something problematic, I will add it to my […]
Supermetrics for Excel: Quick Start Guide
Supermetrics for Excel is one of the last products from Supermetrics which I had not interviewed. In today’s article, I will walk you through its setup process, the good, and the bad of the DESKTOP version of the product. So please by seated and let’s start. Why Would You Even Want to Use Supermetrics for […]
Webhooks & Make/Integromat: Gateway to Online Automation for Dummies
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** If you are looking to pass data from one online system to another, one of the options you may have is to use webhooks. Modern applications (such as Slack for example) with modern APIs support sending […]
How to Get CallRail Data to Google Sheets
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** Everyone running lead generating campaigns will sooner or later come to the point where calls need to be tracked and reported on. One of the widely used call tracking solutions is CallRail. The problem with CallRail […]
Shared Negative Keywords Manager in Google Sheets
A new script is out! Managing shared negative keyword lists is still a clunky experience in Google Ads. Today, I’m releasing a new script which will ease some of your pains. These are the problems the script is solving: You can fit all negative keywords lists onto one screen (=one sheet in Google Sheets). You […]