Case Study — Customised Business Tool

Social Media
Management Tool.

A content planning and tracking dashboard built for a business active on five platforms — Facebook, Instagram, TikTok, Line OA and Shopee. One place to plan, record and measure what gets posted, replacing five separate apps and a shared Google Doc that was always out of date.

The Problem

Five platforms.
Zero overview.

The business was posting on Facebook, Instagram, TikTok, Line OA and Shopee — each with its own app, its own format and its own login. Content was planned in a shared Google Doc that was perpetually two weeks out of date. Nobody knew what had been posted last week, what performed well or whether the monthly posting target had been hit.

The tool was built to bring the plan and the record into one place. Content is scheduled in a visual calendar, logged when published, and tracked for basic performance metrics. Monthly reports are generated automatically — posting frequency per platform, best-performing content type, and a comparison of engagement across channels. The team opens one screen and knows exactly where things stand.

What It Manages

Five modules.
One content hub.

Built around the exact platforms, content types and team workflow of this specific business — not a scheduling tool subscription with 80% of features unused.

📅

Content Calendar

A visual monthly calendar where posts are planned per platform. Draft status, scheduled date, content type (photo, video, story, reel, product listing) and assigned team member — all in one grid view.

Replaces the shared Google Doc

📱

Platform Coverage

Each post is tagged to one or more platforms: Facebook, Instagram, TikTok, Line OA, Shopee. The dashboard shows at a glance which platforms are active this week and which are falling behind the posting plan.

FB · IG · TikTok · Line OA · Shopee

🖼️

Asset Library

Approved images, caption templates and hashtag sets stored and reusable. A post can be assembled from library assets in seconds — no more digging through WhatsApp image threads to find the right photo.

Replaces the WhatsApp image archive

📊

Performance Tracking

Engagement figures logged per post after publishing — likes, shares, comments, reach, saves. No API integration needed: figures entered manually in 20 seconds, stored in the database, charted over time.

Simple log, powerful history

📋

Monthly Reports

Auto-generated end-of-month summary: total posts per platform, average engagement by content type, best-performing post, posting consistency score and a comparison to the previous month — without building a single formula.

Ready in one click · PDF export

Approval Workflow

Content moves through a simple status flow: Draft → Ready for review → Approved → Published. The manager approves posts before they go live. No more "who said this was OK?" after a post is already up.

Team of 1 or team of 5 — same flow

Before vs After

Same team.
Actual visibility.

social-dashboard — this week
>content plan — week 24
Facebook 3 posts scheduled · 2 published
Instagram 4 posts scheduled · 3 published
TikTok 2 posts planned · 0 published · overdue
Line OA 1 broadcast sent · 1 pending approval
Shopee product listings up to date
 
>best post — last 30 days
Instagram reel · 12 Jun · 4,200 reach · 380 saves
content type video outperforms photo 3:1 this month
 
>monthly report — May
total posts 38 · target was 40 · consistency 95%
avg engagement up 18% vs April
 
>
Before
Google Doc  ·  5 separate apps  ·  WhatsApp for approvals
  • Content plan in a Google Doc nobody updates after day 3
  • No record of what was actually posted vs what was planned
  • Performance data lives inside each platform app separately
  • Approvals via WhatsApp — "which version did we go with?"
  • Monthly report takes 3 hours to assemble across 5 platforms
After — one custom tool
One dashboard  ·  Any device  ·  Full team access
  • Visual calendar updated live — plan and record in one place
  • Every post logged with platform, date, status and performance
  • Engagement figures aggregated across all platforms in one view
  • Approval workflow tracked with timestamps — no ambiguity
  • Monthly report generated automatically in one click
Optional Add-on

AI caption drafts
on request.

Some versions of this tool include an AI writing assistant wired directly into the post creation form.

What it does
  • One-click caption draft based on product name, platform and tone
  • Hashtag suggestions tailored to the business category and location
  • Caption variants for different platforms from a single input
  • Configurable tone: formal, casual, promotional, informational
How it's wired in
  • API call goes to the configured AI model (DeepSeek, Claude or GPT-4o)
  • Business context — brand name, product categories, tone guide — stored in the tool config
  • Draft returned directly into the post form for editing before approval
  • Cost per generation under $0.001 — included in the monthly fee
Why It Matters

This is exactly what
we build for your business.

Consistent social media presence is one of the hardest things for a small business to maintain — not because content is difficult, but because there's no system. Posts happen reactively, performance is never measured, and the plan exists only in someone's head. A tool that makes the plan visible and the history searchable changes the behaviour of the whole team.

This one was built for a specific business with specific platforms and a specific team size. The content types, the approval steps, the platform list, the report format — all scoped to what was actually needed. No scheduling subscription, no per-seat fee, no features that don't apply. Just the tool, maintained monthly, growing as the business grows.

Want something similar..?

We build it
around your platforms.

Different platforms, different team size, different workflow — same principle. We scope the tool around how you actually create and publish content.