YoutubeCampaignProductsStatsView

YoutubeCampaignProductsStatsView

Fields available for query in youtube_campaign_products_stats_view table.

Fields
date

Date

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

gross_sales

Price

Optional. Gross sales amount, excluding refunds.

net_sales

Price

Optional. Net sales amount includes both purchases and refunds.

commissions

Price

Optional. Net commission amount includes both purchases and refunds.

campaign_id

string

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

channel_title

string

Optional. The title of the creator channel.

video_id

string

Optional. The id of the video.

video_url

string

Optional. The URL of the video.

video_title

string

Optional. The title of the video.

product_title

string

Optional. The title of the product.

content_type

ContentType

Optional. The format of the video.

orders

int64

Optional. Number of orders.

views

int64

Optional. Number of YouTube views.

clicks

int64

Optional. Number of product clicks.

impressions

int64

Optional. Number of impressions.

conversion_rate

double

Optional. Conversion rate.