PPC Experience: Necessary or Not?

In many careers, the longer you’re at it, the better you get. Think about teaching or coaching, for example. First-year teachers can be downright scary to parents, because they lack experience and may not know how to handle tough classroom situations. The same thing goes for customer service. I worked in customer service for 4 years, and I definitely got better at it the longer I did it.

But what about in PPC? After all, the only constant in the PPC world is change. Knowledge you had yesterday can be obsolete tomorrow – just look at what Enhanced Campaigns did to device-specific campaigns. So does experience matter?

Jeremyah Grigery posted that very question on PPC Chat this week:

Grigery
A flurry of fascinating conversation followed, with most contending that experience counts in many ways. Although performing actual PPC tasks may not require years of experience, knowing what tasks to perform does.

I believe that experience counts for a lot in PPC. Knowing the history of PPC helps veteran PPC’ers come up with workarounds in situations like Enhanced Campaigns – because in the early days, we had to use a LOT of workarounds! I like how Julie Bacchini put it:

Bacchini
A lot of people also talked about having general business savvy, which is something else that comes with time. We often find that junior staff (and this goes beyond PPC to all areas of the agency) are not experienced in dealing with clients, so they struggle with it. Let’s face it – client communication is a learned skill. When I first came to the agency world in 2007, I had a lot to learn, despite working in customer service for much of my career and in PPC for 5 years. So if you’re dealing with clients at all, experience definitely matters.

In fact, life experience helps – and that’s true of any job. Susan Wenograd said it best:

Wenograd
In fact, experience dealing with change is super important in PPC, as Tamsin Mehew points out:

Mehew
I’ve worked with people over the years who were very resistant to change. Any time a new process was put in place, they complained and resisted it. I’ve even dealt with a few people like this in the time I’ve done PPC, although they’re usually not fellow PPC’ers, but rather people in support roles. Nonetheless, learning to adapt to change makes a difference, so if you’ve had experience with it before, it’ll likely be easier to swallow.

So if you’re new to PPC or only have a year or two of experience, does that mean you’re doomed? Absolutely not! Willingness to learn, combined with a curious and positive attitude, is a good recipe for success in PPC. Some skills can be learned faster than others. I’ve found that daily PPC management tasks are easier to grasp, while dealing with clients and giving presentations are harder and take longer to master. But that’s a generalization: I’ve known people who were great with clients but shaky on the day-to-day. As with all things PPC, it depends!

Did you see the discussion about PPC experience on PPC Chat? What do you think? Does experience matter? Share in the comments!

Related Posts:

Think You’re Cut Out for Being A PPC Manager? Take This Quiz

So you wanna be a PPC manager. Do you think you can bring the goods? Here’s a quiz to see if you’re cut out for PPC:

1. You’ve run into a problem on the job that has you stumped. You:
a. Ask your boss for help
b. Look up the answer online
c. Move on – it’s probably not that big of a deal

2. You’re reading a book or article and you see a word or phrase that’s new to you. You’re not sure what it means. You:
a. Keep reading, making a note to ask someone about it later
b. Stop reading and dig out your smartphone to search for more information
c. Who has time to read?

3. At the weekly staff meeting, the boss announces that the entire office is being remodeled and all the desks will be moved around, creating a new seating arrangement. You:
a. Go along with it, but cringe inside at the thought of sitting next to people you don’t know well
b. Embrace the change, even though it may be challenging at first
c. Complain! Who needs the disruption of yet another office move?

4. You’re having trouble finding the answer to problem you were working on in Question 1. You:
a. Keep doggedly running Google searches in hopes of eventually finding the answer
b. Go to an online forum, discussion board, or Twitter and ask your question there
c. Fuhgeddaboudit

5. You’re talking to a colleague who doesn’t know a lot about your job, and they’re asking a lot of questions. You:
a. Answer them as quickly as you can
b. Patiently explain the concept in layman’s terms, pausing to check for understanding
c. Tell them to ask someone else

6. You’re at an amusement park with your best friend. He or she is bugging you to ride the latest thrill ride. You:
a. Hesitate, feeling the need to research the ride first
b. Run ahead to get in line for the ride
c. Tell him or her no thanks, it’s not your type of ride

7. Your boss has given you a new assignment, something you haven’t done before. You:
a. Ask a lot of questions, and check in with the boss daily for reassurance
b. Map out a plan, get the boss’s ok, and run with it from there
c. Ask the boss to assign the work to someone else

