Dimension

adjust

_network

This report includes distinct network names from Adjust. Learn more.

name	type	description	values
network_x_id	INT
account_x_id	INT	The universal ID of the account_id.
network_updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
network_network	STRING	Name of the network.

_partner

This report includes distinct partner names from Adjust. Learn more.

name	type	description	values
partner_x_id	INT
account_x_id	INT	The universal ID of the account_id.
partner_updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
partner_partner	STRING	Name of the partner.

date_calendar

__calendar

This is a universal date calendar. It includes dates as well as their characteristics (week, month, is_weekend etc).

name	type	description	values
calendar_year	INT	Year number (yyyy).
calendar_week	INT	Number of the week	1-52
calendar_quarter	INT	Quarter number.	1-4
calendar_month_name	STRING	Name of the month.
calendar_month	INT	Number of the month.	1-12
calendar_is_weekend	STRING	Boolean true for Sat/Sun, false for Mon/Tue/Wed/Thu/Fri	true, false
calendar_day_week	INT	Day of the week. 1 is for Monday.	1-7
calendar_day_name	STRING	Name of the day	Mon, Tue, Wed, Thu, Fri, Sat, Sun
calendar_day_month	INT	Day of the months	1-30
calendar_date_start_year	DATE	First day of the year (yyyy-MM-dd).
calendar_date_start_month	DATE	First day of the month (yyyy-MM-dd).
calendar_date_monday_week	DATE	Monday of the week (yyyy-MM-dd).
calendar_date	DATE	The date (yyyy-MM-dd).

default

_accounts

This universal report includes accounts from connected/available services.

name	type	description	values
account_x_id	INT	The universal ID of the account_id.
account_organization_id	STRING	Organization id of user's organization used by maya.
account_id	STRING	The ID of the account.
account_slug	STRING	Slug name of user's organization used by maya.
account_service	STRING	The name of the service that data were extracted from.
account_organization_name	STRING	Organization name of user's organization defined by the user.
account_name	STRING	The name of the account. Name of the account.

_campaigns

This universal report combines distinct ad_groups from different services. Also includes all-time metrics as well as Maya metrics.

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.
campaign_id	STRING	The ID of the campaign.
campaign_ad_group_id	STRING	The ID of the ad_group.
campaign_type	STRING	The type of the campaign. The campaign type.
campaign_status	STRING
campaign_sessions_alltime	NUMERIC	Number of total sessions.
campaign_service	STRING	The name of the service that data were extracted from.
campaign_name	STRING	The name of the campaign.
campaign_last_appeared_date	DATE	Last appeared timestamp.
campaign_impressions_alltime	NUMERIC	The number of impressions. Number of total impressions.
campaign_first_appeared_service	STRING	First appeared source service.
campaign_first_appeared_date	DATE	First appeared timestamp.
campaign_days_alltime	NUMERIC	Numbers of days that metrics are calculated for.
campaign_cost_alltime	NUMERIC	The amount of money spend.
campaign_conversions_alltime	NUMERIC	The number of conversions. This only includes conversions specified by the user in service platform. Number of total conversions.
campaign_cluster_9	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
campaign_cluster_8	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
campaign_cluster_7	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
campaign_cluster_6	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
campaign_cluster_5	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
campaign_cluster_4	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
campaign_cluster_3	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
campaign_cluster_2	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
campaign_cluster_10	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
campaign_cluster_1	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
campaign_clicks_alltime	NUMERIC	The number of clicks. Number of total clicks.
campaign_ad_group_type	STRING	The type of the ad_group. The ad_group type.
campaign_ad_group_status	STRING
campaign_ad_group_name	STRING	The name of the ad_group.
campaign_account_name	STRING	The name of the account.

_ads

This universal report combines distinct ads from different services. Also includes all-time metrics as well as Maya metrics.

name	type	description	values
ad_x_id	INT	The universal ID of the ad.
ad_id	STRING	The ID of the ad.
ad_type	STRING	The type of the ad. The ad type.
ad_service	STRING	The name of the service that data were extracted from.
ad_name	STRING	The name of the ad.

_crawl

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

name	type	description	values
landing_page_x_id	INT	The universal ID of the landing page.
landing_page_url_domain_base_x_id	INT	Base of search result url domain. i.e www.example.com -> example .
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.
crawl_title	STRING	Title of search result.
crawl_snippet	STRING	Short summary/bried of the content of search result.
crawl_landing_page_url_domain_base	STRING	Base of search result url domain. i.e www.example.com -> example .
crawl_landing_page_url_domain	STRING	The domain of the landing page URL.
crawl_landing_page_url	STRING	The landing page URL.
crawl_is_competitor	NUMERIC	Check if is a competitor.
crawl_competitor_category	STRING	Search result website category (check common_website_domain table).
crawl_avg_paid_rank	NUMERIC	Rank of competitors on paid ads of search results.
crawl_avg_organic_rank	NUMERIC	Rank of competitors on organic search results.

