Google AdWords script to automate the stock advertising using Ad Customizer feature: fetch live data and update an ad to reflect current prices.
Please apply only if you are familiar with Google Adwords scripts and you have developed at least one project using Adwords scripts. Send me the link to the project or at least a short description of the project.
I need adwords script that pulls the stock quotes into google sheet on a daily(hourly) basis and updates the ad group ads based on updated stock data. Ads will include stock names(GOOG), current price($123), daily change (5%).
I see this task in following 2 steps:
Pull stock quotes to google sheets from reliable data source
Any given stock list (should be possible to automate)
Updated hourly, every 5 minutes etc (should be able to define the timeframe for data update)
Generate Ads Automatically based on google sheets data and update the campaign/ad groups
In my google spreadsheet I have a sample stock “GOOG” which price is $740,94, daily increase of 0.16% or $1,17. We need to update this table daily, hourly, every 15 minutes if possible.
After the update is completed the script needs to update ad group ads using the latest data.
Financial Data Feed API should be free and working 100% accurate with the live data
What you need to deliver:
Google Spreadsheet with stock data, see sample file attached.
Adwords script ready to copy/paste into my Adwords MCC.
Let me know if you have any questions,
Sample file: https://docs.google.com/spreadsheets/d/1U3yEs5aSQrUMHsSal5KkFuBtdP0-XUhq4ZD71dzb5LY/edit?usp=sharing