UPDATE 2016-01-26: In response to some common issues, this script has been updated to include some enhancements. Please see the change log notes for v1.2.
As a follow up to my questions about cool scripts for Black Friday / Cyber Monday, today I put together a script to run through your urls and check if the item is out of stock on the website. If it is, we will pause the AdGroup.
This script has some of the same elements of my script on checking for broken links in your account, but it actually pulls the html source of each page and searches for a configurable string that lets it know when it is out of stock.
Let's walk through an example. I love some of the quirky gifts I find on ModCloth.com. But like any online store, some items go out of stock. Here is one I found while testing this script.
Alright, so now I know what text I need to use to fill in the OUT_OF_STOCK_TEXT variable in my code. Now each site is going to be a little different, so I have a simple script that uses the same url logic as the complete script that you can use for testing.
Once you find some HTML text in the source of the landing page that identifies if an item is out of stock, you should be good to go on the full script. There are a few other options in the script that allow you to enable or disable various url manipulations in the script. And remember, this will pause only the Ads or Keywords that link to the page with the out of stock item.
Wednesday, October 30, 2013
Monday, October 21, 2013
Black Friday is quickly approaching for retailers in the United States. I have some ideas for ways that you can automate your campaigns using AdWords Scripts, but I'd love to get your thoughts on some of them. Here's what I can think of. Please comment with the ones that you'd like to see most.
- Countdown Script - Similar to this script from Google but read the information from a Google doc and add support for timezones.
- Add Pricing, Inventory, and percent discount to Creatives - Use a Google Spreadsheet to update prices and inventory for your items. That info will be read by the script get updated in the Ads hourly.
- Automatically Pause Ads as Items Go Out of Stock - This script will monitor your landing pages and pause the ads once it sees that the item is no longer in stock.
- Update Mobile Modifiers and Location Modifiers for Retail Locations Throughout the Day - This script would start with a boost to specific location and mobile modifiers for your campaigns and then slowly ramp them back down throughout the day. Set the end time and it will automatically calculate the ramp down.
Those are just a few ideas I had. Do you have a better idea? Would you like to see one of the scripts above? Let me know by leaving a comment. I'll implement the winner by the end of October.