I have a suite of online courses. I have students that buy my courses outright and I have students that get into the courses for free through a free coupon. My free coupons unfortunately have proliferated quite a bit around the web, so I'm considering shutting them off (not allowing any new free students).
I have a list of 12 excel sheets that are quite messy. They show my monthly revenue for ach month and they tie them to a student name.
I need someone with excel skills to calculate just how much the value of a free student is. That is to say, IF a student joins one of my courses first, how much do they on average spend on my other courses.
I run promotions bi-monthly and have a lot of cross enrollments.
You'll need to go to each excel and see the names of the free students, then compare them across the other sheets to the names of the paid students. If there are matches then calculate the amount they purchase and add that into the total average.
Attached is a sample monthly earnings report.
*Please keep in mind: there are many students that use the same name but are different people. You will need to control for this possibility and to save the datas integrity remove any names that that appear to be duplicate (ie listed as enrolled in the same course twice, either paid or free)*
We can talk in private message over more details to make sure we're on the same page.