Drivers: Electronic Game (-8.9%), Social Media (-9.7%), Pretty Pretty Princess (-27.1%)
  
 
Overview
Week over Week: $1.0M for 7/13 to 7/19 vs. $1.1M for 7/6 to 7/12
Profit: -0.3% to $1.0M
•  Profit's decrease vs. last week is a loss of $3,514
•  Electronic Game, Social Media, and Pretty Pretty Princess together fully explain profit's decrease
• Without the negative impact of these 3 drivers, profit would have been up +6.1% instead of down -0.3%
Profit is -$3,514 because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
product_category
Electronic Game
-8.9%-$35K-$35K
2
source
Social Media
-9.7%-$28K-$20K
3
product_name
Pretty Pretty Princess
-27.1%-$11K-$12K
Explains -$68K
Fully explains the $3,514 decrease
chart
Between unit_sale_price and unit_cost, unit_sale_price had a greater impact on profit.
Profit
- -0.3%
=
Sale Price
- -1.1%
-
Cost
- -2.7%
Why is profit down?
1. product_category › Electronic Game -8.9%
Electronic Game profit is down -8.9% between 7/13 to 7/19 ($360K) and 7/6 to 7/12 ($395K), resulting in a decrease of -$35K.
Electronic Game profit is down -$35K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
Metric
unit_sale_price
-8.7%-$51K-$51K
Explains -$51K
Fully explains the $35K decrease
chart
Without Electronic Game's -8.9% decrease, overall profit for 7/13 to 7/19 would have been up +3% instead of down -0.3%.
chart
Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on Electronic Game profit.
Profit
- -8.9%
=
Sale Price
- -8.7%
-
Cost
- -8.2%
2. source › Social Media -9.7%
Social Media profit is down -9.7% between 7/13 to 7/19 ($259K) and 7/6 to 7/12 ($287K), resulting in a decrease of -$28K.
Social Media profit is down -$28K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
Metric
unit_sale_price
-10%-$44K-$44K
Explains -$44K
Fully explains the $28K decrease
chart
Without Social Media's -9.7% decrease, overall profit for 7/13 to 7/19 would have been up +2.3% instead of down -0.3%.
chart
Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on Social Media profit.
Profit
- -9.7%
=
Sale Price
- -10%
-
Cost
- -10.6%
3. product_name › Pretty Pretty Princess -27.1%
Pretty Pretty Princess profit is down -27.1% between 7/13 to 7/19 ($30K) and 7/6 to 7/12 ($41K), resulting in a decrease of -$11K.
Pretty Pretty Princess profit is down -$11K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
Metric
unit_sale_price
-26.4%-$16K-$16K
Explains -$16K
Fully explains the $11K decrease
chart
Without Pretty Pretty Princess' -27.1% decrease, overall profit for 7/13 to 7/19 would have been up +0.7% instead of down -0.3%.
chart
Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on Pretty Pretty Princess profit.
Profit
- -27.1%
=
Sale Price
- -26.4%
-
Cost
- -24.9%
What else is driving profit?
Underperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
product_categoryElectronic Game-$35K-8.9%-3.3%
sourceSocial Media-$28K-9.7%-2.6%
Metricunit_sale_price-$18K-1.1%-1.7%
campaigntwitter-$17K-21.5%-1.6%
Metricunit_cost-$15K-2.7%+1.4%
product_nameMattel Auto Race-$13K-35.2%-1.2%
campaignannouncement_blast-$11K-12.2%-1.1%
product_namePretty Pretty Princess-$11K-27.1%-1.1%
product_nameChutes and Ladders-$8,351-19.5%-0.8%
product_nameBarrel O' Monkeys-$8,019-20.2%-0.8%
product_nameBattleship-$7,184-18.5%-0.7%
sourceEmail Marketing-$6,886-2.6%-0.7%
Overperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
product_categoryBoard Game+$25K+7.1%+2.3%
campaignbing+$20K+24.5%+1.9%
sourceOrganic Search+$19K+7.1%+1.8%
sourcePaid Acquisition+$12K+5.1%+1.1%
product_nameDungeons & Dragons+$11K+38.6%+1.1%
campaignoutbrain+$8,925+15.4%+0.8%
product_nameGame Boy+$8,813+30.5%+0.8%
product_nameTwister+$7,681+21.9%+0.7%
product_categorySocial Game+$7,126+2.3%+0.7%
product_nameMonopoly+$6,829+21.8%+0.6%
product_namePong+$6,740+20.8%+0.6%
product_nameMad Libs+$5,632+17.1%+0.5%
Where is this data from?
This analysis compares total profit between 7/13 to 7/19 and 7/6 to 7/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 Sat. July 20, 2024 at 3:35am EST.
 
 
Logo
line
Build your own briefing to discover new insights