Supabase

Learn how to track lead conversion events with Supabase and Dub

Conversion tracking require a Business plan subscription or higher.

When it comes to conversion tracking, a lead event happens when a user performs an action that indicates interest in your product or service. This could be anything from:

• Signing up for an account
• Adding a product to cart
• Joining a mailing list

In this guide, we will be focusing on tracking new user sign-ups for a SaaS application that uses Supabase for user authentication.

Prerequisites

Before you get started, make sure you follow the Dub Conversions quickstart guide to get Dub Conversions set up for your links:

1. Enable conversion tracking for your links
2. Install the @dub/analytics client-side SDK
3. Install the Dub server-side SDK

Configure Supabase

Next, configure Supabase to track lead conversion events in the auth callback function.

Here’s how it works in a nutshell:

1. In the /api/auth/callback route, check if:
   • the dub_id cookie is present.
   • the user is a new sign up (created in the last 10 minutes).
2. If the dub_id cookie is present and the user is a new sign up, send a lead event to Dub using dub.track.lead
3. Delete the dub_id cookie.

Next.js App Router

// app/api/auth/callback/route.ts
import { cookies } from "next/headers";
import { NextResponse } from "next/server";
import { createClient } from "@/lib/supabase/server";
import { waitUntil } from "@vercel/functions";
import { dub } from "@/lib/dub";

export async function GET(request: Request) {
  const { searchParams, origin } = new URL(request.url);
  const code = searchParams.get("code");
  // if "next" is in param, use it as the redirect URL
  const next = searchParams.get("next") ?? "/";

  if (code) {
    const supabase = createClient(cookies());
    const { data, error } = await supabase.auth.exchangeCodeForSession(code);
    if (!error) {
      const { user } = data;
      const dub_id = cookies().get("dub_id")?.value;
      // if the user is created in the last 10 minutes, consider them new
      const isNewUser =
        new Date(user.created_at) > new Date(Date.now() - 10 * 60 * 1000);
      // if the user is new and has a dub_id cookie, track the lead
      if (dub_id && isNewUser) {
        waitUntil(
          dub.track.lead({
            clickId: dub_id,
            eventName: "Sign Up",
            customerExternalId: user.id,
            customerName: user.user_metadata.name,
            customerEmail: user.email,
            customerAvatar: user.user_metadata.avatar_url,
          })
        );
        // delete the clickId cookie
        cookies().delete("dub_id");
      }
      return NextResponse.redirect(`${origin}${next}`);
    }
  }

  // return the user to an error page with instructions
  return NextResponse.redirect(`${origin}/auth/auth-code-error`);
}

Here’s the full list of attributes you can pass when sending a lead event:

Property	Required	Description
clickId	Yes	The unique dub_id parameter that the lead conversion event is attributed to.
eventName	Yes	The name of the event. Example: “Sign up”.
customerExternalId	Yes	The unique ID of the customer in your system. Will be used to identify and attribute all future events to this customer.
customerEmail	No	The email address of the customer. If not passed, a random email address will be generated.
customerName	No	The name of the customer. If not passed, a random name will be generated (e.g. “Big Red Caribou”).
customerAvatar	No	The avatar URL of the customer. If not passed, a random avatar URL will be generated.

Example App

To learn more about how to track leads with Supabase, check out the following example app:

Supabase + Next.js App Router Example

Check out a real-world example of this in action – Extrapolate uses Supabase Auth and Next.js App Router to track new user sign-ups.

View your conversions

Once you’ve completed the setup, all your tracked conversions will show up in Dub Analytics. We provide 3 different views to help you understand your conversions:

• Time-series: A time-series view of the number clicks, leads and sales.

• Funnel chart: A funnel chart view visualizing the conversion & dropoff rates across the different steps in the conversion funnel (clicks → leads → sales).

• Real-time events stream: A real-time events stream of every single conversion event that occurs across all your links in your workspace.