Social performance
Last 30 days · updated 4 minutes ago
Where every number on this dashboard comes from. Exports respect the active range: last 30 days.
Sync health across the reporting pipeline
| Source | Status | Last sync | Records | Owner |
|---|---|---|---|---|
| LinkedIn Pages API | Healthy | 4 min ago | 182,411 | Growth Ops |
| Instagram Graph API | Healthy | 6 min ago | 146,908 | Growth Ops |
| Site click attribution | Delayed | 3 h ago | 38,220 | Web team |
| CRM demo requests | Healthy | 12 min ago | 1,204 | Revenue |
| Paid social spend | Action needed | 2 d ago | — | Finance |
Rows in warehouse
368,743
Across five sources
Refresh cadence
15 min
Incremental pulls
Retention
26 months
Rolling window
Map a LinkedIn or Instagram CSV / JSON export onto the reporting schema
Drop a LinkedIn export here, CSV or JSON
Nothing leaves this browser. The file is read locally and checked against the schema.
Standard LinkedIn export headers and where each one lands.
| Native field | Table | Column | Transform | In file |
|---|---|---|---|---|
| Impressions (organic) | metrics_snapshots | views | Direct | Waiting for a file |
| Clicks | metrics_snapshots | clicks_swipes | Adds document swipes | Waiting for a file |
| Reposts | metrics_snapshots | shares_sends | Sums with sends | Waiting for a file |
| Saves | metrics_snapshots | saves | Direct | Waiting for a file |
| Page / profile name | social_accounts | account_name | Matched on first import | Waiting for a file |
The schema already holds columns for these. Adding them later is a credentials job, not a rebuild.
Page insights, reels plays and unified Views land in the same snapshot rows.
Columns already in place
Turn this on to reserve it in the sync queue. Nothing runs until the API is connected.
Channel reports map watch time and subscriber velocity onto existing columns.
Columns already in place
Turn this on to reserve it in the sync queue. Nothing runs until the API is connected.
Raw rows behind the channel pages
| Post | Channel | Format | Published | Reach | Eng. rate | Clicks |
|---|---|---|---|---|---|---|
| How our field team cut install time by a third | Carousel | Sep 04 | 24,810 | 6.8% | 1,420 | |
| Behind the truck: a day with Crew 12 | Reel | Sep 03 | 31,200 | 5.1% | 640 | |
| Q3 safety record, in numbers | Single image | Sep 01 | 18,740 | 4.4% | 910 | |
| Hiring: senior estimator, Chicago | Text | Aug 29 | 15,220 | 7.9% | 2,180 | |
| Before / after: Lincoln Park retrofit | Carousel | Aug 27 | 21,460 | 6.2% | 520 | |
| What clients actually ask on day one | Video | Aug 24 | 12,980 | 3.8% | 470 | |
| Crew spotlight: Marisol | Story set | Aug 22 | 9,840 | 8.4% | 260 | |
| Three permit mistakes that cost weeks | Carousel | Aug 20 | 27,310 | 5.6% | 1,710 |
