Jump to Interactive Bizcor Sample PPC Report

Welcome to Part 2 of Making Sense of Your PPC Data, where we take a deeper dive into some more nuanced PPC metrics, and more importantly learn how to digest everything, visualize it, and turn your data into actionable improvements!

Deeper Dive

The truth is that the metrics discussed in Part 1 of this blog are just the tip of the iceberg when it comes to PPC data. To be able to make continued account improvements over the long term, you’ll need to dive deeper into your Google Ads and Google Analytics data to better predict where and when you have the best chance to make a sale. You will still be using your basic metrics and conversion data as your benchmark for success, and bid adjustments as your method of optimization, but to truly dial in your ads you’ll need to look beyond your campaign and keyword data at some more nuanced metrics.

Three often overlooked optimizations you can make to your PPC account are ad scheduling, location targeting, and device bid adjustments. Each allows you to set bid adjustments beyond your original keyword bid, allowing you to bid more or less depending on when a user searches, where a user searches from, and what device a user is using.

After your ads have been running for a bit, and have generated some solid data, Google Ads provides a lot of very valuable information for each individual click. You can segment your data by both time of day and day of week to understand when users are searching, when they are clicking, and when they are booking. By taking ROI data for each of these time slots, you can set up an optimized ad schedule with bid increases during the hours and days that a user is most likely to book and bid decreases when a booking and strong ROI seems less likely.

The same goes for geographic and device data. Google Ads shows you the precise locations from where your users are searching, down to the zip code. Zip codes or states with high ROIs and strong booking numbers deserve bid increases, whereas locations with low ROIs deserve bid decreases. With more and more users searching and booking from mobile devices, it’s also important to analyze device data to ensure that you are not overspending on mobile, where search traffic is often high, but ROI is generally low.

By adding these more advanced bid adjustments to your account, you can really start to optimize your ad spend, focusing more on proven ROI winners while limiting your wasted spend. For example, imagine you have a $1 Max. CPC bid for a keyword. You also know that searches from San Francisco produce strong a ROI (+25% bid adjustment), searches at 6pm on a Wednesday produce a strong ROI (+50% bid adjustment), and searches from desktop computers produce a strong ROI (+25% bid adjustment). All of these bid adjustments add together, so if someone searches for your keyword from SF at 6pm on a Wednesday, on their desktop, your $1 max CPC increases to $2 (+100%), as you actively set bid increases for these conditions. Remember when we said there were many factors that come into play when determining CPC?

Not only do these more nuanced metrics help you optimize your account, but they can help with other areas of your business as well. You can find the perfect time to send an email blast to maximize bookings. You can determine pain points on your mobile website to find areas of improvement. You can determine the best locations to focus your print advertising or place billboards. All of this info is additional value added from your PPC campaigns beyond your ROI.

And So Much More

Congratulations! That’s everything there is to know about PPC data. Just kidding, if we were to cover everything, this would probably be a 20-part blog series. Instead, let’s go over some final metrics that can help you truly understand your PPC account.

Quality Score (QS) is an important metric that Google uses to determine where your ad shows vs. competitors, also known as ad rank. While your keyword Max. CPC bids (as well as additional bid adjustments) determine how much you are willing to spend per click, QS is equally as important to determine how high in the search results your ad shows. It’s Google’s way of saying “I think this is a relevant ad for this search,” and is a rating from 1 to 10. Ad Rank is calculated by multiplying your Max. CPC bid and your QS. Thus, a $2 keyword bid with an 8/10 QS (16) will show higher in the search results than a $10 bid for the same keyword with a 1/10 QS (10).

Many factors go into determining QS, and it’s important to try and optimize for QS as much as possible. Historical performance for keywords plays a big role, so if Google knows a specific keyword performs well in your account, it will get a better QS. Additionally, a high CTR on your keywords and ads improves QS. If Google knows that people see your ads and click them, they know they must be relevant. Landing page performance is also important. If users click your ad and immediately bounce from your website, Google will deem this as a problem and reduce your Quality Score.

Speaking of website performance, looking at your on-site Google Analytics metrics is a very important step towards improving your PPC account. You can make as many account optimizations as you’d like, but if searchers have a bad user experience once they get to your site, you are leaving money on the table. You should be looking at things like bounce rate, average time on site, and pages per session, making sure users are getting to your site and staying there. Additionally, you should make sure your checkout flow is going smoothly, so that users who are getting to the checkout page aren’t having issues completing their booking.

Running a competitor analysis is also beneficial in understanding where you stand vs. your competition for ad space. Google allows you to see your own search impression share, as well as competitors search impression shares for your keywords. If you have a 60% search impression share for your keywords, that means your ad shows 60% of the time someone searches for one of your keywords. The other 40% of the time you’ve either run out of budget for the day, or competitors outbid you for the ad space. By checking competitors’ search impression share, you can see how aggressive they are for your keywords, and how their aggressiveness has changed over time. If you see competitors getting more and more aggressive, and thus increasing their search impression share, it may be time to increase bids to remain relevant.

