{"id":3512,"date":"2014-02-26T14:30:16","date_gmt":"2014-02-26T14:30:16","guid":{"rendered":"https:\/\/cherylroll.com\/6-tasks-automate-adwords-without-scripts-tools-184902\/"},"modified":"2014-02-26T14:30:16","modified_gmt":"2014-02-26T14:30:16","slug":"6-tasks-automate-adwords-without-scripts-tools-184902","status":"publish","type":"post","link":"https:\/\/cherylroll.com\/6-tasks-automate-adwords-without-scripts-tools-184902\/","title":{"rendered":"6 Tasks To Automate In AdWords Without Scripts Or Tools"},"content":{"rendered":"

When we think about automation in PPC, our minds tend to jump to expensive tools like Marin, Kenshoo and Acquisio or advanced algorithms and Google Scripts.<\/p>\n

However, you shouldn’t let the word “automation” scare you into forgetting the simple things that make it great: speed and consistency. Today, I’m going to take you through six common PPC tasks you can do yourself for free in AdWords through the magic and wonder of automation.<\/p>\n

Search Query Reports<\/h2>\n

Working with multiple clients, there are certain tasks I want to do at least once a month — things that can be fairly time consuming and also will look amateurish if I forget to do them. Mining search queries is one of these tasks. You certainly don’t want your boss or client looking through your broad match terms and finding that your “Honda Cars” campaign has spent thousands on Honda lawnmower queries (I’ve seen it happen).<\/p>\n

With this in mind, I decided to start automatically emailing myself the data I need, saving at least 15 minutes per week, per account and much more importantly, reminding me to actually pull the reports I’m supposed to.<\/p>\n

Now, that Honda example I alluded to might be an extreme example, but consider the other end of the spectrum: a small account that hardly changes from month to month. After doing SQRs for a year, ignoring the need for them can become an easy thing to do — “I’m pretty sure there are no useless terms showing up, so I won’t check it this month” (or next month). What happens when new search trends or products start sneaking in and your own laziness has caused you to miss them? The answer is not “good things.”<\/p>\n

To create a useful and automated search term report, you need to first open up your Search Terms data from the Keywords tab by selecting “Details” > “Search Terms” > “All.” From here, apply the filters relevant to your particular account. In my case, this first report is looking for all Keywords that have spent twice my cost per conversion target without converting.<\/p>\n

\"setting\"setting<\/p>\n

Once you apply this filter (or any filter that applies to how you normally do your search query mining), click on the download button to schedule this report. I do this on the first of the month for my small biz clients and weekly on specific days for larger accounts that need checking in on more regularly.<\/p>\n

\"SQR\"SQR<\/p>\n

Rather than jump through these hoops every time, I just open Excel straight from my email, select the queries that look like they’ve wasted money or aren’t too relevant, and drop them back into the AdWords Editor as negatives.<\/p>\n

\"An\"An<\/p>\n

I call this my “money wasting terms” report. Another SQR report I email myself is “CTR killers” — a list of irrelevant search terms sorted by high impressions and a low number of clicks, e.g. clicks < 2, Impressions > 1000.<\/p>\n

Work out what you “need” to see every week\/month and set up the report. I also recommend setting up a report for “terms to add,” which might look something like: Conversions > 2, Added\/Excluded matches “None.”<\/p>\n

Automated Bid Changes<\/h2>\n

There are plenty of ways to automate bid changes that don’t involve paying any money to anybody (other than our good friends at AdWords). You could just use the Google Conversion Optimizer<\/a>, and I’ve seen good success from it on larger campaigns.<\/p>\n

However, for smaller campaigns or accounts without conversion tracking, automated bid rules can save you a ton of time as long as you make sure to check in on them.<\/p>\n

\"A\"A<\/p>\n

I have one client whose ads perform way better in position three than any other position — it seems to be the sweet spot of conversion rate and cost.<\/p>\n

For them, we have a relatively simple automated bid strategy set up, which utilizes two rules running concurrently. The first increases bids every day on keywords that have an average position less than 3.2 (with a max bid set to avoid things getting out of hand). The second rule runs exactly the same way but bids keywords down 5% that are higher than position 2.5.<\/p>\n

\"A\"A<\/p>\n

There are lots of options out there for automated bid adjustments. For accounts without conversion tracking, you could try bidding down all keywords with bounce rates way above your average.<\/p>\n

\"Rules\"Rules<\/p>\n

You can overlap a lot of these different bid rules to build a system that is much more robust and complex than could be done manually, and without wasting a lot of time. Make sure any overlapping rules make sense and aren’t causing anything crazy to happen (use min and max bids if worried).<\/p>\n

Changing Ad Status<\/h2>\n

For offer-based ads, try using “Enable ads when…” and “Pause ads when…” from the “Automate” button within your ads tab.<\/p>\n

I have a client who shows different messaging based upon the day of the week. During the week (Mon-Thurs), they run weekday package specials and for Fri-Sun they have ads showing their weekend pricing. I can automate to pause my weekday ads and unpause my weekend ads on Thursday night and vice versa on Sunday night.<\/p>\n

The same thing can be equally useful for one-time events like pausing holiday specific ads. Nothing looks worse than ads where the content has expired — “Great Xmas Deals” tends to lose impact in February.<\/p>\n

\"An\"An<\/p>\n

Dimensions Reports<\/h2>\n

Ever been in a meeting with your boss\/client and have them ask something like, “Which countries are we selling well in?” or “How’s our traffic from tablets doing?”<\/p>\n

These are the kinds of questions that, when answered quickly, show that you’re on the ball with your account — allowing you to send out exactly the kind of positive “this guy knows what he’s doing” vibes you want to be oozing with. They’re also the kind of questions for which I all too often have to stumble and say, “Err, I’ll get back to you on that.”<\/p>\n

There are loads of these different insights you probably want to schedule for yourself:<\/p>\n