Drivers: unit_sale_price (-7.5%)
  
 
Overview
Week over Week: $879K for 5/8 to 5/14 vs. $963K for 5/1 to 5/7
Profit: -8.7% to $879K
•  Profit's decrease vs. last week is a loss of $84K
•  unit_sale_price fully explains profit's decrease
• Without the negative impact of this driver, profit would have been up +2.4% instead of down -8.7%
Profit is -$84K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
Metric
unit_sale_price
-7.5%-$108K-$108K
Explains -$108K
Fully explains the $84K decrease
chart
Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on profit.
Profit
- -8.7%
=
Sale Price
- -7.5%
-
Cost
- -5%
Why is profit down?
1. Metric › unit_sale_price -7.5%
unit_sale_price is down -7.5% between 5/8 to 5/14 ($1.3M) and 5/1 to 5/7 ($1.4M), resulting in a decrease of -$108K.
unit_sale_price is down -$108K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
product_category
Electronic Game
-15.8%-$79K-$79K
2
campaign
weekly_newsletter
-26.5%-$38K-$32K
3
product_name
Scrabble
-47.2%-$26K-$18K
Explains -$129K
Fully explains the $108K decrease
chart
Without unit_sale_price's -7.5% decrease, overall profit for 5/8 to 5/14 would have been up +2.4% instead of down -8.7%.
chart
What else is driving profit?
Underperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
Metricunit_sale_price-$108K-7.5%-11.2%
product_categoryElectronic Game-$56K-16.7%-5.8%
sourceOrganic Search-$37K-15.2%-3.8%
product_categorySocial Game-$27K-7.9%-2.8%
campaignweekly_newsletter-$26K-26.4%-2.6%
sourceEmail Marketing-$25K-9.8%-2.6%
Metricunit_cost-$23K-5%+2.4%
sourceSocial Media-$19K-7.9%-2%
product_nameScrabble-$19K-49.7%-1.9%
campaignyahoo-$18K-22.1%-1.8%
campaigngoogle-$17K-20.6%-1.8%
campaignbing ads-$15K-23%-1.6%
Overperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
campaigngoogle ads+$12K+22.4%+1.2%
product_nameNintendo+$7,370+30.9%+0.8%
product_nameXbox+$6,852+27%+0.7%
product_nameBattleship+$6,614+33.1%+0.7%
product_nameMad Libs+$6,510+21.1%+0.7%
campaignannouncement_blast+$6,024+8.9%+0.6%
campaigngoogle plus+$4,623+8.9%+0.5%
product_namePong+$4,299+17.4%+0.4%
product_nameDungeons & Dragons+$3,743+15.5%+0.4%
product_nameTwister+$2,659+7.7%+0.3%
campaignfacebook ads+$1,975+4.3%+0.2%
product_nameLife+$1,815+5.5%+0.2%
Where is this data from?
This analysis compares total profit between 5/8 to 5/14 and 5/1 to 5/7.
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 Sun. May 15, 2022 at 3:35am EST.
 
 
Logo
line
Build your own briefing to discover new insights