The Content Funnel Dashboard Playbook

What you're building

One page. Three funnel stages.

A single-page dashboard: a wide Awareness band tapering to Consideration and a narrow Conversion point. Each card shows a proven reference reel (handle · views · outlier · link) next to your client's minimal-edit version.

TOP OF FUNNEL — AwarenessReach · satisfying, relatable, high-outlier reels

MIDDLE — ConsiderationTrust · educational hooks & topics

BOTTOM — ConversionOffer · lead capture

The process

6 steps, start to live

Set the client up in Sandcastles

Create a project per client, then find their niche's top creators and add them to the watchlist — that's what every "top X" pull reads from.

Search the niche (e.g. "outdoor living") and add 8–15 strong channels.
Let it index. Garbage in, garbage out.

Pull the content by funnel stage

TOF: top videos by outlier score + top formats → the reels that over-performed. Pick 5–6.
MOF: top topics + hooks → educational / authority pieces. Pick 3–4.
BOF: search for "comment / DM / consult" offer posts. Add 1 + your own closers.

Rule of thumb: high outlier + no talking = TOF · educational = MOF · offer/CTA = BOF.

Adapt to the client — don't reinvent

Keep the original hook and format. Swap one noun (their location, product, or price). Mark it "their version," and bracket real numbers like [$X] for them to fill.

Build from the template

Duplicate your master dashboard file, drop in the card data per stage, then rebrand: swap the logo and set three color variables (--tof --mof --bof). Save as index.html.

Automate it

No-code: keep a saved prompt that pulls the client's latest TOF/MOF/BOF and rebuilds the file for you. At scale: a small script hits the Sandcastles API with your key, injects the JSON into the template, and a weekly cron auto-refreshes every client's dashboard.

Deploy to a client subdomain

Drag index.html into a Cloudflare Pages project and point a subdomain at it — client.youragency.com or white-labeled on their domain. Free, instant, HTTPS.

The per-client checklist

✓Create Sandcastles project + add niche channels

✓Pull TOF (outlier reels), MOF (topics/hooks), BOF (offers)

✓Adapt each to the client (minimal edits, bracket numbers)

✓Fill the template + rebrand (logo + 3 colors)

✓Auto-generate (saved prompt or API script)

✓Deploy to a client subdomain on Cloudflare

✓Schedule a weekly auto-refresh

Productize it: this is a sellable deliverable — a "Content Strategy Dashboard" you set up in an afternoon and refresh automatically. Charge a setup fee plus a monthly for the always-updating version.

Copy-paste — it's yours

The exact prompt we run

Paste this into Cowork with the Sandcastles plugin connected, fill in the [brackets], and it builds the whole dashboard for you.

You're my content strategist and the Sandcastles plugin is connected.
Build a content-funnel dashboard for [CLIENT NAME], a [NICHE] business in [LOCATION].

1. From my Sandcastles [PROJECT NAME], pull the reference content by funnel stage:
   - TOP OF FUNNEL (reach): the 5-6 videos with the highest OUTLIER scores
     (satisfying / relatable / little-to-no talking). Use search_my_videos sorted
     by outlier + top_formats.
   - MIDDLE OF FUNNEL (trust): 3-4 educational / authority pieces. Use top_topics + top_hooks.
   - BOTTOM OF FUNNEL (convert): 1-2 offer / lead-capture posts - search for
     "comment", "DM", "consult", or "free".

2. For each reference, write [CLIENT]'s MINIMAL-EDIT version: keep the original
   hook and format, swap ONE noun (their location / product / price), and bracket
   real numbers like [$X] for them to fill.

3. Generate ONE self-contained HTML page shaped like a funnel: a wide AWARENESS
   band tapering to CONSIDERATION and a narrow CONVERSION point. Each card shows
   the reference (handle, views, outlier, watch link) next to the client's version.
   Brand it: inline [CLIENT]'s logo as base64 and set the CSS variables
   --tof / --mof / --bof to their colors.

4. Save it as index.html, fully self-contained, ready to drop on Cloudflare Pages.

Show me the funnel preview and the file when it's done.

Want us to just build it for you?

We'll set up your funnel dashboard, brand it, and keep it auto-updating. DM "BUILD" and let's talk.

Work with us