Four Hours, One Spreadsheet, and a Much Smarter Social Strategy
You do not need a pricey agency report to see what is broken. A focused afternoon and the right questions will show you.
Most social media accounts are not failing. They are drifting, and drift is much harder to notice than failure. Posts still go out, a few likes still roll in, and nobody stops to ask whether any of it is working. Months pass, the bio still mentions a promotion that ended long ago, and the link in it goes to a page that no longer exists.
A social media audit fixes drift. It does not need to be a forty-page agency report or a week of meetings. With one focused afternoon, a spreadsheet, and the right questions, you can see what is working, what is broken, and what to change first. This is the same framework the White Glove Social Media team runs when we take over a new account, simplified so any business owner can do it.
Hour One: Profiles and First Impressions
Start where your customers start. Before anyone reads a single post, they see your profile picture, your name, your bio, and your link. These details shape the first impression in about three seconds, and they are the easiest things to fix. Open every account you own in a fresh browser window and look at it like a stranger would.
Check the basics on every profile
- Name and handle: are they the same, or close to it, on every platform?
- Profile photo: is it a clear logo or face that reads well as a tiny circle?
- Bio: does it say what you do, who you help, and where you are in plain words?
- Link: does it work, and does it go to a page that makes sense for social visitors?
- Contact options: can someone call, email, or book without hunting?
- Cover images and highlights: are they current, or left over from an old campaign?
Search for yourself like a stranger
Type your business name into the search bar of each platform. Do you show up first? Are there fan pages, old location pages, or imposter accounts competing with you? Then search for the service you offer plus your city. If competitors appear and you do not, note it. That gap is an opportunity.
Find the accounts you forgot about
Almost every business has an abandoned profile somewhere, such as an old business listing or a forgotten video channel. List them all in your spreadsheet. Each one should either be updated and used, or closed and redirected so it stops confusing people.
Hours Two and Three: Content and Audience
With profiles cleaned up, it is time to look at what you have actually been posting and who is actually seeing it. This is the heart of the audit, and it is where most businesses find their biggest surprises. Give yourself two full hours here, because patterns only show up when you look at enough posts at once.
Pull your last ninety days of posts
Most platforms let you export or view post performance from their insights tools. Copy the last ninety days into your spreadsheet with one row per post. If you post on several networks, give each platform its own tab so you can compare them later.
Columns worth adding
- Post date and platform
- Format, such as photo, carousel, video, or text
- Topic or content pillar
- Reach or impressions
- Engagement, including comments, shares, and saves
- Link clicks, if any
- Leads, calls, or sales you can connect to the post
Sort by what actually moved
Sort the sheet by engagement, then by link clicks, then by leads. Look at your top ten and bottom ten posts in each view. Ask simple questions. Do videos beat photos? Do how-to posts beat promotions? Do posts featuring people beat posts featuring products? The answers are often obvious once the data is in front of you, even if they surprise you.
Look at who is really following you
Open the audience section of each platform's insights. Check location, age range, and active times. A local plumber with half its followers in another country has a problem worth knowing about. So does a brand aimed at business owners whose audience skews heavily toward college students. Your followers should look like your customers.
Note what your competitors do better
Spend twenty minutes on two or three competitor accounts. You are not copying them. You are looking for formats, topics, or habits that clearly resonate with the same audience you want. Add any useful ideas to a separate tab so they are ready when you plan your next month.
Hour Four: Results and the Action List
The last hour is where the audit turns into a plan. Without this step, all you have is an interesting spreadsheet. With it, you leave the afternoon knowing exactly what to change next week and why.
Connect social to the money
Open your website analytics and look at traffic from social media sources over the same ninety days. Which platforms send visitors who stay, browse, and contact you? Check your form submissions and phone call logs too. Even rough numbers are useful here, because they show which platforms deserve more of your time.
Give each platform a grade
Based on everything you have found, sort each account into one of three groups:
- Keep: it reaches the right people and contributes to leads or sales.
- Fix: the audience is right, but the content or profile needs work.
- Pause: it takes time and gives little back, so park it for now.
Write three changes, not thirty
The biggest mistake after an audit is trying to fix everything at once. Pick three changes with the most impact and the least effort. Maybe that is rewriting your bios, shifting two posts a week to video, and replying to comments faster. Write each change down with an owner and a deadline, then schedule a short check-in a month from now.
Repeat it every quarter
A quick audit every three months keeps drift from creeping back in. Each round gets faster because your spreadsheet is already built. Over a year, those small, steady fixes add up to an account that actually supports the business. If you want a second set of eyes on your findings, the team behind our social media case studies is happy to take a look.
The Afternoon That Pays for Itself
A social media audit does not have to be complicated to be valuable. Spend the first hour cleaning up profiles and first impressions. Spend the next two studying your posts, your real audience, and a few competitors. Use the final hour to connect social to revenue, grade each platform, and commit to three focused changes. That is enough to stop drift and point your effort where it counts.
Do it once and you will wonder why you waited. Do it every quarter and your accounts will keep getting sharper while competitors keep guessing. When you are ready to turn your audit into a full strategy, reach out to White Glove Social Media and we will help you build on what you found.
More From the White Glove Blog
Ready to turn ideas like these into booked calls?
White Glove Social Media builds strategies across social media, search, paid ads, and AI answers. Tell us what you want more of and we will map the fastest path there.
We create bespoke social media experiences that captivate, engage, and convert.
