Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Social Media Marketing › Intermediate

Capstone: Auditing a Social Presence and Writing a Strategy

The capstone of the intermediate social media level asks you to audit an invented aquarium's scattered social accounts with the presence scorecard, then write the strategy that fixes what the audit finds. It draws on platform playbooks, creators and paid amplification, community and reporting, and is judged against explicit criteria.
Capstone projectIntermediate levelModule 3: Reporting and audits6 minUpdated

Brief

Coralline Aquarium is an invented independent aquarium in a coastal town. It runs a conservation programme for native seahorses, hosts school trips and corporate evening hire, and depends on ticket sales and an annual membership. A new marketing manager has joined, inherited a tangle of social accounts set up over the years by different staff, and has hired you for a month to audit them and write a strategy she can run with a part-time assistant.

Her questions are plain: which accounts should we keep, what should each one do, how do we work with the local creators who keep asking to film here, and how do I show the director that social sells tickets?

The constraints:

  • Social time is limited to the manager's share of the week and a part-time assistant.
  • The director wants one monthly report she can read in a few minutes.
  • Some accounts were created with personal email addresses by staff who have since left.
  • There is a small paid social budget, currently spent on boosting posts at random.
  • School and corporate bookings are made by enquiry form; tickets and memberships are sold online.

The brand and its data

Illustrative example — not a real result

Coralline Aquarium: accounts, activity and results

AccountOwner and accessFollowersLast postPatternNotes
Instagram (main)Business tools, two admins8,400Yesterday3 to 5 posts a weekFeeding times, behind the scenes; replies within a day
Facebook pageBusiness tools, one admin6,100This weekEvent listings and closuresUnanswered complaints about parking from last month
TikTokFormer aquarist's personal email2,3007 months agoBursts of daily posts, then silenceTwo videos past 100,000 views, both seahorse births
YouTubeBusiness account1402 years ago4 long videosNo Shorts; no links in descriptions
LinkedIn pageUnknown admin90NeverEmptyTagline missing
X accountFormer manager's login1,2003 years agoAbandonedStill appears in search

Last quarter: 52,000 tickets sold online, 1,900 memberships, 38 school trips and 11 corporate evening hires. Analytics shows 4,100 sessions from social sources, of which 2,600 are an untagged Instagram referral. Paid social spend was £1,800, all on boosted posts chosen on the day. Three local creators have asked to film; one family creator posted an unpaid visit that drew comments asking about opening times and prices.

Task

Produce two deliverables: the scored audit and the strategy. Work in this order.

  1. Score the audit. Use the social media presence scorecard, one column per account, rating each row missing, partial or solid. Score the platform fit and ownership gates first, then the remaining rows. Write the goal you assumed for each account before you score it.
  2. Band and decide the portfolio. Give each account a band and decide which grow, which are repaired and which pause, with a pointer to the active accounts. Name the access recoveries that come before any other work.
  3. Give each kept platform a role and a goal metric. For each, the audience it serves, the job it does and its KPI. Apply the platform playbooks from the first module: what the LinkedIn page is for when corporate hire is the buyer, what the TikTok account can sustain, and how Shorts and long-form share the YouTube channel.
  4. Set pillars and cadence. Choose a small set of content pillars, map them to the platforms, and set a floor and a ceiling for each account from the team's real capacity. Show one idea adapted natively across at least two platforms.
  5. Plan creators, customer content and paid amplification. Decide which creators to work with and on what basis, what the brief must contain, and how customer content is earned, permissioned and credited. Replace random boosting with a plan that amplifies proven posts, following the guide to amplifying creator content with paid ads: licence and authorisation, candidate selection, testing and fatigue.
  6. Set community standards. Response times, the escalation route for complaints, and what happens to the unanswered parking complaints this week.
  7. Design the reporting. Write the monthly report's structure using the social media reporting guide: the question, each platform's goal metric against its own baseline, context, learning and decisions. Specify the UTM convention for every social link, starting from the guide to naming conventions and UTMs and the UTM and naming conventions template. Map the report to the monthly marketing report template.
  8. Summarise on one page. Put the strategy's headline decisions on the one-page marketing plan so the director can approve it in one sitting, and attach the social page optimisation checklist as the assistant's first week of work.
Illustrative example — not a real result

One row of a strong strategy, for comparison

PlatformRoleGoal metricBaselineCadencePaid
TikTokReach among families who have never visitedViews from non-followers per monthRebuilt over the first 3 months after recoveryFloor of 2 posts a week, ceiling of 4; one seahorse-keeper seriesTop 2 posts each month tested as Spark Ads at £100 each, winner scaled

The row names an audience, one metric, how the baseline will be built and a cadence the assistant can keep, and ties paid spend to proven posts rather than to the day's mood.

Evaluation criteria

Assess your submission against each row, or ask a peer to. A strong answer meets every row; most first attempts miss two or three.

CriterionWhat a strong answer showsCommon gap
Gates scored firstOwnership failures are recovered or the account is closed before any content workPolishing profiles on accounts the aquarium does not control
Portfolio decisionEach account is grown, repaired or paused, with the abandoned accounts handledKeeping every account alive out of habit
Platform rolesOne audience, one job and one goal metric per platform, reflecting what each platform rewardsThe same content and goal on every account
Native adaptationOne idea shown in a different format, opening and call to action per platformCross-posting the same video everywhere
Sustainable cadenceA floor and ceiling per account derived from the team's hoursA daily plan for every platform
Creators and customer contentCreators chosen on audience fit, briefed with freedom, customer content permissioned and credited separatelyPaying for reach, or reposting customer posts without permission
Paid amplificationLicence and authorisation recorded, proven posts tested, budget moved on results, fatigue watchedBoosting whatever was posted today
CommunityWritten response standards and an escalation route, with the open complaints handled nowIgnoring public complaints while planning content
ReportingGoal metrics against the aquarium's own baseline, with Reach reported per platform and decisions with ownersA follower-count report with no decisions
TrackingA lower-case convention for every social link, including the bio link, built through a shared builderLeaving the largest source of visits untagged

Submission checklist

0/15

When you have finished, compare your report design with the worked example in the social media reporting guide and return to the intermediate social media level to mark the level complete.

Pages this lesson applies

Terms used on this page

Also related

Related