06-reference/research

mac matrix downloadable template status

2026-05-18·research-brief·source: deep-research

MAC Matrix Downloadable Template - Status and Ship Plan

The question

The May 11 practitioner-newsletter-acquisition brief named MAC as the Phase 1 lead-magnet candidate for Sanity Check. The mechanic only works if the matrix is a one-click, copy-into-my-workspace artifact - not a markdown file in a private vault. Where does the MAC matrix template live today as a public downloadable, and is the lift from "currently exists" to "Notion / Google Sheet duplicable with email capture" low enough to ship this week, or is real design work in the path?

What we already know (from the vault)

What the web says

Conversion benchmarks for niche practitioner lead-magnets (2026)

The format-matters numbers across multiple sources converge tightly:

Format Opt-in rate Source
Generic "subscribe to newsletter" box 1-3% DigitalApplied 2026 benchmarks
Generic PDF guide 5-10% DigitalApplied 2026 benchmarks
Niche checklist / calculator 25-40% DigitalApplied 2026 benchmarks
Interactive self-assessment 25-40% DigitalApplied 2026 benchmarks
Free tool / calculator (SaaS audiences) 28-42% NetPartners 2026
Audit report 15-25% DigitalApplied 2026 benchmarks

The 3-5x multiplier for niche vs generic lead-magnets is consistent across the surveyed sources. The MAC matrix sits in the high-converting band: it is concrete (18 cells, named severity tiers), it is industry-specific (analytics-engineering / dbt), and it is immediately useful in the persona's actual work (definition-of-done for a new dbt model).

Notion-as-template-mechanism: the canonical pattern

Notion has a first-class "Allow duplicate as template" toggle that converts any published page into a one-click copy into the visitor's workspace. The flow:

  1. Share button -> Share to web -> ON
  2. Toggle "Allow duplicate as template" -> ON
  3. Optional: turn OFF search-engine indexing (recommended for lead-magnets - you want the landing page indexed, not the raw template)
  4. Copy the public URL

When a visitor hits the URL, Notion shows a preview with a prominent "Duplicate" button that drops the page into their workspace (any plan, including free). This is the lowest-friction copy mechanism on the practitioner-tool internet today. Lower friction than Google Sheets (which requires a Google account and a File -> Make a copy step) and dramatically lower than a PDF (which requires the user to manually re-create the structure to use it).

The well-known cited examples confirm the mechanic works for senior practitioners:

The MAC matrix shape is closest to Lenny's spreadsheet pattern: a structured grid the persona fills in for their own model, then copies for the next model.

Format choice: Notion vs Google Sheets vs PDF for MAC specifically

The 18-cell matrix has three usage modes:

  1. Reading / understanding (one-time): the populated worked example. Static. Any format works. PDF is fine.
  2. Filling in for a real model (recurring): a blank template the engineer fills in per dbt model. This is the high-value use. Needs to be re-usable, version-controlled in the team's own workspace, and shareable internally.
  3. Reference patterns (lookup): the SQL appendix. Static reference. Markdown / code-snippet format is best.

Notion handles all three in one document - prose for #1, a duplicate-and-fill database or page-per-model pattern for #2, and code blocks for #3. Google Sheets handles #2 well but degrades for #1 and #3. PDF handles only #1.

Recommendation: Notion as primary, with a Google Sheets mirror for engineers who prefer that surface. The Notion version is the canonical artifact promoted on the MAC landing page. The Sheets version is a secondary download from the same page for engineers who live in spreadsheets (a real subset of the practitioner persona, particularly data analysts vs data engineers).

Friction points that kill conversion for senior practitioners specifically

Cross-checked against the May 11 practitioner-newsletter brief and the 2026 lead-magnet best-practice sources:

Convergences and contradictions

Internal sources, web evidence, and the MAC product trajectory all point the same direction: the matrix template IS the lead-magnet shape that fits this persona, and Notion-with-duplicate-toggle IS the right delivery mechanism. No real contradictions in the inputs.

The one tension is the MAC landing page design directive (B&W blocky/graffiti aesthetic) vs Notion's neutral default styling. A duplicated Notion template will look like every other Notion template once it lands in the user's workspace. That is FINE for the artifact itself - the user wants it to blend into their team's existing Notion. The landing page is where the MAC visual personality lives. The Notion template is the utility hand-off.

The May 14 pre-launch checklist's P0 scrub blocker does not apply to the existing testing-matrix-template.md - it uses generic SF Closed-Won and ARR Waterfall examples, no MG client identifiers. The scrub blocker applies to deck and dashboard materials. The matrix template can ship as-is (with one small naming sweep below).

Synthesis for RDCO - the ship plan

Verdict: ship this week. Friction is low. No design work blocks it.

The work decomposes into 5 hours total, sequenced:

Step 1 (45 min): Port the markdown matrix into a Notion page.

Step 2 (30 min): Sweep the Closed-Won example for any remaining over-specific language. The existing markdown is already generic but worth one read-through. The ARR Waterfall example is fully synthetic and ships as-is.

Step 3 (15 min): Configure Notion sharing.

Step 4 (90 min): Wire the email-capture loop on mac.raydata.co per [[01-projects/mac-landing/2026-05-05-build-spec]].

Step 5 (60 min): Mirror to Google Sheets as a secondary download.

Step 6 (15 min): Update the May 11 practitioner-newsletter brief with the now-resolved status, and update this page in Notion with the published Notion URL.

Design work that is NOT required this week (deferred to Phase 2):

Why this ships now, not after the paid product: The lead-magnet's job is to build the Sanity Check list while the paid MAC product is still being de-MG-scrubbed. The two work surfaces are decoupled. The free Notion template is the practitioner-acquisition lever today; the paid sample-project + commercial drip campaign is the September product. Shipping the free template earns audience signal (download volume, share rate, email replies) that informs the paid product positioning at zero opportunity cost.

Open follow-ups

  1. Does the founder want the Notion template hosted under the existing Ray Data Co workspace, or in a dedicated "templates" workspace separated from internal RDCO operations? (Surface for audit if engineers explore upward in the URL.)
  2. Should the Sheets mirror be a Google Sheet, a downloadable .xlsx, or both? Slight preference for both - some engineers will not touch Google's surface.
  3. When the next Sanity Check piece ships ("Your dbt models are about to get Tickered"), should the matrix download be the in-body CTA or the footer-only CTA? Recommend in-body at the natural cliff-hanger point in the essay (after the framework is named but before the worked example).
  4. Open from the May 11 brief, restated here for completeness: does the founder have warm-network reach to ask Daniel Beach, Ananth Packkildurai, Benn Stancil, or Joe Reis to include the template in a curated link? Cheap distribution multiplier once the artifact is live.

Sources