Project Detail

Description

Hi. I have a feed of products in csv format that I need to be parsed into a csv in the format that is used in Google Adwords Editor for campaign imports.

The csv I have will containing the following fields -

Product Name
Product Price
Direct URL

An example of input and output are attached.

As well as putting the information in the appropriate format the app will also create the text each individual advert. This involves creating three lines for the adword. The first line 'Headline' can be upto 25 characters, and the following two lines can be upto 35 characters.

Within these three lines the app has to include the products name, and price and if possible pad out the rest of the space. For example, my csv contains the product and price for -

B.L.K. (Blood, Liver & Kidney) x 500 Gm
£19.98

Maybe the add created for this could be -

Buy B.L.K. Here £19.98
(Blood, Liver & Kidney) x 500 Gm
10% off first order

If the product name is long then the app will have to split it up, or if the name is short then the app will have to use something else on line 2. It would be good if the app could have some settings that I'm able to change to modify what I want on different lines.

All in all I think this should be a pretty simple app if you understand what I'm asking for.

Thanks


Additional files submitted:
input.csv
output.csv