universo-virtual.com

buytrendz.net

thisforall.net

benchpressgains.com

qthzb.com

mindhunter9.com

dwjqp1.com

secure-signup.net

ahaayy.com

soxtry.com

tressesindia.com

puresybian.com

krpano-chs.com

cre8workshop.com

hdkino.org

peixun021.com

qz786.com

utahperformingartscenter.org

maw-pr.com

zaaksen.com

ypxsptbfd7.com

worldqrmconference.com

shangyuwh.com

eejssdfsdfdfjsd.com

playminecraftfreeonline.com

trekvietnamtour.com

your-business-articles.com

essaywritingservice10.com

hindusamaaj.com

joggingvideo.com

wandercoups.com

onlinenewsofindia.com

worldgraphic-team.com

bnsrz.com

wormblaster.net

tongchengchuyange0004.com

internetknowing.com

breachurch.com

peachesnginburlesque.com

dataarchitectoo.com

clientfunnelformula.com

30pps.com

cherylroll.com

ks2252.com

webmanicura.com

osostore.com

softsmob.com

sofietsshotel.com

facetorch.com

nylawyerreview.com

apapromotions.com

shareparelli.com

goeaglepointe.com

thegreenmanpubphuket.com

karotorossian.com

publicsensor.com

taiwandefence.com

epcsur.com

odskc.com

inzziln.info

leaiiln.info

cq-oa.com

dqtianshun.com

southstills.com

tvtv98.com

thewellington-hotel.com

bccaipiao.com

colectoresindustrialesgs.com

shenanddcg.com

capriartfilmfestival.com

replicabreitlingsale.com

thaiamarinnewtoncorner.com

gkmcww.com

mbnkbj.com

andrewbrennandesign.com

cod54.com

luobinzhang.com

bartoysdirect.com

taquerialoscompadresdc.com

aaoodln.info

amcckln.info

drvrnln.info

dwabmln.info

fcsjoln.info

hlonxln.info

kcmeiln.info

kplrrln.info

fatcatoons.com

91guoys.com

signupforfreehosting.com

faithfirst.net

zjyc28.com

tongchengjinyeyouyue0004.com

nhuan6.com

oldgardensflowers.com

lightupthefloor.com

bahamamamas-stjohns.com

ly2818.com

905onthebay.com

fonemenu.com

notanothermovie.com

ukrainehighclassescort.com

meincmagazine.com

av-5858.com

yallerdawg.com

donkeythemovie.com

corporatehospitalitygroup.com

boboyy88.com

miteinander-lernen.com

dannayconsulting.com

officialtomsshoesoutletstore.com

forsale-amoxil-amoxicillin.net

generictadalafil-canada.net

guitarlessonseastlondon.com

lesliesrestaurants.com

mattyno9.com

nri-homeloans.com

rtgvisas-qatar.com

salbutamolventolinonline.net

sportsinjuries.info

topsedu.xyz

xmxm7.com

x332.xyz

sportstrainingblog.com

autopartspares.com

readguy.net

soniasegreto.com

bobbygdavis.com

wedsna.com

rgkntk.com

bkkmarketplace.com

zxqcwx.com

breakupprogram.com

boxcardc.com

unblockyoutubeindonesia.com

fabulousbookmark.com

beat-the.com

guatemala-sailfishing-vacations-charters.com

magie-marketing.com

kingstonliteracy.com

guitaraffinity.com

eurelookinggoodapparel.com

howtolosecheekfat.net

marioncma.org

oliviadavismusic.com

shantelcampbellrealestate.com

shopleborn13.com

topindiafree.com

v-visitors.net

qazwsxedcokmijn.com

parabis.net

terriesandelin.com

luxuryhomme.com

studyexpanse.com

ronoom.com

djjky.com

053hh.com

originbluei.com

baucishotel.com

33kkn.com

intrinsiqresearch.com

mariaescort-kiev.com

mymaguk.com

sponsored4u.com

crimsonclass.com

bataillenavale.com

searchtile.com

ze-stribrnych-struh.com

zenithalhype.com

modalpkv.com

bouisset-lafforgue.com

useupload.com

37r.net

autoankauf-muenster.com

bantinbongda.net

bilgius.com

brabustermagazine.com

indigrow.org

miicrosofts.net

mysmiletravel.com

selinasims.com

spellcubesapp.com

usa-faction.com

snn01.com

hope-kelley.com

bancodeprofissionais.com

zjccp99.com

liturgycreator.com

weedsmj.com

majorelenco.com

colcollect.com

androidnews-jp.com

hypoallergenicdogsnames.com

dailyupdatez.com

