1 2 Previous Next 15 Replies Latest reply on Apr 27, 2017 11:18 AM by Megha Chhabra

    New Spender data

    Megha Chhabra



      I have a purchase dataset for my application. It has data for all my purchasers.


      I am trying to calculate my new spender revenue for a particular time frame.


      New Spender is a person who made their first purchase in that period.


      Question: New Spender Weekly Revenue


      Week 1: April 3-April 9

      Week 2: April 10-April 16


      So for my Week 1 , I would have the revenue from all the users who made their first purchase in april3-april 9 but i want their total revenue for april3rd-9th and not just the revenue from my first purchase. Similarly for Week 2 Revenue from users who made their first purchase between april 10-16.


      Please find attached the sample data.

        1 2 Previous Next