Analytics

adjust

adjust

This report contains Adjust performance data. Learn more.

name	type	description	values
partner_x_id	INT
network_x_id	INT
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.
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.
sessions	NUMERIC
revenue_events	NUMERIC	Number of revenue events.
revenue	NUMERIC
rejected_installs	NUMERIC	Number of rejected installs. This is the sum of rejected_installs_anon_ip + rejected_installs_too_many_engagements + rejected_installs_distribution_outlier + rejected_installs_click_injection
reattributions	NUMERIC	Number of reattributions generated per period.
partner	STRING	Partner to which the data belongs.
paid_installs	NUMERIC	The number of installs, for which there is cost data.
paid_impressions	NUMERIC	The number of impressions, for which there is cost data.
paid_clicks	NUMERIC	The number of clicks, for which there is cost data.
network	STRING	The network to which the data belongs.
limit_ad_tracking_reattributions	NUMERIC	Number of reattributions from devices with Limit Ad Tracking enabled.
limit_ad_tracking_installs	NUMERIC	Number of installs from devices with Limit Ad Tracking enabled.
installs	NUMERIC
install_cost	NUMERIC	Install cost.
impressions	NUMERIC	The number of impressions.
impression_cost	NUMERIC	Impression cost.
gdpr_forget_users	NUMERIC	Number of users wanting to be forgotten per period.
events	NUMERIC
event_cost	NUMERIC	Cost calculated over a specific event occurrence.
date	DATE	The date (yyyy-MM-dd).
currency	STRING	The currency of the account.
cost	NUMERIC	The amount of money spend.
clicks	NUMERIC	The number of clicks.
click_cost	NUMERIC	Click cost.
ad_revenue	NUMERIC
ad_impressions	NUMERIC

adjust_conversions

Overview queries provide data for App KPIs as well as Event KPIs. You will typically be interested in metrics such as clicks, sessions, installs, etc. over a given period. Learn more.

name	type	description	values
partner_x_id	INT
network_x_id	INT
device_x_id	INT	The universal ID of the device type.
country_x_id	INT	The universal ID of the country.
conversion_x_id	INT	The universal ID of the conversion name.
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.
partner	STRING	Partner to which the data belongs.
network	STRING	The network to which the data belongs.
date	DATE	The date (yyyy-MM-dd).
currency	STRING	The currency of the account.
conversions_value	NUMERIC	The value of conversions. This only includes conversions specified by the user in service platform.
conversions	NUMERIC	The number of conversions. This only includes conversions specified by the user in service platform.
conversion_name	STRING	The name of the conversion.

google_analytics

analytics_conversions

This report contains google analytics conversions data. Learn more.

name	type	description	values
language_x_id	INT	The universal ID of the language.
landing_page_x_id	INT	The universal ID of the landing page.
conversion_x_id	INT	The universal ID of the conversion name.
attribution_x_id	INT	Surrogate key to uniquely identify attribution channel using account_id,country,device,campaign,landing_page_path,source_medium,channel_grouping.
account_x_id	STRING	The universal ID of the account_id.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
source_service	STRING	The name of the service that data were extracted from.
date	DATE	The date (yyyy-MM-dd).
conversions_value	NUMERIC	The value of conversions. This only includes conversions specified by the user in service platform. The total numeric value for the requested goal number.
conversions	NUMERIC	The number of conversions. This only includes conversions specified by the user in service platform. The total number of completions for the requested goal number.

analytics

This report contains google analytics performance data. Learn more.

name	type	description	values
language_x_id	INT	The universal ID of the language.
landing_page_x_id	INT	The universal ID of the landing page.
attribution_x_id	INT	Surrogate key to uniquely identify attribution channel using account_id,country,device,campaign,landing_page_path,source_medium,channel_grouping.
account_x_id	INT	The universal ID of the account_id.
users	NUMERIC	The total number of users for the requested time period.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
transactions	NUMERIC	The total number of transactions.
source_service	STRING	The name of the service that data were extracted from.
sessions	NUMERIC	The total number of sessions.
new_users	NUMERIC	The number of sessions marked as a user's first sessions.
date	DATE	The date (yyyy-MM-dd).
bounces	NUMERIC	The total number of single page (or single interaction hit) sessions for the property.

analytics_page_speed

It contains google analytics site speed metrics. The following occurs page_load_time = A.redirection_time + B.domain_lookup_time + C.server_connection_time + D.server_response_time + E.dom_interactive_time + F.dom_content_loaded_time + G.page_download_time. Learn more.

