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!
Browse By Category
The PPC Newsflash: Take Advantage of the New Google Text Ad Changes
In this podcast, Hanapin experts Matt Umbro and Jeff Allen discuss the new Google Ads update, how it will affect the PPC industry, and give you ways you can take advantage of this extra ad space.
LinkedIn Ads: How Videos are Performing
LinkedIn’s release of video ads gives advertisers an opportunity to test the informational power of video in a B2B focused environment.
Amazon Updates Seller Central & AMS Campaign Manager Features
Amazon is back at it again with more updates to the campaign manager on both the Seller Central advertising platform and Vendor Central AMS platform.
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
The PPC Newsflash: Exclude Your Ads from Mobile Apps in the GDN
When we heard the news about the targeting changes, our analysts got to work...and we have a solution!
The Missing Ingredient to Your PPC Strategy: Non-Branded Campaigns
Learn how to employ a non-branded campaign strategy that will increase traffic, capture new customers, and beat the competition.
Is AI the Secret to Google Ads Success?
Stay in the running with your competitors on Google Ads, but don't stop there! Conquer them!
Load More »