MUST SIGN NON DISCLOSURE AGREEMENT to get job. This will be customer data and must be held in strict confidence.
I have roughly 30,000 customer records. These records need to be cleanly organized for marketing purposes into the following:
- First Name
- Last Name
- email address
- City, State, Country, Zip Code
- Vehicle Year
- Vehicle Chassis code according to enthusiast jargon (will require research and automotive knowledge)
- Vehicle Make
- Vehicle Model
- Vehicle Sub Model
- Vehicle transmission
- Vehicle drivetrain
- Vehicle engine
-- Many of these records will not have all of this information, though will have some of it.
-- Research will need to be conducted to find chassis codes when the year, make and model is provided.
-- All terminology will need to be consistent with that found on www.AWE-Tuning.com (e.g. 2.0L Turbo will need to be called "2.0T," "AWD" on an Audi will need to be called "Quattro" etc.
Final output, a clean excel or CSV sheet.