Drivers: unit_sale_price (+3.7%)
  
 
Overview
Week over Week: $1,140,401 for 6/20 to 6/26 vs. $1,097,928 for 6/13 to 6/19
Profit: +3.9% to $1.1M
•  Profit's increase vs. last week is a gain of $42K
•  unit_sale_price fully explains profit's increase
• Without the positive impact of this driver, profit would have been down -1.7% instead of up +3.9%
Profit is +$42K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
Metric
unit_sale_price
+3.7%+$61K+$62K
Explains +$62K
Fully explains the $42K increase
chart
Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on profit.
Profit
- +3.9%
=
Sale Price
- +3.7%
-
Cost
- +3.4%
Why is profit up?
1. Metric › unit_sale_price +3.7%
unit_sale_price is up +3.7% between 6/20 to 6/26 ($1.7M) and 6/13 to 6/19 ($1.7M), resulting in an increase of +$62K.
unit_sale_price is up +$62K because:
Percent
Change
info
Independent
Impact
info
Incremental
Impact
info
1
product_category
Electronic Game
+11.3%+$60K+$60K
2
source
Paid Acquisition
+13%+$49K+$25K
3
product_name
Pong
+54.4%+$26K+$15K
Explains +$100K
Fully explains the $62K increase
chart
Without unit_sale_price's +3.7% increase, overall profit for 6/20 to 6/26 would have been down -1.7% instead of up +3.9%.
chart
What else is driving profit?
Underperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
campaigngoogle-$22K-18.2%-2%
campaignindustry_news_in_context-$19K-18.1%-1.7%
product_nameConnect Four-$15K-33%-1.4%
sourceOrganic Search-$9,654-3.3%-0.9%
product_nameLife-$9,474-21.6%-0.9%
product_nameBattleship-$9,427-23.6%-0.9%
campaigngoogle plus-$9,101-11.1%-0.8%
product_nameAtari 2600-$8,535-19.4%-0.8%
product_nameHungry Hungry Hippos-$7,265-16.9%-0.7%
product_nameDungeons & Dragons-$5,628-12.5%-0.5%
product_categorySocial Game-$4,194-1.1%-0.4%
product_nameGame Boy-$4,003-11.3%-0.4%
Overperformers
ColumnDriverAbs. ChangePct. ChangeOverall Impact
Metricunit_sale_price+$62K+3.7%+5.6%
product_categoryElectronic Game+$38K+10.9%+3.5%
sourcePaid Acquisition+$35K+14.2%+3.2%
campaignweekly_newsletter+$23K+28.5%+2.1%
Metricunit_cost+$19K+3.4%-1.7%
product_namePong+$18K+57.4%+1.7%
campaigngoogle ads+$17K+32.1%+1.6%
product_nameOperation+$17K+56.7%+1.5%
product_nameRock 'Em Sock 'Em Robots+$16K+56%+1.4%
product_nameRisk+$15K+48.2%+1.3%
campaigntwitter+$13K+20.1%+1.2%
campaignbing+$11K+13.3%+1%
Where is this data from?
This analysis compares total profit between 6/20 to 6/26 and 6/13 to 6/19.
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. June 27, 2019 at 3:35am EST.
 
 
Logo
line
Build your own briefing to discover new insights