Anonymized customer story

Independent digital publisher · UK

MarketingMedia & publishing · Mid-market

A digital publisher replaced 14 spreadsheets with one funnel.

An independent publisher’s audience team spent eleven hours every week assembling reports from fourteen spreadsheets. Kimo replaced them with a single reader-to-subscriber funnel, and the time went back into growing the audience instead of describing it.

time spent on weekly reporting11 h → 4.2 h a week: -62%
spreadsheets retired: 14
newsletter → paid conversion: +19%
from first read to paid member: 1 funnel

1Challenge

Fourteen spreadsheets and three definitions of “reader”

The company is an independent business publication with a daily newsletter, a weekly podcast on YouTube and a membership program that funds the newsroom. Revenue comes from two places: paid members and sponsors who buy newsletter and podcast placements. Both depend on the same question: how many engaged readers do we have, and where did they come from?

Answering it took fourteen spreadsheets. One for GA4 traffic by section, one per newsletter for Mailchimp opens, one for YouTube watch time, one for LinkedIn followers, one for Stripe memberships, a sponsor-reporting template per client, and a master sheet that tried to reconcile them with VLOOKUPs nobody dared touch. Every Monday the audience team spent most of the day on it, with editorial and commercial adding a few hours of their own.

The numbers also disagreed. Editorial counted “readers” as GA4 users, commercial counted newsletter subscribers, and finance counted paid members. When a sponsor asked how many engaged professionals would see their placement, three people gave three answers.

“Our Mondays used to be about copying numbers. Now they are about deciding what to publish next.”

Audience Director
Independent digital publisher · UK

2Solution

How the digital publisher set up Kimo

The audience team connected GA4, Mailchimp, YouTube, LinkedIn, Stripe and the one spreadsheet worth keeping (sponsor contracts) into Kimo. The team then built a single funnel model with five stages: visitor, newsletter signup, engaged reader (three or more opens in 30 days), member trial and paid member. Each stage is defined once in the semantic layer, with the definition visible to anyone who hovers the number.

Sponsor reporting moved from a template to a filtered dashboard per sponsor, sharing the same engaged-reader definition, so that commercial and editorial finally quote the same figure. Section editors got a view showing which stories pulled readers into the newsletter rather than which stories got clicks, which quietly changed what made the front page.

The Monday meeting now starts from a live dashboard and an Ask Kimo thread: “Which sections drove the most newsletter signups that became members this month?” Anomaly alerts flag sudden changes in open rates, which caught a deliverability problem with one email provider within hours instead of weeks.

Week 101/03
Six sources, one place
GA4, Mailchimp, YouTube, LinkedIn, Stripe and the sponsor sheet synced.
Week 202/03
One funnel, five stages
Visitor → signup → engaged → trial → paid, defined once for everyone.
Week 303/03
Spreadsheets retired
Sponsor reports and the Monday pack rebuilt as live dashboards.

Inside the workspace

What the digital publisher looks at every week

A recreation with fictional data. Hover the chart for values.

Independent digital publisher · UK · Reader → member funnel

Live

Readers (30d)

1.42M

+8%

Newsletter subs

186k

+4%

Paid members

12,480

+19%

Sponsor CTR

2.7%

+0.3 pts

Hours spent assembling reports

Per week, by team

Audience

Editorial

Commercial

Funnel this month

Stage	People	Conversion
Visitors	1,420,300	—
Newsletter signups	9,860	0.7%
Engaged readers	6,120	62.1%
Member trials	1,140	18.6%
Paid members	412	36.1%

Ask Kimo: sections that drove newsletter signups that became members

Results at a glance

time spent on weekly reporting: -62%
spreadsheets retired: 14
newsletter → paid conversion: +19%
from first read to paid member: 1 funnel

3Results

-62% time spent on weekly reporting.

Within three weeks the fourteen spreadsheets were archived. Reporting time across the audience, editorial and commercial teams fell from about eleven hours a week to 4.2, a 62% reduction, and most of what remains is discussion rather than assembly. Sponsors now receive a live link instead of a PDF, which has made renewal conversations shorter and friendlier.

The bigger win was editorial. Once section editors could see which pieces brought readers into the newsletter, the newsroom leaned into explainers and data stories that convert, and away from fast news that did not. Newsletter-to-paid conversion rose 19% over the next quarter, and the publisher added more members in Q3 than in the previous two quarters combined.

Independent digital publisher · UK: before and after Kimo
Metric	Before Kimo	With Kimo
Weekly reporting time	11 h	4.2 h
Sources of truth	14 spreadsheets	1 funnel
Sponsor reports	Monthly PDF	Live link
Definition of “reader”	3 competing	1, documented

“Sponsors stopped asking how we count readers. They can see it, and they renew faster.”

Commercial Director
Independent digital publisher · UK

4Stack

From 6 sources to one answer.

Sources

Google Analytics 4
Mailchimp
YouTube Analytics
LinkedIn Ads
Stripe
Google Sheets

Kimo models

Reader → member funnel
Newsletter engagement
Sponsor delivery

Semantic layer · one definition per metric

Dashboards

Monday audience pack
Sponsor portal
Section performance

Want results like these? Start with the demo.

Explore Kimo Marketing with realistic data, then talk to us about your sources.

See the Marketing demo Open the live app