There are also conversion attribution models, search term reports, A/B testing, ad extension analysis, etc., etc. The moral of the story is that there’s no shortage of ways to analyze your keywords and ads and improve your ROI. Understanding each metric is time consuming, but important towards ensuring your account is running like a well-oiled machine.

Data Digestion

Now that you have all the data you could ever want, what do you do with it? How can you possibly keep track of it all? For starters, Google Ads provides a great user interface, with access to each and every data point. You can segment your data however you’d like, adjust timeframes, compare year over year, and make all of your budget and bid adjustments in one place. You can also import your conversion data from Google Analytics to bring in online lead and booking data.

That being said, Google Ads has its limitations as well. For starters, despite being a user-friendly interface, it still takes time and effort to truly understand all of its capabilities. It’s meant more for full time PPC specialists than your average business owner. Additionally, you are limited to bringing in your online lead and booking data, meaning you are potentially missing out on some offline conversions that can give you a more accurate picture of your ROI and CPL. It certainly is able to provide usable data, but your best data should be housed elsewhere, in easy to visualize reports with blended data.

Data blending allows you to bring in data from multiple sources to give yourself as accurate a picture as possible of your account performance. You can bring in data from Google Ads, Bing Ads, Google Analytics, call tracking services, CRMs, property management software, as well as any other data source you have. Then, using your preferred method, you can blend all of your data together to give yourself the full scope of what you are spending on your ads, and what you are getting in return. With this data automatically updating on a daily basis, you now have all of your most important metrics in one place, allowing you to do with it what you’d like.

Once your data is all in one place, it’s time to visualize it in an easily digestible format. Google Data Studio is a great free option for this. You can customize your reports to your liking and focus in on your most important metrics while leaving out the fluff. Start out with your basic metrics and conversion data to ensure things are running smoothly and you are producing a solid ROI. Then, progressively go into more and more detail that can be used to improve the account. How are search campaigns doing vs. remarketing campaigns? How do our metrics stack up against the same dates last year? Including week over week and month over month data is also a great way to show continued progress, as well as alert you to any seasonality changes that may occur in your specific market.

As your report goes on, you can get deeper into your data. Campaign and Keyword performance, with every conversion point you can imagine, can get you closer to your true ROI and allow you to better focus your spend. Deeper dives into your most important Google Analytics metrics can teach you how your website is performing and whether adjustments need to be made. Visualizing geographic click and booking data makes it easy to identify top performing locations, as well as locations that eat up spend without producing results.

A well-made PPC report should be your one-stop shop to understand how your account has been performing in both the short and long term, how that performance compares to previous years, what areas of your account are specifically driving your conversions, and what optimizations can be made to improve performance further. At the same time, it needs to be easy to digest, something that doesn’t require a PPC expert to understand. See below for what a sample interactive Bizcor PPC report looks like (use the arrows in the bottom left corner to navigate through the pages):

Hopefully this blog helps you make sense of your PPC data! If you have any questions, we’re always happy to help. Reach out to [email protected] for more information!

When it comes to the vacation rental industry, paid search (PPC), and Google Ads in particular, has proven to be a very effective marketing tool. It’s tough to imagine a better way to spend your marketing dollars than directing it squarely at potential guests while they are in the midst of searching Google for their next vacation. This rings especially true when you have your ads dialed in; adjusting your ad spend for each individual searcher, based on important factors such as their location, the time of day & year, the device they’re searching from, the specific phrase they searched for, and so much more.
If you’ve run PPC ads in the past, you know that the value that they generate doesn’t end with the increase in leads and bookings that you see. The real value lies in the massive amount of data that each click to your site brings. Without this data, you’re simply putting ads out there, hoping to strike gold. Sure, you’ll get lucky and find a booking or two, but ultimately you’ll be wasting tons of money that could be better spent elsewhere. When you’re able to make sense of the data you’re generating, however, the story changes, and you can begin to focus your ads, limit your wasted spend, and start seeing some real ROI improvements.

Basic Metrics

To begin understanding PPC data, you first need to understand your basic account metrics. These are the numbers you should be reviewing on a daily to weekly basis, to ensure that a) your account is running smoothly, and b) that you’re staying on budget. Impressions, clicks and spend are the key things to look at here. How many times have your ads shown? How many clicks did they generate? What was the total cost of those clicks? If anything looks out of the ordinary here, it’s important to troubleshoot right away.

