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

    New Spender data

    Megha Chhabra

      Hi,

       

      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