Apple Public Data fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Apple Public Data data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

11 metrics102 dimensions

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEVICE

item_supported_devices
Field label Supported devices
Description List of devices that app supports
Field type dimension
Data type string.text.value
is_iphone_supported
Field label Supports iPhone
Description Does the app support iPhone
Field type dimension
Data type bool
is_ipad_supported
Field label Supports iPad
Description Does the app support iPad
Field type dimension
Data type bool
is_watch_supported
Field label Supports Apple Watch
Description Does the app support Apple Watch
Field type dimension
Data type bool
is_mac_supported
Field label Supports Mac
Description Does the app support Mac computers
Field type dimension
Data type bool

IMAGE

item_artwork_60_url
Field label Item logo 60px URL
Description URL of the 60 pixel logo of the app
Field type dimension
Data type string.text.url
item_artwork_60_image
Field label Item logo 60px
Description The 60 pixel logo of the app
Field type dimension
Data type string.text.formula
Destinations Google Sheets
item_artwork_100_url
Field label Item logo 100px URL
Description URL of the 100 pixel logo of the app
Field type dimension
Data type string.text.url
item_artwork_100_image
Field label Item logo 100px
Description The 100 pixel logo of the app
Field type dimension
Data type string.text.formula
Destinations Google Sheets
item_artwork_512_url
Field label Item logo 512px URL
Description URL of the 512 pixel logo of the app
Field type dimension
Data type string.text.url
item_artwork_512_image
Field label Item logo 512px
Description The 512 pixel logo of the app
Field type dimension
Data type string.text.formula
Destinations Google Sheets
item_screenshot_1_url
Field label Screenshot #1 URL
Description URL of the 1st screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_screenshot_1_image
Field label Screenshot #1
Description 1st screenshot image of the app in the App Store
Field type dimension
Data type string.text.formula
Destinations Google Sheets
item_screenshot_2_url
Field label Screenshot #2 URL
Description URL of the 2nd screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_screenshot_2_image
Field label Screenshot #2
Description 2nd screenshot image of the app in the App Store
Field type dimension
Data type string.text.formula
Destinations Google Sheets
item_screenshot_3_url
Field label Screenshot #3 URL
Description URL of the 3rd screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_screenshot_3_image
Field label Screenshot #3
Description 3rd screenshot image of the app in the App Store
Field type dimension
Data type string.text.formula
Destinations Google Sheets
item_screenshot_4_url
Field label Screenshot #4 URL
Description URL of the 4th screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_screenshot_4_image
Field label Screenshot #4
Description 4th screenshot image of the app in the App Store
Field type dimension
Data type string.text.formula
Destinations Google Sheets

ITEM

item_name
Field label Item name
Description Name of the item
Field type dimension
Data type string.text.value
item_id
Field label Item ID
Description ID of the item
Field type dimension
Data type string.text.value
item_type
Field label Item type
Description Type of the item
Field type dimension
Data type string.text.value
item_creator_name
Field label Creator name
Description Name of the creator of the item
Field type dimension
Data type string.text.value
item_creator_id
Field label Creator ID
Description ID of the creator of the item
Field type dimension
Data type string.text.value
item_creator_type
Field label Creator type
Description Type of the creator of the item
Field type dimension
Data type string.text.value
item_collection
Field label Collection
Description Collection the item belongs to (eg. a music album)
Field type dimension
Data type string.text.value
item_collection_url
Field label Collection URL
Description URL to view the collection
Field type dimension
Data type string.text.url
item_primary_category
Field label Primary category
Description Primary category of the item
Field type dimension
Data type string.text.value
item_categories
Field label Categories
Description All categories or genres the item belongs to
Field type dimension
Data type string.text.value
item_description
Field label Description
Description Description of the item
Field type dimension
Data type string.text.value
item_preview_url
Field label Preview URL
Description Link to a preview of the item, if available
Field type dimension
Data type string.text.url
item_copyright
Field label Copyright
Description Item copyright owner
Field type dimension
Data type string.text.value
item_price
Field label Price
Description Price of the item
Field type dimension
Data type string.text.value
item_collection_price
Field label Collection price
Description Price of the collection that the item belongs to (eg. a music album)
Field type dimension
Data type float.currency.value
item_currency
Field label Currency
Description Currency of the price
Field type dimension
Data type string.currency.code
item_content_advisory_rating
Field label Age rating
Field type dimension
Data type string.text.value
item_advisories
Field label Advisories
Description App advisories
Field type dimension
Data type string.text.value
item_language_codes
Field label Language codes
Description Languages supported by the app
Field type dimension
Data type string.text.value
item_minimum_os_version
Field label Minimum OS version
Description Minimum operating system version required by the app
Field type dimension
Data type string.text.value
item_file_size_mb
Field label File size (mb)
Description App file size in megabytes
Field type dimension
Data type float.number.value
item_is_game_center_enabled
Field label Is Game Center enabled
Field type dimension
Data type bool
item_release_date
Field label Release date
Description Item release date
Field type dimension
Data type string.time.date
item_feed_url
Field label Feed URL
Description URL of the RSS feed of the item, if available
Field type dimension
Data type string.text.url

ITEM VERSION

item_version
Field label Current version
Description Current version of the app
Field type dimension
Data type string.text.value
item_current_version_release_date
Field label Current version release date
Description Release date of the latest version of the app
Field type dimension
Data type string.time.date
item_release_notes
Field label Release notes
Description Release notes of the latest version of the app
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

RANKING

