- Our Blog
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 ...
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.
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.
July 5, 2017 While PPC nerds certainly love their data, sometimes we can (admittedly) go overboard. We throw every metric, dimension, and number we can think of into a report, maybe add in some notes, sometimes changing the formatting, and call it done. Some clients like this strategy as they want to be able to see every single piece of the data. Others, not so much.
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 ...
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 ...
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 ...
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.
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.
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.
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.
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 ...
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.