An Adwords Script to Update/Add to Campaigns Based on a Spreadsheet
- or -
Post a project like this2736
$$$
- Posted:
- Proposals: 3
- Remote
- #1298242
- Awarded
Description
Experience Level: Expert
We want to utilise adwords scripts to automatically create ads based on information stored on a google sheets spreadsheet.
The ads need to include the MPN and Price, and depending upon whether the ad is 'From £X' or just '£X' needs to be included.
We have written a sort of 'pseudo code' for this:
When the script is run:
Check products in stock vs out of stock (if price is present - instock, otherwise out of stock)
If out of stock - pause all relevant ad groups (there will be 2 ad groups for each MPN and they will be called [MPN]_Exact and [MPN]_Broad and will be located within Search_Generic_Hot_Products_Exact and Search_Generic_Hot_Products_Broad)
For all the remaining MPNs:
If ad group exists and is live ([MP]_Exact and [MPN]_Broad)...
{
Where Adgroup = MPN
Update price across all three ads.
}
Else, if ad group exists but is paused
{
Update price across all three ads (where MPN = ad groups)
Unpause ad group/ads
}
Else, If ad group doesn't exist at all
{
Create 2 ad groups per new MPN ([MP]_Exact and [MPN]_Broad) and sit them in the respective campaigns - Search_Generic_Hot_Products_Exact and Search_Generic_Hot_Products_Broad.
Insert Keywords into the new Ad groups:
for the [MP]_Exact insert [MPN] as keyword (including brackets)
for the [MP]_Broad insert +MPN as keyword (including plus symbol)
Insert 3 ads into each campaign (6 total per new MPN)
If product is marked as 'Actual' in spreadsheet
Ad 1
[MPN] Only �[Price]
New With Full Warranty. Call With
Your Best Quote & We'll Beat It!
www.kingofservers.com/[MPN]
Ad 2
[MPN] Only �[Price]
In Stock For Next Day Delivery
We Wont Be Beaten On Price!
www.kingofservers.com/[MPN]
Ad 3
[MPN] Only �[Price]
Original Product With Warranty
In Stock. Buy Now For Next Day P&P
www.kingofservers.com/[MPN]
If product is marked as 'From' in spreadsheet
Ad 1
[MPN] From �[Price]
New With Full Warranty. Call With
Your Best Quote & We'll Beat It!
www.kingofservers.com/[MPN]
Ad 2
[MPN] From �[Price]
In Stock For Next Day Delivery
We Wont Be Beaten On Price!
www.kingofservers.com/[MPN]
Ad 3
[MPN] From �[Price]
Original Product With Warranty
In Stock. Buy Now For Next Day P&P
www.kingofservers.com/[MPN]
Set Adgroup bid at �1 for each.
}
The spreadsheet will be available on request/and when we decide on who will create this for us. But for reference, the sheet contains the following columns:
MPN URL Price Type Price
The ads need to include the MPN and Price, and depending upon whether the ad is 'From £X' or just '£X' needs to be included.
We have written a sort of 'pseudo code' for this:
When the script is run:
Check products in stock vs out of stock (if price is present - instock, otherwise out of stock)
If out of stock - pause all relevant ad groups (there will be 2 ad groups for each MPN and they will be called [MPN]_Exact and [MPN]_Broad and will be located within Search_Generic_Hot_Products_Exact and Search_Generic_Hot_Products_Broad)
For all the remaining MPNs:
If ad group exists and is live ([MP]_Exact and [MPN]_Broad)...
{
Where Adgroup = MPN
Update price across all three ads.
}
Else, if ad group exists but is paused
{
Update price across all three ads (where MPN = ad groups)
Unpause ad group/ads
}
Else, If ad group doesn't exist at all
{
Create 2 ad groups per new MPN ([MP]_Exact and [MPN]_Broad) and sit them in the respective campaigns - Search_Generic_Hot_Products_Exact and Search_Generic_Hot_Products_Broad.
Insert Keywords into the new Ad groups:
for the [MP]_Exact insert [MPN] as keyword (including brackets)
for the [MP]_Broad insert +MPN as keyword (including plus symbol)
Insert 3 ads into each campaign (6 total per new MPN)
If product is marked as 'Actual' in spreadsheet
Ad 1
[MPN] Only �[Price]
New With Full Warranty. Call With
Your Best Quote & We'll Beat It!
www.kingofservers.com/[MPN]
Ad 2
[MPN] Only �[Price]
In Stock For Next Day Delivery
We Wont Be Beaten On Price!
www.kingofservers.com/[MPN]
Ad 3
[MPN] Only �[Price]
Original Product With Warranty
In Stock. Buy Now For Next Day P&P
www.kingofservers.com/[MPN]
If product is marked as 'From' in spreadsheet
Ad 1
[MPN] From �[Price]
New With Full Warranty. Call With
Your Best Quote & We'll Beat It!
www.kingofservers.com/[MPN]
Ad 2
[MPN] From �[Price]
In Stock For Next Day Delivery
We Wont Be Beaten On Price!
www.kingofservers.com/[MPN]
Ad 3
[MPN] From �[Price]
Original Product With Warranty
In Stock. Buy Now For Next Day P&P
www.kingofservers.com/[MPN]
Set Adgroup bid at �1 for each.
}
The spreadsheet will be available on request/and when we decide on who will create this for us. But for reference, the sheet contains the following columns:
MPN URL Price Type Price
Jane C.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
13 Dec 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Jane, As it seems there is no movement on this one (expiring in 4 days), could you please, at least, cancel the job, so we'll get our proposal credit back. Thanks a lot, Tom
-
Hi Jane, Is the job still on? Thanks, Tom
Jane C.30 Sep 2016Hi Tom, Yes this is still on, client wanted a range of proposals/prices and we will be contacting a shortlist next week. Thanks
Tom C.03 Oct 2016Thanks for your reply.
-
Hi Jane, are you looking for a script within excel or a web-based script where you will upload the excel file and script will do the back-end processing/automation ?
Jane C.23 Sep 2016Hi, the script is to sit in adwords, and reference a google sheets spreadsheet
192711170715161963
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies