Social Media Setup

Social Media Setup

What it is: the business on the channels it can actually sustain - Facebook Page, LinkedIn company page, TikTok - with each profile completed, each channel's format and limits recorded, and a content cadence small enough to keep.

Overview

Works out the smallest useful channel set for the business in front of it, then builds it only when asked. The default output is a short recommendation, not a content calendar. The channel and content register - CSV, SQL DDL, JSON Schema, Notion mapping - is produced on request, from one field list so the four cannot drift apart.

Layer: Layer 6: Engage. Fits: Starter stage. Table code: n/a.

The rule this table exists to enforce: a channel and a post are different rows, and a Row Type discriminator keeps them apart. A channel is a permanent configuration; a post is a dated event that is published once. Merging them means the channel settings change every time something is posted, and the profile checklist can never be marked complete against a post.

The second rule: the cadence has to be one the business can keep with the people it has. A daily plan on one founder is a plan that stops in week three, and an abandoned account is worse than no account. Two posts a week beats five a week for one month.

When to Use This Skill

• Facebook, Facebook Page, LinkedIn, LinkedIn company page, TikTok
• social media setup, profiles, bios, avatars, cover images
• "we are not on social media", "we should be on Instagram"
• content calendar, posting schedule, what to post
• "nobody engages with our posts"
• brand voice on social, tone of voice
• social profiles for recruitment, or for a local customer base

Do not use it for: the link page every bio points to (linktree-link-hub), the presentation (presentation-deck), a paid advertising campaign, or a content marketing or guest-posting plan (seo-directory-backlinks for the citation side).

How It Works

Follow the shared execution contract. The module-specific rules below define only domain fields, decisions, calculations, and safety constraints.

Step 1 - Identify intent

Read the request and pick the intent before asking anything.

• "set up" / "start" / "we are not on" -> artifacts wanted; go to Step 2.
• "we have them, nothing happens" / "fix" -> something exists; capture the current state, then Step 2.
• "which platform should we be on" / "review" -> a decision question, not a build.
• "audit" / "check" -> a check, not a build.

Ask only if this is the highest-value missing fact; otherwise proceed without an opener:

Q: What is the business called, and what does one line of it actually do?

Step 2 - Ask only what is missing

Treat ambiguous replies as unanswered and ask which explicit option the user means. Record unknown values as Unknown; Unknown is not zero. A record must not be Done when a required check fails.

Skip anything already answered. Ask the rest one at a time, and stop as soon as the remaining answers would not change the channel set.

• Audience - Who are the customers - local walk-ins, online, business buyers, job candidates, or a mix? / Where are they already - which platform do they use?
• Current - Are any accounts open, even dormant? / Who has the logins, and are they personal accounts or business pages? / Any customer or staff photos already used?
• Capacity - Who will post, and how many hours a week are genuinely available? / Is there anyone who can respond to a comment within an hour?
• Content - Is there anything to post - finished work, stock, the team, an opening, a tip, an offer? / Can photos be taken on a phone at the premises? / Is anyone willing to be on camera?
• Purpose - What is the channel for - enquiries, recruitment, credibility, community, or advertising? / Is there a website to send people to yet?

Never invent an answer. Handles, follower counts, engagement rates, post volumes, platform names, account URLs and metrics the user has not supplied are Unknown. A follower count is a measurement, never an estimate.

Step 3 - Hold the internal context

module: social-media-setup
intent: null            # set up | fix | review | report | import
scale: null             # Starter | Growth | Scale, only if the answer changes it
areas:
  "Audience": null
  "Current": null
  "Capacity": null
  "Content": null
  "Purpose": null
requested_outputs: []
confirmed_facts: []
open_questions: []

Step 4 - Recommend the smallest workflow

Build an already requested artifact without asking again. For advice-only requests, give a short recommendation and offer the relevant artifact.

Recommended approach: Two channels, not five. A Facebook Page for a local customer base and a LinkedIn company page for credibility and recruitment - both low-effort, both tolerate text and photos, both work with a phone camera. Add TikTok only if there is someone who will genuinely make video, because an empty TikTok is worse than none. Three posts a week: one finished job, one behind the scenes, one useful tip. Every bio points at the same one page.

Why this one: The channel that decides the outcome is the one with people who will reply. Facebook Page and LinkedIn company page need a phone and an hour a week; TikTok needs a person who will be filmed. Starting with the two that can be sustained, and adding the third when there is someone to run it, is the difference between a channel and a dormant profile.

