One of the first things I do when onboarding a new client at Helion 360 is audit their social media presence — not just what they're posting, but how their audience is actually growing. And almost every time, I find the same problem: their follower data lives in four different platform dashboards, nobody's exporting it consistently, and there's no historical record to benchmark against.
So I built a system. It's not complicated, and it doesn't require any paid tools. All you need is access to each platform's native analytics, a consistent schedule, and a well-structured Excel workbook. Here's exactly how I do it.
Why Bother Collecting This Data Manually?
Fair question. There are third-party tools that aggregate social data automatically — Sprout Social, Hootsuite Analytics, Buffer — but they come with monthly fees that not every client can justify. More importantly, the raw export you control is always more trustworthy than a dashboard you're renting access to. When a client asks me why their LinkedIn growth stalled in Q2, I want to show them a clean trendline I've owned from day one, not a screenshot from a SaaS tool we might cancel next month.
Manual collection also forces you to actually look at the numbers. That habit alone catches anomalies early.
Setting Up Your Excel Workbook
I keep one master workbook per client. Inside it, I create a tab for each platform: LinkedIn, Facebook, Instagram, and X (formerly Twitter). Then I create a fifth tab called Summary Dashboard that pulls from all four using simple cell references.
Each platform tab has the same basic column structure:
- Date — always the same day each week (I use Mondays)
- Total Followers / Page Likes — the headline number
- Net Change (Week-over-Week) — calculated with a simple formula
- Follower Growth Rate % — net change divided by previous week's count
- Notes — any campaigns, posts, or events that week worth flagging
For the net change column, I use =B3-B2 (current row minus previous row). For growth rate, it's =(B3-B2)/B2*100. Nothing fancy. The power is in the consistency.
Where to Find the Data on Each Platform
Go to your LinkedIn Page, click Analytics in the top navigation, then select Followers. You'll see total follower count and a graph of new followers over time. LinkedIn also lets you export follower data directly as a CSV — look for the export button in the top right of the analytics panel. I pull this weekly and paste the most recent follower count into my Excel tab. If you're managing a personal profile rather than a company page, you won't have the same export options, so I manually note the count shown on the profile.
Navigate to your Facebook Page, then click Professional Dashboard (or Insights if you're on an older setup). Under the Overview section, you'll find total Page Likes and Followers — note that these can differ, so I track both. Facebook allows data exports through Meta Business Suite under Insights > Export Data. I download the page-level summary monthly and cross-reference it with my weekly manual entries.
Instagram's native insights are only accessible via the mobile app unless you're using Meta Business Suite on desktop. In the app, tap your profile picture, go to Professional Dashboard, then Total Followers. You'll see a count and a growth chart. Unfortunately, Instagram doesn't offer a clean CSV export for follower counts the way LinkedIn does, so I screenshot and manually log the number each Monday. Meta Business Suite on desktop does surface some of this data under the Instagram tab, which can make it faster on larger accounts.
X (formerly Twitter)
Log into X and go to Analytics (analytics.twitter.com). The dashboard shows your follower count and a 28-day summary. X used to offer robust data exports, but since the platform changes in 2023, export functionality has been inconsistent depending on account tier. I manually record the follower count shown on the analytics homepage each week. If you have an X Premium subscription, you may have access to more detailed breakdowns.
Building the Summary Dashboard Tab
This is where the workbook earns its keep. My Summary tab has a row for each platform and columns for current followers, last week's followers, week-over-week change, and growth rate. All values are pulled from the individual platform tabs using references like =LinkedIn!B20 so it updates automatically as I add new rows.
I also add a simple bar chart comparing follower counts across platforms, and a line chart tracking growth rate over the past 12 weeks for each channel. These visuals take about 10 minutes to set up initially and become the centerpiece of monthly client reports.
Making It a Habit That Actually Sticks
The system only works if the data gets collected. Here's what I do to make sure it happens:
- Block 20 minutes every Monday morning specifically for social data collection across all clients.
- Use a checklist — I have a simple Notion page with each platform listed per client so I can tick them off.
- Add the Notes column religiously — if a client ran an ad campaign that week, I note it. If they went viral, I note it. Context is what separates data from insight.
- Version the file monthly — I save a copy at the end of each month labeled with the month and year, so there's always a clean archive.
What This Data Actually Tells You
Once you have eight to twelve weeks of consistent data, patterns emerge that you simply can't see inside a native platform dashboard. You'll notice which platform responds fastest to content pushes, which one flatlines during certain months, and where your client's audience is genuinely growing versus staying stagnant. That context shapes strategy in ways that vanity metrics alone never will.
At Helion 360, this tracking sheet is usually the starting point for every social media strategy conversation. It grounds the discussion in real numbers and makes it much easier to argue for — or against — doubling down on a particular channel.
If you're not collecting this data yet, start this Monday. Pick one client, set up the four tabs, log the numbers, and just keep going. You'll have more useful intelligence in 60 days than most agencies produce in a year.