- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Promotional Analysis / Grouping Weeks / Cumulative Total
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-17-2019 06:36 AM
Hello,
I'm trying to run a promotional analysis where each customer's promotion is running at a different time frame. I will need to measure the run rate of sales for the time leading up to the promotion vs the actual promotion and see what the incremental lift was. I don't know if the best way to perform this is a formula, measure or grouping. The chart below will add some color.
While a much smaller scale this shows what I need to pull off. For example customer A, B and C all have different timings of the promotion and Customer A is running from week# 201801-201804 while Customer B may be running from week 201803-201807.
What is the best way to group customer and have essentially a time frame for the promotion and non promotion?
Any help would be greatly appreciated.
Thanks,
Garrett
Re: Promotional Analysis / Grouping Weeks / Cumulative Total
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-17-2019 10:32 PM
Hi @ggilmoreatu
I need more information.
the "POS sales" means:
whether the customer runs promotion or not, finally they will contribute such sales,
right?
But you say eg. Customer A is running from week# 201801-201804 while Customer B may be running from week 201803-201807,
if my understanding about "POS sales" is right, then "POS sales" in 201805-09 for Customer A are not for the promotion.
"run rate of sales for the time leading up to the promotion vs the actual promotion and see what the incremental lift was."
what is "actual promotion" and "rate of sales for the time leading up to the promotion"?
Best Regards
Maggie
Re: Promotional Analysis / Grouping Weeks / Cumulative Total
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-18-2019 06:09 AM
POS Sales stands for Point of Sale Sales... Meaning just sales: The toal number of sales across that given timeframe.
Yes whether the customer runs promotion or not they will have sales just in theory the promotion sales should be higher.
Yes your understanding is correct 201805-201809 for Customer A is not in the promotion.
Actual promotion is the dates listed that the promotion is running and the rate of sales leading up to the promotion would be all sales outside of the promotion (it needs to be a cummulative running total as well) in order to see the effect of the promtion vs non promotion sales.
Example: Customer A 201801-201804 = Promotion
201805-End = Non Promotion.