Top 3 Ways to Self-Automate Your PPC Account Work
July 16, 2012
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!
Hanapin's PPC Resources Are Now Ungated!
You can now access Hanapin's whitepapers and toolkits without having to fill out a form!
View Ad Creative Through The Eyes Of Your Searchers
Learn to understand that ads do not live in the vacuum of an excel sheet and common practices should be tested.
[New Webinar!] 11 Red Flags To Watch Out For When Working With An Agency
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
Leveraging Analytics For Remarketing: Picking The Ripest Fruit
Remarketing prevalence is well founded based on competitive returns in both volume and efficiency. With that said, this "low hanging fruit" world isn't always easy to pick.
How To Analyze Time-Of-Day Performance For Luxury Products
The importance of ad schedules varies across industries, services, and products. For e-commerce companies that sell luxury goods, ad schedules are more crucial.
One Week Left to Save 25% at Hero Conf London!
You still have time to join us for Hero Conf London, 24-26 October at etc.venues St Paul's at 25% off the conference price. But time is running out.
4 Common Questions Prospects Ask Me During The Sales Process
There’s always new, hot topics and questions we get asked by prospects to see what our company’s take is, and how we go about implementing from a services perspective. Read what our most common questions are.
Mobile Price Extensions Rolling Out In AdWords
It looks like "Christmas in July" has come to Google. Recently announced price extensions are designed to help mobile marketers qualify clicks and inform prospective consumers.
[New Whitepaper!] 4 Ways To Survive PPC Campaigns for the Healthcare Market...
This whitepaper will highlight four examples of how thinking at the corners can help boost your PPC performance in the healthcare industry.
Create Visually Appealing Reports With Google Data Studio
When we talk about what tasks tend to eat up a significant chunk of time, reporting is surely mentioned. You may want to explore another option - Google Data Studio.
Liveblogging 2016 DoubleClick Announcements
Today is the day we learn more about the latest DoubleClick updates. Follow along live as we share DoubleClick's announcements as well as our opinions.
The 2016 Top 25 Most Influential PPC Experts
After a month of voting, rigorous research and data analysis, we are excited to announce the wildly anticipated list of the Top 25 Most Influential PPC Experts for 2016.
[New Webinar with AdEspresso!] 4 Effective Strategies for Facebook Lead Gen...
In this new webinar, AdEspresso and Hanapin experts discuss four effective strategies to use Facebook Lead Gen Ads for your business.