You can see the field IDs associated with each definition by clicking Show field IDs beside the term being defined. Alternatively, you can toggle all field ID visibility at once.

Android App ID string  Show field IDs

Google’s unique identifier for each application on the Google Play Store

Primary key: ANDROID_APPS.ID
Foreign key: ANDROID_SALES_REPORT_ESTIMATES.APP_ID, 
             ANDROID_DAILY_USAGE_ESTIMATES.APP_ID, 
             ANDROID_WEEKLY_USAGE_ESTIMATES.APP_ID, 
             ANDROID_MONTHLY_USAGE_ESTIMATES.APP_ID, 
             ANDROID_SESSION_COUNT_ESTIMATES.APP_ID, 
             ANDROID_TIME_SPENT_ESTIMATES.APP_ID, 
             COHORT_APPS.APP_ID

Android Publisher ID string  Show field IDs

Google’s unique identifier for each app developer on the Google Play Store

Primary key: ANDROID_PUBLISHERS.ID
Foreign key: ANDROID_APPS.PUBLISHER_ID

App Name string  Show field IDs

The application name that the app developer has chosen for the store. (This can change over time and be different across stores)

IOS app name:     IOS_APPS.NAME
Android app name: ANDROID_APPS.NAME

Avg Session Count float  Show field IDs

Counts the weekly average count of sessions that daily active users of the selection cohort apps have on filter cohort apps

Android Weekly Cohort Engagement Estimates:   ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.AVERAGE_SESSION_COUNT
Android Weekly Engagement Insights Estimates: ANDROID_WEEKLY_ENGAGEMENT_INSIGHTS_ESTIMATES.AVERAGE_SESSION_COUNT

Avg Time Spent float  Show field IDs

Counts the weekly average count of time spent that daily active users of the selection cohort apps have on filter cohort apps

Android Weekly Cohort Engagement Estimates:   ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.AVERAGE_TIME_SPENT
Android Weekly Engagement Insights Estimates: ANDROID_WEEKLY_ENGAGEMENT_INSIGHTS_ESTIMATES.AVERAGE_TIME_SPENT

Cohort ID string  Show field IDs

Sensor Tower’s unique identifier for each consumer intel cohort. Many apps can be linked to a single cohort ID

Primary key: COHORTS.ID
Foreign key: COHORT_APPS.COHORT_ID, 
             ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.SELECTION_COHORT_ID, 
             ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.FILTER_COHORT_ID, 
             ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES_CONFIDENCE.SELECTION_COHORT_ID, 
             ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES_CONFIDENCE.FILTER_COHORT_ID,
             ANDROID_WEEKLY_ENGAGMENT_INSIGHTS_ESTIMATES.SELECTION_COHORT_ID,
             ANDROID_WEEKLY_ENGAGEMENT_INSIGHTS_ESTIMATES_CONFIDENCE.SELECTION_COHORT_ID

Confidence number  Show field IDs

The confidence level of the data that can range from 29 (very confident) to 0 (no confidence)

Android Weekly Cohort Engagement Estimates Confidence:   ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES_CONFIDENCE.CONFIDENCE
Android Weekly Engagement Insights Estimates Confidence: ANDROID_WEEKLY_ENGAGEMENT_INSIGHTS_ESTIMATES_CONFIDENCE.CONFIDENCE

Country string  Show field IDs

The Country Code for the country in which this data is referring to. For a full list of country codes please use: Country Code List

Android Sales Report Estimates:  ANDROID_SALES_REPORT_ESTIMATES.COUNTRY
Android Daily Usage Estimates:   ANDROID_DAILY_USAGE_ESTIMATES.COUNTRY
Android Weekly Usage Estimates:  ANDROID_WEEKLY_USAGE_ESTIMATES.COUNTRY
Android Monthly Usage Estimates: ANDROID_MONTHLY_USAGE_ESTIMATES.COUNTRY
Android Session Count Estimates: ANDROID_SESSION_COUNT_ESTIMATES.COUNTRY
Android Time Spent Estimates:    ANDROID_TIME_SPENT_ESTIMATES.COUNTRY
IOS Sales Report Estimates:      IOS_SALES_REPORT_ESTIMATES.COUNTRY
IOS Daily Usage Estimates:       IOS_DAILY_USAGE_ESTIMATES.COUNTRY
IOS Weekly Usage Estimates:      IOS_WEEKLY_USAGE_ESTIMATES.COUNTRY
IOS Monthly Usage Estimates:     IOS_MONTHLY_USAGE_ESTIMATES.COUNTRY
IOS Session Count Estimates:     IOS_SESSION_COUNT_ESTIMATES.COUNTRY
IOS Time Spent Estimates:        IOS_TIME_SPENT_ESTIMATES.COUNTRY

