New Feature: Content Calendar Auto-Scheduling

Priority: 🟡 Pre-launch
Area: Scheduling / Automation
Competitive Reference: Predis.ai (Content Scheduler + Auto-Post), Semrush (Social Media Scheduling), Buffer, Hootsuite

Why This Matters

Every social media management tool offers intelligent auto-scheduling — AI picks the optimal posting times based on audience activity and platform algorithms. Leadmetrics has a content calendar page but content is only scheduled manually or by the deliverable planner. There’s no “best time to post” intelligence.

What Leadmetrics Has Today

• calendar dashboard page — shows content items on a calendar view
• social-calendar-planner agent — plans what to post when (content themes per date)
• DeliverablePlan + DeliverablePeriod — monthly planning structure
• SocialPost.scheduledAt field exists in schema
• No auto-scheduling — no algorithm picks optimal times
• No direct publishing — posts don’t auto-publish at scheduledAt (see #16)
• No engagement-based timing — no analysis of when the audience is most active

Proposed Implementation

Step 1 — Optimal Time Analysis

Analyze connected channel data:

1. Pull past post performance from Facebook/Instagram/LinkedIn APIs (already connected)
2. Group by day-of-week + hour-of-day
3. Calculate average engagement rate per time slot
4. Build a “best times” heatmap per channel per tenant

Step 2 — Auto-Schedule Algorithm

When content is approved and ready to publish:

1. Check the “best times” heatmap for the target platform
2. Find the next available optimal slot that doesn’t conflict with other scheduled posts
3. Respect minimum spacing rules (e.g., no two posts within 4 hours on same platform)
4. Assign scheduledAt automatically
5. Allow manual override

Step 3 — Publish Queue

Once scheduledAt arrives:

1. Scheduler task social.post.publish fires
2. Calls the appropriate platform API (Facebook Graph, LinkedIn, etc.)
3. Updates post status to published
4. Records the published URL/ID

Step 4 — Dashboard UI

• Calendar view shows suggested time slots highlighted in green
• “Auto-schedule” toggle: ON = system picks time, OFF = manual
• “Best Times” analytics page showing the engagement heatmap
• Drag-and-drop reschedule on calendar
• Publish status indicators: scheduled → publishing → published / failed

Related

• Social Post Platform Publishing — prerequisite: posts must actually publish
• Scheduler Missing Task Types — social.post.publish is a new task type