Skip to main content

Analytics

adjust

adjust

This report contains Adjust performance data. Learn more.

nametypedescriptionvalues

device_x_id

INTThe universal ID of the device type.

country_x_id

INTThe universal ID of the country.

campaign_x_id

INTThe universal ID of the campaign.

ad_group_x_id

INTThe universal ID of the adgroup.

account_x_id

INTThe universal ID of the account_id.

updated_at_db

TIMESTAMPThe latest timestamp that record was updated, in database.

sessions

NUMERIC

revenue_events

NUMERICNumber of revenue events.

revenue

NUMERIC

rejected_installs

NUMERICNumber 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

NUMERICNumber of reattributions generated per period.

partner

STRINGPartner to which the data belongs.

paid_installs

NUMERICThe number of installs, for which there is cost data.

paid_impressions

NUMERICThe number of impressions, for which there is cost data.

paid_clicks

NUMERICThe number of clicks, for which there is cost data.

network

STRINGThe network to which the data belongs.

limit_ad_tracking_reattributions

NUMERICNumber of reattributions from devices with Limit Ad Tracking enabled.

limit_ad_tracking_installs

NUMERICNumber of installs from devices with Limit Ad Tracking enabled.

installs

NUMERIC

install_cost

NUMERICInstall cost.

impressions

NUMERICThe number of impressions.

impression_cost

NUMERICImpression cost.

gdpr_forget_users

NUMERICNumber of users wanting to be forgotten per period.

events

NUMERIC

event_cost

NUMERICCost calculated over a specific event occurrence.

date

DATEThe date (yyyy-MM-dd).

currency

STRINGThe currency of the account.

cost

NUMERICThe amount of money spend.

clicks

NUMERICThe number of clicks.

click_cost

NUMERICClick 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.

nametypedescriptionvalues

device_x_id

INTThe universal ID of the device type.

country_x_id

INTThe universal ID of the country.

conversion_x_id

INTThe universal ID of the conversion name.

campaign_x_id

INTThe universal ID of the campaign.

ad_group_x_id

INTThe universal ID of the adgroup.

account_x_id

INTThe universal ID of the account_id.

updated_at_db

TIMESTAMPThe latest timestamp that record was updated, in database.

partner

STRINGPartner to which the data belongs.

network

STRINGThe network to which the data belongs.

date

DATEThe date (yyyy-MM-dd).

currency

STRINGThe currency of the account.

conversions_value

NUMERICThe value of conversions. This only includes conversions specified by the user in service platform.

conversions

NUMERICThe number of conversions. This only includes conversions specified by the user in service platform.

conversion_name

STRINGThe name of the conversion.

google_analytics

analytics_conversions

This report contains google analytics conversions data. Learn more.

nametypedescriptionvalues

language_x_id

INTThe universal ID of the language.

landing_page_x_id

INTThe universal ID of the landing page.

conversion_x_id

INTThe universal ID of the conversion name.

attribution_x_id

INTSurrogate key to uniquely identify attribution channel using account_id,country,device,campaign,landing_page_path,source_medium,channel_grouping.

account_x_id

STRINGThe universal ID of the account_id.

updated_at_db

TIMESTAMPThe latest timestamp that record was updated, in database.

source_service

STRINGThe name of the service that data were extracted from.

date

DATEThe date (yyyy-MM-dd).

conversions_value

NUMERICThe value of conversions. This only includes conversions specified by the user in service platform. The total numeric value for the requested goal number.

conversions

NUMERICThe 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.

nametypedescriptionvalues

language_x_id

INTThe universal ID of the language.

landing_page_x_id

INTThe universal ID of the landing page.

attribution_x_id

INTSurrogate key to uniquely identify attribution channel using account_id,country,device,campaign,landing_page_path,source_medium,channel_grouping.

account_x_id

INTThe universal ID of the account_id.

users

NUMERICThe total number of users for the requested time period.

updated_at_db

TIMESTAMPThe latest timestamp that record was updated, in database.

transactions

NUMERICThe total number of transactions.

source_service

STRINGThe name of the service that data were extracted from.

sessions

NUMERICThe total number of sessions.

new_users

NUMERICThe number of sessions marked as a user's first sessions.

date

DATEThe date (yyyy-MM-dd).

bounces

NUMERICThe 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.

nametypedescriptionvalues

landing_page_x_id

INTThe universal ID of the landing page.

speed_metrics_sample

NUMERICThe 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

NUMERICThe total number of sessions.

server_response_time

NUMERICD.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

NUMERICC.Total time (in milliseconds) all samples spent in establishing a TCP connection to this page.

redirection_time

NUMERICA.The total time (in milliseconds) all samples spent in redirects before fetching this page. If there are no redirects, this is 0.

pageviews

NUMERICThe total number of pageviews for the property.

page_load_time

NUMERICA-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

NUMERICThe sample set (or count) of pageviews used to calculate the average page load time.

page_download_time

NUMERICG.The total time (in milliseconds) to download this page among all samples.

domain_lookup_time

NUMERICB.The total time (in milliseconds) all samples spent in DNS lookup for this page.

dom_latency_metrics_sample

NUMERICSample 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

NUMERICE.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

NUMERICF.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

DATEThe date (yyyy-MM-dd).

browser

STRINGThe name of users browsers.Safari, Internet Explorer, Firefox, etc.

analytics_transactions

This report contains google analytics transaction data. Learn more.

nametypedescriptionvalues

landing_page_x_id

INTThe universal ID of the landing page.

attribution_x_id

INTSurrogate key to uniquely identify attribution channel using account_id,country,device,campaign,landing_page_path,source_medium,channel_grouping.

