In the digital marketing sphere it is so easy to get sucked into the data and feel that as long as the numbers align, then we’re doing everything that we can for our clients. Ultimately, we know that we have to build meaningful relationships with our clients if we want successful partnerships. But that's hard, especially if you're someone who feels more comfortable around pivot … [Read more...] about 5 Simple Steps To Build & Maintain Rapport With Clients
Search Results for: pivot tables
The Winner of Golden Ticket #1 is….
...Adam Garnsey (@garnsee). Congratulations Adam! Your ticket to Hero Conf London is on us. We appreciate all the folks who found Hero #1. The good news, our second hero is already flying over at HeroConf.com. That means another chance for a free ticket is now available, if you can find our hidden, golden PPC Hero (for a recap of the contest rules, please read our post … [Read more...] about The Winner of Golden Ticket #1 is….
The End of 2 Ads per Ad Group: Optimized Rotation Means More Ad Variety & Volume
The industry continues to buzz about Google’s recent announcement to simplify ad rotation settings from four options to just two: "Optimize" and "Rotate Indefinitely". These changes are to take place later this month. You may think to yourself, "Sure, that's neat but I'll continue to rotate indefinitely. I have my A/B testing routine down pat. I've been doing it this way for … [Read more...] about The End of 2 Ads per Ad Group: Optimized Rotation Means More Ad Variety & Volume
Time Saving Automation: Search Query Edition
Search Query Reports (SQRs) - you either love them or hate them. Nonetheless, they are an extremely important component of a PPC campaign. 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, … [Read more...] about Time Saving Automation: Search Query Edition
4 Forgotten Excel Tricks For PPC
If you are reading this post, it's because you know that Excel saves precious time when analyzing PPC data and you want to stay up-to-date on the latest and greatest Excel tricks. I feel the same way! The problem is that we often forget to surf the digital marketing blogs for new Excel tips because we end up spending any training time we have learning about the newest PPC … [Read more...] about 4 Forgotten Excel Tricks For PPC
March Madness Continues: What Excel Tool/Function Rules Them All?
In light of the March Madness season it was thought that we could have some fun and review some of the previous PPC Hero articles on the best ways to utilize Excel in order to more efficiently and effectively manage PPC accounts. First, let's choose the seeds for the respective functions. There are four regions just like in the real tournament for the Excel Tools/Functions … [Read more...] about March Madness Continues: What Excel Tool/Function Rules Them All?
5 Steps To Cross-Account Analysis Superhero Status
This post is part of the Hero Conf Los Angeles Speaker Blog Series. Andrew Miller will join 50+ PPC experts sharing their paid search and social expertise at the World’s Largest All-PPC Event, April 18-20 in Los Angeles, CA. Like what you read? Find out more about Hero Conf. PPC pros know how to use data to make better decisions and optimize campaigns for better results. But … [Read more...] about 5 Steps To Cross-Account Analysis Superhero Status
5 Common Excel Issues And How To Fix
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 that any text … [Read more...] about 5 Common Excel Issues And How To Fix
On Demand Webinar: How To Run An Effective Search Query Report In Less Than 15 Minutes
More about this Webinar Search Query Reports (SQRs) can be overwhelming. Downloading all of your keywords and scouring through the data associated with EVERY word in the hopes of stumbling upon one or two significant findings that MIGHT incrementally improve your account seem overwhelming and not worth the time. There’s gotta be a better way, right? The simple key: pivot … [Read more...] about On Demand Webinar: How To Run An Effective Search Query Report In Less Than 15 Minutes
[New Whitepaper!] 34 Excel Tricks To Save Your PPC Life
PPC and Excel go hand in hand. Like peanut butter and jelly. Not only will you become better at analyzing account performance, but you’ll also save a lot of precious time by becoming savvy with Excel and all of it’s features, formulas, and shortcuts. In this whitepaper, excel wizard and account analyst, Rachael Law, lists out 34 tricks to make your PPC life better. Tricks … [Read more...] about [New Whitepaper!] 34 Excel Tricks To Save Your PPC Life
How To Excel Your Search Query Reports
Search query reports are a fact of life in paid search. No matter how great your keywords are, there will always be queries that, for better or worse, don’t quite match your target. Although it’s a crucial part of account success, the web interfaces leave much to be desired. Choosing queries one by one and setting them as negative or adding them as keywords is inefficient … [Read more...] about How To Excel Your Search Query Reports
Summertime Sadness – How To Adjust For Seasonality In PPC
As we approach the summer months, many businesses are either ramping up or pulling back on PPC and other marketing efforts. It is crucial that as the agency, we fully understand seasonality and the underlying business cycles that drive these decisions. This insight helps us determine strategy and tactics to get the highest impact possible out of paid efforts. Today, we’ll go … [Read more...] about Summertime Sadness – How To Adjust For Seasonality In PPC