Revenue Logic Questions
- Trey Salas (Deactivated)
Summary / TL:DR:
When receiving a ticket about revenue not matching in one data source versus the other it is important to note the core logic differences of how revenue is displayed in each data set. This walkthrough should hopefully help you help them understand how revenue is attributed across different data sources in ThoughtSpot.
Sales & Revenue
Cash flow based. Revenue shows on the date the transaction(s) occur.
Example – Order 123ABC is placed, paid, and refunded:
Batch Date : 6/30/21 $100
Paid Date (Gross): 7/1/21 $100
Refund Date: 8/1/21 -($100)
In this example, we would be showing revenue in three different months – June, July, August since there were three separate cash transactions (order placed, order paid, order refunded).
Marketing Performance
Analytically cohorts revenue to the date the order was placed.
Example – Order 123ABC is placed, paid, and refunded:
Batch Date : 6/30/21 $100
Paid Date (Gross):7/1/21 $100
Refund Date: 8/1/21 -($100)
With this example, if you were to look at the revenue in Marketing Performance data set it would all cohort back to June 30, 2021 for a net of $0 since that is when the order
eComm Mailing Analysis
Cohorts revenue back to the mail date of the email that the promo code was in.
Example – Order 123ABD is placed, paid, and refunded
Mail Date: 6/30/21
Batch Date : 6/30/21 $100
Paid Date (Gross): 7/1/21 $100
Refund Date: 8/1/21 -($100)
In this example, the revenue would all tie back to June 30th since that is when the promo code was mailed, the customer just placed the order at a later date, however, we tie the revenue back to the mail date of the promo.
Lead Gen (List/Lead Level)
All revenue is cohorted back to the date of the signup (be sure to use signup date as the date filter since we do also have transaction date which is the date the order occurred).
Example – Order 123ABD is placed, paid, and refunded
Signup Date: 4/25/21
Batch Date : 6/30/21 $100
Paid Date (Gross): 7/1/21 $100
Refund Date: 8/1/21 -($100)
In this example, the revenue would all tie back to April 25th since that is when the signup occurred.
In order for revenue to show in lead gen, there must be an advantage list tied to the promo code that the customer has purchased on.
IRIS
Iris cohorts all revenue back to the promo mail date, or the date the promo code was scheduled.
Example - Order 123ABC is placed, paid, and refunded:
Scheduled Date 5/25/21
Batch Date : 6/30/21 $100
Paid Date (Gross): 7/1/21 $100
Refund Date: 8/1/21 -($100)
If you were to look at the revenue in IRIS, all revenue would be tied back to May 25th since that is when the promo was first scheduled/created.
Wrap up
To recap, sales and revenue data set will display money during the month each transaction hits, marketing performance displays money back to when the order was placed, mailing data displays money based on when the mailing was sent, lead gen ties it back to the signup date, and IRIS displays money during the month the promo was scheduled.