If you answered mostly B, congratulations! You’re ideally suited to be a PPC manager. The best PPC managers love to dig for the solutions to tricky challenges. They are constantly hungry for learning something new, and aren’t afraid to test it out on their own PPC account. They persist until they find out why performance has fallen off. They embrace change – let’s face it, PPC is a daily dose of something new! They love a new challenge and taking risks. And they’re patient, because most people don’t understand PPC. Whether you work in an agency or in-house, you’re going to have to explain what you do on a regular basis. And good PPC managers know when to ask for help, turning to the fantastic PPC community for help.

If you didn’t score well, don’t despair! You’ve just identified the areas you’ll need to work on in order to succeed as a PPC manager. (Although if you chose mostly C’s, you might want to consider an alternate career path.)

What about you? What traits do you look for when hiring new PPC managers? What do you still need to work on? What’s your favorite aspect of being a PPC manager? Share in the comments!

Related Posts:

PPC and Content Marketing: Audience Research

In an earlier post, I talked about the 4-step content audit, which helps marketers identify what content they have. Once you’ve finished your audit, it’s time to do some audience research.

Audience research in content marketing is as important as keyword research in search PPC. Audience segments will form the basis for your content marketing PPC campaigns.

The first step in researching your audience is to talk to your client, or your sales team if you’re in-house. Ask them about their ideal prospect: what job level they hold, what they like to do, what they’re passionate about, what need they are trying to fulfill.

If you want to get really granular, create marketing personas for your audience. It sounds hokey, but naming each segment of your customer base helps visualize your customer’s needs.

Once you have a good idea of who you’ll be marketing to, it’s time to jump into the engines. It’s easiest to do audience research in the social PPC platforms: Facebook, LinkedIn, and Twitter.

Facebook is probably the first engine that comes to mind when thinking about audiences as opposed to keywords. Facebook targeting focuses primarily around interests and interest groups. A typical Facebook audience for a construction company might look like this:

facebook segment

If you’re a B2B advertiser, or are looking to target individuals associated with companies or job types, LinkedIn is ideal:

linkedin targeting

And with Twitter, you can target individual Twitter handles. It’s a little tougher to find users on Twitter, but if you know the companies or type of individuals you want to target, it’s not too bad.

While you’re doing your content marketing audience research, think outside the box. What do your users like to do? If you’re selling organic food, for instance, you might target those who are interested in environmental issues like recycling and green energy. They might be interested in your competitors – consider creating a segment targeting the competition’s fans! For B2B, targeting fans of industry conferences or trade shows is a good bet. Get creative!

Don’t forget about PPC keywords. Frequently, you’ll want to have a search campaign in addition to social campaigns. Remember, users may see you on a social channel, and then turn to a search engine for more information. Try to use keywords from the content itself, especially if you use product names, buzzwords, or themes in your content. Definitely include branded terms in your research as well. You might even consider keywords like “Company X Facebook” to reach those who saw your ads there.

Once you’ve identified your audience, think about how you want to segment them. This is where your content audit comes into play. Sometimes the segmentation will be obvious: if you have some content for architects and some for builders, separate your audiences that way.

Other times, though, it may not be so simple. In those cases, I often start with a larger audience initially. Then, I watch performance and segment based on that, rather than on audience attributes. Play around with your audience segments and test, test, test!

Audience research can be much more time-consuming than keyword research. But make sure to invest the time. Your content marketing PPC campaigns will be more successful with good audience research.

For some great tips on audience research and getting super-creative, I highly recommend Marty Weintraub’s book, Killer Facebook Ads. It’s a fun read and has some incredible tips on finding prospects with creative audience segments.

Got any killer audience research tips? Share in the comments!

Related Posts:

5 Resources For Mobile PPC

Recently, I had the pleasure of appearing on my good friend David Szetela’s recently revived podcast, PPC Rockstars. We chatted about many things: my band geekiness, speculation on Google’s upcoming April 22 annoucement, and much more. You can check out the episode in the Webmaster Radio archives here (it should be live later today).

We talked a lot about mobile PPC and what advertisers should be doing with mobile. Listen to the episode for many of our expert tips. Here are a few additional resources that you can use to help you on your journey to mobile PPC success.

Generating Local Business Beyond the Click on Web Marketing Today. I wrote this piece geared toward small local businesses who think PPC is too expensive or too expansive for their business. Yes, local businesses can succeed with PPC! This article will show you how.

