Schema · Entity relationship diagram
CreatorCore tables and relationships
Every creator post in your CreatorCore campaigns (TikTok, Instagram, YouTube) with views, likes, comments, shares, engagement, captions and tags, refreshed daily.
ConnectPaste an API key
Default schema
creatorcoreSource API docsbeta.creatorcore.co
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
- One row per creator post with its current metrics as of
refresh_date.engagement_rateis a fraction (0.0777 = 7.77%) andraw_jsonkeeps the full export row.
Primary keyForeign keyReferencesJoins on (not a key)
Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.
Table reference
1 tables · click a table for its columnsposts23 columnsshow in diagram
Primary key: post_id
| Column | Type | Key | Description |
|---|---|---|---|
| post_idPrimary key. | varchar(64) | PK | Primary key. |
| campaign_id | varchar(128) | ||
| post_url | varchar(2048) | ||
| platform | varchar(64) | ||
| content_type | varchar(64) | ||
| published_at | timestamp | ||
| post_date | date | ||
| creator_handle | varchar(256) | ||
| creator_name | varchar(512) | ||
| profile_url | varchar(2048) | ||
| caption | varchar(65535) | ||
| mentions | varchar(65535) | ||
| hashtags | varchar(65535) | ||
| tags | varchar(65535) | ||
| views | bigint | ||
| likes | bigint | ||
| comments | bigint | ||
| shares | bigint | ||
| engagement | bigint | ||
| engagement_rate | decimal(18,6) | ||
| refresh_date | date | ||
| raw_jsonThe full source record as JSON, including fields added later. | varchar(65535) | The full source record as JSON, including fields added later. | |
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |