Engagement by content format · bar
Which formats earned attention, the basis for the strategy.
Audience segment mix · polar area
Who the audience is, used to target content and offers.
Reach by day & hour · heatmap
Audience behaviour analysis used to schedule posts at peak windows.
Audience to revenue opportunity funnel · funnel
From monthly reach down to a sized conversion opportunity.
The question
I run my own digital products and communities. The question I treat like any analytics problem: what content actually grows an engaged audience, and how does that audience convert into a revenue opportunity?
How I did it
- Treated growth as a running experiment, testing formats, hooks and posting times against a baseline and keeping what worked.
- Exported reach, engagement and follower numbers out of the platform analytics into Excel, then built the dashboards and charts there.
- Read audience behaviour off a day by hour reach heatmap and a breakdown of who the audience actually is.
- Laid the audience out as a funnel, from reach down to the people worth turning into revenue.
What the analysis found
- A small set of formats drove most of the reach, doubling down gave a 3.1× reach lift.
- Posting time analysis lifted average engagement to 6.8% by matching content to active hours.
- Disciplined experimentation grew Facebook to 572K in four months and Instagram to 387K in five.
Outcome: It is the same loop a business runs for product or pricing. Pick a hypothesis, test it, measure it, keep what works. Here I just pointed it at audience growth and money. This is the real project behind the method I use in the simulated case studies.
Tools
Platform analytics · Excel · Dashboards · Experimentation