name	type	description	values
landing_page_x_id	INT	The universal ID of the landing page.
speed_metrics_sample	NUMERIC	The sample set (or count) of pageviews used to calculate the averages of site speed metrics. This metric is used in all site speed average calculations, including avgDomainLookupTime, avgPageDownloadTime, avgRedirectionTime, avgServerConnectionTime, and avgServerResponseTime.
sessions	NUMERIC	The total number of sessions.
server_response_time	NUMERIC	D.The total time (in milliseconds) the site's server takes to respond to users' requests among all samples; this includes the network time from users' locations to the server.
server_connection_time	NUMERIC	C.Total time (in milliseconds) all samples spent in establishing a TCP connection to this page.
redirection_time	NUMERIC	A.The total time (in milliseconds) all samples spent in redirects before fetching this page. If there are no redirects, this is 0.
pageviews	NUMERIC	The total number of pageviews for the property.
page_load_time	NUMERIC	A-G.Total time (in milliseconds), from pageview initiation (e.g., a click on a page link) to page load completion in the browser, the pages in the sample set take to load.
page_load_sample	NUMERIC	The sample set (or count) of pageviews used to calculate the average page load time.
page_download_time	NUMERIC	G.The total time (in milliseconds) to download this page among all samples.
domain_lookup_time	NUMERIC	B.The total time (in milliseconds) all samples spent in DNS lookup for this page.
dom_latency_metrics_sample	NUMERIC	Sample set (or count) of pageviews used to calculate the averages for site speed DOM metrics. This metric is used to calculate ga:avgDomContentLoadedTime and ga:avgDomInteractiveTime.
dom_interactive_time	NUMERIC	E.The time (in milliseconds), including the network time from users' locations to the site's server, the browser takes to parse the document (DOMInteractive). At this time, users can interact with the Document Object Model even though it is not fully loaded.
dom_content_loaded_time	NUMERIC	F.The time (in milliseconds), including the network time from users' locations to the site's server, the browser takes to parse the document and execute deferred and parser-inserted scripts (DOMContentLoaded). When parsing of the document is finished, the Document Object Model (DOM) is ready, but the referenced style sheets, images, and subframes may not be finished loading. This is often the starting point of Javascript framework execution, e.g., JQuery's onready() callback.
date	DATE	The date (yyyy-MM-dd).
browser	STRING	The name of users browsers.	Safari, Internet Explorer, Firefox, etc.

analytics_transactions

This report contains google analytics transaction data. Learn more.

name	type	description	values
landing_page_x_id	INT	The universal ID of the landing page.
attribution_x_id	INT	Surrogate key to uniquely identify attribution channel using account_id,country,device,campaign,landing_page_path,source_medium,channel_grouping.
transaction_id	STRING	The transaction ID, supplied by the ecommerce tracking method, for the purchase in the shopping cart.
transactions	NUMERIC	The total number of transactions.
transaction_revenue	NUMERIC	The total sale revenue (excluding shipping and tax) of the transaction.
full_referrer	STRING	The full referring URL including the hostname and path.
date	DATE	The date (yyyy-MM-dd).

analytics_transactions_product

This report contains google analytics transaction data in product level. Learn more.

name	type	description	values
transaction_id	STRING	The transaction ID, supplied by the ecommerce tracking method, for the purchase in the shopping cart.
revenue_per_item	NUMERIC	The average revenue per item.
product_sku	STRING	The product SKU, defined in the ecommerce tracking application, for purchased items.
product_removes_from_cart	NUMERIC	Number of times the product was removed from the shopping cart (Enhanced Ecommerce).
product_refunds	NUMERIC	Number of times a refund was issued for the product (Enhanced Ecommerce).
product_refund_amount	NUMERIC	Total refund amount associated with the product (Enhanced Ecommerce).
product_name	STRING	The product name, supplied by the ecommerce tracking application, for purchased items.
product_list_views	NUMERIC	Number of times the product appeared in a product list (Enhanced Ecommerce).
product_list_clicks	NUMERIC	Number of times users clicked the product when it appeared in the product list (Enhanced Ecommerce).
product_coupon_code	STRING	Code for the product-level coupon (Enhanced Ecommerce).
product_checkouts	NUMERIC	Number of times the product was included in the check-out process (Enhanced Ecommerce).
product_category_hierarchy	STRING	The hierarchical category in which the product is classified (Enhanced Ecommerce).
product_adds_to_cart	NUMERIC	Number of times the product was added to the shopping cart (Enhanced Ecommerce).
item_quantity	NUMERIC	Total number of items purchased. For example, if users purchase 2 frisbees and 5 tennis balls, this will be 7.
date	DATE	The date (yyyy-MM-dd).

