Drivers: unit_sale_price (-11.4%)
  
 
Overview
Week over Week: $874K for 9/9 to 9/15 vs. $983K for 9/2 to 9/8
Profit: -11% to $874K
•  Profit's decrease vs. last week is a loss of $108K
•  unit_sale_price fully explains profit's decrease
• Without the negative impact of this driver, profit would have been up +6.1% instead of down -11%
Profit is -$108K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
Metric
unit_sale_price
-11.4%-$168K-$168K
Explains -$168K
Fully explains the $108K decrease
chart
Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on profit.
Profit
- -11%
=
Sale Price
- -11.4%
-
Cost
- -12.3%
Why is profit down?
1. Metric › unit_sale_price -11.4%
unit_sale_price is down -11.4% between 9/9 to 9/15 ($1.3M) and 9/2 to 9/8 ($1.5M), resulting in a decrease of -$168K.
unit_sale_price is down -$168K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
product_category
Board Game
-17.4%-$86K-$86K
2
source
Social Media
-17.3%-$66K-$80K
3
source
Email Marketing
-11.5%-$45K-$26K
Explains -$192K
Fully explains the $168K decrease
chart
Without unit_sale_price's -11.4% decrease, overall profit for 9/9 to 9/15 would have been up +6.1% instead of down -11%.
chart
What else is driving profit?
Underperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
Metricunit_sale_price-$168K-11.4%-17.1%
product_categoryBoard Game-$60K-18%-6.1%
Metricunit_cost-$60K-12.3%+6.1%
sourceSocial Media-$42K-16.6%-4.3%
sourceEmail Marketing-$31K-12%-3.2%
sourcePaid Acquisition-$27K-10.7%-2.7%
product_categorySocial Game-$25K-7.5%-2.5%
product_categoryElectronic Game-$24K-7.4%-2.4%
campaignlinkedin-$20K-30.5%-2%
product_nameNintendo-$19K-46.8%-1.9%
campaignoutbrain-$18K-25.7%-1.8%
campaignbing-$16K-19.8%-1.6%
Overperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
campaignyahoo+$15K+21.4%+1.5%
product_nameScrabble+$8,837+35.8%+0.9%
product_namePretty Pretty Princess+$8,143+31.9%+0.8%
product_nameMemory+$7,297+25.6%+0.7%
product_nameTwister+$6,810+24.5%+0.7%
product_nameDominoes+$5,758+21%+0.6%
product_nameRisk+$4,827+20.7%+0.5%
campaigngoogle ads+$4,195+8.3%+0.4%
product_nameGame Boy+$2,756+9.2%+0.3%
product_nameBarrel O' Monkeys+$2,382+9.2%+0.2%
product_nameXbox+$2,086+6.6%+0.2%
product_nameConnect Four+$1,242+4%+0.1%
Where is this data from?
This analysis compares total profit between 9/9 to 9/15 and 9/2 to 9/8.
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 Thu. September 16, 2021 at 3:35am EST.
 
 
Logo
line
Build your own briefing to discover new insights