transaction_id

STRINGThe transaction ID, supplied by the ecommerce tracking method, for the purchase in the shopping cart.

transactions

NUMERICThe total number of transactions.

transaction_revenue

NUMERICThe total sale revenue (excluding shipping and tax) of the transaction.

full_referrer

STRINGThe full referring URL including the hostname and path.

date

DATEThe date (yyyy-MM-dd).

analytics_transactions_product

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

nametypedescriptionvalues

transaction_id

STRINGThe transaction ID, supplied by the ecommerce tracking method, for the purchase in the shopping cart.

revenue_per_item

NUMERICThe average revenue per item.

product_sku

STRINGThe product SKU, defined in the ecommerce tracking application, for purchased items.

product_removes_from_cart

NUMERICNumber of times the product was removed from the shopping cart (Enhanced Ecommerce).

product_refunds

NUMERICNumber of times a refund was issued for the product (Enhanced Ecommerce).

product_refund_amount

NUMERICTotal refund amount associated with the product (Enhanced Ecommerce).

product_name

STRINGThe product name, supplied by the ecommerce tracking application, for purchased items.

product_list_views

NUMERICNumber of times the product appeared in a product list (Enhanced Ecommerce).

product_list_clicks

NUMERICNumber of times users clicked the product when it appeared in the product list (Enhanced Ecommerce).

product_coupon_code

STRINGCode for the product-level coupon (Enhanced Ecommerce).

product_checkouts

NUMERICNumber of times the product was included in the check-out process (Enhanced Ecommerce).

product_category_hierarchy

STRINGThe hierarchical category in which the product is classified (Enhanced Ecommerce).

product_adds_to_cart

NUMERICNumber of times the product was added to the shopping cart (Enhanced Ecommerce).

item_quantity

NUMERICTotal number of items purchased. For example, if users purchase 2 frisbees and 5 tennis balls, this will be 7.

date

DATEThe date (yyyy-MM-dd).

google_play

google_play_installs

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

nametypedescriptionvalues

table_x_id

INTA surrogate key to uniquely identify specific row.

language_x_id

INTThe universal ID of the language.

device_x_id

INTThe universal ID of the device type.

country_x_id

INTThe universal ID of the country.

account_x_id

INTThe universal ID of the account_id.

account_id

STRINGThe ID of the account.

updated_at_db

TIMESTAMPThe latest timestamp that record was updated, in database.

update_events

NUMERIC

uninstall_events

NUMERIC

total_user_installs

NUMERIC

report_category

STRINGThe 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

STRINGThe type of device.

date

DATEThe 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

STRINGThe 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.

nametypedescriptionvalues

table_x_id

INTA surrogate key to uniquely identify specific row.

language_x_id

INTThe universal ID of the language.

device_x_id

INTThe universal ID of the device type.

account_x_id

INTThe universal ID of the account_id.

account_id

STRINGThe ID of the account.

updated_at_db

TIMESTAMPThe latest timestamp that record was updated, in database.

star_rating

NUMERIC

review_title

STRING

review_text

STRING

review_submit_date_and_time

TIMESTAMP
STRING

review_last_update_date_and_time

TIMESTAMP

report_category

STRINGThe name of the service that data were extracted from.

package_name

STRING

language

STRING

device_marketing_name

STRING

device_brand

STRING

device

STRINGThe type of device.

developer_reply_text

STRING

developer_reply_date_and_time

TIMESTAMP

date

DATEThe 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.

nametypedescriptionvalues

search_type

STRINGThe search type.news, image, video, web

position

NUMERICAverage ranking in search results.

impressions

NUMERICThe number of impressions.

date

DATEThe date (yyyy-MM-dd).

clicks

NUMERICThe number of clicks.

queries_organic_page

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

nametypedescriptionvalues

landing_page_x_id

INTThe universal ID of the landing page.

search_type

STRINGThe search type.news, image, video, web

position

NUMERICAverage ranking in search results.

impressions

NUMERICThe number of impressions.

date

DATEThe date (yyyy-MM-dd).

clicks

NUMERICThe number of clicks.

queries_organic

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

nametypedescriptionvalues

query_x_id

INTThe universal ID of the search_term.

landing_page_x_id

INTThe universal ID of the landing page.

device_x_id

INTThe universal ID of the device type.

country_x_id

INTThe universal ID of the country.

account_x_id

INTThe universal ID of the account_id.

updated_at_db

TIMESTAMPThe latest timestamp that record was updated, in database.

search_type

STRINGThe search type.news, image, video, web

property_position

NUMERICAverage ranking in search results.

property_impressions

NUMERIC

property_clicks

NUMERIC

position

NUMERICAverage ranking in search results.

impressions

NUMERICThe number of impressions.

date

DATEThe date (yyyy-MM-dd).

clicks

NUMERICThe number of clicks.

queries_organic_monthly

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

nametypedescriptionvalues

query_x_id

INTThe universal ID of the search_term.

landing_page_x_id

INTThe universal ID of the landing page.

device_x_id

INTThe universal ID of the device type.

country_x_id

INTThe universal ID of the country.

account_x_id

INTThe universal ID of the account_id.

updated_at_db

TIMESTAMPThe latest timestamp that record was updated, in database.

search_type

STRINGThe search type.news, image, video, web

property_impressions

NUMERIC

property_clicks

NUMERIC

position

NUMERICAverage ranking in search results.

impressions

NUMERICThe number of impressions.

date

DATEThe date (yyyy-MM-dd).

clicks

NUMERICThe number of clicks.