|
| Week over Week: $991K for 3/13 to 3/19 vs. $1.1M for 3/6 to 3/12 | | Profit: -8.3% to $991K |
|
 |
Profit's decrease vs. last week is a loss of $90K | |
unit_sale_price fully explains profit's decrease | | Without the negative impact of this driver, profit would have been up +3% instead of down -8.3% |
|
|
| Profit is
-$90K
because: | Percent
Change |  |
| Independent
Impact | |
| Incremental
Impact | |
| | -7.6% | -$123K | -$123K |
| Explains
-$123K
| | Fully explains the $90K decrease |
|
|
|
| Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on profit. | | Profit | 
-8.3% |
| |
| Sale Price | |
-7.6% | | |
| Cost | |
-6.1% | |
|
|
|
| 1. Metric › unit_sale_price -7.6% | | unit_sale_price is down -7.6% between 3/13 to 3/19 ($1.5M) and 3/6 to 3/12 ($1.6M), resulting in a decrease of -$123K. |
| | unit_sale_price is
down
-$123K
because: | Percent
Change | |
| Independent
Impact | |
| Incremental
Impact | |
| | -17.2% | -$73K | -$73K |
| -15.8% | -$66K | -$66K |
| -5.2% | -$21K | -$21K |
| Explains
-$160K
| | Fully explains the $123K decrease |
|
|  | | Without unit_sale_price's -7.6% decrease, overall profit for 3/13 to 3/19 would have been up +3% instead of down -8.3%. |  |
| |
|
|
| What else is driving profit? |
|
|
|
| Column | Driver | Abs. Change | Pct. Change | Overall Impact | | Metric | unit_sale_price | $123K | 7.6% | 11.3% | | source | Email Marketing | $53K | 18.5% | 4.9% | | product_category | Social Game | $49K | 13.5% | 4.6% | | source | Paid Acquisition | $49K | 17.2% | 4.5% | | product_category | Electronic Game | $34K | 9.5% | 3.2% | | Metric | unit_cost | $33K | 6.1% |  3% | | campaign | announcement_blast | $28K | 27.7% | 2.6% | | campaign | bing ads | $17K | 23.7% | 1.5% | | campaign | industry_news_in_context | $17K | 17.6% | 1.5% | | product_name | Chutes and Ladders | $16K | 48.9% | 1.5% | | product_name | Life | $16K | 36% | 1.4% | | source | Social Media | $15K | 5.5% | 1.4% |
|
|
| Column | Driver | Abs. Change | Pct. Change | Overall Impact | | source | Organic Search | $26K | 10.6% | 2.4% | | campaign | yahoo | $17K | 22.2% | 1.5% | | campaign | google | $14K | 16.2% | 1.3% | | product_name | Pretty Pretty Princess | $13K | 45.1% | 1.2% | | product_name | Dominoes | $9,660 | 35.3% | 0.9% | | product_name | Game Boy | $8,238 | 24.5% | 0.8% | | product_name | Mattel Auto Race | $6,213 | 19.6% | 0.6% | | campaign | google plus | $4,212 | 6.3% | 0.4% | | product_name | Battleship | $2,559 | 7.3% | 0.2% | | product_name | Twister | $1,817 | 5.1% | 0.2% | | product_name | Memory | $1,500 | 4.7% | 0.1% | | product_name | Barrel O' Monkeys | $1,401 | 4.1% | 0.1% |
|
|
| This analysis compares total profit between 3/13 to 3/19 and 3/6 to 3/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 Mon. March 20, 2023 at 3:35am EST. | |
