HomeCasa Social media audit from your own data with a 90-day action plan
Audit your social media accounts using your own metrics: profile review, content by format and pillar, qualitative competitor comparison and a prioritized 30-, 60- and 90-day plan. Designed for ChatGPT, Claude, Gemini and Microsoft Copilot. It includes 5 customizable variables and you can copy it for free in one click.
Advanced · Text · Pending editorial review
Prompt
Act as a social media consultant who runs data-based audits for small and mid-sized businesses.
Context:
- Brand and platforms to audit: {{brand}}
- Business goal for social media: {{goal}}
- Data from the last 90 days (paste an export or table: post, date, format, reach, engagements, saves, clicks, followers gained): {{data}}
- Competitors or role models: {{competitors}}
- Available resources (people, hours, budget): {{resources}}
If the data is incomplete or mixes periods, tell me what is missing and ask for it before drawing conclusions.
Deliverables:
1. Profile audit per platform: name, bio, link, highlights or pinned sections, visual consistency. Score from 1 to 5 with the reason.
2. Content analysis using my data: performance by format and by topic or pillar, the top 10% and bottom 10% with a hypothesis for why, and actual posting frequency. State the engagement rate formula you use.
3. Qualitative comparison with competitors: what they do differently in formats, topics and tone, without inventing their metrics.
4. Diagnosis: the 3 main problems and the 3 clearest opportunities, tied to {{goal}}.
5. A prioritized 30-, 60- and 90-day plan as a table: action, expected impact (high, medium, low), effort, owner and tracking metric, sized to {{resources}}.
6. A dashboard of 5-7 KPIs to review monthly, and the threshold that would make me change course.
Constraints:
- Use only the numbers I provide. Do not invent industry averages; if you mention general benchmarks, say they vary widely and must be verified.
- Always separate facts (data) from hypotheses (interpretations).
- Where information is missing, write [FILL IN].
Format: a 5-line executive summary, numbered sections, tables and a final list of next steps.How to use it
Export the last 90 days of metrics from each platform’s insights or your scheduling tool and paste them as a table. Check that the hypotheses make sense for your business before acting, and repeat the audit every quarter.
Usage example
Brand: physical therapy clinic in Raleigh on Instagram and Facebook · Goal: more first-visit bookings · Resources: 1 person, 4 hours a week.
Sample output
Before drawing conclusions: the data field still holds the sample text, so the last 90 days of metrics are missing. Paste the export (post, date, format, reach, engagements, saves, clicks, followers) and I will complete sections 2 and 6. In the meantime, here is what can move forward.
Executive summary (provisional)
- Goal: more first-visit bookings.
- Resources: 4 hours a week, no ad budget → few actions, well chosen.
- Performance by format: [FILL IN from your data].
- Immediate priority: the profile should lead to a booking in one tap.
- Key metric: clicks on the booking link.
1. Profile audit (criteria)
| Element | What to check | Score 1-5 |
|---|---|---|
| Name field | Does it include "Physical Therapy Raleigh"? | [FILL IN] |
| Bio | Does it say who you help and how to book? | [FILL IN] |
| Link | Does it go straight to first-visit booking? | [FILL IN] |
| Highlights | Is there one for "First visit: what to expect"? | [FILL IN] |
Engagement rate formula: (engagements + saves) / reach × 100.
5. Plan (first 30 days)
| Action | Impact | Effort | Metric |
|---|---|---|---|
| Link straight to first-visit booking | High | Low | Link clicks |
| "First visit" highlight with price [FILL IN] and length | High | Low | Replies and clicks |
| 1 educational reel a week on a common complaint | Medium | Medium | Saves |
…
Key facts
- Category
- Social media · Growth strategies
- Output type
- Text
- Level
- Advanced
- Designed for
- ChatGPT, Claude, Gemini and Microsoft Copilot
- Verified in
- Pending editorial verification
- Variables
- Brand and platforms, Business goal, Data from the last 90 days, Competitors or role models and Available resources
- Language
- English
- Price
- Free, no sign-up
- Updated
- Nov 7, 2026
Frequently asked questions
What data do I need for a good audit?
At minimum, per post: date, format, reach and engagements, plus saves, shares and clicks if possible. With 90 days of data most accounts already show reliable patterns.
Why does it not give me industry averages?
Because they vary widely by platform, account size and source, and the model could make them up. Comparing yourself with your own past performance is usually more useful.
What is this prompt for?
Audit your social media accounts using your own metrics: profile review, content by format and pillar, qualitative competitor comparison and a prioritized 30-, 60- and 90-day plan.
Which AI tools does it work with?
It is designed for ChatGPT, Claude, Gemini and Microsoft Copilot. We have not verified it in these tools yet, so results may vary between them.
How do I customize the prompt?
Click “Customize” and fill in the variables (Brand and platforms, Business goal, Data from the last 90 days, Competitors or role models and Available resources). The text updates instantly and you can then copy it in one click. Values are stored only in your browser.
Do I need experience to use it?
It is advanced: it is meant for people with experience in the topic who can evaluate and adjust the result.
Is this prompt free?
Yes. Every HomeCasa Prompts prompt is free, with no sign-up or subscription. You can also use them in professional projects.
Can I trust the AI output?
Treat it as a high-quality draft: always check data, figures and important claims before publishing or making decisions.