Daily Active Users integer  Show field IDs

Counts the number of unique users who logs at least 1 session in an app for at least two seconds in a given day.

IOS:     IOS_DAILY_USAGE_ESTIMATES.DAILY_ACTIVE_IPHONE_USERS + IOS_DAILY_USAGE_ESTIMATES.DAILY_ACTIVE_IPAD_USERS
Android: ANDROID_DAILY_USAGE_ESTIMATES.DAILY_ACTIVE_USERS

Download integer  Show field IDs

A unique install per iOS or Google Play account, not including reinstalls, app updates, or subsequent installs on additional devices with the same account.

IOS:     IOS_SALES_REPORT_ESTIMATES.IPHONE_DOWNLOADS + IOS_SALES_REPORT_ESTIMATES.IPAD_DOWNLOADS
Android: ANDROID_SALES_REPORT_ESTIMATES.ANDROID_DOWNLOADS

Filter Cohort ID string  Show field IDs

The ID of the cohort for which usage is being calculated based on the selection criteria. “Users of the selection cohort apps use the filter cohort apps in the following way”

Android Weekly Cohort Engagement Estimates:            ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.FILTER_COHORT_ID
Android Weekly Cohort Engagement Estimates Confidence: ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES_CONFIDENCE.FILTER_COHORT_ID

iOS App ID integer  Show field IDs

Apple’s unique identifier for each application on the iOS App Store

Primary key: IOS_APPS.ID
Foreign key: IOS_SALES_REPORT_ESTIMATES.APP_ID, 
             IOS_DAILY_USAGE_ESTIMATES.APP_ID, 
             IOS_WEEKLY_USAGE_ESTIMATES.APP_ID, 
             IOS_MONTHLY_USAGE_ESTIMATES.APP_ID, 
             IOS_SESSION_COUNT_ESTIMATES.APP_ID, 
             IOS_TIME_SPENT_ESTIMATES.APP_ID, 
             COHORT_APPS.APP_ID

iOS Publisher ID integer  Show field IDs

Apple’s unique identifier for each app developer on the iOS App Store

Primary key: IOS_PUBLISHERS.ID
Foreign key: IOS_APPS.PUBLISHER_ID

Monthly Active Users integer  Show field IDs

Counts the number of unique users who logs at least 1 session in an app for at least two seconds in a given month.

IOS:     IOS_MONTHLY_USAGE_ESTIMATES.MONTHLY_ACTIVE_IPHONE_USERS + IOS_MONTHLY_USAGE_ESTIMATES.MONTHLY_ACTIVE_IPAD_USERS
Android: ANDROID_MONTHLY_USAGE_ESTIMATES.MONTHLY_ACTIVE_USERS

Monthly Sessions integer  Show field IDs

Counts the total number of sessions by daily active users for a particular month

IOS/Monthly:       IOS_SESSION_COUNT_ESTIMATES.MONTHLY_SESSIONS
IOS/Quarterly:     IOS_SESSION_COUNT_ESTIMATES.QUARTERLY_SESSIONS
Android/Monthly:   ANDROID_SESSION_COUNT_ESTIMATES.MONTHLY_SESSIONS
Android/Quarterly: ANDROID_SESSION_COUNT_ESTIMATES.QUARTERLY_SESSIONS

Monthly Time Spent integer  Show field IDs

Counts the total time spent in seconds by daily active users for a particular month, this is a calculation of session count and session duration

IOS:     IOS_TIME_SPENT_ESTIMATES.MONTHLY_TIME_SPENT
Android: ANDROID_TIME_SPENT_ESTIAMTES.MONTHLY_TIME_SPENT

Name string  Show field IDs

The name of the cohort. This can be the name of an app, category, or general grouping

COHORTS.NAME

Observation Date timestamp  Show field IDs

The date the data is related to.