google_play

google_play_installs

It contains google play aggregated report for installs. Learn more.

name	type	description	values
table_x_id	INT	A surrogate key to uniquely identify specific row.
language_x_id	INT	The universal ID of the language.
device_x_id	INT	The universal ID of the device type.
country_x_id	INT	The universal ID of the country.
account_x_id	INT	The universal ID of the account_id.
account_id	STRING	The ID of the account.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
update_events	NUMERIC
uninstall_events	NUMERIC
total_user_installs	NUMERIC
report_category	STRING	The name of the service that data were extracted from.
package_name	STRING
language	STRING
install_events	NUMERIC
device_marketing_name	STRING
device_brand	STRING
device	STRING	The type of device.
date	DATE	The date (yyyy-MM-dd).
daily_user_uninstalls	NUMERIC
daily_user_installs	NUMERIC
daily_device_upgrades	NUMERIC
daily_device_uninstalls	NUMERIC
daily_device_installs	NUMERIC
country	STRING	The name of the country.
carrier	STRING
app_version_code	INT
android_os_version	STRING
active_device_installs	NUMERIC

google_play_reviews

It contains google play aggregated report for installs. Learn more.

name	type	description	values
table_x_id	INT	A surrogate key to uniquely identify specific row.
language_x_id	INT	The universal ID of the language.
device_x_id	INT	The universal ID of the device type.
account_x_id	INT	The universal ID of the account_id.
account_id	STRING	The ID of the account.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
star_rating	NUMERIC
review_title	STRING
review_text	STRING
review_submit_date_and_time	TIMESTAMP
review_link	STRING
review_last_update_date_and_time	TIMESTAMP
report_category	STRING	The name of the service that data were extracted from.
package_name	STRING
language	STRING
device_marketing_name	STRING
device_brand	STRING
device	STRING	The type of device.
developer_reply_text	STRING
developer_reply_date_and_time	TIMESTAMP
date	DATE	The date (yyyy-MM-dd).
app_version_name	STRING
app_version_code	INT

google_search_console

queries_organic_aggregated

This report contains SEO performance data from Google Search console, in date level only. Learn more.

name	type	description	values
search_type	STRING	The search type.	news, image, video, web
position	NUMERIC	Average ranking in search results.
impressions	NUMERIC	The number of impressions.
date	DATE	The date (yyyy-MM-dd).
clicks	NUMERIC	The number of clicks.

queries_organic_page

This report contains SEO performance data from Google Search console, in date and page level. Learn more.

name	type	description	values
landing_page_x_id	INT	The universal ID of the landing page.
search_type	STRING	The search type.	news, image, video, web
position	NUMERIC	Average ranking in search results.
impressions	NUMERIC	The number of impressions.
date	DATE	The date (yyyy-MM-dd).
clicks	NUMERIC	The number of clicks.

queries_organic

This report contains SEO performance data from Google Search console, in date/query/device/country level. Learn more.

name	type	description	values
query_x_id	INT	The universal ID of the search_term.
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.
account_x_id	INT	The universal ID of the account_id.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
search_type	STRING	The search type.	news, image, video, web
property_position	NUMERIC	Average ranking in search results.
property_impressions	NUMERIC
property_clicks	NUMERIC
position	NUMERIC	Average ranking in search results.
impressions	NUMERIC	The number of impressions.
date	DATE	The date (yyyy-MM-dd).
clicks	NUMERIC	The number of clicks.

queries_organic_monthly

This report contains SEO performance data from Google Search console, in month/query/device/country level. Learn more.

name	type	description	values
query_x_id	INT	The universal ID of the search_term.
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.
account_x_id	INT	The universal ID of the account_id.
updated_at_db	TIMESTAMP	The latest timestamp that record was updated, in database.
search_type	STRING	The search type.	news, image, video, web
property_impressions	NUMERIC
property_clicks	NUMERIC
position	NUMERIC	Average ranking in search results.
impressions	NUMERIC	The number of impressions.
date	DATE	The date (yyyy-MM-dd).
clicks	NUMERIC	The number of clicks.