TikTok publication detail

The int_tiktok__publication_detail contains detailed metrics and information about TikTok publications, including reach, engagement metrics, and campaign tagging data. Each row represents a unique TikTok post with its associated metrics and tags.

Key components: - Publication identifiers and basic information (ID, creation date, caption, URL) - Engagement metrics (views, likes, shares, comments) - Video-specific metrics (average watch time, total watch time, video duration) - Campaign tagging information (post name, objectives, offer category)

This intermediate table joins raw TikTok video data with campaign tagging information from Google Sheets, enabling analysis of both organic and campaign performance. The data is partitioned by export date and clustered by account name for optimal query performance.

Table description

name	data_type	description
publication_id	STRING	The unique identifier for the publication. Format varies by platform: numeric ID for Instagram, alphanumeric for TikTok.
publication_creation_date	DATE	The date when the content was originally posted on the social media platform.
publication_caption	STRING	The text content accompanying the publication, including hashtags, mentions, and emojis.
publication_link	STRING	The permanent URL to access the publication directly on the social media platform.
publication_export_date	DATE	The date when the publication's metrics were extracted from the platform.
publication_account_name	STRING	The identifier of the account that posted the content, prefixed with the platform name (e.g., instagram_, tiktok_).
is_publication_tagged	BOOLEAN	Boolean indicator (TRUE/FALSE) showing whether the publication is part of a tracked campaign.
publication_reach	INT64	The number of unique accounts that saw the publication at least once.
publication_video_views	INT64	The total number of times the video content was played. Only applicable for video content.
publication_likes	INT64	The number of unique accounts that liked the publication.
publication_shares	INT64	The number of times the publication was shared by users to their stories or with other users.
publication_comments	INT64	The total number of comments received on the publication.
average_tiktok_publication_time_watched	FLOAT64	The average duration (in seconds) that viewers spent watching the video.
total_tiktok_publication_time_watched	INT64	The cumulative time (in seconds) spent by all viewers watching the video.
tiktok_publication_video_duration	FLOAT64	The total length of the video content in seconds.
tiktok_publication_full_video_watched_rate	FLOAT64	The percentage of viewers who watched the entire video from start to finish.
publication_engagement_rate	FLOAT64	The ratio of total interactions (likes + comments + shares) to reach.
publication_tag_post_name	STRING	The unique identifier assigned to the publication for campaign tracking purposes.
publication_tag_macro_objective	STRING	The high-level marketing goal of the publication.
publication_tag_micro_objective	STRING	The specific marketing objective of the publication.
publication_tag_offer_category	STRING	The category of the offer associated with the publication.
publication_tag_region_name	STRING	The region name associated with the publication.