Drivers: unit_sale_price (+3%)
  
 
Overview
Week over Week: $1,126,491 for 5/13 to 5/19 vs. $1,098,609 for 5/6 to 5/12
Profit: +2.5% to $1.1M
•  Profit's increase vs. last week is a gain of $28K
•  unit_sale_price fully explains profit's increase
• Without the positive impact of this driver, profit would have been down -2% instead of up +2.5%
Profit is +$28K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
Metric
unit_sale_price
+3%+$50K+$50K
Explains +$50K
Fully explains the $28K increase
chart
Between unit_sale_price and unit_cost, unit_sale_price had a greater impact on profit.
Profit
- +2.5%
=
Sale Price
- +3%
-
Cost
- +4%
Why is profit up?
1. Metric › unit_sale_price +3%
unit_sale_price is up +3% between 5/13 to 5/19 ($1.7M) and 5/6 to 5/12 ($1.6M), resulting in an increase of +$50K.
unit_sale_price is up +$50K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
product_category
Board Game
+8.2%+$44K+$44K
2
campaign
industry_news_in_context
+11.5%+$16K+$27K
3
campaign
linkedin
+24.5%+$26K+$23K
Explains +$95K
Fully explains the $50K increase
chart
Without unit_sale_price's +3% increase, overall profit for 5/13 to 5/19 would have been down -2% instead of up +2.5%.
chart
What else is driving profit?
Underperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
product_nameScrabble-$14K-30.7%-1.2%
campaigngoogle plus-$13K-17.1%-1.2%
product_nameHungry Hungry Hippos-$13K-26%-1.2%
product_nameBarrel O' Monkeys-$13K-35.1%-1.2%
product_categoryElectronic Game-$12K-3.2%-1.1%
campaignbing ads-$11K-17.9%-1%
product_nameClue-$7,871-21.2%-0.7%
product_nameSorry!-$7,524-18.3%-0.7%
product_nameLife-$7,393-17.4%-0.7%
product_namePretty Pretty Princess-$7,281-15.5%-0.7%
campaigntwitter-$5,619-7.5%-0.5%
campaignweekly_newsletter-$5,019-6%-0.5%
Overperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
Metricunit_sale_price+$50K+3%+4.5%
product_categoryBoard Game+$25K+7%+2.3%
campaignfacebook ads+$23K+40.2%+2.1%
Metricunit_cost+$22K+4%-2%
campaignlinkedin+$16K+22.9%+1.5%
product_nameDungeons & Dragons+$16K+53.4%+1.5%
product_categorySocial Game+$14K+4%+1.3%
campaignindustry_news_in_context+$13K+13.7%+1.2%
product_nameOperation+$12K+51.3%+1.1%
sourceEmail Marketing+$12K+4.3%+1.1%
product_nameUno+$12K+37%+1.1%
product_nameBattleship+$11K+36.8%+1%
Where is this data from?
This analysis compares total profit between 5/13 to 5/19 and 5/6 to 5/12.
The following dimensions are included in analysis of potential drivers of profit:
•  product_name (e.g. "Atari 2600")
•  product_category (e.g. "Board Game")
•  source (e.g. "Email Marketing")
• campaign (e.g. "announcement_blast")
The data was retrieved using a SQL query on Mon. May 20, 2019 at 3:35am EST.
 
 
Logo
line
Build your own briefing to discover new insights