Excel and Google sheets are every PPC account manager’s best friend. As a newbie, getting familiar with these tools and knowing their applications for everyday PPC is super important. In order to help you along, I’ve outlined some helpful tips and how to apply them to your PPC account management. Essentially, I’m helping you *excel* at your job. You’re welcome!
Disclaimer: I have a personal preference for Google sheets, so you’ll notice that’s where the screenshots in this post come from. All of these tips are still applicable for excel lovers!
Concat & Concatenate: The Greatest Function of All Time
Okay, if you don’t know about concat and concatenate, then I am about to blow. your. mind. Concatenate lets you combine a number of different strings of text, while it’s little sister, concat, let’s you combine two strings of text.
Concatenate has a plethora of applications in the PPC word. For one, using concatenate to combine different elements of ad copy is super helpful! For example, you can insert locations into your ad copy to make your ads seem more relevant to the user. (A more advanced way to do this is with geographic customizers, but this post is for newbies!).
Warning: This technique requires good campaign naming conventions, which you can learn more about here.
1. Create an excel or sheets doc with the campaign names and ad groups you’d like to create ads for. Duplicate your campaign name column and add three or more columns directly to the right of it.
2. Assuming your campaigns include location in their naming conventions, use the “split text to columns” tool under the data tab to split the rest of the campaign name from its location*. (Keep in mind that the split text tool will make a column for each grouping of data. Don’t forget to add extra columns or you’ll lose the data in your columns to the right).
3. Delete the columns with extra campaign name data that you don’t need and relabel the column with your locations.
4. You’ll notice in this example that there’s a brand campaign, so we end up with “brand” in the location column. You can use find & replace to exchange “brand” for something like “near you”. Create a filter and filter out any branded campaigns for now, since the ad copy phrasing will be slightly different between your brand and location-specific campaigns.
5. Now use the concatenate function to create your ad copy. You can either type in the text you’d like combined with your location text or you can reference other cells.
6. Repeat the last step with your branded campaigns, and there you have it! Fresh, new, ad copy that speaks directly to the user! Concatenate is especially great when you have a lot of data to work with.
Your finished product will look something like this:
*Pro Tip: If your campaigns don’t include the location in their naming convention, you can export the campaign settings along with the location column, and use a vlookup to match campaign, ad group, and location data.
Bonus Pro Tip: You can also use the concat function to combine campaign and ad group names to create a unique key for vlookups!
Creating Broad Match Modified Keywords
Broad match modified (BMM) keywords are wonderfully useful in your account, but if you need to bulk upload many at a time, it can be a pain to manually add those plus signs. Here’s a quick and easy way to add the modifiers to your broad match keywords:
1. Find and replace the spaces between any keywords/phrases with a space and a plus sign.
2. Use the “concat” or “concatenate” function to insert “+” at the beginning of each word.
You’ll still need to include a column in your upload sheet with match type, but this strategy should make creating BMM keywords a breeze!
Pro Tip: Sometimes if you’re making edits to existing BMM keywords, sheets and excel will mistake those keywords for a formula. You can concat an apostrophe to the beginning of these keywords to force excel/sheets to recognize the keyword as text.
Get Sorted with Sort Range
Filters and pivot tables are great for organizing data, but their unfortunate limitation is that you can only sort by one metric at a time. Using the tool “Sort Range” allows you to sort by multiple metrics in order of importance, and becomes incredibly useful in tasks like trying to determining the best ad copy. While metrics like click-through rate (clicks divided by impressions) are useful on their own, sometimes they don’t give you the full picture of what’s going on. An ad could have a 100% click-through rate, which sounds great on the surface, but less great when you find out it only had 5 clicks and 5 impressions. Here’s how to use “Sort Range” to get the most out of your data:
1. Highlight the range you’d like to sort and choose the data tab and then the sort range option.
2. Once you choose sort range, it will give you a number of columns to sort your data by. Check the “data has header row” box so you know what metrics you’re sorting by. Order the metrics that are most important to you.
3. If you want to see the best performing ad overall, you might only sort by metrics like conversions, click-through rate (CTR) and impressions. (Hint: Z to A for numbers means most to least). You can also determine which ads are the best performers in each ad group. Sort by campaign and ad group from A to Z, and then the rest of the metrics from Z to A. The best performing ads will appear at the top of each ad group in the sorted range.
In this example, it looks like Ad Variation 1 was the best performing ad in each ad group.
If this post has made you super excited about all the sheets and excel possibilities, learn to master excel with The Essential Toolkit for PPC Marketers. Happy PPCing!
Hero Conf’s Excel Workshop is aimed to help you better understand the Excel functions and features that can help you to optimize your analysis and reporting so you can spend more of your time on high-level, strategic work.
How Automation Hurts Rank, And How to Fix It
Imagine you are offered an opportunity to have control of all the creative, copy, and budget in your Google Ads account (or your paid media platform of choice) put in the hands of an anonymous six-year-old user. Each day, you are allowed to tell them whether they should or should not spend money, how valuable a conversion is, and nothing else. This is billed as a massive gain inefficiency, as they can handle all the tedious tasks while you focus on the bigger picture. Whether or not you get to keep your job depends on this user’s continued success. Do you feel just a hint of hesitation or fear moving forward with this plan? When put in those terms, probably so. Yet somehow, we all seem to have no problem implementing automated bid strategies across our accounts.
There’s no arguing that automated bidding can be an effective tool, but it’s a technology that gets plenty of undeserved credit too. Machines do their best work when they are performing rote, repetitive tasks. Humans do their best work when they’re thinking strategically, and a successful account requires input from both parties. However, there are few, if any, paid media platforms that provide an adequate framework for communication between both parties. In the PPC world, miscommunications can be costly. In this article, we’ll go through the role of automation in paid media, how that influences rank, why rank is relevant, and how to use the tools you have at your disposal to make automation work for you.
Automation’s Role in Paid Media
Saying that automation is ubiquitous in PPC would be an understatement. It’s no secret that as advertisers call for more depth and granularity, advertising platforms answer their demands by developing increasingly complex features that require more automation to use. This is not only pragmatic but wholeheartedly welcome. Letting machines focus on execution means we can spend more time on the activities uniquely suited to humans, like analyzing and strategizing. However, as our focus broadens, we start to lose oversight into the most fundamental aspects of our campaigns, such as our rank.
Why Rank is Relevant
Rank determines where ads are relative to other ads, but it also serves a much more vital function. It determines whether ads show up at all. Even though it serves the most critical function in an account, we still don’t talk about it all that often for a number of reasons:
- The term rank is sometimes thought of as synonymous with the average position. When Google sunsetted the average position metric in 2019, conversations surrounding rank became scarce.
- Increasing complexity in our advertising platforms is causing our attention to become fragmented. We don’t have the bandwidth to manage something that at least appears to be managing itself.
- When efficiency is our main metric of success, how our ads are serving is only as important as our ability to pace our account budget. If spending is fine, no questions are asked.
- We trust automation too much. If a campaign sees low volume, we assume it’s for reasons out of our control. We’re either reluctant to question if automation is relevant, or we’re so entrenched in it that we don’t even think about it in the first place.
How Automation Hurts Rank
There are valid reasons rank may not always be top-of-mind, and it might not need to be if it weren’t for the fact that the automated bidding strategies we use everyday bid far too conservatively, inherently limiting our volume. Then consider the compounding effect of a schedule of continuous optimizations that further limit and refine an account where volume is already limited. Campaigns using automated bidding will end up serving a mere sliver of the potential audience. Without specific attention put towards improving rank and scale, every optimization made on a campaign brings it an inch closer to irrelevance.
Making Automation Work for You
It is clearer than ever that those of us who manage paid accounts need to rethink automation. The question isn’t whether or not to use it. The benefits are clear. What we need to consider is how we can make better use of automation without artificially limiting our audience. There are a number of options to test, ranging from simple to complex:
- Testing unconventional automated bid strategies.
- Testing unconventional combinations of values and goals.
- Test for growth opportunity by (briefly) turning your account into a tessellation of micro-campaigns, then recombine them with updated settings.
Using any of the strategies above has the potential to positively impact rank and help you retain efficiency at scale, but the safest method for doing so is the one that allows for the most manual control. In this case, that involves taking management into your own hands by breaking your campaigns down into smaller components to give yourself the clearest line of sight into growth opportunities. It’s a technique we’ve employed across a variety of clients at Voro, which has helped them achieve impressive results.
If you’re interested in learning more about how to take back control from the machines, employing an effective mechanism for retaining efficiency at scale, how to manage stakeholders’ expectations even when performance doesn’t go according to plan, or how burritos and popcorn relate to paid media management, I’ll be going in-depth on these topics and more at PPC Hero Conference.
Entireweb Articles – Read the latest Articles and News in Search Engine related world!
Ad Fraud Warnings to Look Out for in 2022
Advertisers spend $455 billion in online advertising per year and $42 billion of it lost due to ad fraud in 2019, according to Juniper Research. In addition, the Wall Street Journal reported that 28% of all web traffic likely comes from “non-human” bots.
Why hasn’t ad fraud been stopped yet?
In short, it’s still difficult to detect.
Fraudsters are using far more sophisticated techniques today than in the earlier days of the web and a single advertiser can run millions of ad impressions across hundreds of websites, making it extremely difficult to spot irregularities at such a large scale.
It’s not a secret that ad fraud remains a major problem. But are advertisers aware of it and, if so, are they doing anything about it?
Fraud Blocker, a click fraud protection software, sent out a survey to PPC marketers to help answer some of these questions as they plan for their 2022 campaigns.
What is ad fraud?
Ad fraud is a means to defraud advertisers by using techniques that inflate the total number of ad clicks or views for financial gain.
With click fraud, malicious actors can employ robots or low-wage workers to repeatedly click on ads illegally. Unaware of the fraud, advertisers then pay for the clicks as if they were real humans with actual buyer intent.
Another type of ad fraud, impression fraud, is often done by serving ads in places that are invisible to the human eye. This can be done by stacking ads on top of one another, loading them in tiny iframes, or serving them in the background of a mobile application.
Here are a few of the most common types of ad fraud today:
- Ad Stacking: Multiple ads are stacked on top of one another where only the top ad is visible, however advertisers are charged for the non-viewable ads.
- Pixel Stuffing: A malicious publisher loads ads, or an entire website, inside a 1×1 pixel. The ads are non-visible to the human eye.
- Click Farms: Attackers hire a group of individuals whose job it is simply to click on ads throughout the day. Click farms use techniques that give the impression that each click is from a different user and device.
- Click Bots: One of the most popular methods of click fraud is done by web robots. These bots can be simple programs that click on ads repeatedly or they can be large operations that are installed with malware on user’s devices and click on ads unknowingly in the background.
- Location Fraud: The geographic location of ads are spoofed using a Virtual Private Network (VPN). This makes ads appear to be shown in a more desirable location, such as in the US, despite actually being shown in a less desirable country.
- Video Viewing Fraud: The popularity of video channels can be easily faked to appear more appealing to advertisers, much like social media followers. Advertisers ultimately end up paying based on the view counts which a large portion of may not be from real humans.
- Affiliate Ad Fraud: Fraudsters manipulate the cookies on a user’s device to wrongly credit an associated affiliate as the source of purchase without the user’s knowledge.
- Source Spoofing: The data detailing where an advertisement ran is altered to appear as a more trustworthy publisher or mobile app.
- Domain Spoofing: The domain name is changed to falsely appear as if the ad came from a more premium site, such as changing from junknewssite.com to WSJ.com.
Visit here for more details on the different types of ad fraud.
Ad fraud still remains a large concern for advertisers
In the new survey, PPC managers were asked about their awareness of ad fraud, their overall level of concern and, what role in marketing they held to see if there was any correlation.
The vast majority of all respondents, 70%, stated they were somewhat or very concerned about ad fraud.
The survey also showed that more experienced marketers had a larger concern about fraud. These particular respondents may be able to identify fraud more frequently due to their dedicated marketing and analytics experience relative to more general business owners and consultants.
Ad fraud continues to significantly impact campaign performance
All respondents to the survey had direct experience managing PPC ad campaigns and most of them reported seeing a large amount of fraud.
74% of those respondents experienced more than five percent of fraud in their ad campaigns and an incredible 11% of marketers experienced greater than 25% of fraud. Even a small amount of fraud can have a tremendous impact on an advertiser’s budget and performance.
The types of ad fraud, and their marketing channels, still vary wildly
Historically, click bots were often the most commonly mentioned type of fraud, but today the survey shows “ad stacking” and fraudulent URL sources as the most common problems for PPC managers.
Click bots and “pixel stuffing” were the third and fourth most commonly mentioned and over 10% stated that competitors clicking their ads was a major problem for them.
The respondents also experienced fraud across every channel in nearly the same amount. Even newer technologies, such as over-the-top streaming TV (OTT), reported sizable issues of ad fraud. This could be due to it having less mature ad tech that creates a greater potential for exploits.
Experienced marketers use third-party software to help prevent fraud
Eliminating ad fraud entirely can be very difficult, but advertisers can rely on a few techniques to help save their budgets and improve their performance.
The first is to simply follow best practices to help identify bots, such as adding a “honey pot” to lead forms, or by frequently monitoring data from clicks, views, and leads to find irregularities and then adjusting advertising campaigns accordingly. However, these require experienced marketers to be able to identify the bad data and it can be labor-intensive to frequently monitor and take action.
Another option is to rely on anti-fraud services provided by ad networks, such as Google Ads. This can be effective; however, there is often a conflict of interest the ad networks generate revenue from each click or impression regardless if it’s fraudulent. Reducing their fraud clicks thus reduces their revenue. Some ad networks also provide very little transparency of invalid activity in their reports and then the burden can be up to the advertiser to request reimbursements if fraud is discovered.
Some ad networks, such as Google Ads, provide “invalid clicks” in their campaign reports for advertisers, but one man sued Google after allegedly discovering his invalid clicks were far greater than what the Google reports were showing.
When the survey respondents were asked if they believed Google Ads blocked click fraud, only half of the respondents, 49%, believed Google did. This should be a major consideration for advertising in 2022.
The final option is to use a dedicated, independent ad fraud detection software. There are several players on the market that can help advertisers detect, block fraud in real-time and the survey showed that about 50% of advertisers use these services, or have considered using one.
Overall, the results of this survey indicate the prevalence of fraud in advertising campaigns today is still very high. As marketers plan for 2022 they should consider taking action against this fraud to improve their ad performance and extend their ad budgets.
The Fraud Blocker survey was conducted by Pollfish and concluded on December 1, 2021. It was sent to a randomized group of PPC marketers and media buyers in the US and UK who purchased digital advertising in the prior 24 months. 200 respondents completed the survey. Pollfish is a leading survey company with a pool of over 480 million mobile audience members worldwide that participate in their surveys.
Use Customer Lifetime Value to Find More Clients
With new privacy rules continually changing the landscape of third-party data, brands are increasingly becoming more focused on understanding their current customers in order to make more sophisticated marketing decisions. One approach to this is utilizing customer lifetime value (LTV) to segment your best customers and ultimately find more of them. In this article, we’ll provide a brief outline of LTV but you’ll want to attend Hero Conf 2022 in Austin, Texas for a more in-depth breakdown with key takeaways.
What is customer lifetime value?
The lifetime value of a customer, or customer lifetime value (LTV), represents the total amount of money a customer is expected to spend in your business, or on your products, during their lifetime.
*Note on calculating LTV*
Now to be fair, there are a number of varying ways to calculate LTV going from relatively simple, to complex and complicated. This article will not be focused on evaluating the best approach or even how to calculate LTV. I do have some preferred tools which I’ll share at Hero Conf- but ultimately finding the best tool that works for your brand is important.
Large brands like Amazon and Starbucks have documented how their understanding of LTV has influenced their marketing and overall business decisions. Smaller brands who often have limited resources in their pursuit of growth often overlook LTV or don’t truly appreciate how helpful it can be to their overall growth.
Which campaign is performing better?
Take a look at the chart below – at a glance – which campaign appears to be performing better?
|Campaign A||Campaign B|
|Cost / Acquisition (CPA)||$10.00||$16.67|
Most digital marketers, including myself, would say campaign A. More purchases (revenue), lower CPC, and lower CPA. Seems pretty obvious.
But a question that’s worth asking is – what if campaign B focused on acquiring a better quality customer? Someone who purchased a higher average amount bought more frequently, and stayed, is a customer of the brand for a longer period of time. Ultimately, a customer with a higher LTV. The question of which campaign is performing better looks a lot different when LTV is factored as a metric and could lead to very different marketing approaches.
Looking beyond CPCs & CPAs
These are conversations that more brands should be having. Looking at CPCs, CPAs and the revenue from the first purchase are all very common KPIs, but they can be misleading and myopic. Factoring in LTV provides a more holistic approach to making marketing and overall business decisions.
Going a step further, brands that decide to utilize LTV often come across the hurdle of how to efficiently segment their best from worst customers. In the workshop, I’ll share the most effective analysis that we’ve found. For brands on Shopify, we’ll take it a step further and offer a valuable app that will both help solve LTV and segment your customers as well. There are a number of apps in the Shopify App Store that can help calculate your LTV and effectively segment your customers for you, but there’s one that we’ve found to be leaps and bounds ahead of the rest.
Finally, once you’ve segmented your customers, you now have the ability to supercharge your marketing efforts to find more of your best customers, while also excluding targeting anyone who you believe might be exclusively bargain hunters or cherry pickers.
If you’re interested in scaling your brand, you’ll want to attend this workshop. Understanding LTV and how to find more of your best customers will be an invaluable tool that will help move the needle for your brand in 2022. Key takeaways will be:
- How LTV has shaped the decisions of large brands we all know
- How LTV provides a more holistic picture of success within paid search
- How we’ve helped a women’s apparel and homeware brand find more of their ideal customers
- Tactical insights (including apps/tools) on how to implement an LTV strategy within paid search
Hope to see you there!
Google Deprecating Google My Business API In April 2022
THQ Nordic and Handy Games Publisher Sale is Packed with Deals
10 Creative Whitepaper Ideas To Score Big With Your B2B Audience
Google Promoting Pointy From Google In Business Profiles
Getting Started In International SEO: A Quick Reference Guide
Sand Meets Snow in Phantasy Star Online 2 New Genesis
Snapchat Publishes New Report into the Importance of Privacy Tools in Facilitating Online Sharing
11 Stunning Data Visualizations To Inspire Your SEO Reporting
New Report Underlines the Importance of Social Media in Connecting with Gen Z Consumers
Smart Shopping & Local Campaigns Being Replaced By Performance Max : New Tools
Here’s How Meta Is Changing Facebook Ads Targeting For 2022
14 Top Reasons Why Google Isn’t Indexing Your Site
Pages That Look Like Error Pages Can Be Considered Soft 404s By Google
20 Tips and Best Practices
Are Nofollow Links a Google Ranking Factor?
17 Actionable Content Marketing Tips for 2022
10 Things You Need To Know To Be Successful
How To Help Google Rank Products With Duplicate Descriptions
Google On How To Improve SEO Audits
Google AdSense Guide: increase earnings and escape low CPC
SEARCHENGINES7 days ago
Bug With Google Ads Discovery & Performance Max Campaigns & New Placement Reports
SEARCHENGINES4 days ago
67% Of Google Searches Have Duplicate Top Stories & Web Results URLs
SEO6 days ago
What Is a Google Broad Core Algorithm Update?
SEO5 days ago
Google Ads Introduces New Experiments Page
SEARCHENGINES7 days ago
Google New York City Conference Room View
MARKETING4 days ago
The Best Social Media Channels for Marketing in 2022, According to Company & Consumer Data
MARKETING3 days ago
Getting Your First 1000 YouTube Subscribers
SEO6 days ago
Google Says It’s Not Possible To Prevent Outages