Android Sales Report Estimates:               ANDROID_SALES_REPORT_ESTIMATES.OBSERVATION_DATE,
Android Daily Usage Estimates:                ANDROID_DAILY_USAGE_ESTIMATES.OBSERVATION_DATE,
Android Weekly Usage Estimates:               ANDROID_WEEKLY_USAGE_ESTIMATES.OBSERVATION_DATE,
Android Monthly Usage Estimates:              ANDROID_MONTHLY_USAGE_ESTIMATES.OBSERVATION_DATE,
Android Session Count Estimates:              ANDROID_SESSION_COUNT_ESTIMATES.OBSERVATION_DATE,
Android Time Spent Estimates:                 ANDROID_TIME_SPENT_ESTIMATES.OBSERVATION_DATE,
Android Weekly Cohort Engagement Estimates:   ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.OBSERVATION_DATE,
Android Weekly Engagement Insights Estimates: ANDROID_WEEKLY_ENGAGEMENT_INSIGHTS_ESTIMATES.OBSERVATION_DATE,
IOS Sales Report Estimates:                   IOS_SALES_REPORT_ESTIMATES.OBSERVATION_DATE,
IOS Daily Usage Estimates:                    IOS_DAILY_USAGE_ESTIMATES.OBSERVATION_DATE,
IOS Weekly Usage Estimates:                   IOS_WEEKLY_USAGE_ESTIMATES.OBSERVATION_DATE,
IOS Monthly Usage Estimates:                  IOS_MONTHLY_USAGE_ESTIMATES.OBSERVATION_DATE,
IOS Session Count Estimates:                  IOS_SESSION_COUNT_ESTIMATES.OBSERVATION_DATE,
IOS Time Spent Estimates:                     IOS_TIME_SPENT_ESTIMATES.OBSERVATION_DATE

PCT DAU float  Show field IDs

The percentage of daily active users of the selection cohort apps, that uses the filter cohort apps

ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.PCT_DAU

Publisher Name string  Show field IDs

The app developer’s name as it is in the App Store or Google Play Store (This can change over time and be different across stores)

IOS:     IOS_PUBLISHERS.NAME
Android: ANDROID_PUBLISHERS.NAME

Quarterly Sessions integer  Show field IDs

Counts the total number of sessions by daily active users for a particular quarter

IOS:     IOS_SESSION_COUNT_ESTIMATES.QUARTERLY_SESSIONS
Android: ANDROID_SESSION_COUNT_ESTIMATES.QUARTERLY_SESSIONS

Quarterly Time Spent integer  Show field IDs

Counts the total time spent in seconds by daily active users for a particular quarter, this is a calculation of session count and session duration

IOS:     IOS_TIME_SPENT_ESTIMATES.QUARTERLY_TIME_SPENT
Android: ANDROID_TIME_SPENT_ESTIMATES.QUARTERLY_TIME_SPENT

Revenue integer  Show field IDs

Metric for measuring net app bookings, minus Apple and Google’s 15–30% taxes. Revenue includes spending on app cost, in-app purchases, and subscriptions. It does not include third-party purchases outside of the app stores or ad revenue. Revenue is reported in USd.

IOS:     IOS_SALES_REPORT_ESTIMATES.IPHONE_REVENUE + IOS_SALES_REPORT_ESTIMATES.IPAD_REVENUE
Android: ANDROID_SALES_REPORT_ESTIMATES.ANDROID_REVENUE

Revision Date timestamp  Show field IDs

The date the data was last revised by Sensor Tower. This is different from the Observation Date as Sensor Tower has a slight delay between the observation date and when we are able to post the data. This may also be affected by our Quarterly Data Updates.

