CompetitiveVisibilityTopMerchantView

CompetitiveVisibilityTopMerchantView

Fields available for query in competitive_visibility_top_merchant_view table.

Competitive visibility report with business with highest visibility.

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

Fields
date

Date

Date of this row.

Cannot be selected in the SELECT clause. A condition on date is required in the WHERE clause.

domain

string

Domain of your competitor or your domain, if 'is_your_domain' is true.

Required in the SELECT clause. Cannot be filtered on in the 'WHERE' clause.

is_your_domain

bool

True if this row contains data for your domain.

Cannot be filtered on in the 'WHERE' clause.

report_country_code

string

Country where impressions appeared.

Required in the SELECT clause. A condition on report_country_code is required in the WHERE clause.

report_category_id

int64

Google product category ID to calculate the report for, represented in Google's product taxonomy .

Required in the SELECT clause. A condition on report_category_id is required in the WHERE clause.

traffic_source

TrafficSourceEnum

Traffic source of impressions.

Required in the SELECT clause.

rank

int64

Position of the domain in the top merchants ranking for the selected keys ( date , report_category_id , report_country_code , traffic_source ) based on impressions. 1 is the highest.

Cannot be filtered on in the 'WHERE' clause.

ads_organic_ratio

double

Ads / organic ratio shows how often the domain receives impressions from Shopping ads compared to organic traffic. The number is rounded and bucketed.

Cannot be filtered on in the 'WHERE' clause.

page_overlap_rate

double

Page overlap rate shows how frequently competing retailers’ offers are shown together with your offers on the same page.

Cannot be filtered on in the 'WHERE' clause.

higher_position_rate

double

Higher position rate shows how often a competitor’s offer got placed in a higher position on the page than your offer.

Cannot be filtered on in the 'WHERE' clause.