I am looking to have a tool developed for internal use only that will assist us in creating bulk upload sheets for our SEM accounts (Google AdWords , Yahoo Search Marketing, Bing/AdCenter).
Every day, our company releases new software products to our .com and international websites. These new software products have to be uploaded into our Search Engine Marketing accounts, which is done with bulk upload sheets.
We will have a delimited data feed of the 100 most recently published products each day, which will have timestamps that can be used to sort by most recent. This will be a file hosted on a shared internal network drive, not an XML file or something else that needs to be fed from someone else's server.
The script will read from the information in this feed (software title, pc/mac, language, etc) to create excel or csv files for search engine ads.
We will need an Access database of keywords for "mad libbing"… for example:
The Access database for English software will have keywords like “buy xxxxx”, “download xxxxx” and the script will replace xxxxx with the title of that software when building the sheet for that product.
We will also use a database for the Ad text (in the same way, "mad libbing"), so most of the actual campaign building will be simple text replacement.
Lastly, we need to store a log of which pieces of software were uploaded and when (like a changelog).
The script will create bulk upload sheets (xls or csv) and let us download them from the tool. We will upload these bulk sheets into our accounts manually, so you don't need to worry about APIs. I have examples of each of the 3 types of bulk upload sheets (Google, MS, Yahoo) I can provide for formatting guidelines.
We also have a rough mock-up as well as copies of an existing Excel macro that we are using to accomplish the same task, and we can provide these for your reference. Yes... everything I'm explaining is currently being done with a simple Excel macro, the only difference being it can only handle one product at a time.
There is additional functionality and some conditional if/else type components, language/character support, etc... but this is the bulk of what the tool will do.
The front end will be just a system of check boxes, radio buttons and text boxes.
Because the point of this is to create BULK sheets, this PHP script will need to be versatile. If the person using it selects "Japanese" as the language and both "Yahoo" and "Google" as the engines, then the script must display the Japanese-language software from the datafed, allow the user to check off which products they want, populate the components in text boxes (ad titles, bids, etc) so that we can make manual edits if needed, and then let us download a zip file of two sheets: Google and Yahoo. This is only one example for illustration.
You will be asked to sign a non-disclosure agreement, as this project will include proprietary and sensitive information regarding our company.
We are available from 9AM - 5PM Pacific time to discuss the project by email or IM once it has been awarded.
I am a beginner PHP developer and I'm pretty sure I could build this myself in under a week (just to give an idea of the scope/size of this project).
When bidding, please keep in mind that there are features not detailed here and we may ask for some revisions.
PLEASE NOTE: Although we are asking for this in PHP, we DO NOT have a MySQL database available for this. Any db-driven elements must pull from and/or write to an Access database.