Unified Publishers:                                      UNIFIED_PUBLISHERS.REVISION_DATE,
IOS Publishers:                                          IOS_PUBLISHERS.REVISION_DATE,
Android Publishers:                                      ANDROID_PUBLISHERS.REVISION_DATE,
Unified Apps:                                            UNIFIED_APPS.REVISION_DATE,
IOS Apps:                                                IOS_APPS.REVISION_DATE,
Android Apps:                                            ANDROID_APPS.REVISION_DATE,
Cohorts:                                                 COHORTS.REVISION_DATE,
Cohort Apps:                                             COHORT_APPS.REVISION_DATE,
Android Weekly Cohort Engagement Estimates:              ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.REVISION_DATE,
Android Weekly Cohort Engagement Estimates Confidence:   ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES_CONFIDENCE.REVISION_DATE,
Android Weekly Engagement Insights Estimates.            ANDROID_WEEKLYENGAGEMENT_INSIGHTS_ESTIMATES.REVISION_DATE,
Android Weekly Engagement Insights Estimates Confidence: ANDROID_WEEKLY_ENGAGEMENT_INSIGHTS_ESTIMATES_CONFIDENCE.REVISION_DATE,
IOS Sales Report Estimates:                              IOS_SALES_REPORT_ESTIMATES.REVISION_DATE,
IOS Daily Usage Estimates:                               IOS_DAILY_USAGE_ESTIMATES.REVISION_DATE,
IOS Weekly Usage Estimates:                              IOS_WEEKLY_USAGE_ESTIMATES.REVISION_DATE,
IOS Monthly Usage Estimates:                             IOS_MONTHLY_USAGE_ESTIMATES.REVISION_DATE,
IOS Session Count Estimates:                             IOS_SESSION_COUNT_ESTIMATES.REVISION_DATE,
IOS Time Spent Estimates:                                IOS_TIME_SPENT_ESTIMATES.REVISION_DATE,
Android Sales Report Estimates:                          ANDROID_SALES_REPORT_ESTIMATES.REVISION_DATE,
Android Daily Usage Estimates:                           ANDROID_DAILY_USAGE_ESTIMATES.REVISION_DATE,
Android Weekly Usage Estimates:                          ANDROID_WEEKLY_USAGE_ESTIMATES.REVISION_DATE,
Android Monthly Usage Estimates:                         ANDROID_MONTHLY_USAGE_ESTIMATES.REVISION_DATE,
Android Session Count Estimates:                         ANDROID_SESSION_COUNT_ESTIMATES.REVISION_DATE,
Android Time Spent Estimates:                            ANDROID_TIME_SPENT_ESTIMATES.REVISION_DATE

Selection Cohort ID string  Show field IDs

The ID of the cohort whose population is being analyzed

Primary key: COHORTS.ID
Foreign key: COHORT_APPS.COHORT_ID, 
             ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.SELECTION_COHORT_ID, 
             ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.FILTER_COHORT_ID, 
             ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES_CONFIDENCE.SELECTION_COHORT_ID, 
             ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES_CONFIDENCE.FILTER_COHORT_ID,
             ANDROID_WEEKLY_ENGAGMENT_INSIGHTS_ESTIMATES.SELECTION_COHORT_ID,
             ANDROID_WEEKLY_ENGAGEMENT_INSIGHTS_ESTIMATES_CONFIDENCE.SELECTION_COHORT_ID

Stock Ticker string  Show field IDs

Sensor Tower set field that showcases if this app is associated with a Public Stock Exchange Ticker. Format: {stock_exchange}: {ticker}; Example: NYSE: DIS

UNIFIED_PUBLISHERS.STOCK_TICKER

Subtype string  Show field IDs

The subgrouping that cohort’s with a type of “App” or “Game” belong to. These subtypes typically align with more general app and game categories

Cohorts: COHORTS.SUBTYPE

Type string  Show field IDs

The main associated grouping that a cohort belongs to. Valid types can be app, game, group, or category

Cohorts: COHORTS.TYPE

Unified App ID string  Show field IDs

Sensor Tower’s unique identifier for each combination of iOS and Google Play applications. This includes different versions of the apps across stores or countries.

Primary key: UNIFIED_APPS.ID
Forein key:  IOS_APPS.UNIFIED_APP_ID, ANDROID_APPS.UNIFIED_APP_ID

Unified Publisher ID string  Show field IDs

Sensor Tower’s unique identifier for each combination of iOS and Google Play app developer. This includes different versions of the app developer across stores or countries.

Primary key: UNIFIED_PUBLISHERS.ID
Foreign key: IOS_PUBLISHERS.UNIFIED_PUBLISHER_ID, ANDROID_PUBLISHERS.UNIFIED_PUBLISHER_ID

Visible boolean  Show field IDs

A True/False indication of if data for this combination of cohorts are visible on the frontend

Android Weekly Cohort Engagement Estimates:   ANDROID_WEEKLY_COHORT_ENGAGEMENT_ESTIMATES.VISIBLE,
Android Weekly Engagement Insights Estimates: ANDROID_WEEKLY_ENGAGEMENT_INSIGHTS_ESTIMATES.VISIBLE

Weekly Active Users integer  Show field IDs

Counts the number of unique users who logs at least one session in an app for at least two seconds in a given week.

IOS Weekly Usage Estimates:     IOS_WEEKLY_USAGE_ESTIMATES.WEEKLY_ACTIVE_IPHONE_USERS + IOS_WEEKLY_USAGE_ESTIMATES.WEEKLY_ACTIVE_IPAD_USERS,
Android Weekly Usage Estimates: ANDROID_WEEKLY_USAGE_ESTIMATES.WEEKLY_ACTIVE_USERS