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
Coralline Aquarium: accounts, activity and results
| Account | Owner and access | Followers | Last post | Pattern | Notes |
|---|---|---|---|---|---|
| Instagram (main) | Business tools, two admins | 8,400 | Yesterday | 3 to 5 posts a week | Feeding times, behind the scenes; replies within a day |
| Facebook page | Business tools, one admin | 6,100 | This week | Event listings and closures | Unanswered complaints about parking from last month |
| TikTok | Former aquarist's personal email | 2,300 | 7 months ago | Bursts of daily posts, then silence | Two videos past 100,000 views, both seahorse births |
| YouTube | Business account | 140 | 2 years ago | 4 long videos | No Shorts; no links in descriptions |
| LinkedIn page | Unknown admin | 90 | Never | Empty | Tagline missing |
| X account | Former manager's login | 1,200 | 3 years ago | Abandoned | Still 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.
- 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.
- 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.
- Give each kept platform a role and a goal metric. For each, the audience it serves, the job it does and its KPIA metric tied directly to an objective.. 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.
- 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.
- 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.
- Set community standards. Response times, the escalation route for complaints, and what happens to the unanswered parking complaints this week.
- 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 UTMURL tags identifying traffic source. 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.
- 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.
One row of a strong strategy, for comparison
| Platform | Role | Goal metric | Baseline | Cadence | Paid |
|---|---|---|---|---|---|
| TikTok | Reach among families who have never visited | Views from non-followers per month | Rebuilt over the first 3 months after recovery | Floor of 2 posts a week, ceiling of 4; one seahorse-keeper series | Top 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.
| Criterion | What a strong answer shows | Common gap |
|---|---|---|
| Gates scored first | Ownership failures are recovered or the account is closed before any content work | Polishing profiles on accounts the aquarium does not control |
| Portfolio decision | Each account is grown, repaired or paused, with the abandoned accounts handled | Keeping every account alive out of habit |
| Platform roles | One audience, one job and one goal metric per platform, reflecting what each platform rewards | The same content and goal on every account |
| Native adaptation | One idea shown in a different format, opening and call to action per platform | Cross-posting the same video everywhere |
| Sustainable cadence | A floor and ceiling per account derived from the team's hours | A daily plan for every platform |
| Creators and customer content | Creators chosen on audience fit, briefed with freedom, customer content permissioned and credited separately | Paying for reach, or reposting customer posts without permission |
| Paid amplification | Licence and authorisation recorded, proven posts tested, budget moved on results, fatigue watched | Boosting whatever was posted today |
| Community | Written response standards and an escalation route, with the open complaints handled now | Ignoring public complaints while planning content |
| Reporting | Goal metrics against the aquarium's own baseline, with ReachUnique people who saw an ad. reported per platform and decisions with owners | A follower-count report with no decisions |
| Tracking | A lower-case convention for every social link, including the bio link, built through a shared builder | Leaving the largest source of visits untagged |
Submission checklist
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.
