learn-ship-ecommerce-enabler-with-phoebe / Leader session 3 of 6
Ship It: Social Commerce Enablers · Leader session 3 of 6

A channel nobody knew how to sell on

A marketplace opens a live channel. Hosts arrive from entertainment streaming, do what worked there, and the rooms fill up and do not buy. The only number anyone reports is GMV, and GMV cannot tell a good host from a big room, so coaching runs on opinion. Tonight's story is Pasar Live, a constructed channel on the fictional marketplace Pasar, where Serai Commerce ran streams for 12 brands in the channel's first two quarters. You leave with the four stages and the North Star that replaced the one number, the one table that got eight teams reading the same rows, and a first scorecard for whatever channel your business does not yet know how to sell on.

🟡 Core Enabler, agency and marketplace leaders Anyone who has to coach a team on a new channel 45 min
0-3 · Welcome 3-19 · One number, eight teams, two hosts 19-39 · Build-along: your channel's first scorecard 39-45 · Q&A
Part 0

Where this sits in the leader track

Session 1 drew the money map: an enabler owns neither the goods nor the buyer, so its margin is hours. Session 2 turned that into a sequencing rule. Tonight is the first story where the roadmap meets a channel that did not exist a year earlier, and the lesson is not about livestreaming. It is about what happens when a business judges a new activity on the one number it already had. Everything about Pasar Live on this page is constructed: the marketplace, the channel, the hosts, the eight streams and the lift at the end are invented to teach the shape of the problem, and every figure says so. The mechanics of livestream data science, from reading a room minute by minute to proving a lift, belong to the live commerce analytics course; here you get the leader's version, one link at each seam.

🎫 Clear all three quiz questions to stamp your passport Live = presented in the 45 minutes Self-study = the full depth, after class 🔍 Every diagram zooms

★ What you walk out with tonight. A one-page scorecard for a channel you are being asked to grow: the one number it is judged on today, the four stages and the North Star that should replace it, each with its denominator written down, who owns each event, two host types with one coaching line each, and the cadence of the loop. Plus a sentence you can say when someone shows you a GMV league table: "which of these rooms converted, and which were just big?"

Part 1 · covers why GMV alone cannot coach, and the four stages that can

One number cannot coach a host

6 min live

Pasar Live's first quarter looked like this from the weekly report: a column of streams, a column of GMV, sorted. The top of the table was always the same four hosts, the marketplace's own creators with big followings. The brands' own people sat at the bottom. Then someone asked how many people had been in each room, and the table fell apart.

FROM GMV ONLY TO FOUR STAGES AND A NORTH STAR constructed · eight Pasar Live streams, pooled by host type live card impressions STOP entries / impressions HOLD completers / entries LOVE replays / entries BUY clicks / impressions orders / clicks platform hosts 4 streams, 245 orders 8.39% 11.67% 2.83% 5.00% · 14.85% brand hosts 4 streams, 192 orders 3.98% 33.24% 8.71% 12.79% · 23.27% the one number NORTH STAR = orders / room entries platform 0.63% · brand 2.79% · brand hosts convert 4.4x Constructed. Pooled as ratio of sums, so big rooms weigh more; a mean of the eight rates would read differently.
🔍 Click to zoom - platform hosts win the GMV table on 245 orders; brand hosts win the only number that coaches
LiveWhat GMV-only reporting hides3 min▶

Pasar Live was new, so the marketplace lent Serai its own creator roster to host the first streams: people with followings, used to entertainment rooms where the job is to keep a crowd laughing for two hours. They did exactly that. The rooms were big, the chat was fast, and every week the GMV table ranked them first, because a room of 9,600 people that converts badly still out-sells a room of 1,600 that converts well.

That is the whole trap in one sentence: a big room with weak selling beats a small room that converts, every time, on GMV. The number is not wrong. It is the right number for the marketplace, whose fees are a share of it. It is the wrong number for anyone who has to decide which host to book next week, what to say to the host who lost the room at minute 14, or whether the brand's own product manager, quietly converting three times better in a room a fifth the size, should be given the bigger slot. GMV cannot answer any of those, because it is a total, and a total has no denominator.

