Rachael Law

  • RStudio for PPC: A Beginner’s Intro

    With the ever-changing PPC landscape, we’re always looking for new ways to access, manipulate, and analyze data. The Account Analyst team at Hanapin has begun working with RStudio as a tool to do just that. This article is a basic intro to RStudio, describing what it does and why you’d want to use it for your PPC endeavors.

    Rachael Law/ PPC Heroin Paid Search- 11 readers -
  • Troubleshooting Google Analytics Tracking

    As an Account Analyst, a frequent request we get is to troubleshoot Google Analytics. Sometimes it’s a very specific request, like “can you see why our sessions don’t match our AdWords clicks?” and other times it’s a generic “can you make sure GA is set up correctly?”. In this post, we’ll go through some reasons why your data might not be accurate due to the account set up and tagging.

    Rachael Law/ PPC Heroin Google- 16 readers -
  • 6 Things You Didn’t Know You Could Do In Google Sheets

    Google Sheets is a versatile tool for PPC marketers. Whether you’re using it build reports for your clients, analyze data, or other miscellaneous PPC tasks, getting familiar with some of the lesser known functions can be beneficial. Here are the features we’ll cover in this post: Import Sitemaps Currency Conversions Sparklines Import from other workbooks Check for ...

    Rachael Law/ PPC Heroin Paid Search Google- 17 readers -
  • PPC Persona Targeting for the Fitness & Health Industry

    September 5, 2017 When developing a PPC strategy for your health/wellness/fitness business, it can be helpful to start by building out personas. What is a persona, you may ask? Here’s Hubspot’s definition: “A buyer persona is a semi-fictional representation of your ideal customer based on market research and real data about your existing customers.

    Rachael Law/ PPC Heroin Paid Search- 17 readers -
  • Did I Do That: Using the GA Effect Tool For Statistical Significance

    August 1, 2017 I’m going to run a scenario by you, let’s see if this sounds familiar: “We launched display a few months ago, has this had an impact on our search traffic?” “Is direct conversion volume affected by ___?” Like Steve Urkel, you might be wondering… What’s your next step in any of the above situations? One option is to pull a simple report showing the appropriate metrics.

    Rachael Law/ PPC Heroin Paid Search- 20 readers -
  • Time Saving Automation: Search Query Edition

    June 1, 2017 Search Query Reports (SQRs) – you either love them or hate them. While you probably pull these semi-regularly (or maybe you don’t do them at all), are you getting the most out of them? With a little bit of work on the front end, you can save time by automating these reports. Once you get it all set up, simply check in on the Google Sheets workbook every month (o ...

    Rachael Law/ PPC Heroin Affiliate- 22 readers -
  • Gain Deeper PPC Insights With The User Explorer Report

    May 1, 2017 Do you ever wish you could get more granular data in Google Analytics? Do you find yourself laying in bed at night wondering what users are doing on your site? Want to see exactly what your converting customers are doing on your site? You’re in luck! Enter the User Explorer Report. What Is The User Explorer Report? The User Explorer Report is used to examine in ...

    Rachael Law/ PPC Heroin Paid Search- 19 readers -
  • New PPC Account Analysis For Beginners

    March 14, 2017 Looking at an account that is unfamiliar to you can be daunting. There are many things to look at and so many reports to pull. How do you know what’s most important? This post will go through some of the common reports/analysis to pull when inheriting an account. Account Health Checkup / Learn The Lay Of The Land KPIs Key performance indicators (KPIs) are wh ...

    Rachael Law/ PPC Heroin Affiliate Paid Search- 22 readers -
  • Google Data Studio: Revisited

    February 13, 2017 Last year Google launched Data Studio in beta. We did a write up of our initial thoughts of the platform. While the idea behind it was good, there were some bugs that popped up here and there, especially when it came to adding data sources. You were also limited to only five reports with the free version. If you have more than a couple accounts to work with, this isn’t ideal.

    Rachael Law/ PPC Heroin Paid Search Google- 17 readers -
  • Prioritizing Your PPC To-Do List

    December 1, 2016 There are about a million things you could be doing in your PPC accounts right now. How do you sift through it all and decide what needs to be done, what should be done, and what can wait? Here we’ll go through some tips on how to prioritize your PPC to-do list and spend your time wisely. Gauging Account Impact vs.

    Rachael Law/ PPC Heroin Paid Search- 20 readers -
  • Why Your PPC Account Isn’t Living Up To Its Potential

    September 20, 2016 When a PPC account isn’t hitting goals, there can be any number of reasons why. The hard part is figuring out what’s going wrong. Other times, while performance isn’t necessarily bad, it isn’t what it could be. In these instances, there is a lot of opportunity to get the account running to its full potential.

    Rachael Law/ PPC Heroin Paid Search- 24 readers -
  • 5 Common Excel Issues And How To Fix

    August 18, 2016 Excel, while a fabulous tool for PPC, is not without its occasional hang-ups. In this post, we’ll go through some common problems, and how to fix them. To kick things off, it may be helpful to review Excel errors and what they mean. The Error The Meaning The Fix #NAME? Excel doesn’t recognize text in a formula Ensure your formulas are typed correctly, and th ...

    Rachael Law/ PPC Heroin Paid Search How To's- 24 readers -
  • Create Visually Appealing Reports With Google Data Studio

    July 20, 2016 When we talk about what tasks tend to eat up a significant chunk of time, reporting is surely mentioned. You find yourself slaving away day after day pulling numbers, calculating CPCs and CPLs, only to end up with a mediocre looking report. But wait. There has to be a better way. Let’s explore another option: Google Data Studio.

    Rachael Law/ PPC Hero- 19 readers -