# Apple Store: Overview Report

## Description

* Each record represents daily metrics for each app\_id

## 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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| INTEGER | impressions            | 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: [BusinessofApps](https://www.businessofapps.com/insights/understanding-the-app-store-metrics/#:~:text=Impressions%20%E2%80%93%20%E2%80%9CThe%20number%20of%20times,was%20clicked%20on%20and%20viewed.))                                                                                                                                                                                    |
| INTEGER | page\_views            | 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: [Apple](https://help.apple.com/app-store-connect/#/itcf19c873df), [BusinessofApps](https://www.businessofapps.com/insights/understanding-the-app-store-metrics/#:~:text=Impressions%20%E2%80%93%20%E2%80%9CThe%20number%20of%20times,was%20clicked%20on%20and%20viewed.)) |
| 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 | 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-overview-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.
