|
Week over Week: $1,051,461 for 10/15 to 10/21 vs. $1,122,236 for 10/8 to 10/14 | Profit: -6.3% to $1.1M |
|
|
Profit's decrease vs. last week is a loss of $71K | |
unit_sale_price fully explains profit's decrease | | Without the negative impact of this driver, profit would have been up +3.9% instead of down -6.3% |
|
|
Profit is
-$71K
because: | Percent Change | |
| Independent Impact | |
| Incremental Impact | |
| | -6.8% | -$114K | -$114K |
Explains
-$114K
| Fully explains the $71K decrease |
|
|
|
Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on profit. | Profit |
-6.3% |
| |
Sale Price |
-6.8% | | |
Cost |
-7.7% | |
|
|
|
1. Metric › unit_sale_price -6.8% | unit_sale_price is down -6.8% between 10/15 to 10/21 ($1.6M) and 10/8 to 10/14 ($1.7M), resulting in a decrease of -$114K. |
| unit_sale_price is
down
-$114K
because: | Percent Change | |
| Independent Impact | |
| Incremental Impact | |
|
| product_category |
Board Game |
|
| -15.2% | -$88K | -$88K |
| -7.5% | -$30K | -$37K |
| -31.8% | -$40K | -$23K |
Explains
-$147K
| Fully explains the $114K decrease |
|
| | Without unit_sale_price's -6.8% decrease, overall profit for 10/15 to 10/21 would have been up +3.9% instead of down -6.3%. | |
| |
|
|
What else is driving profit? |
|
|
|
Column | Driver | Abs. Change | Pct. Change | Overall Impact | Metric | unit_sale_price | $114K | 6.8% | 10.2% | product_category | Board Game | $57K | 14.7% | 5% | Metric | unit_cost | $43K | 7.7% | 3.9% | campaign | twitter | $26K | 31.4% | 2.3% | source | Social Media | $24K | 8.5% | 2.2% | product_name | Twister | $21K | 44.5% | 1.9% | source | Paid Acquisition | $21K | 7.7% | 1.9% | product_name | Battleship | $20K | 39.4% | 1.8% | campaign | facebook ads | $19K | 23.3% | 1.7% | campaign | weekly_newsletter | $18K | 15.9% | 1.6% | product_category | Electronic Game | $16K | 4.3% | 1.4% | source | Email Marketing | $13K | 4.5% | 1.2% |
|
|
Column | Driver | Abs. Change | Pct. Change | Overall Impact | product_name | Candy Land | $12K | 34.1% | 1.1% | product_name | Uno | $7,935 | 23.2% | 0.7% | product_name | Dominoes | $7,855 | 27.2% | 0.7% | product_name | Trivial Pursuit | $7,438 | 26.1% | 0.7% | product_name | Rock 'Em Sock 'Em Robots | $6,949 | 24.6% | 0.6% | campaign | facebook | $5,978 | 9.8% | 0.5% | product_name | Monopoly | $5,486 | 18.4% | 0.5% | campaign | google plus | $5,278 | 7.7% | 0.5% | campaign | industry_news_in_context | $4,451 | 4.7% | 0.4% | product_name | Mad Libs | $4,194 | 10.2% | 0.4% | product_name | Nintendo | $3,288 | 10% | 0.3% | campaign | bing ads | $2,903 | 4.7% | 0.3% |
|
|
This analysis compares total profit between 10/15 to 10/21 and 10/8 to 10/14. | 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. October 22, 2024 at 3:35am EST. | |