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 <https://developers.google.com/adwords/api/docs/guides/ad-customizers#ad_customizers> .
You could use the ad customizer to add dynamic price to your expanded text ad which is a feed-based <https://developers.google.com/adwords/api/docs/guides/feed-services> 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 <https://developers.google.com/adwords/api/docs/guides/ad-customizers#ad_customizers> for more information and this complete sample code <https://developers.google.com/adwords/api/docs/samples/java/advanced-operations#add-an-ad-customizer-feed> (also available in other languages) for reference. Let me know if this helps. Thanks and regards, Luis AdWords API Team On Monday, December 3, 2018 at 1:30:28 PM UTC+8, Paul 111111 wrote: > > 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 > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/125c3066-b52f-4437-b99d-43a70ba02993%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
