Tiktok Ads: Url Report

Description

• Each record in this table represents the daily performance of ads at the URL 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.
DECIMAL	ad_group_id	Ad group ID.
STRING	ad_group_name	Ad group name.
DECIMAL	ad_id	Ad ID.
STRING	ad_name	Ad name.
STRING	base_url	The base URL of the ad, extracted from the landing page url.
STRING	url_host	The URL host of the ad, extracted from the landing page url.
STRING	url_path	The URL path of the ad, extracted from the landing page url.
STRING	utm_source	The utm_source parameter of the ad, extracted from the landing page url.
STRING	utm_medium	The utm_medium parameter of the ad, extracted from the landing page url.
STRING	utm_campaign	The utm_campaign parameter of the ad, extracted from the landing page url.
STRING	utm_content	The utm_content parameter of the ad, extracted from the landing page url.
STRING	utm_term	The utm_term parameter of the ad, extracted from the landing page url.
STRING	currency	Advertiser's currency.
DECIMAL	category	Ad group category.
STRING	gender	Gender that you want to target.
STRING	audience_type	Audience Type
DECIMAL	budget	Ad budget. Returns 0.0 when Campaign Budget Optimization (budget_optimize_switch) is on.
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.