Snowflake

Pull data from the Sensor Tower platform with SQL rather than via the front-end or API

Definitions of data available in Snowflake

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 & Google’s 30% platform tax and 15% subscription tax. 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.

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

Was this article helpful?

Have more questions? Submit a request