Workflow: Audience and platform confirmed → One canonical bio written → Profiles completed - name, category, address, hours, contact → Avatars and covers cut from the master mark → Website and link page connected → Three-post weekly pattern agreed → Approval and response ownership set → First fortnight scheduled → Comments answered within the hour → Reviewed at 30 days against the stated purpose

Step 5 - Build only on request

Once the user asks for it, derive the fields from the confirmed context and emit the requested artifacts. For machine-readable text, keep prose outside the data; for files, provide a usable link. Report material validation failures or limitations separately.

A selected Notion output is rendered by notion-manual-import, so route the Notion step there. When the user selects Notion, hand that step to @notion-manual-import: it holds the CSV, the property mapping, the import steps and the verification checklist, and it renders the Field Reference below instead of defining a table of its own. Do not restate the mapping here and do not improvise the import steps. Manual CSV and mapping outputs need no connection. For requested workspace changes, follow the shared contract: verify actual tool access and the target before writing. A user saying "connected" is not tool evidence. Never ask for a Notion password or token.

Row ID,Row Type,Platform,Account Handle,Account Type,Audience,Posting Cadence,Post Format,Post Caption,Hashtag Set,Media Asset,Link Destination,Publish Date,Publish Time,Call To Action,Approval Status,Owner,Brand Voice,Profile Checklist Complete,Review Date,Status,Notes
,Channel,Facebook Page,Unknown,Business page,Local customers within the service area,Three posts a week,"Photo or short video with a caption","Behind-the-scenes, a finished job, or one useful tip - one idea per post",Not used,"One photo per post, shot on a phone",https://example.com/,2026-09-27,,Reply within one hour,Not required,Unknown,Plain and direct,Not started,2026-10-27,Draft,Example row - replace every value before use.

-- Engine assumption: PostgreSQL. For another engine use the engine's auto-increment
-- equivalent and keep the rest portable.
CREATE TABLE social_record (
  row_id BIGINT PRIMARY KEY,
  row_type VARCHAR(50) NOT NULL,
  platform VARCHAR(100) NOT NULL,
  account_handle VARCHAR(255),
  account_type VARCHAR(100) NOT NULL,
  audience VARCHAR(100) NOT NULL,
  posting_cadence VARCHAR(100) NOT NULL,
  post_format VARCHAR(100) NOT NULL,
  post_caption TEXT,
  hashtag_set VARCHAR(255),
  media_asset VARCHAR(255),
  link_destination TEXT,
  publish_date DATE,
  publish_time VARCHAR(20),
  call_to_action VARCHAR(100) NOT NULL,
  approval_status VARCHAR(100) NOT NULL,
  owner VARCHAR(255),
  brand_voice VARCHAR(100) NOT NULL,
  profile_checklist_complete BOOLEAN NOT NULL,
  review_date DATE,
  status VARCHAR(50) NOT NULL,
  notes TEXT,
  created_at TIMESTAMP DEFAULT NOW(),
  updated_at TIMESTAMP DEFAULT NOW(),
  CONSTRAINT social_row_type CHECK (row_type IN ('Channel','Post','Comment','Bio','Media')),
  CONSTRAINT social_approval_status CHECK (approval_status IN ('Not required','Draft','In review','Approved','Rejected','Published')),
  CONSTRAINT social_checklist_applies CHECK (row_type <> 'Channel' OR profile_checklist_complete IS NOT NULL)
);

CREATE INDEX idx_social_record_row_type ON social_record (row_type);
CREATE INDEX idx_social_record_platform ON social_record (platform);
CREATE INDEX idx_social_record_status ON social_record (status);

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Social Media Setup",
  "type": "object",
  "additionalProperties": false,
  "properties": {
      "Row ID": { "type": "integer" },
      "Row Type": { "type": "string" },
      "Platform": { "type": "string" },
      "Account Handle": { "type": "string" },
      "Account Type": { "type": "string" },
      "Audience": { "type": "string" },
      "Posting Cadence": { "type": "string" },
      "Post Format": { "type": "string" },
      "Post Caption": { "type": "string" },
      "Hashtag Set": { "type": "string" },
      "Media Asset": { "type": "string" },
      "Link Destination": { "type": "string", "format": "uri" },
      "Publish Date": { "type": "string", "format": "date" },
      "Publish Time": { "type": "string" },
      "Call To Action": { "type": "string" },
      "Approval Status": { "type": "string" },
      "Owner": { "type": "string" },
      "Brand Voice": { "type": "string" },
      "Profile Checklist Complete": { "type": "boolean" },
      "Review Date": { "type": "string", "format": "date" },
      "Status": { "type": "string" },
      "Notes": { "type": "string" }
  },
  "required": [
      "Row Type",
      "Platform",
      "Account Type",
      "Audience",
      "Posting Cadence",
      "Post Format",
      "Call To Action",
      "Approval Status",
      "Brand Voice",
      "Profile Checklist Complete",
      "Status"
  ]
}

