A deep dive into how to look at audiences, ad copy, and data over time through quick and easy Excel pivot tables.
Continue Reading A Deep Dive Into Advanced Pivot Tables for PPC
Pivot Tables
How to Pivot Paid Search Data in Excel
Create Pivot tables to analyze how campaigns are performing across different marketing platforms, campaign type, and client-specific goals.
Free PPC Training for the Noobs at Your Agency
Hero Academy offers short, entry-level how-to training videos for marketers new to paid media at no cost. Perfect for an employee that just started working at your digital marketing agency.
Continue Reading Free PPC Training for the Noobs at Your Agency
4 Forgotten Excel Tricks For PPC
Learn four easy-to-use, Excel tricks that will save you time doing PPC analysis. Tips include a keyword building tool, custom keyboard shortcuts, and more.
How To Evaluate Your PPC Ad Rotation Settings
Learn what options you have for PPC ad rotation and how to quickly identify opportunities.
Continue Reading How To Evaluate Your PPC Ad Rotation Settings
How To Excel Your Search Query Reports
Search query reports are a fact of life. No matter how great your keywords are, there will always be queries that don’t quite match your target.
Easy-To-Build Pivot Tables For Quick SQRs
Search Query Reports (SQRs) can be overwhelming. Learn how to use pivot tables in Excel to complete an SQR in under 10 minutes.
Finding Ad Copy Significance Levels Through Excel Testing
Constantly testing new copy in order to improve performance is very helpful. Excel can be utilized in order to help with ad copy testing.
Continue Reading Finding Ad Copy Significance Levels Through Excel Testing
Pivot Tables Made Easy: The Last Demo You’ll Need
The more PPC managers I’ve gotten to know, the more I realize that all nerds are not created equal. We talk of Analytics and Excel, and we use the term “pivot tables” a lot. And if you’ve ever tried and...
Continue Reading Pivot Tables Made Easy: The Last Demo You’ll Need
How Your Average CPC is Lying to You
“Averages lie.” I had a few statistics courses back in college with a professor who was fond of saying that. Seems like he might’ve gotten that turn of phrase from someone else, now that I think about it. This is...
Turn A Lazy AdWords Report Into A Money Making Tool
As PPC Heroes, we like to think we’ve got all sorts of magic stuffed up our sleeves. Truth be told, there are plenty of approaches we use that may be less common to the outside world. That’s why this week’s...
Continue Reading Turn A Lazy AdWords Report Into A Money Making Tool
Do Long-Tail Keywords Matter in PPC?
One of the trickiest decisions in building out new campaigns in your account is how in depth you need to get with your keyword build out. On the one hand, building out every conceivable search term into its own exact...
