Social
TikTok Organic schema
SightShark syncs TikTok Organic into a data warehouse you own. It creates 2 tables holding 60 fields, refreshed daily. Profile data with daily follower movement and audience demographics, plus per-video metrics including impression sources and watch time.
2 tables / 60 fields / Tables from the production sync
Tables and fields
Every table this connector creates, and every field in it, named as you will query it.
reports_profile_data
33 fields
- username
- display_name
- bio_description
- profile_image
- profile_deep_link
- is_verified
- is_business_account
- followers_count
- following_count
- total_likes
- videos_count
- video_views
- unique_video_views
- profile_views
- likes
- comments
- shares
- phone_number_clicks
- lead_submissions
- app_download_clicks
- bio_link_clicks
- email_clicks
- address_clicks
- daily_total_followers
- daily_new_followers
- daily_lost_followers
- engaged_audience
- audience_activity
- audience_ages
- audience_genders
- audience_countries
- audience_cities
- insert_dttm
snapshots_video_data
27 fields
- item_id
- username
- caption
- create_time
- video_duration
- thumbnail_url
- likes
- comments
- shares
- impression_sources
- favorites
- reach
- video_views
- total_time_watched
- average_time_watched
- new_followers
- profile_views
- website_clicks
- lead_submissions
- email_clicks
- audience_cities
- audience_genders
- audience_countries
- phone_number_clicks
- address_clicks
- app_download_clicks
- insert_dttm
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Organic numbers live behind a different login from paid, so the two halves of the same channel are usually reported separately and never add up.
Questions people ask
What tables does SightShark create from TikTok Organic?
2 tables, including reports_profile_data, snapshots_video_data. reports_profile_data is one row per profile, per sync. Every one is listed on this page, with its fields.
Which TikTok Organic fields can I get?
All 60 listed fields are on this page, table by table, named as they appear in your warehouse.
How often does TikTok Organic data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join TikTok Organic data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across TikTok Organic and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 7 min read
What happens when a platform changes its API.
A pipeline that stops gets fixed today. A pipeline that keeps returning rows can be wrong for a month.
Read it - 6 min read
How to write metric definitions that hold across clients.
Most arguments about a number are arguments about what the number means. Write it down once.
Read it - 7 min read
How far back a new client's marketing data goes.
Further than you expect in places, and gone for good in others. Worth knowing before the day you need it.
Read it
Get started
Want TikTok Organic in your own warehouse?
A call with someone who can answer the schema questions.