These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Social Media Management
- Data model and import order
The tables behind Social Media Management
Social Media Management ships with 24 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 24
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Content:
Posts, content library, content library tags, content tags, post content tags, Hashtags, hashtag items. Post copy and media, reusable assets, tags and hashtag groups.
Approval and delivery:
Approvals, post channel targets, social accounts. Approval steps, each destination's outcome and the connected accounts.
Campaigns:
Campaigns, campaign posts. Campaign dates, goals and their posts.
Community:
Inbox messages, message replies, Mentions, routing rules, routing rule keywords, routing rule pool members. Conversations, replies, mentions and how they are routed.
Performance and research:
Engagements, post analytics, competitor accounts, competitor posts. Engagement events, daily rollups and captured competitor content.
People:
Users2, Users. Team members with role and active flag, and platform accounts.
Every table, by feature
- Content planning8
- Approval and channel delivery5
- Campaign coordination5
- Community inbox8
- Mentions and competitor research7
- Performance reporting8
- Shared and settings1
- Posts
The core publish unit.
Linked to Users 2, Hashtags - Content library
Reusable asset library — images, videos, copy snippets, link templates.
Linked to Users 2 - Hashtag items
One row per hashtag in a group.
Linked to Hashtags - Users 2
App users — Marketing Managers, Content Creators, Community Managers, Approvers, Viewers, Admins.
- Approvals
Per-Post approval chain.
Linked to Users 2, Posts - Posts
The core publish unit.
Linked to Users 2, Hashtags - Post channel targets
Per-channel fan-out rows for a Post.
Linked to Posts, Social accounts - Users 2
App users — Marketing Managers, Content Creators, Community Managers, Approvers, Viewers, Admins.
- Campaigns
Bundled multi-post initiatives.
Linked to Users 2 - Campaign posts
Many-to-many join — one row per (Campaign, Post) pair.
Linked to Campaigns, Posts - Posts
The core publish unit.
Linked to Users 2, Hashtags - Post analytics
Aggregated metrics per Post per Channel per Date.
Linked to Posts, Social accounts - Users 2
App users — Marketing Managers, Content Creators, Community Managers, Approvers, Viewers, Admins.
- Inbox messages
DMs, comments, and inbound replies that need a direct response.
Linked to Social accounts, Posts, Users 2 - Message replies
The reply thread on an Inbox Message.
Linked to Inbox messages, Users 2 - Routing rules
Auto-assign rules for inbound Mentions and Inbox Messages.
Linked to Social accounts - Routing rule keywords
Trigger keywords for a routing rule.
Linked to Routing rules - Routing rule pool members
Community Managers in the round-robin pool for a rule.
Linked to Routing rules, Users 2 - Posts
The core publish unit.
Linked to Users 2, Hashtags - Users 2
App users — Marketing Managers, Content Creators, Community Managers, Approvers, Viewers, Admins.
- Mentions
Public mentions, brand-keyword hits, and tag-of-our-handle events.
Linked to Social accounts, Posts, Users 2, Inbox messages - Inbox messages
DMs, comments, and inbound replies that need a direct response.
Linked to Social accounts, Posts, Users 2 - Competitor accounts
Competitor handles being monitored for content benchmarking.
- Competitor posts
Captured public posts from Competitor Accounts.
Linked to Competitor accounts - Posts
The core publish unit.
Linked to Users 2, Hashtags - Users 2
App users — Marketing Managers, Content Creators, Community Managers, Approvers, Viewers, Admins.
- Post analytics
Aggregated metrics per Post per Channel per Date.
Linked to Posts, Social accounts - Engagements
Raw engagement events per Post per channel.
Linked to Posts, Post channel targets - Post channel targets
Per-channel fan-out rows for a Post.
Linked to Posts, Social accounts - Posts
The core publish unit.
Linked to Users 2, Hashtags - Campaigns
Bundled multi-post initiatives.
Linked to Users 2 - Campaign posts
Many-to-many join — one row per (Campaign, Post) pair.
Linked to Campaigns, Posts - Competitor posts
Captured public posts from Competitor Accounts.
Linked to Competitor accounts
Keys and references
A post references its author, approver and hashtag group; approvals, channel targets, engagements, analytics rows and campaign links reference the post. Channel targets and analytics rows also reference the social account. Replies reference their inbox message; mentions can link to an inbox message and a related post. Routing keywords and pool members reference their rule. Keep account codes, post numbers and channel post IDs stable and import by them.
Migration order
- Load Users and Users2, then social accounts.
- Load content tags, Hashtags with hashtag items, and the content library.
- Load routing rules with their keywords and pool members.
- Load Campaigns and Posts with their approvals and channel targets, preserving the planned publication dates.
- Load open inbox messages, Mentions and competitor accounts.
- Reconcile planned posts and open conversations with the current tool and test permissions before go-live.
Set up Social Media Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.