This assignment is to create a fully compatible data file for bulk upload into Yahoo! Sponsored Search acct
PRIOR KNOWLEDGE & EXPERIENCE WITH YAHOO! SPONSORED SEARCH BULK UPLOAD FILE FORMAT REQUIRED.
We will supply raw product data feed file in Excel format with approx 900 products.
Each product has separate row with attributes: sku, title, description, price, MSRP, discount, quantity included, image url, landing page url, shipping , etc.
We will supply "format formulas" to augment/edit each required output column in Yahoo file.
For example, product urls appended with tracking code text based on combos from data file. i.e. <http://productURLfromSpreadsheetHere> + source + sku + type + keyword
Same thing with titles & descrip:
Ad Title Text = title + certain KW's if space avail.
Short Description Text = TITLE + text + DISCOUNT% Off + TYPE + promo text.
Long Description Text = TITLE + DESCRIPTION. promo text + TITLE.
Display URL = main domain+product KW for subdomain or directory (simple standard format)
Landing Page URL's appended with tracking code text based on specific combination of variable text i.e. "&trackid=" + sku + cat + source.
Char Length to be monitored for all relevant fields in data file -- with substitution if space not available.
For keywords, we need the 15-20 variations of KW structure for each product i.e. cheap PRODUCT, PRODUCT discount, buy PRODUCT, cheap PRODUCT categoryKW, PRODUCT gift, PRODUCT discount gift, etc
File should have 1 Campaign w/ 1 Adgroup/product. Each Adgroup with 15-20 KW's generated + 3 ad variations
The final product should be fully ready to bulk upload into Yahoo! PPC acct.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
WindowsXP PC will be used to read, verify and upload file into our Yahoo! PPC account.