| | | | Week over Week: $1.1M for 9/11 to 9/17 vs. $1.0M for 9/4 to 9/10 | | Profit: +1.8% to $1.1M |
|  |
Profit's increase vs. last week is a gain of $19K | |
Email Marketing, Simon, and twitter together fully explain profit's increase | | Without the positive impact of these 3 drivers, profit would have been down -3.9% instead of up +1.8% |
|
|
| Profit is
+$19K
because: | Percent
Change |  |
| Independent
Impact | |
| Incremental
Impact | |
| |
+15.4% | +$39K | +$39K |
|
+39.8% | +$11K | +$11K |
|
+14.1% | +$9,243 | +$10K |
| Explains
+$60K
| | Fully explains the $19K increase |
|
|
| | Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on profit. | | Profit |
+1.8% |
| |
| Sale Price | |
+1.7% | | |
| Cost | |
+1.6% | |
|
| |
| 1. source › Email Marketing +15.4% | | Email Marketing profit is up +15.4% between 9/11 to 9/17 ($289K) and 9/4 to 9/10 ($251K), resulting in an increase of +$39K. |
| | Email Marketing profit is
up
+$39K
because: | Percent
Change | |
| Independent
Impact | |
| Incremental
Impact | |
| |
+14.7% | +$56K | +$56K |
| Explains
+$56K
| | Fully explains the $39K increase |
|
|  | | Without Email Marketing's +15.4% increase, overall profit for 9/11 to 9/17 would have been down -1.9% instead of up +1.8%. |  |
| | Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on Email Marketing profit. | | Profit | |
+15.4% |
| |
| Sale Price | |
+14.7% | | |
| Cost | |
+13.3% | |
|
|
|
| 2. product_name › Simon +39.8% | | Simon profit is up +39.8% between 9/11 to 9/17 ($40K) and 9/4 to 9/10 ($28K), resulting in an increase of +$11K. |
| | Simon profit is
up
+$11K
because: | Percent
Change | |
| Independent
Impact | |
| Incremental
Impact | |
| |
+39.4% | +$17K | +$17K |
|
+20.3% | +$613 | +$613 |
| Explains
+$17K
| | Fully explains the $11K increase |
|
|  | | Without Simon's +39.8% increase, overall profit for 9/11 to 9/17 would have been up only +0.7% instead of +1.8%. |  |
| | Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on Simon profit. | | Profit | |
+39.8% |
| |
| Sale Price | |
+39.4% | | |
| Cost | |
+38.7% | |
|
|
|
| 3. campaign › twitter +14.1% | | twitter profit is up +14.1% between 9/11 to 9/17 ($75K) and 9/4 to 9/10 ($66K), resulting in an increase of +$9,243. |
| | twitter profit is
up
+$9,243
because: | Percent
Change | |
| Independent
Impact | |
| Incremental
Impact | |
| |
+10.2% | +$10K | +$11K |
|
+36.6% | +$1,183 | +$513 |
 | | product_category | |
Board Game |
|
|
+12.1% | +$2,401 | +$576 |
| Explains
+$12K
| | Fully explains the $9,243 increase |
|
|  | | Without twitter's +14.1% increase, overall profit for 9/11 to 9/17 would have been up only +0.9% instead of +1.8%. |  |
| | Between unit_sale_price and unit_cost, unit_sale_price had a much greater impact on twitter profit. | | Profit | |
+14.1% |
| |
| Sale Price | |
+10.2% | | |
| Cost | |
+2.9% | |
|
|
|
| | What else is driving profit? |
|
| | | Column | Driver | Abs. Change | Pct. Change | Overall Impact | | campaign | google plus |  $15K | 20.1% | 1.5% | | source | Organic Search | $13K | 5.1% | 1.3% | | product_name | Atari 2600 | $12K | 29.7% | 1.2% | | product_name | Nintendo | $12K | 31.8% | 1.2% | | product_category | Board Game | $12K | 3.4% | 1.1% | | source | Social Media | $10K | 3.8% | 1% | | campaign | facebook ads | $10K | 15.1% | 1% | | product_name | Mouse Trap | $10K | 25.4% | 1% | | campaign | bing | $7,954 | 8.6% | 0.8% | | campaign | linkedin | $6,824 | 10% | 0.7% | | product_name | Memory | $6,146 | 17.5% | 0.6% | | campaign | yahoo | $5,925 | 7.1% | 0.6% |
| | | Column | Driver | Abs. Change | Pct. Change | Overall Impact | | source | Email Marketing | $39K | 15.4% | 3.7% | | Metric | unit_sale_price | $27K | 1.7% | 2.6% | | product_category | Electronic Game | $23K | 7% | 2.2% | | campaign | industry_news_in_context | $22K | 25.6% | 2.1% | | campaign | weekly_newsletter | $13K | 15.6% | 1.2% | | product_name | Simon | $11K | 39.8% | 1.1% | | campaign | bing ads | $11K | 14.8% | 1% | | product_name | Rock 'Em Sock 'Em Robots | $10K | 32.7% | 1% | | campaign | outbrain | $9,694 | 17.1% | 0.9% | | campaign | twitter | $9,243 | 14.1% | 0.9% | | Metric | unit_cost | $8,362 | 1.6% | 0.8% | | product_name | Sorry! | $8,223 | 28.1% | 0.8% |
| |
| This analysis compares total profit between 9/11 to 9/17 and 9/4 to 9/10. | | 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. September 18, 2025 at 3:35am EST. | |
|
| |
