Google Sheets

  • Time Saving Automation: Search Query Edition

    … in on the Google Sheets workbook every month (or whatever schedule you like to run your SQRs on). We’ve already covered SQRs here and here, but today we’ll cover alternative methods to automate your search query reports. Automation Set Up The Script Setting up this script allows us to segment search queries into “N-Grams”, which is a fancy way of saying…

    Rachael Law/ PPC Heroin Affiliate- 21 readers -
  • Building An Automated PPC Spend Tracker In Google Sheets

    … is to pull in spend information for our given timeframe so we can see how it stacks up with budget every time we check the tracker. This step benefits greatly from an add-on such as Supermetrics which allows you to directly pull data from your marketing platforms into Google Sheets, as it will streamline the process and pave the way for easier automation…

    PPC Heroin Paid Search Google- 25 readers -
  • Work Smarter, Not Harder – Using Google Sheets for PPC

    January 10, 2017 Between reporting, analysis, dashboards, and action item lists, we use Excel a lot for PPC. Recently, our team has begun to rely on Google Sheets for items like reporting, dashboards, and even to-do lists and status docs. We’ll go through how to get your data into Google Sheets and how to manipulate it once it’s there.

    Rachael Law/ PPC Hero- 26 readers -