Automatically Update Text Ad Prices

[Paul 111111]

Hello there,

I am looking for a solution to a text ad update challenge.

We have thousands of text ads for products where prices of those products requires updating regularly. We are struggling to update the text ads with pricing information at the same pace that the prices are changing.

We have the ability to generate scheduled CSV downloads of product details e.g. Column 1: Product SKU code, Column 2: Price. We can do this on an hourly basis.

We can also import this data into a Google Sheet so that the data can "talk" to other Google products.

However, I am really struggling to find a solution that enables us to update prices in text ads based on that generated data.

I thought that there may be a solution that looks a bit like this:

If our original CSV download data is: Column 1: abcde, Column 2: £5.99 from spreadsheet Pricing_Update

I thought that I would be able to create a text ad that says something like:

Buy the abcde for {Pricing_Update.abcde.%Column 2]

This may be a little naive on my part. In this example I would like the value in the {} brackets to look up the abcde value in the Pricing.Update spreadsheet and return whatever the value is next to it (a bit like a VLOOKUP function).

I thought that maybe I could manipulate the data in Google Sheets where the product code (abcde) could be transposed into a column title (cell A1) and then a product price inserted beneath it (in cell A2). This way, the next product fghij could be a column title (in cell B1) with its fluctuating price in cell B2. I thought I might be able to target the column title on an ad by ad basis by targeting the column header in the Google Ad, but I'm not sure this is targetable on an ad by ad basis. 

We have a Google Shopping feed running as well. I thought that there may be a way of taking the product ID and inserting the price into the text ad that corresponds with the item ID but there seems to be no way of doing this.

I have explored the AdParams option and it appears that you can change prices based only on keywords.

I have also explored Ad Customizers and it seems you can only target the prices based on Campaign or Ad Group name.

What I am really looking for is more granular solution where I can target a specific sku code and update the price for that sku code in a text ad, but I just can't find a solution.

I hope this is clear from my explanation.

I would be most grateful if anyone can suggest a solution please.

Many thanks in advance.

Kind regards,

Paul

[Luis Xander Talag (AdWords API Team)]

Hi Paul,

Thank you for providing detailed information on your concern. If you are planning to get the product price from spreadsheet and upload it as dynamic info into an ad, then I'm afraid it is not possible in AdWords API as we do not support integration of the Google Spreadsheet. However, the closest solution we could provide to you is to use the ad customizer. 

You could use the ad customizer to add dynamic price to your expanded text ad which is a feed-based solution for injecting dynamic information into your ads. Once you set up the feed with targeting options for specific campaigns, ad groups, and/or keywords, you could then associate it with the ads with the information in the feed, so the values in the feed are shown at serve time. You may check this guide for more information and this complete sample code (also available in other languages) for reference.

Let me know if this helps.

Thanks and regards,

Luis

AdWords API Team