5 Critical Factors for Optimized Mobile PPC Targeting by Joe Kerschbaum over at Search Engine Watch. Joe offers a rundown of best practices for any mobile PPC advertiser.

B2B Search: It’s Time To Go Mobile by me, again at Search Engine Watch. I’ve found that many B2B advertiser have been slow to embrace mobile. This article talks about why B2B needs to get on board with mobile PPC.

Do Mobile PPC Ads Even Work? by Dan Shewan at WordStream. This info-packed post, complete with awesome screenshots and illustrations, shows exactly how to get your mobile ads to perform well.

If you haven’t gotten on the mobile PPC train yet, these articles are your ticket!

What about you? What are your favorite tips and success stories for mobile PPC? Share in the comments!

Related Posts:

The History of PPC

Once in a while, it’s good to look back on where we came from. I didn’t start out in PPC – in fact it didn’t exist when I started working. My PPC career began in 2002 when Google announced the CPC version of Adwords.

But the history of PPC, surprisingly, doesn’t start with Google. It started with GoTo back in the late 1990s. GoTo turned into Overture, and then Yahoo bought them in 2003.

Recently, some of us on PPCchat started a new hashtag, #ppctbt. It’s an homage to Throwback Thursday, but specifically related to the history of PPC. It’s been fun to reminisce about all the retro PPC engines that aren’t around anymore: FindWhat, LookSmart, Kanoodle, Enhance, and many more.

Back in the day, when I did in-house SEM and CPCs were a lot lower, I tested so many of these early engines. We tested FindWhat (so-so), LookSmart (decent), Kanoodle (not good), Enhance (pretty bad), Findology (not good, although shockingly, they still exist – which I didn’t realize until today!), and Quigo (which wasn’t bad, although time-consuming to manage).

It’s so funny to look at that list and realize that I was actually able to manage all of those engines and not lose my mind! Although, if you think about it, today isn’t that different. We just have Facebook, Twitter, and LinkedIn instead of Kanoodle and FindWhat.

In those early days of history, PPC was so new that there was only a small group of professionals doing it. We hung out on search forums like IHelpYou, Search Engine Watch, and High Rankings, sharing tips and asking questions. In those days, I learned so much from Danny Sullivan, Andrew Goodman, Jill Whalen, Brad Geddes, Kevin Lee – and many others who’ve since left the SEM field.

It’s interesting to look back and see how much the space has changed. We didn’t have Twitter in 2002; in fact, the Search Engine Watch forums didn’t exist in 2002, and SES had just started (I’m still getting used to calling it ClickZ Live, folks). Few blog posts on PPC strategy existed. We learned by trial and error. It was great!

Lest I sound too much like PPC Moses, I’ll just say that it’s fun to see the industry evolve. PPC is both easier and harder than it used to be: easier, because the engines have improved so much usability-wise; and harder, because the competition is so fierce. 10 years ago, I wouldn’t have dreamed of paying more than $2-$3 per click; now, $20-$30 CPCs are common.

But I wouldn’t change it for the world. It’s been a great ride so far!

What about you? What do you remember about the history of PPC? When did you get your start? Share in the comments, or on Twitter using #ppctbt – you don’t have to wait till Thursday to chime in!

Related Posts:

6 Ways To Spot Bad PPC Advice

This has been the week for bad PPC advice around the web. First came yet another New York Times article filled with small business owners whining that Adwords doesn’t work. We’ve been down this road before with NYT, so I won’t go into it here. You can read my rant about their last article to see how I feel about that.

On the heels of that foolishness came this gem from WhiteShark Media. I got skeptical when 3 paragraphs in, it starts talking about a 40% conversion rate. If you’re getting a 40% conversion rate from PPC, you shouldn’t be writing blog posts – you should be figuring out how to spend as much as you can on PPC.

But I digress. This article was full of so much bad that I can only conclude it was written as linkbait. Let’s rebut each piece of bad advice.

It tells you to spend more money.

You know it’s a wrong-headed article when the first “tip” for improving PPC results is “increase your bids and budget.” Was this article guest-written by Google? That’s always Google’s first “optimization” recommendation, and it’s not a good one.

Now, if you indeed are getting a 40% conversion rate (ha ha), and you’re making a profit on those conversions, then you should absolutely spend more money. But if you’re not, then a safer approach is wiser. Spend what you can afford, and work to optimize every aspect of your campaign: keywords, ad copy, landing pages, etc.

It tells you to geotarget the world.

The advice to “target more geographies” is mind-boggling, frankly. Unless you started using PPC in only a small area to test the waters, you should never expand to other areas without a clear expansion strategy.

For example, if you are a small local business, you should only advertise in the areas near you. Running ads in California if you’re a small clothing store in Michigan makes no sense whatsoever. Same thing goes for national advertisers. Unless you’re equipped to sell to other countries, don’t do it!

Bottom line, you should only invest in the areas that fit your business strategy.

It recommends using broad match.

I have seen countless small businesses who say that Adwords doesn’t work. When I dig deeper, I find that they’re bidding on the broadest possible terms: broad-matched “women’s clothing” and the like. I don’t recommend that strategy for my largest, deepest-pocketed advertisers, much less most PPC clients. It just doesn’t make sense. Instead, you should use exact and phrase match terms, and modified broad match if you need to cast a wider net.

Now, if your search volume is very low, you may want to add a few more broad terms. But this needs to be done carefully and measured closely.

It suggests adding high-volume keywords.

The article advises finding keywords with high search volume. While I don’t think every advertiser should avoid high-volume terms, advertisers need to proceed with extreme caution. Have a plan in place when you add a high-volume term. Put it in its own ad group, or even its own campaign. Be sure to have realistic budget caps in place. And watch it like a hawk. It might work for you – but it might not. I’ve seen a single keyword spend 4 or 5 figures in a single day. Can you afford that kind of risk?

It says to focus on short-tail keywords.

Using short-tail terms, as the article advises, is usually not a good idea unless your budget is very large and you have an awareness strategy in place. Short-tail terms rarely convert well, and often have very competitive bids. You’ll be duking it out with everyone else who sells “women’s clothing” – and unless you’re a major national retailer, you probably can’t compete.

By sticking to longer-tail terms, you’ll moderate traffic and have a much better chance of driving conversions.

It says to include appealing promotions.

OK, the last bit of advice I actually agree with. Ad copy should contain language that compels qualified users to click. If you have a strong promotion running, use that. Focus on the unique benefits of your product or service. Include a sense of urgency (“Limited Time!”) and a strong call to action (“Buy Now!). Test different elements of your ad copy to see what works best.

A word of caution about promotions: Think long and hard before making promotions a part of your marketing strategy. While promotions can and do drive sales and profits, some businesses end up relying on deeper and deeper discounts to acquire customers. This becomes a race to the bottom and can hurt sales in the long run.

Remember, any time you see an article that equates “grow your business” with “spend more money,” be afraid. Be very afraid.

Did you read the NYT and/or the WhiteShark posts? What do you think? Share in the comments!

Related Posts:

Reader Poll: PPC Topics for 2014

Thanksgiving was last week, and people are still thinking about what they’re thankful for. I’m thankful for a lot of things: my family, my awesome job, my Michigan State Spartans, and much more.

I’m also very thankful for you, my blog readers. Without you, I’d be, well, talking to myself. Many of you I’ve never met; many others I have met in real life and we’ve become friends. Whichever camp you fall into, thank you.

Now is your chance to tell me what PPC topics you’d like to hear more about in 2014. Answer the poll below and let me know!

Got something special you’re thankful for? Share in the comments!

Related Posts:

The Top 3 PPC Engines That Don’t Want My Money

Here it is – the post I’ve been threatening to write. In today’s online advertising world, it seems as though new social media platforms are sprouting every day, and adding an ad network at the same time. Advertisers are excited about testing out new platforms like Promoted Pins and Instagram Ads.

Most of the new platforms’ ad interfaces are awful. Even some stalwart PPC engine interfaces are awful. Now it’s time to name names. Here are the top 3 PPC engines that don’t seem to want my money.

#1: LinkedIn Ads

I work at a B2B-focused agency, so naturally many of our clients are interested in LinkedIn ads. We’ve had good luck with LinkedIn – the nice thing about advertising with them is that if you reach just a handful of people in your key target audience, the ads pay for themselves. As a result, clients who try LinkedIn are often eager to spend more money once they see the results.

And what a challenge it is to spend more money. LinkedIn’s advertising interface has countless shortcomings, and they’re detailed in this wonderful post by Merry Morud over at aimClear, so I won’t rehash most of them here.

