CompetitiveVisibilityCompetitorView

CompetitiveVisibilityCompetitorView

Fields available for query in competitive_visibility_competitor_view table.

Competitive visibility report with businesses with similar visibility.

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

Fields
date

Date

Date of this row.

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 similar businesses 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.

relative_visibility

double

Relative visibility shows how often your competitors’ offers are shown compared to your offers. In other words, this is the number of displayed impressions of a competitor retailer divided by the number of your displayed impressions during a selected time range for a selected product category and country.

Cannot be filtered on in the 'WHERE' clause.