marketing-spend-analysis

What this skill does

# Marketing Spend Analysis

## Overview

Marketing spend is typically the largest variable cost in a DTC ecommerce business — often 15–40% of revenue. Unlike most costs, marketing spend is directly controllable in near-real-time: you can increase or decrease budgets on paid channels within minutes. This creates both opportunity (scale what works) and risk (waste capital on what does not).

The core goal is to maximize total contribution profit from your marketing investment — not just revenue. A channel with high ROAS but thin margins, high return rates, or low AOV may generate less actual profit than a channel with lower ROAS and stronger unit economics.

This skill guides you through building a unified view of marketing spend and performance across all channels, using tools designed specifically for ecommerce merchants.

## When to Use This Skill

- When managing marketing budgets across multiple platforms (Meta, Google, TikTok, Amazon Ads)
- When wanting to identify which channels generate the most profitable customers
- When needing a unified marketing performance dashboard fed by multiple ad platforms
- When hitting diminishing returns on a key channel and deciding how to reallocate spend
- When comparing platform-reported ROAS against first-party attributed ROAS
- When building a marketing efficiency report for a board or investor update

## Core Instructions

### Step 1: Choose a unified marketing analytics tool

The biggest problem in marketing spend analysis is that each platform (Meta, Google, TikTok) reports its own ROAS using its own attribution window — and they all claim 100% credit. You need a tool that pulls data from all platforms into one view and compares against your actual order data.

| Platform | Recommended Tool | What It Does |
|----------|-----------------|-------------|
| **Shopify** | **Triple Whale** or **Polar Analytics** | Connects Shopify orders + all ad platforms; shows blended ROAS, MER, and channel-level true ROAS side by side |
| **Shopify** (budget option) | **Shopify Analytics** + **Google Analytics 4** | Free; last-click attribution only; no cross-platform comparison |
| **WooCommerce** | **Metorik** + **GA4** | Metorik adds UTM attribution to WooCommerce orders; GA4 provides channel-level conversion reporting |
| **BigCommerce** | **Glew.io** or **Rockerbox** | Both connect BigCommerce orders to ad platform spend data |
| **All platforms** | **Northbeam** or **Rockerbox** | Platform-agnostic; provide first-party multi-touch attribution across all channels with spend pacing |

**Key metrics to track in your chosen tool:**

| Metric | Definition | Why It Matters |
|--------|-----------|---------------|
| **Platform ROAS** | Revenue attributed by each platform / spend on that platform | What the ad platform claims (typically inflated) |
| **First-party ROAS** | Revenue attributed by your own pixel / spend | More accurate; corrects for view-through over-attribution |
| **Blended MER** | Total revenue / total marketing spend across all channels | Overall marketing efficiency; harder to game |
| **True ROAS** | Gross profit attributed to channel / spend | Accounts for COGS; the right metric for profitability decisions |
| **CAC (new customers only)** | New customer acquisition spend / new customers acquired | Separate from retargeting/retention spend |
| **ROAS break-even** | 1 / (1 - COGS rate - fulfillment rate) | Minimum ROAS needed to not lose money |

### Step 2: Set up your marketing analytics stack

---

#### Shopify

**Triple Whale setup (recommended for $50K+/mo ad spend):**