_conversions

This universal report combines distinct conversion actions from different services. Also includes all-time metrics as well as Maya metrics.

name	type	description	values
conversion_x_id	INT	The universal ID of the conversion name.
account_x_id	INT	The universal ID of the account_id.
conversion_id	STRING	The ID of the conversion.
conversion_service	STRING	The name of the service that data were extracted from.
conversion_name	STRING	The name of the conversion.
conversion_cluster_9	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
conversion_cluster_8	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
conversion_cluster_7	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
conversion_cluster_6	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
conversion_cluster_5	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
conversion_cluster_4	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
conversion_cluster_3	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
conversion_cluster_2	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
conversion_cluster_10	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
conversion_cluster_1	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
conversion_category	STRING	Conversion category.

_countries

This universal report combines distinct countries from different services. Also includes all-time metrics as well as Maya metrics.

name	type	description	values
country_x_id	INT	The universal ID of the country.
country_sub_region	STRING	Continent of the country. i.e united kingdom -> northern europe.
country_region	STRING	Continent of the country. i.e united kingdom -> europe.	europe, americas, asia, oceania
country_official_name	STRING	Official country name of the language. i.e united kingdom.
country_name	STRING	The name of the country. Country name used. i.e united kingdom.
country_language_group	STRING	Language group that belongs to. i.e english.
country_lang_group_spanish	STRING	Country has spanish as official language.
country_lang_group_russian	STRING	Country has russian as official language.
country_lang_group_portuguese	STRING	Country has portuguese as official language.
country_lang_group_italian	STRING	Country has italian as official language.
country_lang_group_greek	STRING	Country has greek as official language.
country_lang_group_german	STRING	Country has german as official language.
country_lang_group_french	STRING	Country has french as official language.
country_lang_group_english	STRING	Country has english as official language.
country_lang_group_dutch	STRING	Country has dutch as official language.
country_lang_group_chinese	STRING	Country has chinese as official language.
country_lang_group_arabic	STRING	Country has arabic as official language.

_devices

This universal report combines distinct devices from different services. Also includes all-time metrics as well as Maya metrics.

name	type	description	values
device_x_id	INT	The universal ID of the device type.
device_name	STRING	The type of device.
device_category	STRING	The category of the device.

_external_domains

This universal report combines distinct external domains from different services. Also includes all-time metrics as well as Maya metrics.

name	type	description	values
external_domain_x_id	INT
external_domain_hubspot_id	STRING
external_domain_elorus_id	STRING
external_domain_source_service	STRING	The name of the service that data were extracted from.
external_domain_metric_last_appeared_at	DATE
external_domain_metric_first_appeared_source_service	STRING
external_domain_metric_first_appeared_at	DATE
external_domain_metric_crawl_result_type	STRING
external_domain_metric_crawl_organic_results	NUMERIC
external_domain_metric_crawl_ad_results	NUMERIC
external_domain_external_domain_suffix	STRING
external_domain_external_domain_base	STRING
external_domain_external_domain	STRING
external_domain_date	DATE	The date (yyyy-MM-dd).
external_domain_cluster_9	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
external_domain_cluster_8	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
external_domain_cluster_7	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
external_domain_cluster_6	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
external_domain_cluster_5	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
external_domain_cluster_4	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
external_domain_cluster_3	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
external_domain_cluster_2	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
external_domain_cluster_10	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
external_domain_cluster_1	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).

_keywords

This universal report combines distinct keywords from different services. Also includes all-time metrics as well as Maya metrics.

name	type	description	values
keyword_x_id	INT	The universal ID of the keyword.
keyword_id	STRING	The ID of the keyword.
keyword_service	STRING	The name of the service that data were extracted from.
keyword_name	STRING	The text of the keyword.
keyword_match_type	STRING	Match type of keyword.	Broad, Exact
keyword_last_appeared_date	DATE	Last appeared timestamp.
keyword_impressions_alltime	NUMERIC	The number of impressions. Number of total impressions.
keyword_first_appeared_service	STRING	First appeared source service.
keyword_first_appeared_date	DATE	First appeared timestamp.
keyword_days_alltime	NUMERIC	Numbers of days that metrics are calculated for.
keyword_cost_alltime	NUMERIC	The amount of money spend.
keyword_conversions_alltime	NUMERIC	The number of conversions. This only includes conversions specified by the user in service platform. Number of total conversions.
keyword_cluster_9	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
keyword_cluster_8	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
keyword_cluster_7	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
keyword_cluster_6	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
keyword_cluster_5	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
keyword_cluster_4	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
keyword_cluster_3	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
keyword_cluster_2	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
keyword_cluster_10	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
keyword_cluster_1	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
keyword_clicks_alltime	NUMERIC	The number of clicks. Number of total clicks.

