An Adwords Script to Update/Add to Campaigns Based on a Spreadsheet
£250-750 GBP
Pagado a la entrega
We want to utilise the adwords scripts to automatically create ads based on information stored on a 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!
[url removed, login to view][MPN]
Ad 2
[MPN] Only �[Price]
In Stock For Next Day Delivery
We Wont Be Beaten On Price!
[url removed, login to view][MPN]
Ad 3
[MPN] Only �[Price]
Original Product With Warranty
In Stock. Buy Now For Next Day P&P
[url removed, login to view][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!
[url removed, login to view][MPN]
Ad 2
[MPN] From �[Price]
In Stock For Next Day Delivery
We Wont Be Beaten On Price!
[url removed, login to view][MPN]
Ad 3
[MPN] From �[Price]
Original Product With Warranty
In Stock. Buy Now For Next Day P&P
[url removed, login to view][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 [url removed, login to view] for reference, the sheet contains the following columns:
MPN URL Price Type Price
Nº del proyecto: #11599806
Sobre el proyecto
1 freelancer está ofertando el promedio de £350 para este trabajo
Hi I just read the details regarding the project and interested in working for your project. SEO Services: 1: Find the best seo keywords for your website, business or niche and i will make sure i provide you a d Más