I have to mention the timeout issue, though. The LI interface times out after about 5 minutes, even if you are working in it. Yes folks, you can be in the middle of adding companies to a campaign (one by one, because there is no bulk upload), and then it times out. It’s enough to make me take my money and go someplace else, like Facebook which never times out.

The icing on the user interface disaster cake is that LinkedIn’s CPCs are well above industry averages. The minimum CPC on one of our campaigns is $4.00 – because we excluded entry-level people. LinkedIn, please take some of that exorbitant CPC you’re charging and use it to overhaul your interface.

#2: Twitter Ads

In Twitter’s defense, their ad platform is fairly new. They haven’t had a lot of time to work out the bugs. Also, audience data is limited to 140 characters – so it’s no easy task to achieve laser-focused targeting.

Still, Twitter Ads leaves so much to be desired. For one thing, their reporting is TERRIBLE. It took me about a week to even find out where to download a custom report.

Imagine you’re new to Twitter. Where would you go to download a report?

twitter report

I see the “CSV” button, but it’s not clear that that’s the button you click to customize your report. Even at that, the available stats are very limited.

The thing is, if I can’t download detailed results data, I can’t optimize the campaign. If I can’t optimize the campaign, I’m not inclined to keep spending money there.

Another big downfall of Twitter ads is the lack of dayparting. Businesses often want to promote tweets during business hours, not at 2am when Twitter is full of drunk college students. Want to do that? No can do.

Limited options mean limited spend, Twitter.

#3: Facebook Ads

I realize I praised Facebook Ads earlier in this post. They have many, many positive features.

The constant changes to their ads interface are not on that list.

Merry Morud strikes again with a nice comment on the latest changes:

FB ads

(Side note: If you want a good laugh, go read the whole conversation, especially Andrew Goodman’s response. You won’t be disappointed.)

I had the same challenge as Merry with updating URLs. Like most FB advertisers, to create new ads I duplicate ads and then edit them. I tried this in Power Editor, but it wouldn’t let me edit the destination URL. All I was doing was updating the Google Analytics tag – I wasn’t changing the URL itself. And what if I did want to change the URL? So what? Why can’t I do that, Facebook?

If I can’t track it, I can’t optimize it. If I can’t optimize it… You know the rest.

Honorable Mention: Bing Ads

Sorry Bing – I have to put you guys on the list for the recent login fiasco. You did not win friends and influence PPC’ers with that move. I was thisclose to pulling every dime out of Bing when I couldn’t log in.

Thankfully, the issue was resolved and we’re back to seeing the good results we normally do with Bing. I get that there were security issues, but this was not the way to handle them – especially when so many people are reluctant to use Bing due to low traffic.

I find it interesting that Google is all too eager to take our money (case in point: their “optimization” suggestions that equate to “increase your bids” – I just got one of these from them today), and yet their competitors throw up roadblock after roadblock.

Are they competitive with Google? Hardly. I’m not sure they want our money.

What do you think? Do you agree with my list? Got someone to add? Share in the comments!

Related Posts:

Why Agencies Need Better PPC Support

There has been a lot of chatter in the PPC community recently about Google Adwords support, or lack thereof. I’ve written more than my share of rants on the topic. It’s no surprise that Google would bear the brunt of PPC pros’ frustration – after all, they are the market leader and therefore are the platform we all use every day.

But step back from your daily annoyances and think about the big picture that is Google Adwords. They actually have built a decent platform for agencies, with MCCs and sub-MCCs. They have Adwords Editor. They have Google Partners.

I know Google Partners is nothing to write home about. But have you tried working in any of the social PPC platforms? Tried contacting their PPC support team? Gotten any nice gifts from them?

I thought so.

Here’s the thing. Agencies handle many (not all, but many) of the large PPC accounts out there. We are frequently the ones getting advertisers to try new things like Pinterest Ads. It behooves the search engines to give us the support we need to spend our clients’ money!

I’m sure that many of the questions crossing the desks of the engines’ PPC support staff are basic, and likely come from mom and pop advertisers trying to do PPC themselves. So why should the PPC engines offer any support to agencies when our numbers are relatively small? Isn’t general support enough?

No. And here’s why.

We are not beginners.

Sure, agencies hire new PPC staff all the time, and frequently these new hires have no experience with PPC. The fact of the matter is, though, the newbies aren’t always the ones calling Google or Bing for help. In the agency world, many of us who call are very experienced in PPC. Experienced PPC’ers see support calls as a last resort. We’ve already exhausted all other resources, including reading the help files and tinkering with the interface ourselves. We’re stuck, and that’s why we’re calling.