_languages

This universal report combines distinct languages from different services. Also includes all-time metrics as well as Maya metrics.

name	type	description	values
language_x_id	INT	The universal ID of the language.
language_official_name	STRING	Official language name. i.e english
language_name	STRING	Language name used. i.e english.
language_country_sub_region	STRING	Continent of the country. i.e united kingdom -> northern europe.
language_country_region	STRING	Continent of the country. i.e united kingdom -> europe.	europe, americas, asia, oceania
language_country_official_name	STRING	Official country name of the language. i.e united kingdom.
language_country_alpha_3	STRING	Country 3-letter-code. i.e united kingdom -> gbr.
language_country_alpha_2	STRING	Country 2-letter-code. i.e united kingdom -> gb.
language_alpha_3	STRING	Language 2-letter-code. i.e english -> eng.
language_alpha_2	STRING	Language 3-letter-code. i.e english -> eng.

_report_levels

This universal report includes all supported levels.

name	type	description	values
report_level_name	STRING	The level of the report.	ad, ad_group, campaign, search_term, keyword, placement

_queries

This universal report combines distinct queries from different services. Also includes all-time metrics as well as Maya metrics.

name	type	description	values
query_x_id	INT	The universal ID of the search_term.
query_word_count	NUMERIC	Number of words.
query_text_translated_from_language	STRING	Translation detected language.
query_text_translated_confidence	NUMERIC	Translation validity confidence.
query_text_translated	STRING	Query translation.
query_text_maya	STRING	Maya search term.
query_text_latin	STRING	Search term converted to Latin characters.
query_text	STRING	The text of the search_term.
query_manual_sub_category	STRING
query_manual_dimension_1	STRING
query_manual_category	STRING
query_last_appeared_date	DATE	Last appeared timestamp.
query_is_translated	INT	Is query translated.
query_is_competitor_auto	NUMERIC	Search term refers to competitor.
query_is_brand_auto	NUMERIC	Search term refers to brand.
query_impressions_paid_alltime	NUMERIC	Number of impressions from paid services.
query_impressions_organic_alltime	NUMERIC	Number of organic impressions.
query_impressions_alltime	NUMERIC	The number of impressions. Number of total impressions.
query_first_appeared_service	STRING	First appeared source service.
query_first_appeared_date	DATE	First appeared timestamp.
query_days_alltime	NUMERIC	Numbers of days that alltime measures are calculated for.
query_cost_last3M	NUMERIC	The amount of money spend, last 3 month.
query_cost_last1Y	NUMERIC	The amount of money spend, last 1 year.
query_cost_alltime	NUMERIC	The amount of money spend.
query_conversions_paid_alltime	NUMERIC	Number of conversions from paid services.
query_conversions_organic_alltime	NUMERIC	Number of organic conversions.
query_conversions_alltime	NUMERIC	The number of conversions. This only includes conversions specified by the user in service platform. Number of total conversions.
query_cluster_9	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
query_cluster_8	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
query_cluster_7	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
query_cluster_6	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
query_cluster_5	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
query_cluster_4	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
query_cluster_3	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
query_cluster_2	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
query_cluster_10	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
query_cluster_1	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
query_clicks_paid_alltime	NUMERIC	Number of clicks from paid services.
query_clicks_organic_alltime	NUMERIC	Number of organic clicks.
query_clicks_alltime	NUMERIC	The number of clicks. Number of total clicks.
query_character_count	NUMERIC	Number of characters.

_words

This universal report includes words derived from queries from the universal _queries report. Also includes all-time metrics as well as Maya metrics.

name	type	description	values
word_x_id	INT
query_x_id	INT	The universal ID of the search_term.
word_text_stemmed	STRING
word_text	STRING
word_last_appeared_date	DATE
word_impressions_paid_alltime	NUMERIC
word_impressions_organic_alltime	NUMERIC
word_impressions_alltime	NUMERIC	The number of impressions.
word_first_appeared_date	DATE
word_cost_alltime	NUMERIC	The amount of money spend.
word_conversions_alltime	NUMERIC	The number of conversions. This only includes conversions specified by the user in service platform.
word_character_count	NUMERIC