| CSV column | Notion property | Set after import |
|---|---|---|
| Row ID | Text (preserve source ID) | Keep imported IDs as Text; optionally add a separate Unique ID property |
| Row Type | Select (add options after import) | Convert to Select, add options: "Channel", "Post", "Comment", "Bio", "Media" |
| Platform | Select (add options after import) | Convert to Select, add options: "Facebook Page", "LinkedIn Company Page", "TikTok", "Instagram", "YouTube", "X", "Pinterest", "Google Business Profile", "Other" |
| Account Handle | Text | Leave as Text. No @ - store the bare handle. Leave blank for a Channel row the business has not claimed |
| Account Type | Select (add options after import) | Convert to Select, add options: "Business page", "Personal profile", "Creator account", "Group", "Community" |
| Audience | Text | Leave as Text. Who this channel is for, in customer words |
| Posting Cadence | Text | Leave as Text. A number the business has agreed to, e.g. "Three posts a week" |
| Post Format | Text | Leave as Text. What a post looks like on this platform |
| Post Caption | Title | Use as the database title |
| Hashtag Set | Text | Leave as Text. "Not used" is a valid and often correct entry |
| Media Asset | Text | Leave as Text. Filename or asset reference from the asset register, not a pasted file |
| Link Destination | URL | Convert to URL |
| Publish Date | Date | Convert to Date. Blank for a Channel row |
| Publish Time | Text | Leave as Text. Local time with the zone, e.g. "18:30 IST". Blank for a Channel row |
| Call To Action | Text | Leave as Text. What the reader should do |
| Approval Status | Select (add options after import) | Convert to Select, add options: "Not required", "Draft", "In review", "Approved", "Rejected", "Published" |
| Owner | Text | Leave as Text. A person, not a department. This is the column that makes the cadence real |
| Brand Voice | Select (add options after import) | Convert to Select, add options: "Plain and direct", "Formal", "Warm", "Technical", "Playful" |
| Profile Checklist Complete | Checkbox | Convert to Checkbox. True only when name, category, address, hours, contact, avatar, cover and bio are all done |
| Review Date | Date | Convert to Date. The 30-day review for a channel; the publish check for a post |
| Status | Select (add options after import) | Convert to Select, add options: "Planned", "In progress", "Live", "Needs update", "Retired" |
| Notes | Text | Leave as Text |

The rows above are documentation examples only. Emit empty templates unless the user explicitly requests examples. A Channel row has no caption, no media and no publish date - those belong on a Post row, and putting them on both is how a profile ends up with a stranger's draft caption in its bio field.

Field Reference

Select Options

Row Type - four kinds of row. Bio and Comment exist because the bio is a piece of copy that needs owning and versioning, and because the comment-response rule is a standing commitment rather than a one-off post.

Channel | Post | Comment | Bio | Media

Platform - a starting set, restricted to the three this module is asked about most. Google Business Profile is included because the same photo and caption often serves the profile and the Facebook Page, and the owner needs to know it is being reused.

Facebook Page | LinkedIn Company Page | TikTok | Instagram | YouTube | X | Pinterest | Google Business Profile | Other

Account Type - business pages and personal profiles behave differently for reach, for contact details and for who can edit them. Personal profile on a Facebook Page row is a mistake worth catching early.

Business page | Personal profile | Creator account | Group | Community

Posting Cadence - free text, because the honest answer is a number the business has agreed to, not a category. A cadence nobody can keep is a cadence of zero by month two.

Brand Voice - a starting set. Set it once and hold it across every channel; the same business sounding different on Facebook and LinkedIn reads as two businesses.

Plain and direct | Formal | Warm | Technical | Playful

Approval Status - Not required is legitimate for a small business with one poster, and Published closes the loop so the register shows what actually went out.

Not required | Draft | In review | Approved | Rejected | Published

Status

Planned | In progress | Live | Needs update | Retired

Relations

None standalone. Media Asset names an asset from the register in logo-image-design; confirm whether the business wants those two joined. Owner names a person from the operational pack's people register, which is not in this artifact set, so it stays Text with a note naming the intended target.