A view allows the result of a query to be accessed as if it were a table. Sensor Tower has a number of views that allow you to easily access key cross-platform data (i.e., data from both the App Store and Google Play Store).
Views serve a variety of purposes, including combining, segregating, and protecting data. For example, you can create separate views that meet the needs of different types of employees. The query is specified in the CREATE VIEW statement.
Apps
CROSS_PLATFORM_APPS
SELECT *
FROM (
SELECT ID,
NAME,
UNIFIED_APP_ID,
PUBLISHER_ID,
'ios'AS PLATFORM
FROM IOS_APPS
) UNION (
SELECT ID,
NAME,
UNIFIED_APP_ID,
PUBLISHER_ID,
'android'AS PLATFORM
FROM ANDROID_APPS
)
Daily Usage Estimates
CROSS_PLATFORM_DAILY_USAGE_ESTIMATES
SELECT *
FROM (
(
SELECT APP_ID,
OBSERVATION_DATE,
COUNTRY,
DAILY_ACTIVE_IPHONE_USERS + DAILY_ACTIVE_IPAD_USERS AS DAILY_ACTIVE_USERS,
DAILY_ACTIVE_IPHONE_USERS,
DAILY_ACTIVE_IPAD_USERS,
'ios'AS PLATFORM
FROM IOS_DAILY_USAGE_ESTIMATES
) UNION (
SELECT APP_ID,
OBSERVATION_DATE,
COUNTRY,
DAILY_ACTIVE_USERS,
0AS DAILY_ACTIVE_IPHONE_USERS,
0AS DAILY_ACTIVE_IPAD_USERS,
'android'AS PLATFORM
FROM ANDROID_DAILY_USAGE_ESTIMATES
)
)
Weekly Usage Estimates
CROSS_PLATFORM_WEEKLY_USAGE_ESTIMATES
SELECT *
FROM (
(
SELECT APP_ID,
OBSERVATION_DATE,
COUNTRY,
WEEKLY_ACTIVE_IPHONE_USERS + WEEKLY_ACTIVE_IPAD_USERS AS WEEKLY_ACTIVE_USERS,
WEEKLY_ACTIVE_IPHONE_USERS,
WEEKLY_ACTIVE_IPAD_USERS,
'ios'AS PLATFORM
FROM IOS_WEEKLY_USAGE_ESTIMATES
) UNION (
SELECT APP_ID,
OBSERVATION_DATE,
COUNTRY,
WEEKLY_ACTIVE_USERS,
0AS WEEKLY_ACTIVE_IPHONE_USERS,
0AS WEEKLY_ACTIVE_IPAD_USERS,
'android'AS PLATFORM
FROM ANDROID_WEEKLY_USAGE_ESTIMATES
)
)
Monthly Usage Estimates
CROSS_PLATFORM_MONTHLY_USAGE_ESTIMATES
SELECT *
FROM (
(
SELECT APP_ID,
OBSERVATION_DATE,
COUNTRY,
MONTHLY_ACTIVE_IPHONE_USERS + MONTHLY_ACTIVE_IPAD_USERS AS MONTHLY_ACTIVE_USERS,
MONTHLY_ACTIVE_IPHONE_USERS,
MONTHLY_ACTIVE_IPAD_USERS,
'ios'AS PLATFORM
FROM IOS_MONTHLY_USAGE_ESTIMATES
) UNION (
SELECT APP_ID,
OBSERVATION_DATE,
COUNTRY,
MONTHLY_ACTIVE_USERS,
0AS MONTHLY_ACTIVE_IPHONE_USERS,
0AS MONTHLY_ACTIVE_IPAD_USERS,
'android'AS PLATFORM
FROM ANDROID_MONTHLY_USAGE_ESTIMATES
)
)
Publishers
CROSS_PLATFORM_PUBLISHERS
SELECT *
FROM (
(
SELECT ID,
NAME,
UNIFIED_PUBLISHER_ID,
REVISION_DATE,
'ios'AS PLATFORM
FROM IOS_PUBLISHERS
) UNION (
SELECT ID,
NAME,
UNIFIED_PUBLISHER_ID,
REVISION_DATE,
'android'AS PLATFORM
FROM ANDROID_PUBLISHERS
)
)
Sales Report Estimates
CROSS_PLATFORM_SALES_REPORT_ESTIMATES
SELECT *
FROM (
(
SELECT APP_ID,
OBSERVATION_DATE,
COUNTRY,
IPHONE_DOWNLOADS + IPAD_DOWNLOADS AS DOWNLOADS,
IPHONE_REVENUE + IPAD_REVENUE AS REVENUE,
IPHONE_DOWNLOADS,
IPAD_DOWNLOADS,
IPHONE_REVENUE,
IPAD_REVENUE,
REVISION_DATE,
'ios'AS PLATFORM
FROM IOS_SALES_REPORT_ESTIMATES
) UNION (
SELECT APP_ID,
OBSERVATION_DATE,
COUNTRY,
ANDROID_DOWNLOADS AS DOWNLOADS,
ANDROID_REVENUE AS REVENUE,
0AS IPHONE_DOWNLOADS,
0AS IPAD_DOWNLOADS,
0AS IPHONE_REVENUE,
0AS IPAD_REVENUE,
REVISION_DATE,
'android'AS PLATFORM
FROM ANDROID_SALES_REPORT_ESTIMATES
)
)
Time Spent Estimates
CROSS_PLATFORM_TIME_SPENT_ESTIMATES
SELECT *
FROM (
(
SELECT APP_ID,
COUNTRY,
OBSERVATION_DATE,
MONTHLY_TIME_SPENT,
QUARTERLY_TIME_SPENT,
REVISION_DATE,
'ios'AS PLATFORM
FROM IOS_TIME_SPENT_ESTIMATES
) UNION (
SELECT APP_ID,
COUNTRY,
OBSERVATION_DATE,
MONTHLY_TIME_SPENT,
QUARTERLY_TIME_SPENT,
REVISION_DATE,
'android'AS PLATFORM
FROM ANDROID_TIME_SPENT_ESTIMATES
)
)
Session Count Estimates
CROSS_PLATFORM_SESSION_COUNT_ESTIMATES
SELECT *
FROM (
(
SELECT APP_ID,
COUNTRY,
OBSERVATION_DATE,
MONTHLY_SESSION_COUNT,
QUARTERLY_SESSION_COUNT,
REVISION_DATE,
'ios'AS PLATFORM
FROM IOS_SESSION_COUNT_ESTIMATES
) UNION (
SELECT APP_ID,
COUNTRY,
OBSERVATION_DATE,
MONTHLY_SESSION_COUNT,
QUARTERLY_SESSION_COUNT,
REVISION_DATE,
'android'AS PLATFORM
FROM ANDROID_SESSION_COUNT_ESTIMATES
)
)
Press and Media