Jun 18, 2025
Оfftopic Community
Оfftopic Community
Forums
New posts
Search forums
What's new
Featured content
New posts
New media
New media comments
New resources
New profile posts
Latest activity
Media
New media
New comments
Search media
Resources
Latest reviews
Search resources
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
OnTopic Community
MarketPlace
How do I control for spikes in sales data?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="GabeK" data-source="post: 1445629" data-attributes="member: 307503"><p>My manager periodically runs contests "stretch weeks" throughout the year in an effort to boost sales. We see a spike in sales but also a dip just prior to and after the contest. This is due to the staff holding their best leads and customer renewals for the contest week. My manager and I are in disagreement as to whether there is a benefit to continuing this practice. </p><p></p><p>I have acquired two years of weekly sales data. My question is what would be the best way to determine if we actually benefit (monetarily) from stretch weeks? </p><p></p><p>I have applied a 3 and 5 week rolling average to smooth the data, but am at an impasse as to how to take that information and say we make (or lose) $X by holding the contests. If that is even the best approach.</p><p></p><p>Your assistance is greatly appreciated.</p></blockquote><p></p>
[QUOTE="GabeK, post: 1445629, member: 307503"] My manager periodically runs contests "stretch weeks" throughout the year in an effort to boost sales. We see a spike in sales but also a dip just prior to and after the contest. This is due to the staff holding their best leads and customer renewals for the contest week. My manager and I are in disagreement as to whether there is a benefit to continuing this practice. I have acquired two years of weekly sales data. My question is what would be the best way to determine if we actually benefit (monetarily) from stretch weeks? I have applied a 3 and 5 week rolling average to smooth the data, but am at an impasse as to how to take that information and say we make (or lose) $X by holding the contests. If that is even the best approach. Your assistance is greatly appreciated. [/QUOTE]
Insert quotes…
Name
Verification
Please enable JavaScript to continue.
Loading…
Post reply
Top