Analytics reporting: turning data into decisions

Home / Everything About / Everything About Analytics / Analytics reporting: turning data into decisions

Your marketing director receives the weekly analytics report. Fifty pages. Traffic increased three percent. Bounce rate decreased two percent. Average session duration increased eight seconds. Conversions increased one percent.

She reads through. She thinks everything looks good. She does nothing. Week ends. Next week she receives next report. Same pattern. Everything slightly up. She makes no decisions.

Meanwhile your competitor receives a weekly report. Same data. Different presentation. Report shows: new channel launched Tuesday drove forty percent of week's traffic at double the conversion rate of existing channels. Recommendation: increase budget to new channel by three hundred percent.

Competitor increases budget. New channel grows. Competitor revenue increases fifteen percent this month. Your revenue increases one percent.

Same data. Different reporting. Different outcomes.

The cost of bad reporting

Bad reporting costs real money.

Example: SaaS company with ten thousand monthly recurring revenue. Churn rate is five percent monthly. That is five hundred dollars of revenue lost monthly.

Bad reporting shows churn is happening but does not investigate why. Does not identify which customer segments are churning. Does not connect churn to specific events.

Cost: one hundred customers per year at five hundred dollars each. That is fifty thousand dollars lost that could have been prevented.

Good reporting shows churn increased for customers who did not adopt the main feature. Shows feature adoption is the lever. Recommends onboarding improvement. Company improves onboarding. Churn drops one percent. Revenue increases one hundred dollars monthly. Five thousand dollars annually.

Difference between bad and good reporting: fifty thousand dollars found plus five thousand dollars saved. Fifty-five thousand dollars impact from reporting alone.

The difference between data and insight

Data versus insight

Data: traffic increased three percent this week.

Insight: traffic increased three percent because new paid channel launched Tuesday. New channel averaged eight dollars cost per visitor at three percent conversion rate. Existing channels average twelve dollars cost per visitor at two percent conversion rate. New channel is three percent more efficient. Recommendation: test increasing daily budget from two hundred to five hundred dollars per day for two weeks to understand if efficiency sustains at scale.

Data is just numbers. Insight connects numbers to cause and recommends action.

Bad reports list data. Good reports provide insight.

What makes a report actually useful

Reports answer specific questions

Useful report answers specific question. Does not answer all possible questions. Answers the one question stakeholder needs answered this week.

Example: marketing manager asked "which channels are underperforming." Useful report shows: paid search cost per acquisition increased from eight to twelve dollars over past four weeks. Organic search cost per acquisition increased from two to four dollars (actually free but customer acquisition cost including organic labor). Email cost per acquisition stayed flat at one dollar.

Report conclusion: paid search is underperforming relative to goal of eight dollar cap. Organic search degrading. Email stable. Recommendation: pause paid search expansion, investigate organic search degradation, maintain email spend.

Useless report shows: all channels contributed to overall revenue growth. Paid search generated forty percent of revenue. Organic generated thirty-five percent. Email generated twenty-five percent.

Both use same data. First report answers the question. Second does not.

The three components of useful reporting

Component one: comparison to baseline

Never show metric in isolation. Show metric compared to:

Last week or last month (immediate change). Same period last year (seasonal baseline). Average of last thirteen weeks (normal variation baseline).

Without comparison, metric is meaningless. Traffic was five thousand this week. Is that good or bad. Depends on baseline.

If last week was four thousand, this week is good. If last week was six thousand, this week is bad. If average is five thousand, this week is normal.

Baseline removes ambiguity.

Component two: connection to goal

Every metric should connect to business goal.

Goal: increase revenue. Metric one: revenue this week was fifty thousand. Goal is sixty thousand. Behind by sixteen percent. Metric two: traffic was ten thousand. Goal was eleven thousand. Behind by nine percent. Metric three: conversion rate was four percent. Goal was five percent. Behind by twenty percent.

Metric three is the problem. Traffic is slightly behind. But conversion rate is significantly behind. Recommendation: improve conversion rate to hit goal.

Without goal, metrics are just numbers.

Component three: reason for movement and recommendation

If metric moved, why did it move.

Conversion rate dropped from five to four percent. Why. Which pages converted worse. Which traffic sources converted worse. Which devices converted worse.

If you know why, you can fix it.

Report should explain reason and recommend fix.

What to exclude from reports

Do not include metrics that do not drive decisions.

Page views is a vanity metric. Do not report page views. Report conversions by page. That drives decisions.

Unique visitors is a vanity metric. Report traffic qualified for goal. That drives decisions.

Time on page is context metric. Include if time connects to conversion. But do not report time on page without conversion context.

Exclude metrics that make you feel good but do not guide action.

Report versus dashboard

Different purposes

Report: written narrative with data. Answers specific question. Provides insight and recommendation. Generated weekly, monthly, quarterly.

Dashboard: live view of metrics. No narrative. Self-service. Used for monitoring. Users explore what they want.

Report is pull. Dashboard is push. Report answers question. Dashboard lets you ask questions.

Both serve different purposes. Both needed.

The mistake of changing reports too often

You build a report. You use it for two weeks. You decide it is not useful. You change it.

Two weeks is not enough time to learn from report. You need month of data to see patterns.

Use same report structure for at least one month before deciding it is not working. Give stakeholders time to adapt and learn.

Changing reports constantly prevents learning.

Frequently asked questions

Should we include all metrics we can track in reports or just the most important ones?

How detailed should explanations of metric movements be?

If a metric is down should we explain it as seasonal variation or investigate it as a problem?

How do we prevent reports from taking hours to create?

Should we include competitor data in our reporting?

How often should we completely redesign our reporting structure?

DEVELOPMENT VERSION