Create Supabase Social Metric Snapshots Table #20

Description

Create and populate the optional Supabase table used by the dashboard for YouTube, TikTok, and other creator connection growth charts.

The dashboard already reads this table through SUPABASE_SOCIAL_METRICS_TABLE. It will show connected accounts without graphs until follower/subscriber snapshot rows are being written.

Implementation

Table Definition

Recommended table name: livelatch_social_metric_snapshots

Column specifications documented in: docs/platform-runtime/dashboard-analytics-data.md

Prerequisites

This work is parked pending creation of a snapshot collector:

• Scheduled Laravel job, or
• Supabase Edge Function

that will write follower/subscriber rows to the table.

Owner Follow-Up

• No action needed before a snapshot collector exists
• This is tracked separately; will activate once the collection mechanism is ready