# Apple Store: App Version Report

## Description

* Each record represents daily metrics for each by app\_id, source\_type and app version

## Supported Data Sources

* <img src="https://fivetran.com/integrations/itunes_connect/resources/itunes_connect_logo.png" alt="" data-size="line"> 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                    | 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 [docs](https://developer.apple.com/help/app-store-connect/view-app-analytics/view-acquisition-sources/). |
| STRING  | app\_version                    | The app version of the app that the user is engaging with.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 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 | 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.                                                                                                                                                                                                                                                            |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/apple-store-app-version-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.