I’ve said it before and I’ll say it again: PPC enthusiasts are often Excel nerds . But if you’re just starting off down the road of mass data analysis, Microsoft Excel can be a little daunting. The secret is that once you know a handful of tricks, it become pretty easy to figure out how to make Excel work for you, instead of becoming a source of insecurity and stress. The … [Read more...] about Beginner Excel: 10 Must-Haves for PPC Newbies
Search Results for: pivot table
The 4 Common Keyword Mistakes
There are hundreds of tasks you can complete in a PPC account. There are just as many mistakes you can make, if not more. Today we’ll focus on four mistakes regarding keywords. This is in no way a comprehensive list but gives the four most common areas that must be examined to keep an account running well. Targeting Too Broadly Broad match keywords are vital in finding good … [Read more...] about The 4 Common Keyword Mistakes
Nail Down A Mobile Strategy In 5 Simple Steps
Question: Do you have a solid mobile strategy in place for your PPC efforts? If not, you should carve out some time to think about it and nail down an action plan to capture this ever-growing market in the PPC space. We’ve talked about micro-moments and what that means for advertisers, but we didn’t really talk about the specifics of putting together an overall strategy. … [Read more...] about Nail Down A Mobile Strategy In 5 Simple Steps
[On Demand Webinar!] 11 Excel Tricks To Improve Your PPC Life
PPC and excel are like peanut butter and jelly or macaroni and cheese, you really can’t have one without the other (or at least its not as good a combination!). By becoming super savvy with excel, you’ll save a lot of precious time doing your PPC tasks and overall, become better at analyzing account performance. In this webinar, we’ll cover a variety of tricks that can have big … [Read more...] about [On Demand Webinar!] 11 Excel Tricks To Improve Your PPC Life
Are You Maximizing Your Revenue? Impression Share Reporting in Excel
Lost Impression Share Due to Rank - The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor ad rank. This seems to be a very important metric. Especially when talking about the top performing keywords in your account. So, why is it so underutilized? A lot of the paid search community has appeared to put all their eggs in the … [Read more...] about Are You Maximizing Your Revenue? Impression Share Reporting in Excel
3 Ridiculously Awesome Resources To Prevail Over Excel
PPC and Excel go hand in hand. Like peanut butter and jelly. Or macaroni and cheese. Or tortilla chips and salsa. Ok, you get the picture. Basically, you can't (and shouldn't) do one without the other. We know how important Excel is to you, as well as the many struggles and time sucks you encounter in PPC. So, we've put together a number of resources (ridiculously awesome … [Read more...] about 3 Ridiculously Awesome Resources To Prevail Over Excel
My Top 10 Favorite Paid Search Tools
There are lots of tools that assist us in our paid search efforts. Below I have compiled a list of my favorite paid search tools. Each has its own reason for making “my favorite” list. Some have saved the day, others I use on a daily basis, and others are simply fun tools to use. 1) Conversion Optimizer or CPA Bidding For me, conversion optimizer gets on the list, because … [Read more...] about My Top 10 Favorite Paid Search Tools
Using Auction Competitors To Tell a Business Story
Are we seeking out as much volume from paid search as we should be? Why is cost per click and cost per acquisition increasing? At what point are we just spending more money for the same number of sales? Everyone is telling me that competition has increased. Where’s the proof? How do I know you don’t just have a bad bidding strategy? These are common questions that I … [Read more...] about Using Auction Competitors To Tell a Business Story
Save Time On Tactical PPC Work
After you do all of the hard work analyzing your account, you’re going to need to implement some changes. Whether it’s bid changes, new campaigns, or pausing keywords; getting into your account and optimizing can be a time suck. Tasks To Do Yourself Excel Templates - Excel is a huge part of our day-to-day tasks when it comes to PPC, so you might as well accept it and become … [Read more...] about Save Time On Tactical PPC Work
Finding Ad Copy Significance Levels Through Excel Testing
Ad copy testing is a crucial part of paid search that often gets overlooked. Constantly testing new copy in order to improve performance is very helpful. Excel can be utilized in order to help with ad copy testing. If the test is being ran across multiple ad groups, the best route to take is to utilize the labels function within Adwords. You can select which ads you … [Read more...] about Finding Ad Copy Significance Levels Through Excel Testing
Webinar: 11 Excel Tricks To Improve Your PPC Life
More about this Webinar PPC and excel are like peanut butter and jelly or macaroni and cheese, you really can't have one without the other (or at least its not as good a combination!). By becoming super savvy with excel, you'll save a lot of precious time doing your PPC tasks and overall, become better at analyzing account performance. We cover a variety of tricks that can … [Read more...] about Webinar: 11 Excel Tricks To Improve Your PPC Life
Don’t Forget The Basics! Audit Your Account – A New Case Study
As an Account Analyst, Account Managers usually come to me with some sort of problem. Sometimes it’s “I’d like to brainstorm strategy” and other times it’s “we need to improve ROAS as quickly as possible.” Not being the Account Manager gives me a fresh set of eyes on an account. I found in the past that when I was struggling with a problem on my own account, it was mainly … [Read more...] about Don’t Forget The Basics! Audit Your Account – A New Case Study