1. Install **Triple Whale** from the Shopify App Store
2. Connect all ad accounts under **Settings → Integrations**: Meta, Google, TikTok, Pinterest, Snapchat
3. Triple Whale installs a first-party pixel on your store that tracks the full customer journey
4. Go to **Triple Whale → Summary Dashboard** — view daily spend, attributed revenue, ROAS, MER, new customer CAC, and gross profit by channel in one dashboard
5. Go to **Triple Whale → Attribution → Channel** to see revenue under different attribution models side by side (first-click, last-click, Triple Whale's blended model)
6. Set up **Morning Digest** emails — Triple Whale sends a daily performance summary automatically
7. Set **Budget Alerts** under **Settings → Alerts** — get Slack/email notifications when ROAS drops below threshold or spend is pacing to overshoot monthly budget

**Polar Analytics setup (mid-market, more affordable):**

1. Install **Polar Analytics** from the Shopify App Store
2. Connect ad accounts under **Integrations**
3. Go to **Polar → Channels** — view spend, attributed revenue, ROAS, and gross profit by channel
4. Go to **Polar → Blended Dashboard** — view overall MER and blended spend vs. revenue trend
5. Use **Polar → AI Insights** for automated anomaly detection and spend recommendations

---

#### WooCommerce

**Metorik + GA4 setup:**

1. Install **Metorik** and connect to your WooCommerce store
2. Metorik captures UTM parameters on every order — go to **Metorik → Reports → UTM** to see orders and revenue by utm_source, utm_medium, utm_campaign
3. Install **Google Analytics 4** via the **Site Kit** or **MonsterInsights** plugin
4. In GA4, go to **Advertising → Attribution → Model comparison** — select Google, Paid Social, Email as your channels and compare last-click vs. data-driven attribution
5. For ad spend data from non-Google platforms (Meta, TikTok), manually import spend CSVs into a Google Sheet and connect to Looker Studio alongside GA4 data for a unified view

**Alternative: Northbeam or Rockerbox**
- Both support WooCommerce via JavaScript pixel + order API integration
- Provide the same cross-platform attribution capabilities as Triple Whale but with WooCommerce compatibility

---

#### BigCommerce

1. Install **Glew.io** from the BigCommerce App Marketplace
2. Connect ad accounts (Meta, Google, Amazon) in Glew under **Integrations**
3. Glew shows spend, attributed revenue, ROAS, and blended MER by channel
4. For more advanced first-party attribution: install **Rockerbox** via script injection (BigCommerce → Storefront → Script Manager)

---

### Step 3: Define your ROAS break-even and targets

Before analyzing whether a channel is performing well, calculate your minimum viable ROAS.

**ROAS break-even formula:**
```
Break-even ROAS = 1 / (1 - COGS rate - variable cost rate)

Example:
  COGS rate: 45% of revenue
  Fulfillment + payment fees: 12% of revenue
  Break-even ROAS = 1 / (1 - 0.45 - 0.12) = 1 / 0.43 = 2.33x

Any channel with true ROAS below 2.33x is losing money on every sale.
```

**Target ROAS by channel type:**

| Channel Type | Target ROAS Multiplier Above Break-Even | Why |
|-------------|----------------------------------------|-----|
| Prospecting (new customers) | 1.5–2x break-even | Acquiring new customers has higher long-term value than single-order ROAS suggests |
| Retargeting (existing visitors) | 2–3x break-even | Lower cost; higher conversion rate; but be careful of incrementality |
| Brand search (Google Branded) | 5x+ | High ROAS but low incrementality; customers were coming anyway |
| Non-brand search (Google Generic) | 1.5–2x break-even | True incremental; valuable for new customer acquisition |
| Email/SMS | 10x+ | Low cost per send; high ROAS but measures existing customer retention, not acquisition |

### Step 4: Build a weekly channel performance scorecard

Set up a weekly review with this structure. Pull data from your analytics tool (Triple Whale, Glew, GA4):

```
CHANNEL PERFORMANCE SCORECARD (Last 7 Days vs. Prior 7 Days)
─────────────────────────────────────────────────────────────
Channel    | Spend  | 1P Revenue | 1P ROAS | vs LW | Status
Meta Ads   | $12,400| $38,400    | 3.1x    | +0.3x | OK ✓
Google Ads | $8,200 | $31,100    | 3.8x    | -0.2x | OK ✓
TikTok Ads | $3,100 | $5,700     | 1.8x    | -0.8x | REVIEW ⚠
Amazon Ads | $4,500 | $19,800    | 4.4x    | +0.1x | OK ✓
Email/SMS  | $800   | $22,000