finsilabs/marketing-attribution-dashboard

Marketing Attribution Dashboard

Overview

Every ecommerce business faces attribution chaos: Meta says it drove 300 purchases, Google says 280, and your order management system shows 400 total. The overlap is real, the methodologies differ, and single-touch last-click models misrepresent the true value of upper-funnel channels. A proper attribution dashboard aggregates all marketing data in one place and applies a consistent model so you can make defensible budget decisions. For most merchants, a third-party attribution tool — not custom code — is the fastest path to accurate channel ROI.

When to Use This Skill

• When ad spend decisions rely on platform-reported ROAS rather than actual order data
• When you suspect paid social is stealing attribution from organic search or email
• When preparing a quarterly marketing budget review and need a defensible data source
• When launching a new channel and need to measure its true incremental contribution
• When reporting marketing performance to investors or a board

Core Instructions

Step 1: Choose the right attribution tool

| Platform | Best For | Shopify | WooCommerce | BigCommerce | Price | |----------|---------|---------|-------------|-------------|-------| | Triple Whale | Shopify-native, real-time pixel + CAPI | App Store | Limited | Limited | $129+/mo | | Northbeam | Advanced multi-touch, TV/podcast spend | App Store | Via pixel | Via pixel | $500+/mo | | Rockerbox | Mid-market, all channels including offline | App Store | Via pixel | Via pixel | $500+/mo | | GA4 (free) | All platforms, good enough for most | Via tag | Via tag | Via tag | Free | | Wicked Reports | WooCommerce-native, integrates with Klaviyo | Limited | Plugin | Limited | $299+/mo |

Start with GA4 for most stores — it is free, handles multi-channel attribution with configurable models, and integrates natively with Google Ads. Upgrade to Triple Whale or Northbeam when you need real-time pixel data that survives iOS 14 restrictions.

Step 2: Set up attribution reporting

---

Shopify

With GA4 (recommended starting point):

1. Go to Shopify Admin → Online Store → Preferences → Google Analytics
2. Enter your GA4 Measurement ID (G-XXXXXXXXXX)
3. Enable Enhanced Ecommerce under GA4 property settings
4. In GA4 → Reports → Acquisition → Traffic Acquisition: set secondary dimension to Session campaign to break down by campaign
5. In GA4 → Reports → Acquisition → Traffic Acquisition: set the comparison period to 30 days and filter by Session medium to isolate paid, organic, email, and social

With Triple Whale (Shopify-native, recommended for paid social):

1. Install Triple Whale from the Shopify App Store
2. Go to Triple Whale → Pixel Setup and add the Triple Whale pixel to your theme — this is a first-party pixel not blocked by iOS 14
3. Connect your ad accounts: Triple Whale → Integrations → connect Meta, Google Ads, and TikTok
4. Triple Whale's Summary Page shows a unified ROAS view across all ad platforms using your actual Shopify order data as the source of truth
5. Use Triple Whale → Attribution → Model Comparison to compare last-click, first-click, and linear attribution in a single view

---

WooCommerce

With GA4:

1. Install MonsterInsights (free tier) or Google Site Kit from the WordPress plugin directory
2. Go to MonsterInsights → Settings → Analytics and connect your GA4 property
3. Enable enhanced ecommerce tracking — MonsterInsights handles the data layer events automatically
4. For UTM attribution reports: go to GA4 → Reports → Acquisition → Traffic Acquisition and filter by source/medium

With Wicked Reports (WooCommerce-specific):

1. Install Wicked Reports from the WordPress plugin directory
2. Connect your WooCommerce store and email platform (Klaviyo, Mailchimp)
3. Wicked Reports assigns multi-touch attribution to each order by tracking the full customer journey from first ad click to purchase
4. Go to Wicked Reports → ROI to see revenue per ad campaign using your actual order data

---

BigCommerce

1. Go to BigCommerce Admin → Settings → Analytics → Google Analytics
2. Enter your GA4 Measurement ID and enable Enhanced Ecommerce
3. For advanced attribution: install Triple Whale or Northbeam from the BigCommerce App Marketplace — both support BigCommerce via tracking pixel
4. In BigCommerce Analytics, go to Analytics → Marketing to see channel-level attribution based on BigCommerce's built-in last-click model

---

Custom / Headless

For headless stores, capture first-touch attribution server-side before building any reporting layer. Third-party tools like Triple Whale, Northbeam, or Rockerbox all provide a JavaScript pixel + server-side API for custom stacks.

If you need to build custom multi-touch attribution:

interface TouchpointEvent {
  sessionId: string;
  customerId?: string;
  anonymousId: string;
  channel: string;       // 'paid-social' | 'paid-search' | 'organic' | 'email' | 'sms' | 'direct'
  source: string;        // 'meta' | 'google' | 'tiktok' | 'klaviyo'
  medium: string;
  campaign?: string;
  orderId?: string;
  orderValue?: number;
  timestamp: Date;
}

