Endash: Data Templates
  • Data model templates
    • Ad Reporting: Ad Group Report
    • Ad Reporting: Account Report
    • Ad Reporting: Ad Report
    • Ad Reporting: Campaign Report
    • Ad Reporting: Keyword Report
    • Ad Reporting: Search Report
    • Ad Reporting: Url Report
    • Amazon Ads: Account Report
    • Amazon Ads: Ad Group Report
    • Amazon Ads: Ad Report
    • Amazon Ads: Campaign Report
    • Amazon Ads: Keyword Report
    • Amazon Ads: Portfolio Report
    • Amazon Ads: Search Report
    • Amplitude: Daily Performance
    • Amplitude: Event Enhanced
    • Amplitude: Sessions
    • Amplitude: User Enhanced
    • Apple Search Ads: Ad Group Report
    • Apple Search Ads: Ad Report
    • Apple Search Ads: Campaign Report
    • Apple Search Ads: Keyword Report
    • Apple Search Ads: Organization Report
    • Apple Search Ads: Search Term Report
    • Apple Store: App Version Report
    • Apple Store: Device Report
    • Apple Store: Overview Report
    • Apple Store: Platform Version Report
    • Apple Store: Source Type Report
    • Apple Store: Territory Report
    • Asana: Daily Metrics
    • Asana: Project
    • Asana: Tag
    • Asana: Task
    • Asana: Team
    • Asana: User
    • Facebook Ads: Account Report
    • Facebook Ads: Ad Report
    • Facebook Ads: Campaign Report
    • Facebook Ads: Ad Set Report
    • Facebook Ads: Url Report
    • Facebook Ads: Url Tags
    • Facebook Pages: Pages Report
    • Facebook Pages: Posts Report
    • Github: Daily Metrics
    • Github: Issues
    • Github: Monthly Metrics
    • Github: Pull Requests
    • Github: Quarterly Metrics
    • Github: Weekly Metrics
    • Google Ads: Account Report
    • Google Ads: Ad Group Report
    • Google Ads: Ad Report
    • Google Ads: Campaign Report
    • Google Ads: Keyword Report
    • Google Ads: Url Report
    • Google Play: App Version Report
    • Google Play: Country Report
    • Google Play: Device Report
    • Google Play: Os Version Report
    • Google Play: Overview Report
    • Greenhouse: Application Enhanced
    • Greenhouse: Application History
    • Greenhouse: Interview Enhanced
    • Greenhouse: Interview Scorecard Detail
    • Greenhouse: Job Enhanced
    • Hubspot: Companies
    • Hubspot: Company History
    • Hubspot: Contact History
    • Hubspot: Contact Lists
    • Hubspot: Contacts
    • Hubspot: Deal History
    • Hubspot: Deal Stages
    • Hubspot: Deals
    • Hubspot: Email Campaigns
    • Hubspot: Email Event Bounce
    • Hubspot: Email Event Clicks
    • Hubspot: Email Event Deferred
    • Hubspot: Email Event Delivered
    • Hubspot: Email Event Forward
    • Hubspot: Email Event Dropped
    • Hubspot: Email Event Opens
    • Hubspot: Email Event Print
    • Hubspot: Email Event Sent
    • Hubspot: Email Event Spam Report
    • Hubspot: Email Event Status Change
    • Hubspot: Email Sends
    • Hubspot: Engagement Calls
    • Hubspot: Engagement Emails
    • Hubspot: Engagement Meetings
    • Hubspot: Engagement Tasks
    • Hubspot: Engagement Notes
    • Hubspot: Engagements
    • Instagram Business: Posts
    • Intercom: Admin Metrics
    • Intercom: Company Enhanced
    • Intercom: Company Metrics
    • Intercom: Contact Enhanced
    • Intercom: Conversation Enhanced
    • Intercom: Conversation Metrics
    • Iterable: Campaigns
    • Iterable: List User History
    • Iterable: Events
    • Iterable: User Campaign
    • Iterable: User Unsubscriptions
    • Iterable: Users
    • Jira: Daily Issue Field History
    • Jira: Issue Enhanced
    • Jira: Project Enhanced
    • Jira: User Enhanced
    • Klaviyo: Campaigns
    • Klaviyo: Events
    • Klaviyo: Flows
    • Klaviyo: Person Campaign Flow
    • Klaviyo: Persons
    • Lever: Interview Enhanced
    • Lever: Opportunity Enhanced
    • Lever: Opportunity Stage History
    • Lever: Posting Enhanced
    • Lever: Requisition Enhanced
    • Linkedin Ads: Account Report
    • Linkedin Ads: Campaign Group Report
    • Linkedin Ads: Campaign Report
    • Linkedin Ads: Creative Report
    • Linkedin Ads: Url Report
    • Linkedin Pages: Posts
    • Mailchimp: Automation Activities
    • Mailchimp: Automation Emails
    • Mailchimp: Automations
    • Mailchimp: Campaign Activities
    • Mailchimp: Campaign Recipients
    • Mailchimp: Campaigns
    • Mailchimp: Lists
    • Mailchimp: Members
    • Mailchimp: Segments
    • Marketo: Calendar Spine
    • Marketo: Campaigns
    • Marketo: Change Data Details
    • Marketo: Change Data Pivot
    • Marketo: Email Sends
    • Marketo: Change Data Scd
    • Marketo: Email Templates
    • Marketo: Lead Calendar Spine
    • Marketo: Lead History
    • Marketo: Leads
    • Marketo: Programs
    • Microsoft Ads: Account Report
    • Microsoft Ads: Ad Group Report
    • Microsoft Ads: Ad Report
    • Microsoft Ads: Campaign Report
    • Microsoft Ads: Keyword Report
    • Microsoft Ads: Search Report
    • Microsoft Ads: Url Report
    • Pardot: Campaigns
    • Pardot: Lists
    • Pardot: Opportunities
    • Pardot: Prospects
    • Pendo: Account Daily Metrics
    • Pendo: Account
    • Pendo: Feature Daily Metrics
    • Pendo: Feature Event
    • Pendo: Feature
    • Pendo: Guide Daily Metrics
    • Pendo: Guide Event
    • Pendo: Guide
    • Pendo: Page Daily Metrics
    • Pendo: Page Event
    • Pendo: Page
    • Pendo: Visitor Daily Metrics
    • Pendo: Visitor Feature
    • Pendo: Visitor
    • Pinterest Ads: Ad Group Report
    • Pinterest Ads: Advertiser Report
    • Pinterest Ads: Campaign Report
    • Pinterest Ads: Keyword Report
    • Pinterest Ads: Pin Promotion Report
    • Pinterest Ads: Url Report
    • Qualtrics: Contact
    • Qualtrics: Daily Breakdown
    • Qualtrics: Directory
    • Qualtrics: Distribution
    • Qualtrics: Response
    • Qualtrics: Survey
    • Quickbooks: Ap Ar Enhanced
    • Quickbooks: Cash Flow Statement
    • Quickbooks: Expenses Sales Enhanced
    • Quickbooks: General Ledger By Period
    • Quickbooks: General Ledger
    • Quickbooks: Profit And Loss
    • Recharge: Billing History
    • Recharge: Charge Line Item History
    • Recharge: Customer Daily Rollup
    • Recharge: Customer Details
    • Recharge: Monthly Recurring Revenue
    • Recharge: Subscription Overview
    • Recurly: Account Daily Overview
    • Recurly: Account Overview
    • Recurly: Balance Transactions
    • Recurly: Churn Analysis
    • Recurly: Monthly Recurring Revenue
    • Recurly: Subscription Overview
    • Reddit Ads: Account Report
    • Reddit Ads: Ad Group Report
    • Reddit Ads: Ad Report
    • Reddit Ads: Campaign Report
    • Reddit Ads: Url Report
    • Sage Intacct: Ap Ar Enhanced
    • Sage Intacct: Balance Sheet
    • Sage Intacct: General Ledger
    • Sage Intacct: General Ledger By Period
    • Sage Intacct: Profit And Loss
    • Salesforce: Account Daily History
    • Salesforce: Contact Daily History
    • Salesforce: Contact Enhanced
    • Salesforce: Daily Activity
    • Salesforce: Manager Performance
    • Salesforce: Opportunity Daily History
    • Salesforce: Opportunity Enhanced
    • Salesforce: Opportunity Line Item Enhanced
    • Salesforce: Owner Performance
    • Salesforce: Sales Snapshot
    • Shopify: Customer Cohorts
    • Shopify: Customer Email Cohorts
    • Shopify: Customer Emails
    • Shopify: Customers
    • Shopify: Daily Shop
    • Shopify: Discounts
    • Shopify: Inventory Levels
    • Shopify: Order Lines
    • Shopify: Orders
    • Shopify: Products
    • Shopify: Transactions
    • Snapchat Ads: Account Report
    • Snapchat Ads: Ad Report
    • Snapchat Ads: Ad Squad Report
    • Snapchat Ads: Campaign Report
    • Snapchat Ads: Url Report
    • Social Media Reporting: Rollup Report
    • Stripe: Activity Itemized 2
    • Stripe: Balance Change From Activity Itemized 3
    • Stripe: Balance Transactions
    • Stripe: Customer Overview
    • Stripe: Daily Overview
    • Stripe: Ending Balance Reconciliation Itemized 4
    • Stripe: Invoice Details
    • Stripe: Invoice Line Item Details
    • Stripe: Payout Itemized 3
    • Stripe: Subscription Details
    • Tiktok Ads: Ad Group Report
    • Tiktok Ads: Ad Report
    • Tiktok Ads: Advertiser Report
    • Tiktok Ads: Campaign Report
    • Tiktok Ads: Url Report
    • Twilio: Account Overview
    • Twilio: Message Enhanced
    • Twilio: Number Overview
    • Twitter Ads: Account Report
    • Twitter Ads: Campaign Report
    • Twitter Ads: Keyword Report
    • Twitter Ads: Line Item Report
    • Twitter Ads: Promoted Tweet Report
    • Twitter Ads: Url Report
    • Twitter Organic: Tweets
    • Xero: Balance Sheet Report
    • Xero: General Ledger
    • Xero: Invoice Line Items
    • Xero: Profit And Loss Report
    • Youtube: Age Demographics Pivot
    • Youtube: Demographics Report
    • Youtube: Gender Demographics Pivot
    • Youtube: Video Metadata
    • Youtube: Video Report
    • Zendesk: Sla Policies
    • Zendesk: Ticket Backlog
    • Zendesk: Ticket Enriched
    • Zendesk: Ticket Field History
    • Zendesk: Ticket Metrics
    • Zendesk: Ticket Summary
    • Zuora: Account Daily Overview
    • Zuora: Account Overview
    • Zuora: Billing History
    • Zuora: Line Item History
    • Zuora: Monthly Recurring Revenue
    • Zuora: Subscription Overview
  • 🏡Other guides
    • Endash: Main guide
    • Endash: Export to Google Sheets
    • Endash: Connectors guide
