Intermediate Claude Prompts for Healthcare Instagram Managers: Create a Social Media Reporting Template

You are a senior healthcare social media analyst with 11 years of experience building reporting templates, performance tracking systems, and content optimization frameworks for healthcare organizations where Instagram metrics must be presented to non-social-media stakeholders who make decisions about content budgets based on data they can understand without a social media background. Help me create a social media reporting template so I can increase story and reel views and build a monthly report that connects Instagram performance to the healthcare organization's patient education and community health goals rather than presenting vanity metrics that leadership cannot act on. My situation: - Healthcare organization type and Instagram purpose: [e.g., "regional hospital network — Instagram is used for patient education, staff recruitment, and community health awareness rather than direct appointment booking"] - Current reporting format and its failure: [e.g., "monthly Excel export from Meta Business Suite — leadership asks what the numbers mean every month and the Instagram manager spends 2 hours explaining metrics that the report should explain itself"] - Story and Reel performance problem: [e.g., "Reels average 820 views and Stories average 34% completion rate — both are below benchmarks for healthcare Instagram but the report does not show how these compare to industry averages or to the previous month's performance"] - Stakeholder audience for the report: [e.g., "communications director, VP of Patient Experience, and HR director — each has different priorities and reads the report looking for different signals"] - Key performance goals tied to Instagram: [e.g., "patient education reach for three chronic disease awareness campaigns, nursing recruitment applications from Instagram, and community health event attendance driven by Instagram promotion"] - Current hashtag strategy: [e.g., "using 15 to 20 hashtags per post pulled from a general healthcare list — no analysis of which hashtags are actually driving profile visits or reach, and the list has not been updated in 8 months"] - Reporting frequency: [e.g., "monthly report submitted to leadership by the 5th of each month — must be completable in under 3 hours of data collection and formatting"] Deliver: 1. A monthly social media reporting template with three stakeholder sections — a communications director section covering overall account health (follower growth rate, average reach per post, Story completion rate trend, and Reel view trend), a VP of Patient Experience section covering patient education content performance (reach per awareness campaign post, saves per educational Reel, and the top three performing patient education posts with a one-sentence explanation of why each performed well), and an HR director section covering recruitment content performance (profile visits from recruitment posts, DMs received on nursing career posts, and the top recruitment post of the month) 2. A Story view increase action plan — a five-step protocol for improving the current 34% Story completion rate, covering the optimal Story sequence length (maximum five Stories per sequence), the hook Story format that prevents drop-off after the first frame, the interactive element placement (poll or slider in Story three or four rather than Story one), the posting time recommendation based on the account's follower activity data, and the one content type that consistently produces the highest completion rate in healthcare Instagram accounts 3. A Reel performance improvement brief — the three elements that differentiate Reels averaging 2,000 to 5,000 views from Reels averaging 800 views in the healthcare category, covering the hook duration (under 2 seconds to a visually interesting or text-based opening frame), the caption length recommendation for Reels versus static posts, and the audio selection guide for healthcare content that complies with HIPAA visual and patient privacy requirements 4. A hashtag audit and optimization brief — a process for auditing the current 15 to 20 hashtag list against the account's actual hashtag reach data in Meta Business Suite, identifying which of the current hashtags are driving profile visits versus which are producing impressions with no downstream action, and a replacement process for the lowest-performing hashtags with the criteria for selecting new tags 5. A plain-English metric glossary for the report — definitions for eight Instagram metrics written for a non-social-media audience (reach, impressions, engagement rate, Story completion rate, Reel plays, saves, profile visits, and hashtag reach), each with a one-sentence explanation of why this metric matters for the organization's specific goals rather than a generic definition 6. A campaign performance tracking module for the three awareness campaigns — a template section within the monthly report covering each campaign's reach goal, actual reach achieved, the top-performing post from the campaign, the patient education Reel completion rate, and a one-paragraph summary the communications director can share with the medical department that commissioned the campaign 7. A 3-hour report production workflow — a timed sequence covering 45 minutes for Meta Business Suite data export and the key metric extraction, 30 minutes for the hashtag audit data pull, 45 minutes for the three stakeholder section completion, 30 minutes for the campaign performance module, and 30 minutes for the plain-English summary and action recommendations, producing a complete report within the 3-hour window by the 5th of each month 8. A month-over-month trend visualization brief — instructions for creating three simple charts within the report (a 6-month Story completion rate trend line, a 6-month Reel views bar chart, and a 3-month follower growth rate comparison) using Google Sheets rather than a paid analytics tool, with the exact formula for each chart and the color coding convention that makes declining metrics immediately visible without requiring the reader to interpret the axis values **Write every report section and improvement protocol assuming the Instagram manager is analytically competent but time-constrained, and that the leadership audience has no social media background — every metric must be presented with a benchmark comparison and a one-sentence plain-English interpretation, because a number without context produces a question at the leadership meeting rather than a decision.**