The hey anna blog
Tutorials, methodology notes, and case studies from the analyst we're building.
35 posts· newest first
Filter by:
More posts
Guides
Two Versions of the Same Campaign: Which One Actually Worked?
Most campaign post-mortems compare CPM and CTR and call it done. Anna joins engagement metrics with comment sentiment so the creative director can defend the work with the comments, not just the clicks
For brand
Guides
Why Your Instagram Post Tanked on TikTok: Cross-Platform Engagement Asymmetry, Read at Scale
The same brand creative behaves like three different posts on TikTok, Instagram, and YouTube Shorts. Anna quantifies the asymmetry so next quarter's content plan is a brief, not a guess
For brand
Tutorials
What Subject Lines Actually Earn Clicks? An Analysis of 12 Months of Open Data
Beehiiv and Substack show open rate per email. They don't tell you why. Anna classifies a year of subject lines by theme and surfaces the gap between what gets opened and what actually gets clicked
For creators
Tutorials
TikTok Niche Benchmarking: How Anna Reads 50 Competitor Accounts in 10 Minutes
Manually reviewing 50 peer creators in your niche takes hours and is wrong by next week. Anna pulls the public data, segments by follower tier and posting cadence, and gives you a benchmark report that refreshes on one click
For creators
Tutorials
What YouTube Studio Won't Tell You: Which Topics Retain Subscribers?
YouTube Studio shows watch time per video. It doesn't show which content series actually earns and keeps subscribers. Anna runs a topic-level cohort analysis on your export so you can stop optimising for views
For creators
Guides
Analyse a Notion Workspace Without Building Another Rollup
How to run real analysis on a Notion workspace — projects, CRM, OKRs, content calendars — without rollup chains, formula fields, or third-party sync. Anna reads your databases and answers in plain English.
For saas
Guides
Analyse an Airtable Base Without Building a Single Formula Field
How to run real analysis on an Airtable base — without rollups, scripting blocks, or a paid Sync integration. Anna reads your tables and answers in plain English.
For saas
Guides
Analyse Mailchimp Campaigns Without Exporting Reports
How to analyse Mailchimp campaign performance without CSV exports or paid integrations. Anna pulls campaigns, segments, opens, and clicks, and answers in plain English.
For agency
Guides
Google Search Console Analysis Without Exporting a Single CSV
Analyse Google Search Console data without exports, GA joins, or spreadsheet pivots. Anna connects to GSC, pulls queries, pages, and clicks, and answers in plain English.
For agency
Guides
Your Own Account Is the Best Brief You'll Get This Quarter
Anna pulls your last 90 days of posts, classifies them by category, tone, and product, and tells you which buckets drove engagement. Then she reads the comments, ranks the top engagers, fetches their follower counts, and hands you two lists: ambassadors worth talking to, and customers crying out for help.
For dtc
Guides
Read Every Comment Under Your Competitor's Last 5 Launches
Anna pulls comments from a competitor's TikTok, Instagram, YouTube, X, Facebook, or Threads posts. Sentiment, themes, product mentions, translations. The bit you'd skip if you had to do it by hand.
For dtc
Guides
AI Analysis for Google Analytics: A Way Around the Hardest Tool in Marketing
Can you use AI to analyse Google Analytics? Anna connects to GA4, runs the Explorations you'd otherwise build, and answers in plain English.
For agency
Updates
One Project, Many Reports
Stop duplicating projects to tell a different story. Keep the exec summary, the deep-dive, and the board update side by side — same data, different audiences.
For agency
Guides
How to Find Where Your Ecommerce Funnel Is Leaking
How do you find where customers drop off in your ecommerce funnel? Anna joins GA4, Shopify, and ad data — segment-level drop-off, ranked by recoverable revenue.
For shopify
Guides
Marketing Attribution Across Meta and Google Ads Without an Analyst
Why don't Meta and Google Ads agree on conversions? Anna pulls both platforms plus your revenue source, dedupes overlap, and runs real multi-touch attribution.
For agency
Guides
Paste a Link. Start the Analysis.
If the data lives on a webpage, Anna can read the webpage.
Updates
Your Data Stack Just Became a Conversation
26 integrations are live — with more shipping every week. Connect your tools, ask questions in plain English, and let Anna pull the data and run the analysis.
Guides
How to Analyze Survey Data Without a Statistics Background
How to analyse survey data without a stats background: upload responses, ask Anna what she sees — cross-tabs, sentiment, significance, plain English.
Guides
How to Analyze Your Shopify Sales Data Without Code
How do you analyse Shopify sales data without SQL? Connect orders, ask Anna in plain English — she runs cohort, LTV, and product affinity analysis.
For shopify
Updates
Stop Exporting CSVs Every Time You Need an Answer
Live integrations are here. Connect the tools you already use, launch analysis faster, and stop rebuilding the same dataset by hand.
Tutorials
What Is Cohort Retention Analysis? (And How to Run One Without a Data Team)
What is cohort retention analysis and how do you run one without SQL? Anna builds proper NRR cohort tables from Stripe or your warehouse — no data engineer required.
For saas
Tutorials
How to Analyse HubSpot CRM Data Without an Analyst or SQL
How to analyse HubSpot data without SQL: pipeline coverage, stage conversion, deal velocity. Anna connects directly to HubSpot and runs the maths in plain English.
For saas
Tutorials
How to Analyse a CSV File Online (Without Code or Excel)
How do you analyse a CSV file online without code or Excel? Upload it, ask in plain English, get statistics and a shareable report. Step-by-step guide.
Comparisons
ChatGPT vs Real Data Analysis: Head-to-Head Comparison
What's the difference between ChatGPT and real data analysis? Same dataset, same questions, two tools. One hedged. The other ran the stats. Here's what happened.
For agency
Guides
Become the Data Whisperer. Without Hiring One.
Every team wants data-driven decisions. Most can't afford a data team. Here's how to get the analytical firepower of a full team — for the cost of one tool.
Guides
How to Analyze Stripe Revenue Without SQL
Stripe's dashboard shows MRR. It doesn't show why MRR moved. Anna connects to Stripe directly, runs the cohort math, and tells you what's actually driving the number.
For saas
Updates
What You Share Is What They See
Analysis isn't done until someone else can see it. Here's how shared reports now look when they land in a Slack channel or an email.
For agency
Case studies
Your Monday Doesn't Have to Start With a Spreadsheet
The monthly reporting workflow that takes 2 hours per client can take 10 minutes. Here's the before and after.
For agency
Guides
Dashboards Show What Happened, Not What to Do
Your dashboard shows you that leads dropped 22%. It doesn't tell you why, or what to do about it. That gap is where decisions stall.
Guides
Where Your Data Actually Goes
A plain-English walkthrough of what happens to your file from upload to insight to deletion. No marketing speak, just the architecture.
Case studies
Anna Read 2,000 Customer Reviews. Here's What the Star Ratings Hid.
A DTC skincare brand's reviews told a story their star ratings didn't. Here's how Anna used AI formulas and a 10-minute report to surface a product problem hiding in plain sight.
For dtc
Guides
You Don't Need to Be a Data Person
Everyone hits the spreadsheet ceiling. The tool is built for people with good questions, not advanced Excel skills.
Guides
How Anna Shows Her Work
AI observations are not the same as AI evidence. Here's how Anna backs every finding with statistical proof you can stand behind in a meeting.
Guides
Can ChatGPT Replace a Data Analyst? Honest Comparison (2026)
Can ChatGPT replace a data analyst? Short answer: no. It hedges, can't run real stats, and outputs a chat thread. Here's what actually does the job.
We use cookies to improve your experience. Privacy policy