Powered by GitBook
On this page
  • Description
  • Supported Data Sources
  • Columns

Was this helpful?

  1. Data model templates

Apple Store: Device Report

Last updated 1 year ago

Was this helpful?

Description

  • Each record represents daily subscription metrics by app_id, source_type and device

Supported Data Sources

  • Apple App Store

Columns

Type
Name
Description

DATE

date_day

The date of the report and respective recorded metric(s); follows the format YYYY-MM-DD.

INTEGER

app_id

Application ID.

STRING

app_name

Application Name.

STRING

source_type

STRING

device

Device type associated with the respective metric(s).

INTEGER

impressions

INTEGER

impressions_unique_device

The number of unique devices that have viewed your app for more than one second on on the Today, Games, Apps, Featured, Explore, Top Charts, Search tabs of the App Store and App Product Page views. This metric is presumed to be de-duplicated daily as received from the source data, therefore, aggregating over a span of days is better done in the UI.

INTEGER

page_views

INTEGER

page_views_unique_device

The number of unique devices that have viewed your App Store product page; this metric is presumed to be de-duplicated daily as received from the source data, therefore, aggregating over a span of days is better done in the UI.

INTEGER

crashes

The number of recorded crashes experienced (User Opt-In only); a value of 0 indicates there were 0 crash reports or no value from the source report that day.

