Drivers: unit_sale_price (+3.4%)
  
 
Overview
Week over Week: $1,032,942 for 11/12 to 11/18 vs. $1,005,217 for 11/5 to 11/11
Profit: +2.8% to $1.0M
•  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.3% instead of up +2.8%
Profit is +$28K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
Metric
unit_sale_price
+3.4%+$51K+$51K
Explains +$51K
Fully explains the $28K increase
chart
Between unit_sale_price and unit_cost, unit_sale_price had a greater impact on profit.
Profit
- +2.8%
=
Sale Price
- +3.4%
-
Cost
- +4.5%
Why is profit up?
1. Metric › unit_sale_price +3.4%
unit_sale_price is up +3.4% between 11/12 to 11/18 ($1.6M) and 11/5 to 11/11 ($1.5M), resulting in an increase of +$51K.
unit_sale_price is up +$51K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
product_category
Social Game
+6.4%+$32K+$32K
2
product_category
Board Game
+3.8%+$19K+$19K
3
source
Organic Search
+5.2%+$18K+$12K
Explains +$62K
Fully explains the $51K increase
chart
Without unit_sale_price's +3.4% increase, overall profit for 11/12 to 11/18 would have been down -2.3% instead of up +2.8%.
chart
What else is driving profit?
Underperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
campaigngoogle plus-$18K-23.3%-1.8%
product_namePretty Pretty Princess-$14K-31%-1.4%
product_nameTrivial Pursuit-$12K-32%-1.2%
product_nameLife-$11K-27.1%-1.1%
product_nameMad Libs-$11K-24.8%-1.1%
product_nameXbox-$11K-24.2%-1%
product_nameMouse Trap-$8,390-25.3%-0.8%
product_nameDungeons & Dragons-$7,684-22.5%-0.8%
campaignfacebook ads-$7,183-10.1%-0.7%
campaigngoogle-$6,967-8.7%-0.7%
campaignfacebook-$6,813-10.5%-0.7%
campaignoutbrain-$6,697-9.8%-0.7%
Overperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
Metricunit_sale_price+$51K+3.4%+5%
Metricunit_cost+$23K+4.5%-2.3%
product_categorySocial Game+$22K+6.6%+2.2%
campaigntwitter+$19K+33%+1.9%
sourceOrganic Search+$16K+7.3%+1.6%
campaignbing+$16K+23.8%+1.6%
product_nameUno+$16K+57.5%+1.5%
product_nameMonopoly+$15K+67.3%+1.5%
product_nameBarrel O' Monkeys+$13K+52.1%+1.3%
product_nameHungry Hungry Hippos+$11K+36.7%+1.1%
product_nameConnect Four+$11K+46.7%+1.1%
sourceEmail Marketing+$11K+4.3%+1.1%
Where is this data from?
This analysis compares total profit between 11/12 to 11/18 and 11/5 to 11/11.
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 Tue. November 19, 2019 at 3:35am EST.
 
 
Logo
line
Build your own briefing to discover new insights