| | | | Week over Week: $1,058,579 for 3/17 to 3/23 vs. $1,089,396 for 3/10 to 3/16 | | Profit: -2.8% to $1.1M |
|  |
Profit's decrease vs. last week is a loss of $31K | |
Board Game, google plus, and Life together fully explain profit's decrease | | Without the negative impact of these 3 drivers, profit would have been up +4.1% instead of down -2.8% |
|
|
| Profit is
-$31K
because: | Percent
Change |  |
| Independent
Impact | |
| Incremental
Impact | |
| 
| | product_category | |
Board Game |
|
| -11.4% | -$44K | -$44K |
| -28% | -$20K | -$19K |
| -24.2% | -$11K | -$12K |
| Explains
-$75K
| | Fully explains the $31K decrease |
|
|
| | Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on profit. | | Profit | 
-2.8% |
| |
| Sale Price | |
-2.5% | | |
| Cost | |
-1.7% | |
|
| |
| 1. product_category › Board Game -11.4% | | Board Game profit is down -11.4% between 3/17 to 3/23 ($342K) and 3/10 to 3/16 ($386K), resulting in a decrease of -$44K. |
| | Board Game profit is
down
-$44K
because: | Percent
Change | |
| Independent
Impact | |
| Incremental
Impact | |
| | -10.2% | -$59K | -$59K |
| Explains
-$59K
| | Fully explains the $44K decrease |
|
|  | | Without Board Game's -11.4% decrease, overall profit for 3/17 to 3/23 would have been up +1.2% instead of down -2.8%. |  |
| | Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on Board Game profit. | | Profit | |
-11.4% |
| |
| Sale Price | |
-10.2% | | |
| Cost | |
-7.8% | |
|
|
|
| 2. campaign › google plus -28% | | google plus profit is down -28% between 3/17 to 3/23 ($52K) and 3/10 to 3/16 ($72K), resulting in a decrease of -$20K. |
| | google plus profit is
down
-$20K
because: | Percent
Change | |
| Independent
Impact | |
| Incremental
Impact | |
| | -25.5% | -$27K | -$27K |
| Explains
-$27K
| | Fully explains the $20K decrease |
|
|  | | Without google plus' -28% decrease, overall profit for 3/17 to 3/23 would have been down only -1% instead of -2.8%. |  |
| | Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on google plus profit. | | Profit | |
-28% |
| |
| Sale Price | |
-25.5% | | |
| Cost | |
-20.3% | |
|
|
|
| 3. product_name › Life -24.2% | | Life profit is down -24.2% between 3/17 to 3/23 ($33K) and 3/10 to 3/16 ($44K), resulting in a decrease of -$11K. |
| | Life profit is
down
-$11K
because: | Percent
Change | |
| Independent
Impact | |
| Incremental
Impact | |
| | -19% | -$12K | -$14K |
| | product_category | |
Electronic Game |
|
| -22.8% | -$2,404 | -$533 |
| -10.1% | -$1,077 | -$725 |
| Explains
-$13K
| | Fully explains the $11K decrease |
|
|  | | Without Life's -24.2% decrease, overall profit for 3/17 to 3/23 would have been down only -1.9% instead of -2.8%. |  |
| | Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on Life profit. | | Profit | |
-24.2% |
| |
| Sale Price | |
-19% | | |
| Cost | |
-7.5% | |
|
|
|
| | What else is driving profit? |
|
| | | Column | Driver | Abs. Change | Pct. Change | Overall Impact | | product_category | Board Game | $44K | 11.4% | 4% | | Metric | unit_sale_price | $40K | 2.5% | 3.7% | | campaign | weekly_newsletter | $21K | 20.8% | 2% | | campaign | google plus | $20K | 28% | 1.8% | | source | Social Media | $20K | 7% | 1.8% | | source | Email Marketing | $16K | 5.7% | 1.4% | | campaign | outbrain | $16K | 21.7% | 1.4% | | product_name | Life | $11K | 24.2% | 1% | | product_name | Rock 'Em Sock 'Em Robots | $10K | 25.8% | 0.9% | | product_name | Mattel Auto Race | $9,523 | 27.8% | 0.9% | | Metric | unit_cost | $9,245 | 1.7% |  0.8% | | product_name | Atari 2600 | $7,637 | 18.6% | 0.7% |
| | | Column | Driver | Abs. Change | Pct. Change | Overall Impact | | product_category | Social Game | $12K | 3.4% | 1.1% | | campaign | bing | $12K | 15.3% | 1.1% | | product_name | Battleship | $9,714 | 26.1% | 0.9% | | campaign | facebook ads | $9,488 | 14.1% | 0.9% | | campaign | industry_news_in_context | $9,305 | 11.1% | 0.9% | | source | Organic Search | $9,154 | 3.6% | 0.8% | | campaign | linkedin | $8,458 | 12.8% | 0.8% | | product_name | Dungeons & Dragons | $6,121 | 19.4% | 0.6% | | product_name | Game Boy | $5,026 | 16% | 0.5% | | product_name | Chutes and Ladders | $4,852 | 13.8% | 0.4% | | product_name | Candy Land | $4,778 | 13.2% | 0.4% | | product_name | Twister | $4,609 | 12.3% | 0.4% |
| |
| This analysis compares total profit between 3/17 to 3/23 and 3/10 to 3/16. | | 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 24, 2025 at 3:35am EST. | |
|
| |
