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 |
|---|---|---|---|---|
| Publish Date | metrics_snapshots | publish_date | Kept as YYYY-MM-DD | Waiting for a file |
| Publish Time | metrics_snapshots | publish_time | Kept as HH:MM:SS | Waiting for a 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 | Always Elite Pro | Waiting for a file |
| Platform | social_accounts | platform | Capitalised: LinkedIn, Instagram, Facebook, YouTube | 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 | Publish date | Publish time | Reach | Eng. rate | Clicks |
|---|---|---|---|---|---|---|---|
| How our field team cut install time by a thirdElite Pro | Carousel | 2026-09-04 | 10:30:00 | 24,810 | 6.8% | 1,420 | |
| Behind the truck: a day with Crew 12Elite Pro | Reel | 2026-09-03 | 17:15:00 | 31,200 | 5.1% | 640 | |
| Q3 safety record, in numbersElite Pro | Single image | 2026-09-01 | 13:05:00 | 18,740 | 4.4% | 910 | |
| Hiring: senior estimator, ChicagoElite Pro | Feed | 2026-08-29 | 07:45:00 | 15,220 | 7.9% | 2,180 | |
| Before / after: Lincoln Park retrofitElite Pro | Carousel | 2026-08-27 | 12:00:00 | 21,460 | 6.2% | 520 | |
| What clients actually ask on day oneElite Pro | Video | 2026-08-24 | 09:20:00 | 12,980 | 3.8% | 470 | |
| Crew spotlight: MarisolElite Pro | Story set | 2026-08-22 | 18:40:00 | 9,840 | 8.4% | 260 | |
| Three permit mistakes that cost weeksElite Pro | Carousel | 2026-08-20 | 08:15:00 | 27,310 | 5.6% | 1,710 |
