Sensor Tower
Explore the interactive ERD
Table & Field Reference
ios_active_user
| Column | Type | Keys |
|---|---|---|
date | Instant | PK |
app_id | Unknown | PKFK |
country | Unknown | PKFK |
ipad_users | Unknown | |
iphone_users | Unknown |
ios_rating
| Column | Type | Keys |
|---|---|---|
app_id | Unknown | PKFK |
average | Unknown | |
country | Unknown | |
date | Instant | |
five_star | Unknown | |
four_star | Unknown | |
one_star | Unknown | |
three_star | Unknown | |
total | Unknown | |
two_star | Unknown |
ios_sales_report_estimate
| Column | Type | Keys |
|---|---|---|
date | Instant | PK |
app_id | Unknown | PKFK |
country_code | Unknown | PKFK |
ipad_downloads | Unknown | |
ipad_revenue | Unknown | |
iphone_downloads | Unknown | |
iphone_revenue | Unknown |
ios_review_tag
| Column | Type | Keys |
|---|---|---|
tags | Unknown | PK |
review_app_id | Unknown | PKFK |
review_username | Unknown | PKFK |
ios_review
| Column | Type | Keys |
|---|---|---|
username | Unknown | PK |
app_id | Unknown | PKFK |
content | Unknown | |
country | Unknown | |
date | Instant | |
rating | Unknown | |
title | Unknown | |
version | Unknown |
android_rating
| Column | Type | Keys |
|---|---|---|
app_id | Unknown | PKFK |
average | Unknown | |
country | Unknown | |
date | Instant | |
five_star | Unknown | |
four_star | Unknown | |
one_star | Unknown | |
three_star | Unknown | |
total | Unknown | |
two_star | Unknown |
ios_usage_demography
| Column | Type | Keys |
|---|---|---|
app_id | Unknown | PKFK |
average_age_total | Unknown | |
confidence | Unknown | |
country | Unknown | |
date | Unknown | |
date_granularity | Unknown | |
end_date | Unknown | |
female | Unknown | |
male | Unknown | |
normalized_demographics_female_18 | Unknown | |
normalized_demographics_female_25 | Unknown | |
normalized_demographics_female_35 | Unknown | |
normalized_demographics_female_45 | Unknown | |
normalized_demographics_female_55 | Unknown | |
normalized_demographics_male_18 | Unknown | |
normalized_demographics_male_25 | Unknown | |
normalized_demographics_male_35 | Unknown | |
normalized_demographics_male_45 | Unknown | |
normalized_demographics_male_55 | Unknown |
ios_top_trending_active_user_custom_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
ios_top_trending_active_user_fivetran_id | Unknown | PKFK |
value | Unknown |
ios_top_trending_active_user
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
app_id | Unknown | FK |
date | Instant | |
users_absolute | Unknown | |
users_delta | Unknown | |
users_market_share | Unknown | |
users_transformed_delta | Unknown |
android_usage_retention
| Column | Type | Keys |
|---|---|---|
app_id | Unknown | PKFK |
confidence | Unknown | |
corrected_retention | Json | |
country | Unknown | |
date | Unknown | |
date_granularity | Unknown | |
end_date | Unknown |
android_app_category
| Column | Type | Keys |
|---|---|---|
category | Unknown | PK |
android_app_id | Unknown | PKFK |
android_app_valid_country
| Column | Type | Keys |
|---|---|---|
country | Unknown | PK |
android_app_id | Unknown | PKFK |
android_app_top_country
| Column | Type | Keys |
|---|---|---|
country | Unknown | PK |
android_app_id | Unknown | PKFK |
android_app_permission
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
android_app_id | Unknown | PKFK |
value | Unknown |
android_app
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
advisories | Json | |
app_view_url | Unknown | |
apple_watch_enabled | Unknown | |
bundle_id | Unknown | |
canonical_country | Unknown | |
content_rating | Unknown | |
description | Unknown | |
eula_url | Unknown | |
feature_graphic | Unknown | |
global_rating_count | Unknown | |
humanized_name | Unknown | |
humanized_worldwide_last_month_downloads | Unknown | |
humanized_worldwide_last_month_downloads_prefix | Unknown | |
humanized_worldwide_last_month_downloads_rounded | Unknown | |
humanized_worldwide_last_month_downloads_string | Unknown | |
humanized_worldwide_last_month_downloads_units | Unknown | |
humanized_worldwide_last_month_revenue | Unknown | |
humanized_worldwide_last_month_revenue_prefix | Unknown | |
humanized_worldwide_last_month_revenue_rounded | Unknown | |
humanized_worldwide_last_month_revenue_string | Unknown | |
humanized_worldwide_last_month_revenue_units | Unknown | |
icon_url | Unknown | |
imessage_enabled | Unknown | |
imessage_icon | Unknown | |
in_app_purchase | Unknown | |
name | Unknown | |
os | Unknown | |
price | Unknown | |
privacy_policy_url | Unknown | |
promo_text | Unknown | |
publisher_address | Unknown | |
publisher_country | Unknown | |
publisher_email | Unknown | |
publisher_id | Unknown | |
publisher_name | Unknown | |
publisher_profile_url | Unknown | |
rating | Unknown | |
rating_count | Unknown | |
rating_count_for_current_version | Unknown | |
rating_for_current_version | Unknown | |
release_date | Unknown | |
screenshot_urls | Json | |
short_description | Unknown | |
subtitle | Unknown | |
support_url | Unknown | |
tablet_screenshot_urls | Json | |
unified_app_id | Unknown | |
updated_date | Unknown | |
url | Unknown | |
version | Unknown | |
website_url | Unknown |
ios_app_category
| Column | Type | Keys |
|---|---|---|
category | Unknown | PK |
ios_app_id | Unknown | PKFK |
ios_app_valid_country
| Column | Type | Keys |
|---|---|---|
country | Unknown | PK |
ios_app_id | Unknown | PKFK |
ios_app_top_country
| Column | Type | Keys |
|---|---|---|
country | Unknown | PK |
ios_app_id | Unknown | PKFK |
ios_app_permission
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
ios_app_id | Unknown | PKFK |
value | Unknown |
ios_app
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
advisories | Json | |
app_view_url | Unknown | |
apple_watch_enabled | Unknown | |
bundle_id | Unknown | |
canonical_country | Unknown | |
content_rating | Unknown | |
description | Unknown | |
eula_url | Unknown | |
feature_graphic | Unknown | |
global_rating_count | Unknown | |
humanized_name | Unknown | |
humanized_worldwide_last_month_downloads | Unknown | |
humanized_worldwide_last_month_downloads_prefix | Unknown | |
humanized_worldwide_last_month_downloads_rounded | Unknown | |
humanized_worldwide_last_month_downloads_string | Unknown | |
humanized_worldwide_last_month_downloads_units | Unknown | |
humanized_worldwide_last_month_revenue | Unknown | |
humanized_worldwide_last_month_revenue_prefix | Unknown | |
humanized_worldwide_last_month_revenue_rounded | Unknown | |
humanized_worldwide_last_month_revenue_string | Unknown | |
humanized_worldwide_last_month_revenue_units | Unknown | |
icon_url | Unknown | |
imessage_enabled | Unknown | |
imessage_icon | Unknown | |
in_app_purchase | Unknown | |
name | Unknown | |
os | Unknown | |
price | Unknown | |
privacy_policy_url | Unknown | |
promo_text | Unknown | |
publisher_address | Unknown | |
publisher_country | Unknown | |
publisher_email | Unknown | |
publisher_id | Unknown | |
publisher_name | Unknown | |
publisher_profile_url | Unknown | |
rating | Unknown | |
rating_count | Unknown | |
rating_count_for_current_version | Unknown | |
rating_for_current_version | Unknown | |
release_date | Unknown | |
screenshot_urls | Json | |
short_description | Unknown | |
subtitle | Unknown | |
support_url | Unknown | |
tablet_screenshot_urls | Json | |
unified_app_id | Unknown | |
updated_date | Unknown | |
url | Unknown | |
version | Unknown | |
website_url | Unknown |
android_active_user
| Column | Type | Keys |
|---|---|---|
date | Instant | PK |
app_id | Unknown | PKFK |
country | Unknown | PKFK |
users | Unknown |
android_top_trending_active_user_custom_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
android_top_trending_active_user_fivetran_id | Unknown | PKFK |
value | Unknown |
android_top_trending_active_user
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
app_id | Unknown | FK |
date | Instant | |
users_absolute | Unknown | |
users_delta | Unknown | |
users_market_share | Unknown | |
users_transformed_delta | Unknown |
android_category_ranking
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PK |
chart_type_id | Unknown | PK |
app_id | Unknown | PKFK |
rank | Unknown |
ios_sales_report_estimate_comparison_custom_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
ios_sales_report_estimate_comparison_app_id | Unknown | PKFK |
ios_sales_report_estimate_comparison_date | Instant | PKFK |
value | Unknown |
ios_sales_report_estimate_comparison
| Column | Type | Keys |
|---|---|---|
date | Instant | PK |
app_id | Unknown | PKFK |
absolute | Unknown | |
comparison_revenue_value | Unknown | |
comparison_units_value | Unknown | |
country | Unknown | |
current_revenue_value | Unknown | |
current_units_value | Unknown | |
deltas | Unknown | |
revenue_absolute | Unknown | |
revenue_delta | Unknown | |
revenue_transformed_delta | Unknown | |
transformed_delta | Unknown | |
units_absolute | Unknown | |
units_delta | Unknown | |
units_transformed_delta | Unknown |
android_sales_report_estimate_comparison_custom_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
android_sales_report_estimate_comparison_app_id | Unknown | PKFK |
android_sales_report_estimate_comparison_date | Instant | PKFK |
value | Unknown |
android_sales_report_estimate_comparison
| Column | Type | Keys |
|---|---|---|
date | Instant | PK |
app_id | Unknown | PKFK |
absolute | Unknown | |
comparison_revenue_value | Unknown | |
comparison_units_value | Unknown | |
country | Unknown | |
current_revenue_value | Unknown | |
current_units_value | Unknown | |
deltas | Unknown | |
revenue_absolute | Unknown | |
revenue_delta | Unknown | |
revenue_transformed_delta | Unknown | |
transformed_delta | Unknown | |
units_absolute | Unknown | |
units_delta | Unknown | |
units_transformed_delta | Unknown |
android_usage_demography
| Column | Type | Keys |
|---|---|---|
app_id | Unknown | PKFK |
average_age_total | Unknown | |
confidence | Unknown | |
country | Unknown | |
date | Unknown | |
date_granularity | Unknown | |
end_date | Unknown | |
female | Unknown | |
male | Unknown | |
normalized_demographics_female_18 | Unknown | |
normalized_demographics_female_25 | Unknown | |
normalized_demographics_female_35 | Unknown | |
normalized_demographics_female_45 | Unknown | |
normalized_demographics_female_55 | Unknown | |
normalized_demographics_male_18 | Unknown | |
normalized_demographics_male_25 | Unknown | |
normalized_demographics_male_35 | Unknown | |
normalized_demographics_male_45 | Unknown | |
normalized_demographics_male_55 | Unknown |
android_sales_report_estimate
| Column | Type | Keys |
|---|---|---|
date | Instant | PK |
app_id | Unknown | PKFK |
country_code | Unknown | PKFK |
android_downloads | Unknown | |
android_revenue | Unknown |
android_review_tag
| Column | Type | Keys |
|---|---|---|
tags | Unknown | PK |
review_app_id | Unknown | PKFK |
review_username | Unknown | PKFK |
android_review
| Column | Type | Keys |
|---|---|---|
username | Unknown | PK |
app_id | Unknown | PKFK |
content | Unknown | |
country | Unknown | |
date | Instant | |
rating | Unknown | |
title | Unknown | |
version | Unknown |
ios_usage_retention
| Column | Type | Keys |
|---|---|---|
app_id | Unknown | PKFK |
confidence | Unknown | |
corrected_retention | Json | |
country | Unknown | |
date | Unknown | |
date_granularity | Unknown | |
end_date | Unknown |
ios_category_ranking
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PK |
chart_type_id | Unknown | PK |
app_id | Unknown | PKFK |
rank | Unknown |