Track Marketing Campaigns End-to-End

channel,slug,utm_source,utm_medium,utm_campaign,utm_content
Newsletter,summer-newsletter,newsletter,email,summer-sale-2026,hero-cta
Instagram Story,summer-ig-story,instagram,social,summer-sale-2026,story-swipe-up
Instagram Feed,summer-ig-feed,instagram,social,summer-sale-2026,feed-post
Google Ads,summer-google-ad,google,cpc,summer-sale-2026,search-ad
Influencer Post,summer-influencer,instagram,influencer,summer-sale-2026,influencer-bio
Facebook Ad,summer-fb-ad,facebook,social,summer-sale-2026,carousel-ad

// create-campaign-links.ts
import fs from 'fs';
import { parse } from 'csv-parse/sync';

const API_BASE = 'https://api.sniplink.co/v1';
const API_KEY = process.env.SNIPLINK_API_KEY!;
const WORKSPACE_ID = process.env.SNIPLINK_WORKSPACE_ID!;

const LANDING_PAGE = 'https://outdoorgear.example.com/summer-sale';
const CAMPAIGN_NAME = 'summer-sale-2026';

interface CampaignLink {
  channel: string;
  slug: string;
  utm_source: string;
  utm_medium: string;
  utm_campaign: string;
  utm_content: string;
}

async function createCampaignLink(link: CampaignLink) {
  const response = await fetch(
    `${API_BASE}/workspaces/${WORKSPACE_ID}/links`,
    {
      method: 'POST',
      headers: {
        'X-API-Key': API_KEY,
        'Content-Type': 'application/json',
      },
      body: JSON.stringify({
        url: LANDING_PAGE,
        slug: link.slug,
        title: `Summer Sale 2026 - ${link.channel}`,
        tags: [CAMPAIGN_NAME, link.utm_source, link.utm_medium],
        utmSource: link.utm_source,
        utmMedium: link.utm_medium,
        utmCampaign: link.utm_campaign,
        utmContent: link.utm_content,
      }),
    }
  );

  if (!response.ok) {
    const error = await response.json();
    throw new Error(`Failed to create link: ${error.message}`);
  }

  return response.json();
}

async function main() {
  // Read campaign plan from CSV
  const csvContent = fs.readFileSync('campaign-links.csv', 'utf-8');
  const links: CampaignLink[] = parse(csvContent, {
    columns: true,
    skip_empty_lines: true,
  });

  console.log(`🚀 Creating ${links.length} campaign links...\n`);

  const results = [];

  for (const link of links) {
    try {
      const result = await createCampaignLink(link);
      console.log(`✅ ${link.channel}: ${result.link.shortUrl}`);
      results.push({
        channel: link.channel,
        shortUrl: result.link.shortUrl,
        linkId: result.link.id,
      });
    } catch (error) {
      console.error(`❌ ${link.channel}: ${error.message}`);
    }

    // Rate limiting: wait 1 second between requests
    await new Promise((resolve) => setTimeout(resolve, 1000));
  }

  // Save results to JSON for easy reference
  fs.writeFileSync('campaign-links-output.json', JSON.stringify(results, null, 2));

  console.log(`\n✨ Done! Created ${results.length} links`);
  console.log('📋 Results saved to campaign-links-output.json');
}

main();

npx tsx create-campaign-links.ts

🚀 Creating 6 campaign links...

✅ Newsletter: https://r.sniplink.co/summer-newsletter
✅ Instagram Story: https://r.sniplink.co/summer-ig-story
✅ Instagram Feed: https://r.sniplink.co/summer-ig-feed
✅ Google Ads: https://r.sniplink.co/summer-google-ad
✅ Influencer Post: https://r.sniplink.co/summer-influencer
✅ Facebook Ad: https://r.sniplink.co/summer-fb-ad

✨ Done! Created 6 links
📋 Results saved to campaign-links-output.json

<a href="https://r.sniplink.co/summer-newsletter">
  Shop the Summer Sale →
</a>

Summer Sale is live! 🌞
Get 30% off outdoor gear
👇 Shop now
r.sniplink.co/summer-ig-story

Headline: Summer Outdoor Gear Sale - 30% Off
Description: Premium tents, backpacks & more. Limited time only!
Final URL: https://r.sniplink.co/summer-google-ad

// Using the QR code generation endpoint
const qrCodeUrl = `https://api.sniplink.co/v1/links/${linkId}/qr?size=512&format=png`;

// Or use a service like qrcode.react in your app
import QRCode from 'qrcode.react';

<QRCode value="https://r.sniplink.co/summer-newsletter" size={256} />

// campaign-dashboard.ts
import { api } from './lib/sniplink';

interface CampaignMetrics {
  channel: string;
  clicks: number;
  uniqueClicks: number;
  conversions: number;
  revenue: number;
  spend: number;
  roi: number;
  cpa: number;
}