Digging a little deeper, you begin to look at things like click-through-rate (CTR) and cost-per-click (CPC). CTR tells you the percentage of people that click your ad after seeing it. A low CTR lets you know that you have room to increase and generate more clicks, and it may also mean it’s time to update your ad copy. A high CTR tells you that your ads are communicating well with your searchers and they are interested in what you have to offer. It also means you have competitive bids and are showing high in the search results.

CPC is the average cost for each ad click to your site. And while it may seem like a basic metric, it’s all important when it comes to optimizing your account. You want CPC to be as low as possible, while also driving as much quality traffic to your site as you can. You don’t want it to be so low that you miss out on quality traffic that may now book with a competitor instead, but you also don’t want it so high that you are exhausting your budget before the end of the day. The main factor in determining your average CPC is your Max. CPC bid, which you set for each individual keyword in your account. You are essentially setting the maximum you are willing to pay for each ad click, depending on the keyword. As you’ll learn later, however, there are many other factors that come in to play when determining your actual CPC.


Now that you understand your basic metrics, it’s time to figure out what you’re getting in return. Beyond clicks to your website, you need to know how these users are interacting with your site, and whether or not they are converting. You can generate a ton of clicks to your site, with a very low CPC, but if none of these users are converting into leads and bookings, it’s all wasted spend.

Setting up conversion tracking is one of the first steps you should take when launching a new PPC account. You should make sure that you are tracking all lead points on site, as well as booking and revenue data, making sure that there is no double counting. In addition, call tracking is highly recommended, both for call leads and bookings made over the phone. The key with PPC data is consistency first, accuracy second. If you’ve been tracking data consistently for years, it has meaning. If your tracking methods are constantly changing, things start to lose their value, and year over year comparisons become skewed. Accuracy is also hugely important, but the truth is that numbers will never tell 100% of the story, no matter how accurate you are. Because of this, consistency holds the most importance, followed closely by accuracy.

Another important thing to consider when setting up conversion tracking is that conversions aren’t a standardized metric. CPL (cost per lead) and ROI (return on investment) metrics are not only unique to the industry, but also unique to each individual company. Each company should be tracking things their own way, with many factors differentiating their data from the next closest competitor. This means it’s always important to take cross company comparisons with a grain of salt. If one company is spending heavily on their own branded terms, which drives up ROI, and another doesn’t even bid on their own branded terms, there won’t be too much to learn when comparing the two until you can isolate NonBranded traffic for both.

Now that that’s out of the way, it’s time to understand your booking data. Ultimately, no other metric is a better benchmark for success than ROI. ROI simply takes your booking revenue generated from your ads and divides it by your total ad spend to determine how much revenue you are generating per $1 of ad spend. To be as accurate as possible, you should take your total revenue generated and multiply it by your management fee percentage (20% is a good industry average). So, if you see $100,000 in booking revenue, of which your company receives 20% (the rest goes to owners, taxes, fees, etc.), you are looking at $20,000 in actual revenue. And if it cost $5,000 of ad spend to generate that revenue, ROI becomes $20,000 / $5,000 = $4.00, or $4 in return for every $1 of ad spend.

Other important booking metrics include transactions (you want to make sure your booking volume is where it should be), booking % (the percent of clicks that turn into bookings), CPB (cost per booking), and average order value. Booking % is a metric you always want to increase, meaning your ads are targeting increasingly more relevant users, who have a higher likelihood of completing a booking. In the same respect, you always want to decrease your CPB, and it’s always nice from an ROI perspective to increase your average order value as well. If you know that a user who searches for a “luxury vacation rental” typically produces a higher average order value (despite a lower booking % and higher CPB), you’ll still want to bid higher on that keyword assuming it leads to a higher ROI.

Beyond bookings, it’s also important to track leads. Property inquiries, contact form submissions, phone calls, property management leads, etc. Tracking these provides valuable additional data, allowing you to better optimize at the keyword level. CPL is the main metric to look at here, and you always want to drive CPL lower. If a specific keyword only has a couple of bookings, and thus not enough data to make actionable optimizations, lead data and CPL can provide enough additional information to determine if you need to increase or decrease bids.

One last thing of note: It is important to keep your account organized and efficient to make it easier to filter your data and implement optimizations. Things like Property Management campaigns should be kept separate, as they are not ROI focused but instead CPL focused. Likewise, Branded and NonBranded campaigns need to be kept separate to easily determine the ROI for each. When grouped together, ROI will be inflated as Branded campaigns tend to drive very high ROI’s, as the user is searching for your specific brand. There is a high likelihood that this user would’ve booked with or without the PPC ad. By being able to separate out your NonBranded campaigns and determine your NonBranded ROI, you are increasing the accuracy of your ROI metric allowing for better optimizations.

Stay tuned for our next update as we take a deeper dive into some more nuanced PPC metrics, and more importantly learn how to digest everything, visualize it, and turn your data into actionable improvements!

logo x

  • This field is for validation purposes and should be left unchanged.