I have a suite of online courses: www.udemy.com/user/evankimbrell
I recently ran a survey to get a better idea of who my customers are: https://drive.google.com/open?id=10CKYnes6tcYGFxCLYxTQUBB4vu1HPpY7Vy_k75ZxuTk
Unfortunately, I was only able to ask the users if they paid full price, discounted price, or enrolled for free.
I have 15 excel sheets that list out all of my course sales with matching user names. I need you to match the sales forms to the survey respondents and assign 5 values to each of them. In the revenue reports, each sale will be tagged as either "Organic", "Affiliate", "Instructor Promotion" or "Ad Program". I'll need the number for each sale of each kind for the user and a total.
There are some things to keep in mind:
1) Users typed in their names, so they might not match exactly with the name on file. You'll need to do your best at connecting the names
2) There may be duplicate user names. Check to see if they submitted the form twice or that there are simply two users with similar names
3) If you can't find a user, leave it blank. Do not count it as 0.
I need someone who can start working on this today and not require a lot of oversight.