_services

This universal report includes all connected/available services.

name	type	description	values
service_name	STRING	The name of the service that data were extracted from.	google_ads, google_analytics, facebook_ads etc

_domain_name

This universal report identifies the company's domain based data retrieved from connected services.

name	type	description	values
domain_name	STRING	Base of url domain. i.e www.example.com -> example .

_landing_pages

This universal report combines distinct landing page urls from different services. Also includes all-time metrics as well as Maya metrics.

name	type	description	values
landing_page_x_id	INT	The universal ID of the landing page.
landing_page_url_type_auto	STRING	Url pattern i.e home, blog etc.
landing_page_url_slash_count	NUMERIC	Number of slashes in url.
landing_page_url_path_level_last	STRING	Url part after last slash.
landing_page_url_path_level_3	STRING	Url part after 3rd slash. Supported format www.example.com/level_1/level_2/level_3.
landing_page_url_path_level_2	STRING	Url part after 2nd slash. Supported format www.example.com/level_1/level_2.
landing_page_url_path_level_1_no_language	STRING	Url part after language code part in url, if exists. Supported format www.example.com/en/level_1.
landing_page_url_path_level_1	STRING	Url part after 1st slash. Supported format www.example.com/level_1/.
landing_page_url_path_language	STRING	Language code part in url. Supported format www.example.com/en/.
landing_page_url_has_amp	STRING	Indicates if amp exists in url. Supported format www.example.com/amp/.
landing_page_url_domain_suffix	STRING	Base of url domain. i.e www.example.com -> com.
landing_page_url_domain_prefix	STRING
landing_page_url_domain_base	STRING	Base of url domain. i.e www.example.com -> example.
landing_page_url_domain	STRING	The domain of the landing page URL.
landing_page_url	STRING	The landing page URL.
landing_page_last_appeared_date	DATE	Last appeared timestamp.
landing_page_impressions_paid_alltime	NUMERIC	Number of impressions from paid services.
landing_page_impressions_organic_alltime	NUMERIC	Number of organic impressions.
landing_page_impressions_alltime	NUMERIC	The number of impressions. Number of total impressions.
landing_page_first_appeared_service	STRING	First appeared source service.
landing_page_first_appeared_date	DATE	First appeared timestamp.
landing_page_days_alltime	NUMERIC	Numbers of days that metrics are calculated for.
landing_page_cost_alltime	NUMERIC	The amount of money spend.
landing_page_conversions_paid_alltime	NUMERIC	Number of conversions from paid services.
landing_page_conversions_organic_alltime	NUMERIC	Number of organic conversions.
landing_page_conversions_alltime	NUMERIC	The number of conversions. This only includes conversions specified by the user in service platform. Number of total conversions.
landing_page_cluster_9	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
landing_page_cluster_8	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
landing_page_cluster_7	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
landing_page_cluster_6	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
landing_page_cluster_5	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
landing_page_cluster_4	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
landing_page_cluster_3	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
landing_page_cluster_2	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
landing_page_cluster_10	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
landing_page_cluster_1	STRING	The name of the cluster configured by the user in console (https://app.mayainsights.com).
landing_page_clicks_paid_alltime	NUMERIC	Number of clicks from paid services.
landing_page_clicks_organic_alltime	NUMERIC	Number of organic clicks.
landing_page_clicks_alltime	NUMERIC	The number of clicks. Number of total clicks.
landing_page_analytics_sessions_alltime	NUMERIC	Number of total sessions.

google_analytics

_analytics_attribution

This report includes google analytics attribution levels. 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.
country_x_id	INT	The universal ID of the country.
campaign_x_id	INT	The universal ID of the campaign.
attribution_x_id	INT	Surrogate key to uniquely identify attribution channel using account_id,country,device,campaign,landing_page_path,source_medium,channel_grouping.
ad_group_x_id	INT	The universal ID of the adgroup.
account_x_id	INT	The universal ID of the account_id.
attribution_updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
attribution_source_service	STRING	The name of the service that data were extracted from.
attribution_source	STRING	The origin of your traffic. Such as a search engine (for example, google) or a domain (example.com).
attribution_sessions	NUMERIC
attribution_medium	STRING	The general category of the source, for example, organic search (organic), cost-per-click paid search (cpc), web referral (referral).
attribution_last_appeared_at	DATE
attribution_first_appeared_at	DATE
attribution_channel_grouping	STRING	The Channel Group associated with an end user's session for this View (defined by the View's Channel Groupings).