Hi, I need a program to convert a csv file of keywords, urls and google adwords ads to a csv file that I can import to yahoo search marketing and microsoft adcenter
The program should be a simple windows form application done in c#.
## Deliverables
Hi, I need a project to convert a csv file of keywords, urls and ads to csv file that I can import to yahoo search marketing and microsoft adcenter
The program should be a simple windows form application done in c#.
The current csv file has the following relevant columns
keyword, url, position, adtitle, adline1, adline2, adurl, volume, cpc and a few more columns that are not relevant
Form Details:
1. In the form I should be able to either select the the csv file or or paste in a csv file in the required format.
2. Url Input: I then want to be able to add to the url field on the front and back. It should be a textbox where I would write something like "[login to view URL]{url}&a=1
where {url} is the original url in the csv file.
3. I would also like to have the option specifiying the cost per click field. I will either specify a new cpc value or specify a multiplier. For example if the multiplier was .5 then that would be mutiplied against the current cpc for each record to get the cpc value.
4. Select either Adcenter or Yahoo output
5. Either output to new csv or to textbox that can easily be copied.
CSV Processing:
The program will have to a little work processing the csv. The url field needs to be stripped to the base url.
It also needs to check for escaped " in the ad text.
[login to view URL] (needs to be unicode text)
I have attached a copy of what the first entry from [login to view URL] should look like in the [login to view URL] file
Yahoo Form Values (I skipped ones that can be blank)
Campaign: from windows form
Ad Group: keyword
Component: Ad Group, Ad, Keyword depending on value
Component Status : On
Display Status : Active
Keyword: keyword
Sponsored Search Bid (USD) : cpc value for Ad Group and Default for Keyword
Sponsored Search Status : "On" for Campaign and Ad group Component
Match Type : Advanced
Content Match Status : "Off" for Campaign and Ad group Component
Ad Name: keyword with no spaces
Ad Title: adtitle
Ad Short Description :adline1 + adline 2
Display URL : adurl
Destination URL: url with from windows form
Watch List: Off
[login to view URL]
See sample. need to have 3 lines for each keyword for the 3 types of match (broad, phrase, exact)