YoutubeIndividualCampaignStatsView

YoutubeIndividualCampaignStatsView

Fields available for query in youtube_individual_campaign_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. Condition on campaign_id is required in the WHERE clause.
channel_id	string The ID of the creator channel.
channel_title	string The title of the creator channel.
channel_avatar_uri	string The avatar URI of the creator channel.
video_count	int64 Total video count. Includes videos, shorts, live streams, and stories.
shorts_count	int64 Number of Shorts.
story_count	int64 Number of Stories.
live_count	int64 Number of Live streams.
product_titles	string A string containing all product titles, separated by newlines ('\n').
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.