In the constructed eight-stream table on the figure, the four platform-host streams produced 245 orders and the four brand-host streams 192. On GMV the platform hosts win. The question Serai's live ops lead finally asked, "how many people were in the room?", turned 245 into 245 out of 38,830 entries, and 192 into 192 out of 6,890. The second host type had been converting more than four times better for a quarter and nobody had a column that showed it.

LiveFrom GMV only to Stop, Hold, Love, Buy, plus the North Star3 min▶

Pasar Live's own naming, constructed for this story, follows the viewer through the room. Every stage is a ratio, and every ratio names its denominator:

StageRatioThe question it answersWhose work it grades
Stoproom entries / live card impressionsDid the cover and title pull people in from the feed?Traffic ops, the brand's set-up, the host's face on the card
Holdcompleters / entries (a completer stays past the 10-minute mark, constructed rule)Did the room keep the people it got?The host, minute by minute
Lovereplays / entriesDid people come back or watch the replay?The host and the content
Buyproduct card clicks / card impressions, then orders / clicksDid the pitch make people click, and did the click become an order?The host's ask, commercial's assortment, the brand's price
North Starorders / room entriesOf everyone who came in, how many bought?The whole stream, and the coaching plan

Four stages because four different people can fix four different things. A stream with high Stop and low Hold is a good card on a host who cannot keep a room; a stream with high Hold and a low click rate is a host people love who never asks for the sale. GMV shows one number for both. The stages show which conversation to have.

The live commerce analytics course teaches the marketplace platform's own version of this idea, named Enter, Stay, Click and Buy, and works it down to the minute: read the room. Pasar Live's names are its own, and the point tonight is not the names. It is that a channel judged on a total was re-judged on ratios, and the ratios could be coached.

Self-studyWhy a North Star is a ratio, and what its denominator decides4 min▶

