Build the Nykaa Beauty Discovery Index: From Raw Survey Data to Distribution Kit

Marketing Academy · Field Work●Content Marketing

CoreBuild the Asset· 70 minutes

Nykaa (FSN E-Commerce Ventures)

Objective: Turn a raw 520-respondent survey export into a named, quotable branded index with a moat-grade analysis section and a methodology paragraph, following the lesson's publishing loop.

You're the content lead at Nykaa. Research just handed you a clean export from a 520-respondent survey of Indian beauty shoppers. Nobody has named it, written the analysis, or planned distribution yet.

Name the index, extract the one quotable stat, write the counter-intuitive analysis, and draft the methodology paragraph.

Before you start

What you'll need

Free path (everything below is enough to finish)

Google Sheets

FreeHold and filter the raw 520-row survey export

Free, sufficient for cross-tabbing a single survey wave

Google Docs

FreeDraft the index name, quotable stat, analysis, and methodology paragraph

Free, shareable with editors and PR for the distribution kit

The process

2 steps

Step 01 of 02

Naming a branded institution and a quotable metric

The lesson's Publishing Loop says to name a metric only you can measure and assign a brand name to the dataset before publishing edition one; 'the Acme SaaS Spend Index' beats 'Our Q2 Data Report.'

The survey found 61% of respondents now research a beauty product on social video before buying it, even in-store. What do you name the index, and what's the single quotable sentence?

Google Docs— Draft the index name and the pitch-ready quote at the top of a new doc.

Procedure

Pull the single most surprising, specific stat from the export (61% pre-purchase video research)
Name the index: 'The Nykaa Beauty Discovery Index', not 'Nykaa Survey Report'
Write one quotable sentence a journalist could paste directly into an article
State the cadence: published every six months, starting now

Sample output

INDEX NAME: The Nykaa Beauty Discovery Index, Edition 1
QUOTABLE STAT: '61% of Indian beauty shoppers now watch a video before buying, even when they purchase in-store.'
CADENCE: Published every six months, next edition Q1 2027.

Healthy

A named, quotable index with a stated cadence that a journalist can cite as an ongoing source, not a one-off report.

Unhealthy

'Nykaa Q3 Beauty Survey Results' with no name, no cadence line, and three paragraphs before the actual number appears.

What this means

The name and the single stat are what get quoted; a generic report title gets skimmed once and forgotten.

So what do I do about it?

Symptom	Action	Effort
The report draft opens with methodology instead of the number	Move the single quotable stat to the first sentence of the summary	5 min

YouYou can do this yourself, no engineering access required.

Step 02 of 02

What makes the analysis moat-grade

Moat-grade analysis needs a named trend with a number attached, a counter-intuitive finding, a practitioner quote, and a methodology note so journalists can verify the sample.

The same export shows in-store shoppers now watch more pre-purchase video than online-only shoppers do. What's the counter-intuitive takeaway, and what does the methodology note need to say?

Google Docs— Add a 'Key Finding' and a 'Methodology' section below the quotable stat.

Procedure

State the counter-intuitive finding: in-store shoppers, not online shoppers, are the heavier video researchers
Add one practitioner quote interpreting why (a category lead or founder, not the AI)
Write a methodology note: sample size 520, collection window, how respondents were recruited, any exclusions

Sample output

KEY FINDING: In-store shoppers watch 1.4x more pre-purchase videos than online-only shoppers, the opposite of what most retailers assume.
METHODOLOGY: 520 respondents, Indian metro beauty shoppers, surveyed June-July 2026 via Nykaa's owned panel, excludes respondents who had not purchased beauty products in 90 days.

Healthy

A finding a general-purpose AI could not have written without the dataset, backed by a verifiable methodology note.

Unhealthy

A takeaway that just restates the topline stat ('video matters for beauty shoppers') with no methodology section at all.

What this means

The counter-intuitive angle plus a checkable methodology is what makes journalists trust and cite the number.

So what do I do about it?

Symptom	Action	Effort
The analysis section restates the stat instead of interpreting it	Add one sentence naming who is surprised by the finding and why	5 min

YouYou can do this yourself, no engineering access required.

Final deliverable

A one-page branded index draft: name, quotable stat, counter-intuitive finding, and a verifiable methodology paragraph, ready to hand to a PR team.

See a reference example

Sample output

Casper Sleep Recovery Index, Edition 1 (excerpt)

QUOTABLE STAT: 'Side sleepers who switched mattress firmness reported 22% fewer overnight wake-ups.'
METHODOLOGY: 540 respondents, US mattress owners, surveyed via Casper's post-purchase panel, March 2026.

Success criteria

You're done when you can:

Index has a distinct brand name, not a generic report title
The quotable stat appears in the first sentence of the summary
The analysis section states a counter-intuitive finding, not a restatement of the topline number
A methodology paragraph states sample size, collection window, and recruitment method