INTEGER

first_time_downloads

The number of first time downloads for your app; credit is attributed to the referring app, website, or App Clip of the first time download.

INTEGER

redownloads

The count of redownloads where a redownload occurs when a user who previously downloaded your app adds it to their device again (User Opt-In only); credit is attributed to the source recorded when a user tapped to download/launch your app for the first time. A value of 0 indicates there were 0 redownloads or no value from the source report that day.

INTEGER

total_downloads

Total Downloads is the sum of Redownloads and First Time Downloads.

INTEGER

active_devices

The count of active_device is the count of devices that ran the app at least one time and for at least two seconds on a given day (User Opt-In only); this metric is presumed to be de-duplicated daily as received from the source data, therefore, aggregating over a span of days is better done in the UI. A value of 0 indicates there were 0 active devices or no value from the source report that day.

INTEGER

active_devices_last_30_days

The count of active_devices_last_30_days is the count of devices that ran the app at least one time and for at least two seconds on the date_day of the report minus 30 days (User Opt-In only); this metric is presumed to be de-duplicated daily as received from the source data, therefore, aggregating over a span of days is better done in the UI. A value of 0 indicates there were 0 active devices last 30 days or no value from the source report that day.

INTEGER

deletions

A deletion occurs when a user removes your app from their device (User Opt-In only). Data from resetting or erasing a device’s content and settings is not included. A value of 0 indicates there were 0 deletions or no value from the source report that day.

INTEGER

installations

An installation event is when the user opens the App after they've downloaded it (User Opt-In only). If the App was downloaded but not opened or opened offline, this will not count; if the user opts out of sending data back to Apple, there will also be no data here. A value of 0 indicates there were 0 installations or no value from the source report that day.

INTEGER

sessions

Sessions is the count of the number of times the app has been used for at least two seconds (User Opt-In only). If the app is in the background and is later used again, that counts as another session. A value of 0 indicates there were 0 sessions or no value from the source report that day.

A source is counted when a customer follows a link to your App Store product page. There are 8 types of sources: App Store Browse, App Store Search, App Referrers, Web Referrers, App Clips, Unavailable, Institutional Purchases, and Null. Null is the default value for data that does not provide source types, including: crashes, subscription events and subscription summary.More information can be found in the Apple App Store developer .

The number of times your app was viewed in the App Store for more than one second. This includes search results, Featured, Explore, Top Charts and App Product Page views. (Source: )

The total number of times your App Store product page was clicked and viewed; when a user taps on a link from an app, website or App Clip card that brings them to your App Store product page, the immediate product page_view is attributed to the referring app, website, or App Clip. (Sources: , )

docs
BusinessofApps
Apple
BusinessofApps