It comes as no surprise to most of you, but we get a lot of mileage out of Excel in PPC. Seeing as how the AdWords and Bing Editors are capable of accepting spreadsheet uploads, and how each interface can turn out roughly a billion Excel-based reports, it doesn't hurt to brush up on your Excel skills from time to time. While every function listed here isn't always useful 100% … [Read more...] about 6 Excel Tricks to Save Your PPC Life
Search Results for: pivot tables
4 Easy Ways to Watch Your Account Without Going Crazy
Whenever I talk to people about PPC and what I do, I'm always quick to mention the paradoxical nature of the job. It requires you to be "patiently urgent" - always balancing your immediate deadlines for implementing new ads/keywords or making changes to meet your performance goals... then waiting to watch the results of your work come in, and determining your next steps once … [Read more...] about 4 Easy Ways to Watch Your Account Without Going Crazy
3 Crucial Ways To Look At Day-Parting Data
PPC Hero is a great resource for PPC newbs and PPC vets alike. We throw around a lot of lingo and acronyms, as well as methods and strategies that may be uncharted to some you. Day-parting is a perfect example of a common piece of analysis used by PPC Heroes everywhere that requires an extra step in how you evaluate your data. What is day-parting? This refers to the … [Read more...] about 3 Crucial Ways To Look At Day-Parting Data
One Month-In: The Ultimate AdWords Optimization Checklist
Our friend Andrew Lolk has written some great posts about key AdWords optimizations you should be considering during the first month of your account. The info was so great, in fact, that White Shark Media made an info-GRAPHIC (see what we did there?) out of it. Andrew's original posts are great reads for new accounts, so check them out here, and scroll down for the full … [Read more...] about One Month-In: The Ultimate AdWords Optimization Checklist
Facebook Reports Get an Extreme Makeover
Facebook has finally decided to make our lives in the PPC world a little easier for a change with the recent updates to the Reports in the Facebook Ad Manager. Facebook now allows you to select all the columns you want including: ad performance, spend, URL conversions, unique clicks, unique click through rate (CTR), cost per unique click, cost per 1,000 people reached, and … [Read more...] about Facebook Reports Get an Extreme Makeover
This 15 Minute Excel Macro Provides Granular Search Term Data
It's series week on PPC Hero and we continue our run-down of time-saving techniques we've adopted in the past 12 months. This week Eric has already looked at building out your account, Carrie has dived into quick and dirty quality score techniques, and Sam showed you the ten minute 'sense-check' audit. Today, I'll be showing you how to analyze every word of every search term … [Read more...] about This 15 Minute Excel Macro Provides Granular Search Term Data
Save Time With The Ten Minute PPC Audit
It's series week on PPC Hero and we continue our run-down of time-saving techniques we've adopted in the past 12 months. This week Eric has already looked at building out your account and Carrie has dived into quick and dirty quality score techniques. Today we're going to look at the ten minute 'sense-check' audit. ---- A well-researched, in-depth audit of a PPC account can … [Read more...] about Save Time With The Ten Minute PPC Audit
Has Modified Broad Match Effectively Killed Phrase Match?
I've been creating a lot of campaigns lately between getting new clients, standard keywords research for existing clients, and existing clients getting new products or running sales on seasonal products. With a tight deadline on these campaign builds, I've found myself wondering why I should even bother with phrase match keywords. See, I build my campaigns by match type. I … [Read more...] about Has Modified Broad Match Effectively Killed Phrase Match?
New Keyword-Level Impression Share Data: Hot Tips For Boosting Performance
Google has just announced the release of Search Impression Share data at the keyword level! Our search for tools that allow for the most detailed analysis has reached another mile marker. This will allow us to change our approach to impression share metrics (and the leveraging thereof) Quick glance at what this means, exactly: We are looking at our individual keyword … [Read more...] about New Keyword-Level Impression Share Data: Hot Tips For Boosting Performance
5 Things To Improve AdWords Performance In Under 60 Minutes
Many of us don’t have the time to always be checking our AdWords accounts. I’ve lately talked to many new Clients in White Shark Media who actually dreaded going in and optimizing their AdWords accounts because they felt they had to spend several hours in order to get anywhere. Even though nothing replaces time well spent optimizing an AdWords account, sometimes the best way … [Read more...] about 5 Things To Improve AdWords Performance In Under 60 Minutes
Three Ways to Account for Mobile Traffic in a Post-Enhanced World
For this month’s series on PPC Hero, we’re taking a look back through our archives and revisiting some ideas we’ve talked about in the past and how the past year or more has changed our thinking about them. Things are always changing in PPC, and our views and opinions about it are no exception. Just over one year ago I wrote a post entitled You’re Closer to Being … [Read more...] about Three Ways to Account for Mobile Traffic in a Post-Enhanced World
Case Study: Do People Actually Click Sitelinks?
A little while ago I wrote a post about how much I liked the new features that Enhanced Campaigns brought to Sitelinks. Today I'm going to dive into the newly available Sitelink statistics and see if we can learn something about the impact they have on your user behaviour. There are really two things we want to know: Do Sitelinks work and how well? Do people actually … [Read more...] about Case Study: Do People Actually Click Sitelinks?
