Tiktok Ads: Campaign Report

Description

• Each record in this table represents the daily performance at the campaign level.

Supported Data Sources

• Tiktok Ads

Columns

Type	Name	Description
STRING	source_relation	The source of the record if the unioning functionality is being used. If not this field will be empty.
DATE	date_day	Day of record
DECIMAL	advertiser_id	Advertiser ID
STRING	advertiser_name	Advertiser name
DECIMAL	campaign_id	Campaign ID
STRING	campaign_name	Campaign name
STRING	currency	Advertiser's currency.
INTEGER	impressions	The number of impressions that occurred on the day of the record.
INTEGER	clicks	The number of clicks that occurred on the day of the record.
INTEGER	spend	The amount of spend that occurred on the day of the record.
INTEGER	reach	The number of unique users who saw your ads at least once. This metric is estimated.
INTEGER	conversion	The number of times your ad achieved an outcome, based on the secondary goal you selected. As one campaign may have a number of different secondary goals, this statistic is not supported for campaigns. Please go to ad groups or ads to view. (The total count is calculated based on the time each ad impression occurred.)
INTEGER	likes	The number of likes your video creative received within 1 day of a user seeing a paid ad.
INTEGER	comments	The number of comments your video creative received within 1 day of a user seeing a paid ad.
INTEGER	shares	The number of shares that occurred on the day of the record.
INTEGER	profile_visits	The number of profile visits that occurred on the day of the record.
INTEGER	follows	The number of follows that occurred on the day of the record.
INTEGER	video_watched_2_s	The number of times your video played for at least 2 seconds, or completely played. Replays will not be counted.
INTEGER	video_watched_6_s	The number of times your video played for at least 6 seconds, or completely played. Replays will not be counted.
INTEGER	video_views_p_25	The number of times your video was played at 25% of its length. Replays will not be counted.
INTEGER	video_views_p_50	The number of times your video was played at 50% of its length. Replays will not be counted.
INTEGER	video_views_p_75	The number of times your video was played at 75% of its length. Replays will not be counted.
INTEGER	daily_cpc	The average amount of money you've spent on a click.
INTEGER	daily_cpm	The average amount of money you've spent per 1,000 impressions.
INTEGER	daily_ctr	The percentage of times people saw your ad and performed a click.