If you’ve ever been frustrated at the amount of time you spend creating PPC reports, you’re not alone. Today, I’ll do my best to help you with a new AdWords script I just finished. The severity of the reporting problem became very clear to me at a conference I recently attended. Attendees were asked to leave sticky notes describing the most timing-consuming aspects of their jobs. I know it’s not exactly a scientific study, but I found the results fascinating anyway. Here’s what the board looked like: The orange arrows highlight each note that said “reporting” was the most time-consuming PPC task. Meetings are another time-consuming task people added to the board several times — but I’m not going to help you fix that with a script, so let me focus on reporting, a topic I’ve covered several times in recent posts here. When it comes to reporting, you should really try to produce … [Read more...] about This script automates adding any AdWords data to a Google spreadsheet
Scripts in google sheets
If you’ve kept count of how many of my posts during the past year have touched on AdWords Scripts (6 out of 16), you’ll know how useful I believe they can be to streamline repetitive tasks in AdWords. I use them all the time for accounts I manage; and without them, I simply couldn’t be as efficient as I am now. Because I’ve become so reliant on Scripts, I’ve secretly been worried that one day they might face the same fate as some other Google products that get cancelled during their annual spring cleaning. So imagine my excitement when I read the announcement from Google that AdWords Scripts are now in beta for My Client Center (MCC) accounts. It seems to have hit some critical mass to deserve this promotion to the big leagues of AdWords, the MCC interface. Below are my initial thoughts about MCC Scripts and some ways I think they can be of use. And as always, no post of mine about Scripts is complete without a juicy example, so read all the way to the end … [Read more...] about This AdWords MCC Script Will Save You An Hour Every Day!
For many of us, analyzing our AdWords data starts with downloading a massive .CSV file into Excel and running various calculations and building charts. After that, we turn into fortune tellers, trying to read the analytical tea leaves of our data and predict what changes to make. That analysis is time consuming, difficult, and biased by our personal experiences and emotions. Machine learning can help us fix that. Today, we are going to use the Google Prediction API and AdWords Scripts to predict the future. Asking For A Prediction With the Google Prediction API, you no longer need a dedicated team of PhDs to build and maintain an analytical model for your pay-per-click (PPC) data. All you need to do is format and push your data in, then ask it for a prediction. The more data you can provide, the more accurate that prediction should be. The world of machine learning seems a little daunting at first, but I’m going to give you a crash course to help you get started quickly. … [Read more...] about Machine Learning With AdWords Scripts And Google Prediction API
Ad customizers were introduced about a year ago as a way to create targeted and dynamic ads without losing their ad history. The ads are much more dynamic than the original Ad Params, since they allow you to replace more than just numbers in your ads. Of course, because they have more features, they are also a bit more complicated. Today, we are going to look at a few ways AdWords scripts can help you work with ad customizers. Hopefully, it will give you some ideas of ways you can leverage scripts to make managing your ad customizers a little easier. Quick Overview Of Ad Customizers Managing ad customizers consists of maintaining data sources and also maintaining ads. We are going to try to write some generic code to do just that. If you haven’t already, I recommend you run through this example in the AdWords Scripts documentation before you continue. Much of the code below is based on their solution but is a little more flexible (and probably more complex). Ad customizers can be … [Read more...] about Harness The Power Of Ad Customizers With AdWords Scripts
Back in October 2016, I wrote about how you can use a Python script to determine whether a page has been indexed by Google in the SERPs. As it turns out, Google's webmaster trends analyst Gary Illyes wasn't too happy with the technique that was being utilized by the script, so I cannot endorse this method: Shortly after, Sean Malseed and his team at Greenlane SEO built a similar tool based in Google Sheets (among other awesome tools like InfiniteSuggest), and Googler John Mueller expressed reservations: @greenlaneseo Is this a blackhat tool or does it abide by the webmaster guidelines & robots.txt? (just curious) - John ☆.o(≧▽≦)o.☆ (@JohnMu) December 14, 2016 How could I learn which pages weren't indexed by Google, and do it in a way that didn't break Google's rules? Google doesn't indicate whether a page has been indexed in Google Search Console, won't let us scrape search results to get the answer and isn't keen on indirectly getting the answer from an undocumented API. (That … [Read more...] about How to check which URLs have been indexed without upsetting Google: A follow-up