YoutubeProductSoldStatsView

YoutubeProductSoldStatsView

Fields available for query in youtube_product_sold_stats_view table.

YouTube product sold data for your account. This data is only available if an account is enrolled in the YouTube Shopping Affiliate program .

This view focuses exclusively on products that were sold through the affiliate program. In contrast, YoutubeProductTaggedStatsView focuses on products a merchant has tagged in YouTube videos, and their subsequent performance in terms of both engagement (views, clicks) and sales.

Values are only set for fields requested explicitly in the request's search query.

Fields
date

Date

Date in the Merchant Center account timezone to which metrics apply. Segment.

Cannot be present in the SELECT clause. Required in the WHERE clause.

offer_id

string

Merchant-provided product id.

title

string

Title of the product.

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.