async function getCampaignMetrics(
  linkId: string,
  channel: string,
  spend: number
): Promise<CampaignMetrics> {
  // Fetch analytics from SnipLink
  const analytics = await api.getOverallAnalytics(linkId, {
    startDate: &#039;2026-07-01T00:00:00Z&#039;,
    endDate: &#039;2026-07-07T23:59:59Z&#039;,
  });

  // In a real app, you'd fetch conversions from your e-commerce platform
  // For this example, let's assume a 5% conversion rate
  const conversions = Math.floor(analytics.uniqueClicks * 0.05);
  const revenue = conversions * 100; // $100 average order value

  const roi = ((revenue - spend) / spend) * 100;
  const cpa = conversions > 0 ? spend / conversions : 0;

  return {
    channel,
    clicks: analytics.clicks,
    uniqueClicks: analytics.uniqueClicks,
    conversions,
    revenue,
    spend,
    roi,
    cpa,
  };
}

async function main() {
  const campaignLinks = [
    { linkId: &#039;lnk_newsletter&#039;, channel: &#039;Newsletter&#039;, spend: 1500 },
    { linkId: &#039;lnk_ig_story&#039;, channel: &#039;Instagram Story&#039;, spend: 1000 },
    { linkId: &#039;lnk_ig_feed&#039;, channel: &#039;Instagram Feed&#039;, spend: 1000 },
    { linkId: &#039;lnk_google&#039;, channel: &#039;Google Ads&#039;, spend: 1000 },
    { linkId: &#039;lnk_influencer&#039;, channel: &#039;Influencer&#039;, spend: 500 },
    { linkId: &#039;lnk_fb_ad&#039;, channel: &#039;Facebook Ad&#039;, spend: 0 }, // Organic post
  ];

  console.log(&#039;📊 Campaign Performance Dashboard\n&#039;);
  console.log(&#039;Campaign: Summer Sale 2026&#039;);
  console.log(&#039;Date Range: July 1-7, 2026\n&#039;);

  const metrics = await Promise.all(
    campaignLinks.map((link) =>
      getCampaignMetrics(link.linkId, link.channel, link.spend)
    )
  );

  // Display results in a table
  console.table(
    metrics.map((m) => ({
      Channel: m.channel,
      Clicks: m.clicks,
      Unique: m.uniqueClicks,
      Conversions: m.conversions,
      Revenue: `$${m.revenue.toLocaleString()}`,
      Spend: `$${m.spend.toLocaleString()}`,
      ROI: `${m.roi.toFixed(0)}%`,
      CPA: `$${m.cpa.toFixed(2)}`,
    }))
  );

  // Calculate totals
  const totals = metrics.reduce(
    (acc, m) => ({
      clicks: acc.clicks + m.clicks,
      conversions: acc.conversions + m.conversions,
      revenue: acc.revenue + m.revenue,
      spend: acc.spend + m.spend,
    }),
    { clicks: 0, conversions: 0, revenue: 0, spend: 0 }
  );

  const overallROI = ((totals.revenue - totals.spend) / totals.spend) * 100;
  const overallCPA = totals.conversions > 0 ? totals.spend / totals.conversions : 0;

  console.log(&#039;\n📈 Campaign Totals&#039;);
  console.log(`  Total Clicks: ${totals.clicks.toLocaleString()}`);
  console.log(`  Total Conversions: ${totals.conversions}`);
  console.log(`  Total Revenue: $${totals.revenue.toLocaleString()}`);
  console.log(`  Total Spend: $${totals.spend.toLocaleString()}`);
  console.log(`  Overall ROI: ${overallROI.toFixed(0)}%`);
  console.log(`  Overall CPA: $${overallCPA.toFixed(2)}`);

  // Identify best performer
  const bestChannel = metrics.reduce((best, current) =>
    current.roi > best.roi ? current : best
  );

  console.log(`\n🏆 Top Performer: ${bestChannel.channel}`);
  console.log(`  ROI: ${bestChannel.roi.toFixed(0)}%`);
  console.log(`  Conversions: ${bestChannel.conversions}`);
}

main();

📊 Campaign Performance Dashboard

Campaign: Summer Sale 2026
Date Range: July 1-7, 2026

┌─────────┬───────────────────┬────────┬────────┬─────────────┬─────────┬────────┬────────┬──────────┐
│ (index) │ Channel           │ Clicks │ Unique │ Conversions │ Revenue │ Spend  │ ROI    │ CPA      │
├─────────┼───────────────────┼────────┼────────┼─────────────┼─────────┼────────┼────────┼──────────┤
│ 0       │ 'Newsletter'      │ 4521   │ 3876   │ 194         │ '$19,400'│ '$1,500'│ '1193%'│ '$7.73'  │
│ 1       │ 'Instagram Story' │ 3124   │ 2654   │ 133         │ '$13,300'│ '$1,000'│ '1230%'│ '$7.52'  │
│ 2       │ 'Instagram Feed'  │ 2867   │ 2411   │ 121         │ '$12,100'│ '$1,000'│ '1110%'│ '$8.26'  │
│ 3       │ 'Google Ads'      │ 1932   │ 1621   │ 81          │ '$8,100' │ '$1,000'│ '710%' │ '$12.35' │
│ 4       │ 'Influencer'      │ 1456   │ 1234   │ 62          │ '$6,200' │ '$500'  │ '1140%'│ '$8.06'  │
│ 5       │ 'Facebook Ad'     │ 892    │ 743    │ 37          │ '$3,700' │ '$0'    │ 'Inf'  │ '$0.00'  │
└─────────┴───────────────────┴────────┴────────┴─────────────┴─────────┴────────┴────────┴──────────┘

📈 Campaign Totals
  Total Clicks: 14,792
  Total Conversions: 628
  Total Revenue: $62,800
  Total Spend: $5,000
  Overall ROI: 1156%
  Overall CPA: $7.96

🏆 Top Performer: Instagram Story
  ROI: 1230%
  Conversions: 133

// pages/api/webhooks/clicks.ts
import { NextApiRequest, NextApiResponse } from 'next';

export default async function handler(req: NextApiRequest, res: NextApiResponse) {
  if (req.method !== 'POST') {
    return res.status(405).json({ error: 'Method not allowed' });
  }

  const event = req.body;

  if (event.type === 'link.clicked') {
    const { linkId, clickId, utmSource, utmMedium, utmCampaign } = event.data;

    // Store click event for later attribution
    await db.clicks.create({
      data: {
        clickId,
        linkId,
        utmSource,
        utmMedium,
        utmCampaign,
        timestamp: new Date(),
      },
    });

    console.log(`Click tracked: ${utmSource}/${utmMedium}`);
  }

  res.status(200).json({ received: true });
}

// On your checkout page, attribute the purchase to the click
async function handlePurchase(orderId: string, amount: number) {
  // Get the click ID from cookie or session
  const clickId = getCookie('sniplink_click_id');

  if (clickId) {
    // Find the click in your database
    const click = await db.clicks.findUnique({ where: { clickId } });

    if (click) {
      // Record conversion
      await db.conversions.create({
        data: {
          clickId: click.clickId,
          linkId: click.linkId,
          orderId,
          amount,
          utmSource: click.utmSource,
          utmMedium: click.utmMedium,
          utmCampaign: click.utmCampaign,
          timestamp: new Date(),
        },
      });

      console.log(`Conversion attributed to ${click.utmSource}/${click.utmMedium}`);
    }
  }
}

// Track all clicks in customer journey
const customerJourney = [
  { timestamp: '2026-07-01 10:30', source: 'instagram', medium: 'social' },
  { timestamp: '2026-07-02 14:15', source: 'google', medium: 'cpc' },
  { timestamp: '2026-07-03 16:45', source: 'newsletter', medium: 'email' }, // Converted
];

// Attribution models
const attributionModels = {
  // Last click: All credit to final touchpoint
  lastClick: () => customerJourney[customerJourney.length - 1],

  // First click: All credit to first touchpoint
  firstClick: () => customerJourney[0],

  // Linear: Equal credit to all touchpoints
  linear: () => {
    const credit = 1 / customerJourney.length;
    return customerJourney.map((touch) => ({ ...touch, credit }));
  },

  // Time decay: More recent touches get more credit
  timeDecay: () => {
    const halfLife = 7; // days
    const now = new Date('2026-07-03');

    return customerJourney.map((touch) => {
      const touchDate = new Date(touch.timestamp);
      const daysDiff = (now.getTime() - touchDate.getTime()) / (1000 * 60 * 60 * 24);
      const credit = Math.pow(0.5, daysDiff / halfLife);
      return { ...touch, credit };
    });
  },
};

# Summer Sale 2026 Campaign Report

## Executive Summary
- **Campaign Duration:** July 1-7, 2026 (7 days)
- **Total Investment:** $5,000
- **Total Revenue:** $62,800
- **Overall ROI:** 1,156%
- **Total Orders:** 628
- **Average Order Value:** $100

## Channel Performance

### Top Performers
1. **Newsletter** - 1193% ROI, 194 conversions
2. **Instagram Story** - 1230% ROI, 133 conversions
3. **Influencer Post** - 1140% ROI, 62 conversions

### Underperformers
- **Google Ads** - 710% ROI, $12.35 CPA (above target)
- **Facebook Ad** - Low engagement, needs creative refresh

## Key Learnings
- Email marketing remains our highest-ROI channel
- Instagram audiences respond well to time-sensitive offers
- Search ads require better keyword targeting

## Recommendations for Next Campaign
1. Increase email campaign budget by 50%
2. Scale successful Instagram ad sets
3. Test video ads on Instagram Reels
4. Optimize Google Ads targeting and pause low-performers
5. Partner with 2-3 additional micro-influencers

tags: ['summer-sale-2026', 'instagram', 'paid', 'q3-2026']

expiresAt: '2026-07-07T23:59:59Z'

// Create two versions
const linkA = await createLink({ url: 'example.com/landing-a', slug: 'sale-version-a' });
const linkB = await createLink({ url: 'example.com/landing-b', slug: 'sale-version-b' });

// Split traffic 50/50 manually or use a link rotation service