function classifyChannel(utm: UtmParams, referrer?: string): string {
  if (utm.medium === 'cpc' || utm.medium === 'paid')       return 'paid-search';
  if (utm.medium === 'paid-social' || utm.source?.match(/meta|facebook|instagram|tiktok/i)) return 'paid-social';
  if (utm.medium === 'email')                               return 'email';
  if (utm.medium === 'sms')                                 return 'sms';
  if (referrer?.match(/google|bing|yahoo/i))                return 'organic-search';
  if (referrer && !referrer.includes(process.env.STORE_DOMAIN!)) return 'referral';
  return 'direct';
}

// Attribution model: 40% first touch, 40% last touch, 20% distributed across middle
function positionBasedWeights(touchpoints: TouchpointEvent[]): number[] {
  const n = touchpoints.length;
  if (n === 1) return [1];
  if (n === 2) return [0.5, 0.5];
  const middleShare = 0.2 / (n - 2);
  return touchpoints.map((_, i) => {
    if (i === 0) return 0.4;
    if (i === n - 1) return 0.4;
    return middleShare;
  });
}

Use a dedicated attribution API service like Rockerbox or Northbeam rather than building the full attribution engine from scratch — the complexity of cross-device stitching and model computation is not worth custom-building for most stores.

Step 3: Configure UTM tracking consistently

UTM parameters are the foundation of any attribution system. Without consistent UTMs, even GA4 cannot attribute sessions correctly.

Standard UTM structure:

| Channel | utm_source | utm_medium | utm_campaign | |---------|-------------|-------------|----------------| | Meta Ads | facebook or instagram | paid-social | spring-2026-prospecting | | Google Ads | google | cpc | brand-search | | TikTok Ads | tiktok | paid-social | ugc-spring-2026 | | Klaviyo email | klaviyo | email | welcome-series | | SMS | postscript | sms | abandoned-cart |

Use Google's Campaign URL Builder at ga-dev-tools.google.com/campaign-url-builder to generate UTM links consistently.

In Klaviyo: Go to Klaviyo → Account → Settings → UTM Tracking and enable auto-UTM tagging — Klaviyo appends UTM parameters to all email links automatically.

In Meta Ads: Go to Ads Manager → Campaign → URL Parameters and add utm_source={{site_source_name}}&utm_medium=paid-social&utm_campaign={{campaign.name}}&utm_content={{ad.name}} to your ad URL parameters at the campaign level.

Step 4: Build a blended ROAS dashboard in GA4

1. Go to GA4 → Explore → Free Form and create a new exploration
2. Set Dimensions: Session source/medium, Session campaign
3. Set Metrics: Sessions, Ecommerce purchases, Purchase revenue, Transactions
4. Add a filter: Session medium contains paid to isolate paid channels
5. Use GA4 → Advertising → Attribution to compare last-click vs. data-driven attribution models side by side
6. For manual ROAS: export GA4 revenue by channel → enter ad spend from each platform → calculate Revenue / Spend in a spreadsheet

Automate with Google Looker Studio (free):

1. Connect Looker Studio to GA4, Google Ads, and your Shopify/WooCommerce data source
2. Build a blended channel dashboard using Looker Studio's Blend Data feature
3. Join GA4 session data with Google Ads spend by campaign name

Step 5: Measure attribution health

| Metric | Target | Where to Find | |--------|--------|---------------| | Channel coverage (% of orders with UTM attribution) | > 70% | GA4 Acquisition report | | Email channel share of attributed revenue | Varies by business | GA4 filter by utm_medium=email | | Paid social EMQ score (for Meta CAPI) | 7+ / 10 | Meta Events Manager | | Cross-channel ROAS discrepancy | < 30% variance vs. platform-reported | Compare GA4 vs. Ads Manager |

Best Practices

• GA4 is ground truth, not platform dashboards — every ad platform over-attributes to itself; your order database and GA4 are the closest thing to ground truth
• Use position-based attribution for budget decisions — it rewards both discovery (first-touch) and closing (last-touch) channels; linear attribution underweights email and organic
• Set a 30-day lookback minimum — customers research for weeks before buying; 7-day windows miss upper-funnel contributions from paid social
• Consistent UTMs are more important than the tool — even the best attribution tool fails with inconsistent or missing UTM parameters; audit UTM coverage before buying a tool
• Compare models, not just the default — looking at the same period under last-click vs. linear vs. position-based reveals which channels are being systematically over- or under-credited

Common Pitfalls

| Problem | Solution | |---------|----------| | Direct traffic massively over-attributed | Set a 30-min session timeout in GA4; check for missing UTM parameters on all ad campaigns | | Email channel under-attributed | Enable auto-UTM in Klaviyo; test all links to verify UTMs survive ESP link tracking | | Platform ROAS looks great but profitability is flat | Platforms count view-through attribution; compare attribution windows — use 7-day click only | | Dashboard loads slowly | Use pre-aggregated GA4 summary tables; avoid building attribution from raw event exports |

Related Skills

• @meta-ads-integration
• @google-ads-ecommerce
• @tiktok-ads-integration
• @affiliate-program
• @influencer-marketplace-integration