foodphotographyreviews.com

cricutcom-setup.com

chprowebdesign.com

katyrealty-kanepa.com

tasramar.com

bilgipinari.org

four-am.com

indiarepublicday.com

inquick-enbooks.com

iracmpi.com

kakaschoenen.com

lsm99flash.com

nana1255.com

ngen-niagara.com

technwzs.com

virtualonlinecasino1345.com

wallpapertop.net

nova-click.com

abeautifulcrazylife.com

diggmobile.com

denochemexicana.com

eventhalfkg.com

medcon-taiwan.com

life-himawari.com

myriamshomes.com

nightmarevue.com

allstarsru.com

bestofthebuckeyestate.com

bestofthefirststate.com

bestwireless7.com

declarationintermittent.com

findhereall.com

jingyou888.com

lsm99deal.com

lsm99galaxy.com

moozatech.com

nuagh.com

patliyo.com

philomenamagikz.net

rckouba.net

saturnunipessoallda.com

tallahasseefrolics.com

thematurehardcore.net

totalenvironment-inthatquietearth.com

velislavakaymakanova.com

vermontenergetic.com

sizam-design.com

kakakpintar.com

begorgeouslady.com

1800birks4u.com

2wheelstogo.com

6strip4you.com

bigdata-world.net

emailandco.net

gacapal.com

jharpost.com

krishnaastro.com

lsm99credit.com

mascalzonicampani.com

sitemapxml.org

thecityslums.net

topagh.com

flairnetwebdesign.com

bangkaeair.com

beneventocoupon.com

noternet.org

oqtive.com

smilebrightrx.com

decollage-etiquette.com

1millionbestdownloads.com

7658.info

bidbass.com

devlopworldtech.com

digitalmarketingrajkot.com

fluginfo.net

naqlafshk.com

passion-decouverte.com

playsirius.com

spacceleratorintl.com

stikyballs.com

top10way.com

yokidsyogurt.com

zszyhl.com

16firthcrescent.com

abogadolaboralistamd.com

apk2wap.com

aromacremeria.com

banparacard.com

bosmanraws.com

businessproviderblog.com

caltonosa.com

calvaryrevivalchurch.org

chastenedsoulwithabrokenheart.com

cheminotsgardcevennes.com

cooksspot.com

cqxzpt.com

deesywig.com

deltacartoonmaps.com

despixelsetdeshommes.com

duocoracaobrasileiro.com

fareshopbd.com

goodpainspills.com

kobisitecdn.com

makaigoods.com

mgs1454.com

piccadillyresidences.com

radiolaondafresca.com

rubendorf.com

searchengineimprov.com

sellmyhrvahome.com

shugahouseessentials.com

sonihullquad.com

subtractkilos.com

valeriekelmansky.com

vipasdigitalmarketing.com

voolivrerj.com

zeelonggroup.com

1015southrockhill.com

10x10b.com

111-online-casinos.com

191cb.com

3665arpentunitd.com

aitesonics.com

bag-shokunin.com

brightotech.com

communication-digitale-services.com

covoakland.org

dariaprimapack.com

freefortniteaccountss.com

gatebizglobal.com

global1entertainmentnews.com

greatytene.com

hiroshiwakita.com

iktodaypk.com

jahatsakong.com

meadowbrookgolfgroup.com

newsbharati.net

platinumstudiosdesign.com

slotxogamesplay.com

strikestaruk.com

trucosdefortnite.com

ufabetrune.com

weddedtowhitmore.com

12940brycecanyonunitb.com

1311dietrichoaks.com

2monarchtraceunit303.com

601legendhill.com

850elaine.com

adieusolasomade.com

andora-ke.com

bestslotxogames.com

cannagomcallen.com

endlesslyhot.com

iestpjva.com

ouqprint.com

pwmaplefest.com

qtylmr.com

rb88betting.com

buscadogues.com

1007macfm.com

born-wild.com

growthinvests.com

promocode-casino.com

proyectogalgoargentina.com

wbthompson-art.com

whitemountainwheels.com

7thavehvl.com

developmethis.com

funkydogbowties.com

travelodgegrandjunction.com

gao-town.com

globalmarketsuite.com

blogshippo.com

hdbka.com

proboards67.com

outletonline-michaelkors.com

kalkis-research.com

thuthuatit.net

buckcash.com

hollistercanada.com

docterror.com

asadart.com

vmayke.org

erwincomputers.com

dirimart.org

okkii.com

loteriasdecehegin.com

mountanalog.com

healingtaobritain.com

ttxmonitor.com

bamthemes.com

nwordpress.com

11bolabonanza.com

avgo.top

{"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