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 … [Read more...] about 6 Things You Didn’t Know You Could Do In Google Sheets
Search Results for: account+structure
How To Use The AdWords Keyword Planner
Building a new PPC campaign from scratch can be challenging. You can easily miss keywords or add keywords without search volume. Plus, even if you have a great list of keywords, it can be challenging to organize them into tightly themed groups. Using AdWords Keyword Planner can be an excellent way to get started in building out your next campaigns. Where to Find the Keyword … [Read more...] about How To Use The AdWords Keyword Planner
How To Better Organize Your Shopping Campaigns: Brand vs Non-Brand Segmentation
When I first pondered the notion of branded and non-branded Shopping campaigns I was a little skeptical. I wouldn’t necessarily describe myself as a perfectionist, or even a control freak; however, I’ll take a thorough initiative where I’m in the driver’s seat 10 times out of 10. Shopping campaigns, in general, are somewhat out of our complete control, so adding another level … [Read more...] about How To Better Organize Your Shopping Campaigns: Brand vs Non-Brand Segmentation
Extracting Text in Excel for PPC
Working with text data is a necessary part of analysis but often overlooked in skill development. This leaves gaps in analysis and adds time and tedium to common tasks. Your ability to work and manipulate text greatly enhances your workflow and effectiveness. Splitting keyword, ad text, or campaign structure allows you to gain deeper insights and find new patterns. Too … [Read more...] about Extracting Text in Excel for PPC
4 Tips For Troubleshooting PPC Performance
“Why is PPC performance so different from August to September?” These are the kinds of questions, that left unchecked, can send me into a bit of PPC whirlwind. My instinct is to jump to the “what”. What we will do to fix the problem. That feels easier than sifting through columns of data, trying to piece together a story. So, if you, like me, are unsure of where to start, … [Read more...] about 4 Tips For Troubleshooting PPC Performance
4 Quick Steps to Create Your Mobile App Strategy
There are several questions I get asked when advertisers or businesses are thinking about starting new mobile app campaigns. Just like paid search, it’s important to start your campaigns with a goal in order to measure value and success. Creating your mobile app strategy can be overwhelming. However, these 4 steps should help you when planning your strategy. 1. Know your … [Read more...] about 4 Quick Steps to Create Your Mobile App Strategy
Coffee Talk: Catching Up With Hanapin’s PPC Experts
It is Friday morning. Secret Jake and I walk to a little coffee shop just a block away from our office. We order Guatemalan pour-overs (we are fancy like that). We find a table and sit down only to discover it is wobbly. But we don’t move. For some reason, I feel like sitting and drinking coffee at a wobbly table is just what we need to properly talk PPC. A woman makes her way … [Read more...] about Coffee Talk: Catching Up With Hanapin’s PPC Experts
The Ultimate Guide to Google Ads Quality Score 2024
A comprehensive explainer guide to Google's Quality Score Everyone is familiar with the Quality Score available for individual keywords in your Google Ads account – this is the visible keyword-level Quality Score. What a lot of people fail to recognize, is that there is more at play here than meets the eye. Most of the time, you can’t solve a Quality Score issue with just … [Read more...] about The Ultimate Guide to Google Ads Quality Score 2024
Using Google Sheets as a Script Controller
Today we’re going to use Google Sheets as a control center of sorts for AdWords Scripts. The Sheets interface allows users to make adjustments via a spreadsheet rather than through the code itself. This method not only makes changes easier to implement but empowers less technical users to harness the power of scripts. In this article, we’ll cover an example use case then go … [Read more...] about Using Google Sheets as a Script Controller
All You Need to Know to Succeed With CPA Bidding
For a newer article on this topic visit: Google Ads Target CPA Bidding: Benefits & Drawbacks Using CPA bidding is like living with an unpredictable pet. He’s as likely to bite your guest’s hand as he is to be a saint. There are mixed feelings about using Target CPA bidding. But there’s one big question: are there enough benefits to CPA bidding to … [Read more...] about All You Need to Know to Succeed With CPA Bidding
Bing Exact Match Close Variant Update and Beyond
In an effort to help advertisers reach more customers, Bing shows ads for close variations. Close variants can include singular and plural forms, abbreviations, misspellings, punctuations, word blending, accents and stemming. This can help in not only driving additional clicks where the customer intent is the same, but also save you time by not having to build and manage the … [Read more...] about Bing Exact Match Close Variant Update and Beyond
You may be a potential nightmare PPC client if…
These kinds of posts are always dangerous. I try to avoid them, to be honest, because it's difficult to walk the tightrope of tact and truth. You either end up sounding like a giant jerk that hates everyone, or you fearfully dance around feelings so much that you don't ever really say what is on everyone's mind. The purpose of this post is not simply to gather … [Read more...] about You may be a potential nightmare PPC client if…