A North Star for a channel has one job: to let you compare two streams that were not the same size, on the same night, with the same confidence. A total cannot do that, so a North Star is always a ratio. Then the whole argument moves to the denominator, because the denominator decides what "better" means.

  • Orders per room entry (Pasar Live's choice) says: a host is good if the people who came in bought. It rewards Hold and Buy, and it does not punish a host for a weak card, because the card is somebody else's job.
  • Orders per live card impression would fold Stop in, and would reward reach. Platform hosts would look better on it, because their faces pull entries. It is a fair number for the traffic team and an unfair one for a brand's product expert.
  • Orders per completer would grade only the ask, and would flatter a host who loses everyone but the buyers.

There is a second, quieter denominator decision: how you pool. The eight-stream table's overall conversion is 437 orders over 45,720 entries, which is 0.96 percent. The mean of the eight streams' own conversion rates is 1.71 percent. Both are honest. The first weights every room by its size, so the four big platform rooms drag it down; the second weights every stream equally, so the four small brand rooms lift it. A leader who quotes one without saying which will be corrected in the next meeting by someone quoting the other. Say "ratio of sums" or "mean of ratios", every time, and the room stops arguing about arithmetic and starts arguing about hosts.

Real world

The three questions a serious reader asks of a key metric. The U.S. Securities and Exchange Commission's 2020 guidance on the discussion of results tells companies what it would generally expect to see beside any key metric they report: "a clear definition of the metric and how it is calculated", "a statement indicating the reasons why the metric provides useful information", and how management uses it. Read it as a public checklist rather than a rule for anyone in this room: Pasar Live's North Star passes it only once "orders / room entries" is written down with what counts as an entry and what counts as an order, and GMV alone failed the second question, because nobody could say what decision it informed.

Part 2 · covers the eight teams a live channel touches and the one table that served them

Eight teams, one table

6 min live

The four stages were the easy part. The hard part was that a live stream on Pasar touched eight teams inside and around Serai, and each one had its own spreadsheet, its own clock and its own idea of when the stream started. The fix was not eight dashboards. It was one table at the grain of a minute, and everybody reading their own answer out of it.

EIGHT TEAMS, ONE MINUTE-GRAIN TABLE constructed · solid arrow = what the team gives · dashed arrow = what it reads back TECH gives: events fired per minute reads: which events went missing DATA ENGINEERING gives: one clock, one table reads: where the joins break ANALYSTS gives: four stages, North Star reads: host-type funnels LIVE OPS gives: notes on the minute reads: the minute the room left ONE MINUTE-GRAIN TABLE stream_id · minute · sku entries, cards, clicks, orders one clock UTC, start = 0 TRAFFIC OPS gives: promo and push timestamps reads: did the push land in-room COMMERCIAL gives: assortment per stream reads: which SKU carried the room BRAND TEAMS gives: room set-up, SKU count reads: their brand's scorecard HOSTS gives: the stream itself reads: own scorecard, coaching Constructed. Eight owners, one grain, one clock; every team reads its own answer out of the same rows.
🔍 Click to zoom - nobody gets a dashboard of their own; everybody gets a column in the same minute
LiveWhy one table beat eight dashboards3 min▶

The instinct when eight teams want numbers is to build eight views. Serai tried that for a month on Pasar Live and every Monday meeting became a reconciliation: traffic ops said the push went out at 20:14, live ops had the host's clock saying 20:11, tech's event log was in a different timezone, and the brand team's stream had "started" when the host went live while the analysts' had started when the card first appeared in the feed. Three minutes of clock disagreement is fatal when the thing you are trying to see is the minute a room emptied.

The table that replaced them is dull by design: one row per stream, per minute, per SKU, with the five events counted in it (room entries, product card impressions, product clicks, add to cart, orders), on one clock (UTC, and the stream's first minute is minute 0). Every stage in Part 1 is a sum of two columns of that table divided. Every team's question is a filter on it. Nobody owns a dashboard; each team owns the events it fires and the labels it writes, and reads back the answer it needs. The event spec itself, who owns each of the five events and what a missing one costs, is written as a contract in analyst session 4.

The estate argument matters more than the technical one. Eight dashboards are eight sources of truth, and two of them will disagree next quarter with nobody able to say which is right. One table with eight readers disagrees with nobody. It is the same rule session 6 applies to GMV and take rate for the whole company, met here first, on one channel, at the grain of a minute.

LiveLive ops notes as labels on the minute: the human half3 min▶

The machine half of the table is the five events. The human half is what Serai's live ops team was already doing: sitting in the room with a notebook, writing "minute 14, host went off on a story about her holiday, chat slowed", "minute 22, price reveal, cart spike", "minute 31, sound dropped". Before the table those notes lived in a chat thread and were gone by Thursday.

Attached to the minute, they become labels. Now the analyst can see that Hold collapsed at minute 14 in three of a host's streams and that the note at minute 14 says the same thing each time. The coaching conversation stops being "your Hold is low" and becomes "you lose the room when you leave the product; here are the three minutes it happened". That sentence is the whole reason the table exists. It is also the reason live ops, the least technical team of the eight, is the one the analysts cannot do without.

Self-studyThe loop: score, coach, go live, measure, repeat3 min▶

A scorecard that is read once is a report. A scorecard that is read before every stream is a loop, and the loop is the product. Pasar Live's ran weekly, constructed as follows:

  1. Score every stream the morning after, on the four stages and the North Star, from the minute table. No exceptions for small rooms; small rooms are where brand hosts live.
  2. Coach against the minute the room was lost. Not against the average. One host, one stream, the two or three minutes where Hold fell, with the live ops note beside each.
  3. Go live with one change agreed in that conversation, and only one, so that the next stream can tell you whether it worked.
  4. Measure the next stream the same way, on the same table, with the same denominators.
  5. Repeat, and keep the scorecards, because two quarters of them are what let you say anything about a lift at all.

The cadence is a leadership decision, not an analytical one. Weekly worked for Pasar Live because hosts streamed two or three times a week. A channel with one stream a month needs a different loop, and a channel with hourly streams needs the scoring automated before the loop can be human at all.

Real world

Even "order" has to be written down once. Sea Limited's annual report defines Shopee's GMV as the value of orders on the marketplace and counts an order "regardless of whether the transaction is settled or if the item is returned", with shipping and other charges included. That is a legitimate choice for a listed marketplace. It is also why the eighth column of Pasar Live's minute table needed a sentence beside it: does an order belong to the minute it was placed or the minute it was paid, and does a cancelled one leave the table? Eight teams had eight answers until data engineering wrote one.

Part 3 · covers two host types, why they need different coaching, and what the lift is worth

Two kinds of host, one scorecard

4 min live

Once every stream was scored on the same five ratios, the hosts sorted themselves into two shapes, and neither shape was "good" or "bad". They were good at different stages, and the scorecard said which conversation each one needed.

TWO HOST TYPES, SAME FIVE RATIOS constructed · eight Pasar Live streams pooled by host type · bar length = rate PLATFORM HOSTS · reach high Stop, low Hold, weak ask Stop 8.39% Hold 11.67% Love 2.83% Buy (click rate) 5.00% North Star 0.63% 245 orders · wins on GMV only BRAND HOSTS · product trust low Stop, high Hold, real ask Stop 3.98% Hold 33.24% Love 8.71% Buy (click rate) 12.79% North Star 2.79% 192 orders · converts 4.4x on the North Star Constructed. Same table, same denominators; the teal bar is orders per room entry, the number that coaches.
🔍 Click to zoom - the left column fills rooms, the right column empties carts; the scorecard says which to coach on what
LivePlatform hosts, brand hosts, and two different coaching plans2 min▶

Platform hosts came from the marketplace's roster. Their gift is reach: a face people already follow pulls entries, so Stop is high (8.39 percent pooled, constructed). Their weakness is everything after the door. Hold is low because the room was built for entertainment and drifts from the product; the click rate is low because the ask, "tap the card", is either missing or apologetic. Their coaching line is about structure: stay on the product, ask for the click every four minutes, and let live ops show you the three minutes you lost the room.

Brand hosts are the brand's own staff or merchant creators. Nobody knows their face, so Stop is low (3.98 percent). But the people who do come in stay, because the host knows the product and answers real questions; Hold is 33.24 percent, Love 8.71, and the click rate 12.79. Their coaching line is about the card and the slot: a better cover, a better title, a traffic push timed to the price reveal, because their problem is the door, not the room.

On GMV only, platform hosts win, 245 orders to 192, and Serai would have kept booking them into the best slots. On the North Star, brand hosts convert 4.4 times better (2.79 against 0.63 percent). The right answer was neither "book the brand hosts" nor "coach the platform hosts". It was both, on different stages, with the scorecard deciding which.

LiveThe 3x, and who gets to prove it2 min▶

Over two quarters of the weekly loop, Pasar Live's conversion, orders per room entry, went from 0.8 percent to 2.4 percent. Serai called it "the 3x". This result is constructed, like everything else in the story; it is the shape of what a scorecard-and-loop can do on a channel that was being run on opinion, not a claim about any real channel.

Even as a constructed number it carries a warning worth hearing as a leader. A rise over two quarters is not, on its own, proof that coaching caused it. The channel matured, the marketplace changed its feed, the brand mix shifted, the weak hosts left. Proving that a lift like this was the coaching, by comparing coached hosts against hosts who were not, is a difference-in-differences question and belongs to the live commerce analytics course: prove it worked. What you need to hold as the leader is simpler: keep the scorecards from before the loop started, because without a before there is nothing to prove.

Self-studyWhat the scorecard did to the commercial conversation3 min▶

Three things changed once the scorecard existed, none of them analytical. Slot allocation stopped being a negotiation between whoever shouted loudest and became a question of which host type the brand needed that week: a launch wanted a platform host's door, a repeat-purchase product wanted a brand host's room. Brand reviews gained a page the brand could not get from the marketplace, the per-host funnel for its own streams, which is the first of the "knowing" products session 5 prices. And the marketplace itself started asking Serai for the host-type comparison, because its own reporting was GMV by room and it had the same blind spot Serai had started with.

That last one is the estate lesson. A channel nobody knew how to sell on is a channel where the first team to write down a scorecard becomes the team everyone else asks. The scorecard cost eight teams a month of agreeing on a clock. It paid back as the one thing on the channel that was not opinion.

Real world

A constructed coaching minute, Pasar Live. Constructed to show the shape. Stream S3, platform host, 11,880 entries, the biggest room of the eight. Hold 11.0 percent, click rate 4.8 percent, 71 orders, top of the GMV table for the week. The live ops note at minute 14: "host started the giveaway story, chat asked for the price four times, no card shown until minute 19". The coaching line that came out of the table was one sentence: show the card when the chat asks for the price. Nothing about that conversation needed GMV.

Build-along

Your channel's first scorecard

★ 20 min · everyone builds

No code, no data. Pick a channel your business is being asked to grow and does not yet know how to sell on: a live channel, a short-video shop, a new marketplace, a creator programme. If you have none, do it for Pasar Live with the constructed figures on this page. Five steps, one card, and the card is the artifact you bring to session 4.

THE SCORECARD, ONE CARD, FIVE FIELDS worked example is Pasar Live, constructed · yours will differ 1 · judged on today GMV per stream, ranked weekly retire, do not delete 2 · stages + North Star Stop entries/impr · Hold completers/entries · Love replays/entries · Buy clicks/impr, orders/clicks 3 · event owners entry, card, click: tech · cart, order: data eng · notes on the minute: live ops 4 · host types platform: stay on the product, ask every 4 min · brand: fix the card and the slot 5 · loop cadence score every stream next morning · coach weekly · one change per stream NORTH STAR orders / room entries Five fields is the whole card. If a field needs a second page, the channel is not ready for a scorecard yet.
🔍 Click to zoom - the old number is retired on the card, not deleted; the stamp is the number that replaces it

Name the one number the channel is judged on today. Write it exactly as it appears in the report people actually read, with its sort order. Then write, in one line, the decision it cannot inform. If you cannot think of one, you are not looking at a new channel.

★ Field 1 · Pasar Live, constructedJudged on: GMV per stream, ranked weekly, top four hosts booked into prime slots Cannot tell: which host to coach, on what, or whether a small room converted

Write the four stages and the North Star, each with its denominator. Use your channel's words, not Pasar Live's. The test for each line is that two people reading it would compute the same number from the same table. Then say how you pool: ratio of sums or mean of ratios.

★ Field 2 · stages, constructedStop = room entries / live card impressions Hold = completers (past minute 10) / room entries Love = replays / room entries Buy = product card clicks / card impressions ; orders / clicks North Star = orders / room entries pooled as ratio of sums, say so

List who owns each event. An event with no owner is a column that will be empty on the night you need it. One name per event, and one team for the human labels. If two teams claim the same event, that is the clock disagreement from Part 2 about to happen; settle it now.

★ Field 3 · owners, constructedroom entry tech (player) fires per minute product card impression tech (player) fires per minute product click tech (player) fires per minute add to cart data engineering from the order system, one clock order data engineering placed minute, cancels leave the table notes on the minute live ops written in the room, attached by minute

Pick two host types and write one coaching line each. Not two hosts, two types: the shape you see most and the shape you see second. The coaching line names a stage and an action. If both lines say the same thing, you have one type, and that is worth knowing too.

★ Field 4 · host types, constructedPlatform hosts (high Stop, low Hold) "Stay on the product; ask for the click every four minutes." Brand hosts (low Stop, high Hold) "Your room works; fix the card, the title and the slot."

Write the loop cadence. When streams are scored, when hosts are coached, how many changes per stream, and who keeps the old scorecards. The last item is the one people skip, and it is the one that decides whether you will ever be able to say the coaching worked.

★ Field 5 · cadence, constructedScore: every stream, the next morning, from the minute table Coach: weekly, one host at a time, against the minutes the room was lost Change: one per stream, agreed in the coaching conversation Keep: every scorecard, from before the loop began; analysts own the archive
✗ The scorecard that is still the old report GMV per stream, plus "engagement" (undefined), plus a traffic-light per host set by the live ops lead's judgement. Reviewed monthly. Old reports overwritten.
Homework

Before session 4

30 min
  1. Take last month's report for your channel and add one column: the denominator. Re-sort on the ratio. Write down which rows changed places and bring the two orderings.
  2. Ask the three teams closest to your channel what time a stream, a campaign or a drop "starts". If you get three answers, you have found the clock problem before it finds you.
  3. Find the notes your operations people already write about the channel, wherever they live. Count how many are attached to a time you could join to an event. That count is your human half.
  4. For the two host types on your card, find the best-scoring stream of each on your North Star, not on GMV. If the two lists differ from the ones your slot allocation rewards, bring that to session 4, where the question becomes what data the platform will let you keep about those rooms at all.
Check yourself

Three questions

Clear all three and Leader session 3 gets stamped in your passport.

1 · Pasar Live's weekly report ranked streams by GMV. What could that table not show?

GMV is a total. A room of 9,600 people converting at 0.65 percent out-sells a room of 1,600 converting at 2.75 percent, and the table cannot tell you which is which. Dividing by room entries is the whole move; the four stages then say where in the room the difference happened.

2 · Pooled across all eight constructed streams, conversion is 0.96 percent as a ratio of sums and 1.71 percent as a mean of the eight rates. Why do they differ, and which is right?

The four big platform rooms convert at about 0.6 percent and pull the pooled figure down; the four small brand rooms convert near 2.8 percent and pull the equal-weighted mean up. Neither is wrong. Quoting one without naming it is what starts the argument about arithmetic instead of about hosts.

3 · In the constructed eight-stream table, which host type wins on which number?

Platform hosts fill rooms (Stop 8.39 percent) and sell to few of them; brand hosts fill small rooms (Stop 3.98) and convert 4.4 times better once people are inside. On GMV the first type wins; on orders per entry the second does. The scorecard exists so that both can be coached on the stage each one is losing.

Sources covered

What this session teaches, and where it came from

✓The four stages and the North Star: Stop, Hold, Love, Buy; orders per room entryConstructed, Pasar Live's own naming and definitions; the marketplace platform's Enter, Stay, Click, Buy version is taught in the live commerce analytics course, linked
✓Eight teams, one minute-grain tableConstructed: what each team gives and reads back; one clock, one grain, eight readers
✓Two host types on one scorecard, and the denominator trapConstructed eight-stream table, pooled by host type; 0.96 percent ratio of sums against 1.71 percent mean of ratios
✓The 3x conversion lift, 0.8 to 2.4 percent over two quartersConstructed and labelled so; proving such a lift by difference-in-differences is owned by the live commerce analytics course, a6, linked
◐The per-minute event spec: entry, product card impression, click, add to cart, orderNamed here as the table's five events; written as a contract with owners in analyst session 4
◐What a reader asks of a key metricU.S. Securities and Exchange Commission, "Commission Guidance on Management's Discussion and Analysis of Financial Condition and Results of Operations", Release No. 33-10751, February 2020, read at source; used as a public checklist, not as a rule for any reader here. Sea Limited, Annual Report on Form 20-F for the fiscal year 2019, "Conventions" definitions, read at source

Every fact on this page, and its verification tier, is recorded in the course's source map.

Leader session 3 cheat sheet · pin this

A total cannot coachGMV has no denominator. A big room with weak selling beats a small room that converts, every time.
Four stages, one starStop, Hold, Love, Buy, then orders per room entry. Each ratio grades a different team's work.
The denominator decidesPer entry rewards the room; per impression rewards reach. Ratio of sums or mean of ratios: say which.
One table, eight readersStream, minute, SKU, five events, one clock. Nobody gets a dashboard; everybody gets a column.
Notes become labelsLive ops' minute-14 note, attached to the minute, is the sentence the coaching conversation needs.
Two hosts, two plansReach hosts need structure and the ask; trust hosts need the card and the slot. Keep the old scorecards for the proof.