Top 3 Ways to Self-Automate Your PPC Account Work
The PPC Hero blog series team decided to focus this month on automation in paid search. The rest of the week, our PPC rock stars are going to discuss true automated tools or features to make your jobs easier, but I decided to take a more abstract approach to automation and focus on how you can automate yourself to work more efficiently. For your Monday reading pleasure, I bring you the top 3 ways I automate without buying new software or opting in to actual automated features.
- To-do list like you’ve never to-do listed before. Most grammatically correct sentence on the planet? Definitely not. Accurate? You’d better believe it. When I first started managing paid search accounts, I had one to-do list for the day and that worked wonderfully. However, as I took on more accounts and other internal projects, I quickly realized my post-it method was running out of steam and I needed a more long-range strategy for keeping track of all my tasks. Reason being, not every single thing needs to be done this minute, today, or even this week. That doesn’t make those tasks less important; it just means they can wait. In the world of PPC management, that line is necessary or else we’d all go crazy. So how did I change my strategy? Multiple lists.
For instance, I have a list for today, this week, this month and one final one for general things I want to remind myself to think about, but maybe don’t have a direct task to accomplish yet. This allows me to do two things: First, I can pull tasks for today off my weekly/monthly lists and second, I can put things on my weekly/monthly lists that come up today but don’t require my attention this instant.
This keeps my list for today from getting too full, which in turn tends to result in the list not getting done and me feeling like I didn’t accomplish my goals, no matter how much I did check off the list. This strategy also ensures that I don’t forget anything that pops up within a given day.
To make your brain a little more confused, each of the previously mentioned lists have a few columns: one for account management stuff, another for sales tasks and the last for general inside projects I’m assigned to that fall in to neither category. Organizing the lists in this way helps me make sure I’m not forgetting to put on any of the hats I wear at our office.
- Excel spreadsheets and it’s formulas=your BFF. I know all PPC managers use Excel, so that’s not a secret. However, the secret comes in finding new ways to use that program to your timesaving advantage. A few sub points as examples? Why not!
- Internal/client reporting: At Hanapin, we have clients that require weekly reports and our own internal tracking reports that must be updated and/or sent to the appropriate parties. While the data being pulled and the frequency required are nothing too terrible, setting these up in Excel with formulas cuts back on the time required by a large degree. For instance, a particular in-house report we use requires spend and lead numbers for the last 7 days and month to date, but entering 4 figures pops out three times as many numbers we can analyze; projections for the remainder of the month, CPL’s, etc.
- Populating keyword lists:Keyword research is never easy, and it can be even more time consuming if you’re working with a client with a large product or services list. We’ve had great success with using the CONCATENATE function in Excel for certain clients to cut down on this task tremendously. You simply load one column of your sheet with the base keywords you need to use and another with some qualifiers. Here’s a very basic example:
- Writing ad copy within character limits:This is another template kind of idea with a character count formula to follow each line of ad text to be written, to make sure you’re maintaining the guidelines set forth by the search engines. That could look something like this:
- Make your email calendar work for you, not the other way around. This is actually a trick I use to automate the first step in self-automation. I have all deadlines, recurring tasks or meetings, and/or random to-do’s set up in my email calendar to remind me when they’re due. So at the beginning of each month, week and day, I check out my email calendar and make sure each thing that is set to alert me is funneled on to a to-do list. It’s a bit of a double check, but how can you go wrong with an extra reminder?
The secondary benefit here is that if you DO forget to pull something from the calendar and put it on your to-do list, the pop-up reminder will put it back on your radar for completion. I live by my to-do lists and I can’t count the number of times I still get ‘surprised’ by something I had flagged on my email calendar alerts, but forgot to put on my to-do list.
So how do you self-automate your PPC work, either for a client or an in-house account? Tell us all about it in the comments section below and as always, thanks for reading! Make sure you check back the rest of this week for more information on automation in PPC!
Get Your Brand in Front of Dedicated PPC Pros!
We're headed to London to join nearly 300 of our best PPC friends. And we still have a limited number of opportunities for your brand to join us!
The Top Ten Tips For Effective Dayparting
Determining your need for hour of day modifiers can provide extremely competitive returns based on time invested in implementing.
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
Should You Be Creating Device Specific Campaigns?
Creating new device specific campaigns is a lot of work and can potentially overcrowd your account. You need to determine if this tactic is right for you.
9 Hero Conf London Advanced Sessions You Can't Miss
If you'd like some more details (and we've got plenty of details), how about a rundown of the deepest, most actionable sessions you'll see. These 9 sessions are designed for the expert-level PPC professional.
Why Your PPC Account Isn’t Living Up To Its Potential
I will review common themes that I see in either prospective clients, new clients, or accounts that are red that aren't living up to their potential.
[New Webinar!] 6 Steps To An Advanced Competitor Analysis For Digital Marke...
In this new live webinar, Hanapin’s Jacob Fairclough and SEMrush’s Paul Klebanov will direct you through the process of analyzing your own account, comparing it to your competition, and taking the steps to put your brand above the rest.
5 Psychological Principles You Should Be Using In Your Marketing
I propose that knowing what your audience is thinking or even the steps in their thought process is even more beneficial than simply knowing who they are.
Add It To The List - Structured Snippets Now Available In Bing
Another item for the list of new features in Bing - Structured Snippets are now available to all U.S. advertisers, with international support already being rolled out.
Do You Want A Free PPC Hero T-Shirt?
We're conducting a brief 2-minute survey to get your thoughts and opinions. By taking the survey, you'll get entered to win a certified PPC Hero shirt! Fill out the survey by Friday, September 23rd.
4 Tips To Survive An Account Manager Change
Have you ever received a call or email from your agency that you will be getting a new account manager? The thought could be frightening, especially if you LOVE your current AM. After you take a deep breath and realize life will go on, keep...
Build Your PPC Network, One Pro at a Time!
Do you ever feel that the people who understand your role best live mostly on Twitter? Is it sometimes difficult to find those few individuals you know you can count on for the best PPC advice? We’ve got the solution for your paid search woes.
Balancing Volume, Competition, And Intent To Find The Right Keyword
Although it isn’t going to bring results as quickly as a PPC campaign (and you can even use these methods for PPC), you can’t go wrong with a good old organic traffic campaign running alongside your ads.