# Google Play: Country Report

## Description

* Daily report on installs, ratings, and store performance by app and user country. Records with `NULL` countries (ie did not consent to being tracked) are aggregated together into daily batches.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/google_play/resources/google_play.svg" alt="" data-size="line"> Google Play

## Columns

| Type    | Name                             | Description                                                                                                                                                                                         |
| ------- | -------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| DATE    | date\_day                        | The date on which the data is reported.                                                                                                                                                             |
| STRING  | country\_short                   | Two-letter abbreviation of the country where the user’s Google account is registered.                                                                                                               |
| STRING  | country\_long                    | Full name of the country.                                                                                                                                                                           |
| STRING  | region                           | Geographical region of the country.                                                                                                                                                                 |
| STRING  | sub\_region                      | Geographical subregion of the country.                                                                                                                                                              |
| STRING  | package\_name                    | The package name of the app owning the report data.                                                                                                                                                 |
| INTEGER | device\_installs                 | Devices on which users installed your app on this day. An individual user can have multiple device installs.                                                                                        |
| INTEGER | device\_uninstalls               | The number of devices from which users uninstalled your app on a given day.                                                                                                                         |
| INTEGER | device\_upgrades                 | The number of devices from which users upgraded your app on a given day.                                                                                                                            |
| INTEGER | user\_installs                   | The number of users who installed your app and did not have it installed on any other devices at the time on a given day.                                                                           |
| INTEGER | user\_uninstalls                 | The number of users who uninstalled your app from all of their devices on this day.                                                                                                                 |
| INTEGER | install\_events                  | The number of times your app was installed, including devices on which the app had been installed previously. This does not include pre-installs or device reactivations.                           |
| INTEGER | uninstall\_events                | The number of times your app was uninstalled. This does not include inactive devices.                                                                                                               |
| INTEGER | update\_events                   | The number of times your app was updated.                                                                                                                                                           |
| INTEGER | store\_listing\_acquisitions     | The number of users that visited your store listing and installed your app, who did not have your app installed on any device.                                                                      |
| INTEGER | store\_listing\_visitors         | The number of users that visited your store listing who did not have your app installed on any device.                                                                                              |
| DECIMAL | store\_listing\_conversion\_rate | The percentage of store listing visitors who installed your app on a given day.Note: Does not include visits or installs from users who already have your app installed on another device           |
| INTEGER | active\_devices\_last\_30\_days  | The number of active devices on which your app is installed. An active device is one that has been turned on at least once in the past 30 days.                                                     |
| DECIMAL | average\_rating                  | Average star rating this app has received across all ratings submitted on a given day.                                                                                                              |
| DECIMAL | rolling\_total\_average\_rating  | Average star rating this app received across all ratings submitted up to and including the past day. For each user submitting a rating, only their most recent rating of the app is counted.        |
| INTEGER | total\_device\_installs          | Cumulative number of device installs up to and including this day (aggregated on the dimension of this table). This does not take uninstalls into account and may contain duplicate devices.        |
| INTEGER | total\_device\_uninstalls        | Cumulative number of device uninstalls up to and including this day (aggregated on the dimension of this table). This does not take re-installs into account and may contain duplicate devices.     |
| INTEGER | total\_store\_acquisitions       | Cumulative number of users that visited your store listing and installed your app, who did not have your app installed on any device prior to this.                                                 |
| INTEGER | total\_store\_visitors           | Cumulative number of users that visited your store listing who did not have your app installed on any device at the time.                                                                           |
| INTEGER | rolling\_store\_conversion\_rate | Rolling percentage of store listing visitors who installed your app within a given country. The ratio of `total_store_acquisitions` to `total_store_visitors`.                                      |
| INTEGER | net\_device\_installs            | Cumulative net number of device installs up to and including this day (aggregated on the dimension of this table). This is the difference of `total_device_installs` and `total_device_uninstalls`. |


---

# 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/google-play-country-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.