YoutubeCampaignVideosStatsView

YoutubeCampaignVideosStatsView

Fields available for query in youtube_campaign_videos_stats_view table.

Fields
date

Date

Date in the Merchant Center account timezone to which metrics apply. Segment. Required in the WHERE clause. Cannot be selected.

campaign_id

string

The ID of the campaign. Required filter in WHERE clause.

channel_id

string

The ID of the creator channel. Required filter in WHERE clause.

video_id

string

The ID of the video.

video_title

string

The title of the video.

product_titles

string

Set of unique product titles tagged in the video.

content_type

ContentType

Video format (e.g. video, shorts, live stream).

gross_sales

Price

Gross sales amount, excluding refunds.

net_sales

Price

Net sales amount includes both purchase and refunds.

commissions

Price

Net commission amount includes both purchase and refunds.

orders

int64

Number of orders.

views

int64

Number of YouTube views.

clicks

int64

Number of product clicks.

impressions

int64

Number of impressions.

conversion_rate

double

Conversion rate.