Miscellaneous

default

sitemap

This report include urls crawled from company's webpage sitemap/sitemap index.

name	type	description	values
table_x_id	INT	A surrogate key to uniquely identify specific row.
landing_page_x_id	INT	The universal ID of the landing page.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
priority	STRING	Gives a rating to the priority of the piece of content on your site.	0-1
position	NUMERIC	Indicates the depth inside multiple sitemap files.
parent_sitemap	STRING	Parent sitemap.
last_modified_at	DATE	The timestamp that record was last modified, in source_service. Informs when a landing page was last updated
change_frequency	STRING	indicates how often a page’s content might change

manual_expenses

manual_expenses_detailed

It contains manual expenses input by the user, attributed per day.

name	type	description	values
campaign_x_id	INT	The universal ID of the campaign.
ad_group_x_id	INT	The universal ID of the adgroup.
account_x_id	INT	The universal ID of the account_id.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
is_marketing_related	INT	If expense is marketing related and should be used in marketing related metrics like CPA, CPC etc.
date	DATE	The date (yyyy-MM-dd). Date the expense refers to (date between start_date and end_date).
currency	STRING	The currency of the account. Currency of the amount spent.
cost	NUMERIC	The amount of money spend. The amount spent.

page_speed

speed_report_lighthouse

This report includes page speed insights using both lab (Lighthouse) and field data about a page. Lab data is useful for debugging performance issues, as it is collected in a controlled environment. However, it may not capture real-world bottlenecks. Field data is useful for capturing true, real-world user experience - but has a more limited set of metrics. When PSI is given a URL, it will look it up in the Chrome User Experience Report (CrUX) dataset. If available, PSI reports the First Contentful Paint (FCP), First Input Delay (FID), Largest Contentful Paint (LCP), and Cumulative Layout Shift (CLS) metric data for the origin and potentially the specific page URL. Field data refer to sections performance_google and performance_google_origin only as other sections refer to lab data. Learn more.

name	type	description	values
landing_page_x_id	INT	The universal ID of the landing page.
device_x_id	INT	The universal ID of the device type.
metric_id	STRING	Name of the metric Learn more.
url_link_domain	STRING	The domain of the landing page URL.
strategy	STRING	Test strategy to use.	Desktop, Mobile
section_score	NUMERIC	Total score of the Section. Only applicable for lab data.
section_name	STRING	Name of the Section.	performance_google, performance_google_origin, accessibility, performance, best_practices, seo
section_category	STRING	Section category. Only applicable for field data.	SLOW, AVERAGE, FAST
requested_url	STRING	Url that was requested to perform a speed test.	0-1
parent_metric	STRING	Lighthouse version.
metric_weight	NUMERIC	Weight of the metric to each Section.  Only applicable for lab data.
metric_group	STRING	Group of the metric.  Only applicable for lab data.
landing_page	STRING	The landing page URL. Url for which speed test was performed. If it is different from requested_url then speed test cannot be performed for url_link (i.e redirection etc).
is_audit_successful	INT	Check if speed test was successful.	0-1
date	DATE	The date (yyyy-MM-dd).
audit_score	NUMERIC	Score of the metric.	0-1. 0 is bad, 1 is good. Only applicable for lab data.
audit_numeric_value_proportion_last	NUMERIC	Represents percentage (%) of part 3 (parts 3 in total) of total population. Only applicable for field data.
audit_numeric_value_proportion_first	NUMERIC	Represents percentage (%) of part 1 (parts 3 in total) of total population. Only applicable for field data.
audit_numeric_value_min_last	NUMERIC	Represents min threshold for part 3 (parts 3 in total) of total population. Only applicable for field data.
audit_numeric_value_min_first	NUMERIC	Represents min threshold for part 1 (parts 3 in total) of total population. Only applicable for field data.
audit_numeric_value_max_first	NUMERIC	Represents max threshold for part 1 (parts 3 in total) of total population. Only applicable for field data.
audit_numeric_value	NUMERIC	Numeric score of the metric.
audit_display_value_digit	NUMERIC	Display value of metric to numeric. i.e 5 long tasks, becomes 5. Only applicable for lab data.
audit_display_value	STRING	Display value of metric.  Only applicable for lab data.
audit_category	STRING	Metric category. Only applicable for field data.	SLOW, AVERAGE, FAST

web_search_brand_scraping

brand_crawl

This universal report includes crawled web search results of a subset of queries included on universal _queries report.

name	type	description	values
query_x_id	INT	The universal ID of the search_term.
language_x_id	INT	The universal ID of the language.
landing_page_x_id	INT	The universal ID of the landing page.
landing_page_domain_x_id	INT	The universal ID of the domain of the landing page URL.
landing_page_country_x_id	INT	Surrogate key to uniquely identify search_result using landing_page,search_country.
device_x_id	INT	The universal ID of the device type.
country_x_id	INT	The universal ID of the country.
report_id	STRING	ID of Craw report.
service	STRING	Service used to acquire search results.
result_type	STRING	Type of the result.	ads, organic_result, people_also_ask
landing_page_domain	STRING	The domain of the landing page URL.
index	INT	The rank of search result (in its result_type).
date	DATE	The date (yyyy-MM-dd).
crawl_language	STRING	Search language used for search results.
crawl_country	STRING	Search country used for search results.

web_search_scraping

crawl

This universal report includes crawled web search results of a subset of queries included on universal _queries report.

name	type	description	values
query_x_id	INT	The universal ID of the search_term.
language_x_id	INT	The universal ID of the language.
landing_page_x_id	INT	The universal ID of the landing page.
landing_page_domain_x_id	INT	The universal ID of the domain of the landing page URL.
landing_page_country_x_id	INT	Surrogate key to uniquely identify search_result using landing_page,search_country.
country_x_id	INT	The universal ID of the country.
report_id	STRING	ID of Craw report.
service	STRING	Service used to acquire search results.
result_type	STRING	Type of the result.	ads, organic_result, people_also_ask
landing_page_domain	STRING	The domain of the landing page URL.
index	INT	The rank of search result (in its result_type).
filter_value	STRING	Value of filter_column defined in clustering by user in craw report, that specifies search terms to crawl.
filter_column	STRING	Column defined in clustering by user in craw report, that specifies search terms to crawl.
date	DATE	The date (yyyy-MM-dd).
crawl_location	STRING	Search country used for search results.
crawl_language	STRING	Search language used for search results.
crawl_country	STRING	Search country used for search results.