8 {{ upvoteCount | shortNum }}
8 {{ upvoteCount | shortNum }}

How do you calculate income per lead?

by hillbro
7 replies
I have a mailing list and I market my Teachable courses to that mailing list... I do make sales and I want to figure out how much money I am making per lead over the course of time.

I found income per lead by revenue / leads...

My question is how do you find revenue per lead over six months? Is there any good automated software that could import a CSV file and calculate this?

Suggestions? I thought about coding (vba) an Excel spreadsheet but I was wondering if there was an easier way before I did that...
#calculate #income #lead
Avatar of Unregistered
  • Profile picture of the author ProducerK
    Wouldnt you just divide your total income by the number of leads you have generated to get this number?
    Signature
    EMAIL & SMS MARKETING | DATA & LEADS SALES | SYSTEMS SETUP | EXPERT CONSULTING
    LeadsPlusData.Com | PM For Skype, Telegram, Signal, WhatsApp, And More....
    {{ DiscussionBoard.errors[11390883].message }}
  • Profile picture of the author sean1776
    Writing VBA is a good idea (if you love coding & debugging).
    But if your data has good order(like by month) in your csv,
    the value of revenue / leads over 6 months should be done easily by setting some functions (f(x)=) on other external blank cells.
    Signature
    Difficult the first time, easy the second. A beginner's guide to email marketing.
    {{ DiscussionBoard.errors[11390977].message }}
  • Profile picture of the author Shubho C
    Yes. That's true, jist divide the total sales by total leads.

    To get more in depth, you could get revenue per click by tracking clicks. Etc..
    Signature
    You Can Start Your Own Affiliate Business in 2 to 4 Hours...
    Your How-To Guide Here...
    {{ DiscussionBoard.errors[11390995].message }}
  • Profile picture of the author hillbro
    So I already got income per lead. What I was interested in was finding the average income per lead in each month (1st-6th).

    I ended up coding this in VBA. I can share if anyone is interested in seeing it.

    Sean, wait so my calculus in college was actually useful?? I never even thought of that. Can you explain a little more for me?
    {{ DiscussionBoard.errors[11391205].message }}
    • Profile picture of the author Shubho C
      Hey.. Sure, please go ahead and share it with Sean. He seems to know how to code VBA. I am sorry, I am a rookie at VBA, I only understand digital marketing.

      What otherwise I could suggest you is take the month wise data, calculate average income per lead each month simply by dividing monthly sales by monthly total no of leads.

      Now you can do the following:

      1. Plot this on a line graph and see the monthly trends. See how the sale has been growing.
      2. Calculate month on month growth rate and overall 6 months growth rate.
      3. Plot the sales on a map if you have data on the regions from where the sales are coming. This will help you geo-target your customers and focus on areas that generate more sales.
      4. See which courses are selling more. Focus on promoting those courses more/ developing similar courses.

      You can also start circulating a follow up survey asking people about what they liked in your course. This can be done a month after the course is sold to the customer.

      I see as you have people who are buying from you, definitely start email marketing. Get your customers email address when they purchase your product. There are innumerable number of benefits which come from email marketing.

      True that!!
      Signature
      You Can Start Your Own Affiliate Business in 2 to 4 Hours...
      Your How-To Guide Here...
      {{ DiscussionBoard.errors[11391371].message }}
    • Profile picture of the author sean1776
      Hi hillbro,
      Actually, Shubho's advices are very useful. Thanks Shubho.
      And about coding VBA, I hope you understand the time and effort you are going to spend in the long run.
      Anyway, if there is anything I can help, feel free to share it with me.
      Signature
      Difficult the first time, easy the second. A beginner's guide to email marketing.
      {{ DiscussionBoard.errors[11391425].message }}
  • Profile picture of the author Shubho C
    Hey Sean,

    Thank you. :-D

    Shubho
    Signature
    You Can Start Your Own Affiliate Business in 2 to 4 Hours...
    Your How-To Guide Here...
    {{ DiscussionBoard.errors[11391435].message }}
Avatar of Unregistered

Trending Topics