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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
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/64c1b192-da4c-4f78-a5dd-a9b694628807%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