ranking
Field label Ranking
Description The item's ranking within the list
Field type dimension
Data type int.number.value
ranking_date
Field label Ranking date
Description The date of the ranking
Field type dimension
Data type string.time.date
ranking_top_free_apps
Field label Ranking among top free apps
Description The app's ranking within the top free apps. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_paid_apps
Field label Ranking among top paid apps
Description The app's ranking within the top paid apps. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_grossing_apps
Field label Ranking among top grossing apps
Description The app's ranking within the top grossing apps. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_free_ipad_apps
Field label Ranking among top free iPad apps
Description The app's ranking within the top free iPad apps. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_grossing_ipad_apps
Field label Ranking among top grossing iPad apps
Description The app's ranking within the top grossing iPad apps. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_new_apps_we_love
Field label Ranking among New Apps We Love
Description The app's ranking within the New Apps We Love listing. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_new_games_we_love
Field label Ranking among New Games We Love
Description The app's ranking within the New Games We Love listing. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_free_in_own_category
Field label Ranking among top free apps of the category
Description The app's ranking within the top free apps that are in the same category. You can see the category using the "Primary category" field. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_paid_in_own_category
Field label Ranking among top paid apps of the category
Description The app's ranking within the top paid apps that are in the same category. You can see the category using the "Primary category" field. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_grossing_in_own_category
Field label Ranking among top grossing apps of the category
Description The app's ranking within the top grossing apps that are in the same category. You can see the category using the "Primary category" field. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_free_ipad_in_own_category
Field label Ranking among top free iPad apps of the category
Description The app's ranking within the top free iPad apps that are in the same category. You can see the category using the "Primary category" field. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_grossing_ipad_in_own_category
Field label Ranking among top grossing iPad apps of the category
Description The app's ranking within the top grossing iPad apps that are in the same category. You can see the category using the "Primary category" field. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_podcasts
Field label Ranking among top podcasts
Description The podcast's ranking within the iTunes top podcast list. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_movies
Field label Ranking among top movies
Description The movie's ranking within the iTunes top movies list. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_audiobooks
Field label Ranking among top audiobooks
Description The audiobook's ranking within the iTunes top audiobooks list. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_free_books
Field label Ranking among top free books
Description The books's ranking within the iTunes top free books list. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value
ranking_top_paid_books
Field label Ranking among top paid books
Description The books's ranking within the iTunes top paid books list. Note that we can only get the ranking if it's within the top 200
Field type dimension
Data type int.number.value

RATING

item_average_rating
Field label Average user rating
Description Average rating given by users for the item
Field type metric
Data type float.number.value
item_rating_count
Field label User rating count
Description Number of ratings given by users for the item
Field type metric
Data type int.number.value
item_average_rating_current_version
Field label Average user rating (current version)
Description Average rating given by users for the current version of the app
Field type metric
Data type float.number.value
item_rating_count_current_version
Field label User rating count (current version)
Description Number of ratings given by users for the current version the app
Field type metric
Data type int.number.value

REVIEW

review_title
Field label Review title
Description Title of the review
Field type dimension
Data type string.text.value
review_content
Field label Review content
Description Text content of the review
Field type dimension
Data type string.text.value
review_author_name
Field label Review author
Description Username of the author
Field type dimension
Data type string.text.value
review_author_lnik
Field label Review author link
Description Link to the author
Field type dimension
Data type string.text.url
review_rating
Field label Rating
Description Star rating given by the user (1-5)
Field type dimension
Data type int.number.value
review_item_version
Field label Reviewed version
Description Version of the item that the review concerns
Field type dimension
Data type string.text.value
review_rating_count
Field label Ratings
Description Number of ratings given
Field type metric
Data type int.number.value
review_average_rating
Field label Average rating
Description Average of ratings given
Field type metric
Data type float.number.value
review_rating_1_star
Field label 1-star ratings
Description Number of 1-star ratings given
Field type metric
Data type float.number.value
review_rating_2_star
Field label 2-star ratings
Description Number of 2-star ratings given
Field type metric
Data type float.number.value
review_rating_3_star
Field label 3-star ratings
Description Number of 3-star ratings given
Field type metric
Data type float.number.value
review_rating_4_star
Field label 4-star ratings
Description Number of 4-star ratings given
Field type metric
Data type float.number.value
review_rating_5_star
Field label 5-star ratings
Description Number of 5-star ratings given
Field type metric
Data type float.number.value

STORE

store_country
Field label Store country
Field type dimension
Data type string.geo.country
store_country_code
Field label Store country code
Field type dimension
Data type string.geo.country.twolettercode

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Description Year, e.g. 2017
Field type dimension
Data type string.time.year
yearOfWeek
Field label Year of week (Sun-Sat)
Description Year of week for US-style Sunday-Saturday weeks, e.g. 2017
Field type dimension
Data type string.time.year
yearOfWeekIso
Field label Year of week (Mon-Sun)
Description Year of week for ISO standard Monday-Sunday weeks, e.g. 2017
Field type dimension
Data type string.time.year
yearMonth
Field label Year & month
Description Year and month, e.g. 2017|06
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Description Month, e.g. 6
Field type dimension
Data type string.time.month
yearWeek
Field label Year & week (Sun-Sat)
Description Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweek
yearWeekIso
Field label Year & week (Mon-Sun)
Description Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Description US week number, e.g. 51
Field type dimension
Data type string.time.week
weekIso
Field label Week (Mon-Sun)
Description ISO week number, e.g. 51
Field type dimension
Data type string.time.weekiso
dayOfMonth
Field label Day of month
Description Day of month, e.g. 2
Field type dimension
Data type string.time.dayofmonth
dayOfWeekName
Field label Day of week (Sun-Sat)
Description Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday
Field type dimension
Data type string.time.dayofweek
dayOfWeekNameIso
Field label Day of week (Mon-Sun)
Description Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
hour
Field label Hour
Description Hour in a 24-hour clock, e.g. 18
Field type dimension
Data type string.time.hour