Learn with Phoebe ยท Let's Ship It End to End

Ship It: Social Commerce Enablers

A social-commerce enabler runs a brand's stores, content, livestreams, ads and customer service across several marketplaces, and owns neither the goods nor the buyer. That one fact decides its data roadmap. Its margin is the hours it stops spending, so the first use cases to build are the ones that remove work, and the pricing optimisation most roadmaps start with mostly pays the brand. Its moat is real at the store and the SKU, where the keys are its own, and does not exist at the customer, where the marketplaces mask the buyer. Six leader sessions follow Serai Commerce, a fictional enabler, from its money map to a metric registry fit for a listing. Eight analyst sessions build the estate on real Olist orders and end on a bench that measures, pair by pair, which joins survive the masking.

14sessions, two tracks
7data domains, one estate
8614real orders on the bench
23.3%best customer join, measured
45min per session

Leader track ๐Ÿ›ฐ๏ธ ยท six sessions, no code

For whoever runs, funds or advises an enabler. What it sells, what that decides, what the marketplaces let it keep, and the one-page roadmap a chief executive can fund.

Analyst track ๐Ÿ”ง ยท eight sessions, Python and SQL

Serai's estate built on real Olist orders, split into three masked marketplace exports. Session 8 runs the identity ladder and the roadmap sequencer in your browser.

๐Ÿ—บ๏ธ Analyst session 1 ยท start here

Seven domains, one enabler estate

The estate by the work that makes it, five words for obtainability, the two chains most of the value hangs on, and a grain check on seven real tables.

โ–ถ Start here
๐Ÿ”€ Analyst session 2

Three marketplace exports, one schema

Conform three exports with different names, ids and masking into one order schema, with a platform column and the two mapping tables an enabler owns.

๐Ÿชช Analyst session 3

The identity gate

Which join keys survive masking, at which grain. Pair-based scoring by hand, and why a key that finds every real link can still be worthless.

โฑ๏ธ Analyst session 4

Per-minute events for a live channel

The event spec for Pasar Live: entry, product card impression, click, add to cart and order, per minute, written as a contract with an owner on every field.

๐Ÿงฎ Analyst session 5

Stop, Hold, Love, Buy as code

Four stage metrics and a North Star computed across many brands' streams, with the denominators that make platform hosts and brand hosts comparable.

๐Ÿท๏ธ Analyst session 6

Content to creator yield

A persistent tag on every asset, joined to settled orders, so content and creators are ranked on what sold rather than on what was attributed.

๐Ÿ“ Analyst session 7

The metric registry as code

One definition per metric in a versioned file, with lineage to its source tables, and tests that fail the build when a definition drifts.

๐ŸŽ›๏ธ Analyst session 8

The enabler bench

8,614 real orders, three masked exports, seven keys, three grains, and a roadmap sequencer gated by what the joins can reach. Break it, and nine use cases stop.

the capstone
start here foundations hands-on capstone

Choose your path ๐Ÿ—บ๏ธ

Three doors into the same argument. Both tracks start at their own session 1, because the money map and the estate map are what make the rest arguable.

๐Ÿ’ผ I run or fund an enabler L1 โ†’ L2 โ†’ L4 โ†’ L6 the money map, the sequencing rule, the moat, the registry
๐ŸŽฅ I run the live and creator side L3 โ†’ A4 โ†’ A5 โ†’ A6 from GMV only to a scored stream and a creator ranked on settled sales
๐Ÿ”ง I build the estate A1 โ†’ A2 โ†’ A3 โ†’ A7 โ†’ A8 the map, the schema, the gate, the registry, then measure it

Your passport ๐ŸŽซ

Clear all three quiz questions in a session and it gets stamped. Fourteen stamps across both tracks, and they live in this browser only.

What is real here ๐Ÿงพ

A course about which data you can actually have should be exact about which of its own numbers are measured.

ClaimStatus
Serai Commerce and Pasar LiveFictional. Every Serai figure (48 brands, 220 people, the fee lines, the hour sinks) and every Pasar Live result, including the 3x conversion lift, is constructed and labelled so on the page
The 8,614 orders on the benchReal, from the public Olist dataset (CC BY-NC-SA 4.0): which customer placed each order, the zip and city on it, the store and SKU on every line. The sample keeps Olist's real 3.0 percent repeat rate
The three exports and their maskingConstructed. The split is seeded; the masking is modelled on the patterns public integrator documentation reports for the marketplaces. Names and phones are synthetic, because Olist publishes neither
23.3 percent at customer grain, 100 at store grain, 97.5 at SKU grainMeasured by the bench in your browser, pair by pair, against the hidden real ids, and matched to the digit by a Python reference run. A break button shuffles the ids and every grain falls to near zero
The roadmap sequencerModelled. Every figure comes from one assumptions block on the page, which you can edit. The ordering logic is real arithmetic; the numbers are invented
Marketplace buyer maskingReported, from public integrator documentation, because the marketplaces' own seller centres sit behind a login. Dates are quoted as reported, and they change often
GMV includes shipping; the SEC's three questions for a key metricRead at source: Sea Limited's annual report definitions (fiscal 2019), and the SEC's February 2020 guidance on key performance indicators

The knowledge map ๐Ÿง 

Both tracks at a glance - hover a session to spotlight its concepts, click any node to jump in.