An Adwords Script to Update/Add to Campaigns Based on a Spreadsheet

Cerrado Publicado hace 7 años Pagado a la entrega
Cerrado 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

Google Adwords Marketing por Internet Marketing de motores de búsqueda

Nº del proyecto: #11599806

Sobre el proyecto

1 propuesta Proyecto remoto Activo hace 7 años

1 freelancer está ofertando el promedio de £350 para este trabajo

JUSTDIGITALPVT

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

£350 GBP en 30 días
(0 comentarios)
0.0