Appfigures
Explore the interactive ERD
Table & Field Reference
rating
| Column | Type | Keys |
|---|---|---|
date | LocalDate | PK |
iso | String | PKFK |
product_id | Unknown | PKFK |
average | String | |
breakdown | Json | |
five_star_percent | String | |
four_star_percent | String | |
negative | Unknown | |
neutral | Unknown | |
new_average | String | |
new_negative | Unknown | |
new_neutral | Unknown | |
new_positive | Unknown | |
new_ratings | Json | |
new_total | Unknown | |
one_star_percent | String | |
positive | Unknown | |
three_star_percent | String | |
total | Unknown | |
two_star_percent | String |
country
| Column | Type | Keys |
|---|---|---|
iso | String | PK |
apple_store_no | String | |
name | String |
subscription
| Column | Type | Keys |
|---|---|---|
date | LocalDate | PK |
iso | String | PK |
storefront | String | PK |
product_id | Unknown | PKFK |
activations | Unknown | |
active_discounted_subscriptions | Unknown | |
active_free_trials | Unknown | |
active_grace | Unknown | |
active_subscriptions | Unknown | |
active_trials | Unknown | |
actual_revenue | Unknown | |
all_active_subscriptions | Unknown | |
all_subscribers | Unknown | |
cancellations | Unknown | |
cancelled_subscriptions | Unknown | |
churn | Unknown | |
first_year_subscribers | Unknown | |
grace_drop_off | Unknown | |
grace_recovery | Unknown | |
gross_monthly_recurring_revenu | Unknown | |
gross_revenue | Unknown | |
monthly_recurring_revenu | Unknown | |
new_grace | Unknown | |
new_subscriptions | Unknown | |
new_trial_grace | Unknown | |
new_trials | Unknown | |
non_first_year_subscribers | Unknown | |
paying_subscriptions | Unknown | |
reactivations | Unknown | |
renewals | Unknown | |
transitions_in | Unknown | |
transitions_out | Unknown | |
trial_cancellations | Unknown | |
trial_conversion_rate | Unknown | |
trial_conversions | Unknown | |
trial_grace_drop_off | Unknown | |
trial_grace_recovery | Unknown |
ad_report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
iso | String | FK |
product_id | Unknown | FK |
clicks | Unknown | |
ctr | Unknown | |
date | LocalDate | |
ecpm | Unknown | |
fillrate | Unknown | |
impressions | Unknown | |
network | Unknown | |
requests | Unknown | |
requests_filled | Unknown | |
revenue | Unknown | |
storefront | Unknown |
revenue
| Column | Type | Keys |
|---|---|---|
date | LocalDate | PK |
iso | Unknown | PK |
storefront | Unknown | PK |
product_id | Unknown | PKFK |
ads | Unknown | |
business | Unknown | |
edu | Unknown | |
gross_business | Unknown | |
gross_edu | Unknown | |
gross_iap | Unknown | |
gross_returns | Unknown | |
gross_sales | Unknown | |
gross_subscriptions | Unknown | |
gross_total | Unknown | |
iap | Unknown | |
returns | Unknown | |
sales | Unknown | |
store | Unknown | |
subscriptions | Unknown | |
total | Unknown |
review
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
iso | String | FK |
product_id | Unknown | FK |
author | String | |
date | LocalDateTime | |
has_response | Boolean | |
id | String | |
original_review | String | |
original_title | String | |
predicted_langs | Json | |
review | String | |
stars | Unknown | |
title | String | |
version | Unknown | |
weight | Unknown |
estimate
| Column | Type | Keys |
|---|---|---|
date | LocalDate | PK |
storefront | Unknown | PK |
iso | String | PKFK |
product_id | Unknown | PKFK |
download | String | |
revenue | String |
currency
| Column | Type | Keys |
|---|---|---|
currency | String | PK |
symbol | String |
payment
| Column | Type | Keys |
|---|---|---|
date | LocalDate | PK |
storefront | Unknown | PK |
iso | String | PKFK |
product_id | Unknown | PKFK |
converted_revenue | Unknown | |
estimated_revenue | Unknown | |
financial_revenue | Unknown | |
revenue | Unknown | |
type | String |
event_product
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PKFK |
product_id | Unknown | PKFK |
event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
caption | String | |
date | LocalDateTime | |
details | String | |
origin | String |
installed_sdk
| Column | Type | Keys |
|---|---|---|
id | String | PK |
product_id | Unknown | FK |
active | Boolean | |
found_on | LocalDateTime | |
last_updated | LocalDateTime |
product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
currency | String | FK |
parent_id | Unknown | FK |
source_external_account_id | Unknown | FK |
store_id | Unknown | FK |
accessible_features | Json | |
added_date | LocalDateTime | |
children | Json | |
developer | String | |
devices | Json | |
features | Json | |
icon | String | |
name | String | |
price | Unknown | |
ref_no | Unknown | |
release_date | LocalDateTime | |
sku | String | |
source_active | Boolean | |
source_added_timestamp | LocalDateTime | |
source_hidden | Boolean | |
source_type | String | |
type | String | |
updated_date | LocalDateTime | |
vendor_identifier | Unknown | |
version | Unknown |
languages
| Column | Type | Keys |
|---|---|---|
code | String | PK |
iso | String | FK |
name | String |
archive
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
external_account_id | Unknown | FK |
import_method | String | |
import_timestamp | LocalDateTime | |
region | String | |
report_timestamp | LocalDateTime | |
type | String |
store_supported_feature
| Column | Type | Keys |
|---|---|---|
supported_feature | String | PK |
store_id | String | PKFK |
store_front
| Column | Type | Keys |
|---|---|---|
id | String | PK |
store_id | String | PKFK |
name | String | |
short_name | String | |
type | String |
store_category
| Column | Type | Keys |
|---|---|---|
category_id | Int | PKFK |
store_id | String | PKFK |
store_country
| Column | Type | Keys |
|---|---|---|
iso | String | PKFK |
store_id | String | PKFK |
store
| Column | Type | Keys |
|---|---|---|
id | String | PK |
code | Unknown | |
name | String | |
short_name | String | |
type | String |
user_entitlement
| Column | Type | Keys |
|---|---|---|
entitlement | String | PK |
account_id | Unknown | PKFK |
users_id | Unknown | PKFK |
user_product
| Column | Type | Keys |
|---|---|---|
account_id | Unknown | PKFK |
product_id | String | PKFK |
users_id | Unknown | PKFK |
users
| Column | Type | Keys |
|---|---|---|
account_id | Unknown | PK |
id | Unknown | PK |
account_auto_import | Boolean | |
account_company | String | |
account_is_premium | Boolean | |
account_last_import | LocalDateTime | |
account_name | String | |
account_plan | String | |
account_plan_id | Unknown | |
active | Boolean | |
avatar_url | String | |
currency | String | |
date_format | String | |
email | String | |
is_owner | Boolean | |
last_login | LocalDateTime | |
name | String | |
region | String | |
role | String | |
share_of_profit | Unknown | |
timezone | String |
sale
| Column | Type | Keys |
|---|---|---|
date | LocalDate | PK |
device | Unknown | PK |
storefront | Unknown | PK |
iso | String | PKFK |
product_id | Unknown | PKFK |
app_downloads | Unknown | |
app_returns | Unknown | |
app_returns_amount | Unknown | |
app_revenue | Unknown | |
business_downloads | Unknown | |
business_revenue | Unknown | |
downloads | Unknown | |
edu_downloads | Unknown | |
edu_revenue | Unknown | |
gift_redemptions | Unknown | |
gifts | Unknown | |
gross_app_returns_amount | Unknown | |
gross_app_revenue | Unknown | |
gross_business_revenue | Unknown | |
gross_edu_revenue | Unknown | |
gross_iap_returns_amount | Unknown | |
gross_iap_revenue | Unknown | |
gross_returns_amount | Unknown | |
gross_revenue | Unknown | |
gross_standard_revenue | Unknown | |
gross_subscription_returns_amount | Unknown | |
gross_subscription_revenue | Unknown | |
iap_amount | Unknown | |
iap_returns | Unknown | |
iap_returns_amount | Unknown | |
iap_revenue | Unknown | |
net_downloads | Unknown | |
promos | Unknown | |
re_downloads | Unknown | |
returns | Unknown | |
returns_amount | Unknown | |
revenue | Unknown | |
standard_downloads | Unknown | |
standard_revenue | Unknown | |
store | Unknown | |
subscription_purchases | Unknown | |
subscription_returns | Unknown | |
subscription_returns_amount | Unknown | |
subscription_revenue | Unknown | |
uninstalls | Unknown | |
updates | Unknown |
external_account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | PKFK |
store_id | Unknown | FK |
auto_import | Boolean | |
nickname | String | |
username | String | |
vendor_id | Unknown |
advertisement_spend
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
iso | String | FK |
product_id | Unknown | FK |
clicks | Unknown | |
cost | Unknown | |
cpa | Unknown | |
cpc | Unknown | |
ctr | Unknown | |
date | LocalDate | |
impressions | Unknown | |
installs | Unknown | |
network | Unknown | |
storefront | Unknown |
sdk_external_link
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
sdk_id | String | FK |
type | String | |
value | String |
sdk_tag
| Column | Type | Keys |
|---|---|---|
tags | String | PK |
sdk_id | String | PKFK |
sdk_platform
| Column | Type | Keys |
|---|---|---|
platform | String | PK |
sdk_id | String | PKFK |
sdk_tracked_platform
| Column | Type | Keys |
|---|---|---|
tracked_platform | String | PK |
sdk_id | String | PKFK |
sdk
| Column | Type | Keys |
|---|---|---|
id | String | PK |
active | Boolean | |
code | Unknown | |
description | String | |
developer_links | Json | |
developer_name | String | |
name | String | |
notes | String | |
release_date | LocalDateTime | |
started_tracking | LocalDateTime |
sub_category
| Column | Type | Keys |
|---|---|---|
sub_category | String | PK |
category_id | Unknown | PKFK |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_id | Unknown | FK |
store_id | String | FK |
active | Boolean | |
device | String | |
hidden | Boolean | |
name | String | |
store_front | String |