Therefore, we need dedicated PPC support staffers who are experienced themselves. This is where Bing really shines. We have a dedicated team at Bing, and they are experts. They are not the latest new hires cutting their teeth on the 1-866 number. They get that we get it, so on calls we dispense with the basics and talk strategy; and when we have a problem, they don’t read us the help files – they go in and fix it.

That’s what we want from you, Google – and from all the rest of you: Facebook, LinkedIn, Twitter… LinkedIn only offers support via email, and I don’t think Facebook or Twitter offer it at all. So when we do have a question or something isn’t working, guess what? We often pull our money and spend it elsewhere.

We handle multiple clients.

Like I mentioned earlier, Google is the leader by a long shot in making it easy to work with multiple clients. Bing has gotten better, but their MCC-equivalent leaves a lot to be desired. Facebook has a decent interface for multiple accounts – and they have Power Editor which is awesome. But their reporting is pretty terrible, and both the online UI and Power Editor are glitchy at times.

LinkedIn? Well, they sort of have an MCC but its usefulness is totally overshadowed by the fact that their ads interface times out after about 5 minutes.

A few weeks ago, I was creating a campaign for a client who wanted to target 100 companies. After painstakingly spending an hour entering each company one by one (since LI has no bulk upload function whatsoever), I hit “next” and got the login screen. Thankfully, LI did save my work – but why give people that heart attack?

Agencies are in PPC interfaces all day. Don’t time them out! Facebook and Twitter never time out on me, and neither does Google. Bing only does after several hours of inactivity. C’mon LinkedIn – if you want agencies to spend money with you, don’t force them out of the ads interface every 5 minutes.

I joked on Twitter a while back that I was going to write a blog post called “The Top 3 PPC Engines That Don’t Want My Money.” Let’s hope we get some fast improvement, or I may yet write that post.

What do you think? Is agency PPC support just a pipe dream for all but the largest spenders? Found a way to get better support? Share in the comments!

Related Posts:

The Top 5 Ways To Use Pivot Tables For PPC

PPC managers live in Excel. We use it for everything from keyword research, to ad copy creation, to results data crunching. We love Excel so much that a recent PPC Chat discussion centered on it.

Pivot tables are one of the most powerful features of Excel. I discovered the magic of pivot tables fairly recently – I started using them in earnest about 3 years ago. Once I got the hang of them, I wondered why I’d waited so long to use them.

If you’re not using pivot tables to manage PPC, it’s time to start! Here are 5 resources that will help you get started.

Ultimate Visual Guide to Pivot Tables for PPC Data by Mark Jensen at Get Found First.  This is your starting point for learning how to set up pivot tables. You’ll want to bookmark this fantastic resource as you’re learning how to use pivot tables for PPC.

The 10 Reports that Made Me Fall in Love with Pivot Tables by Sean Quadlin at PPC Hero. Sean walks through 10 ways to use pivot tables to analyze your PPC data. If you’re trying to figure out exactly what’s going on with your PPC account performance, try running some of these analyses using pivot tables.

Wasting Money In Your PPC Accounts? Pivot Tables Are Here To Help! by Dave Rosborough at PPC Hero. If you’re a visual learner, check out this how-to video. Dave does a nice walk-through for using pivot tables to figure out where you’re losing money in your PPC campaigns.

Brad Geddes Presents: How to Identify Google AdWords Quality Score Problems by Brad Geddes for PPC Hero. My good friend and PPC Moses Brad Geddes has a guest appearance at PPC Hero with a video on how to use pivot tables to analyze quality score. I first learned about this technique from Brad at HeroConf 2012, and I’ve used it ever since to optimize PPC quality score.

How To Manage Big Data with Pivot Tables by the brilliant Annie Cushing at Search Engine Land. If you’re having trouble with Excel, head over to SEL and read some of Annie’s posts. She’s probably the top expert on Excel in the SEM field. This post is a how-to, complete with screen shots, on culling insight from large data sets using pivot tables.

I use pivot tables weekly, at minimum. My favorite way to use pivot tables for PPC is for ad copy analysis. Finding the best-performing ad is easy with pivot tables.

What’s your favorite way to use pivot tables for PPC? Share in the comments!

Related Posts: