> For the complete documentation index, see [llms.txt](https://docs.quanti.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.quanti.io/connect/connectors/appfollow.md).

# AppFollow

Follow our setup guide to connect AppFollow to QUANTI:

{% hint style="info" %}
Sync the app store reviews and daily rating history of your mobile app from AppFollow into your warehouse.
{% endhint %}

***

## Prerequisites

* An AppFollow account with the **Owner** or **Admin** role (only they can create API tokens).
* The external ID of your app: Apple App Store numeric ID or Google Play package name.

***

## Authentication

The connector uses an **API token**. Generate it on the **API Dashboard** (API management page) of your AppFollow account and paste it in the setup screen, together with your app's external ID.

***

## Setup Instructions

{% stepper %}
{% step %}
**Enter your token and app**

Paste your **AppFollow API Token** and enter the **App External ID** (e.g. `284882215` or `com.example.app`). You find it in the app store URL or in AppFollow under the app details.
{% endstep %}

{% step %}
**Choose your reports**

Select the reports to sync.
{% endstep %}
{% endstepper %}

***

## Data Model

```mermaid
erDiagram
    ratings_history {
        DATE date PK
        STRING ext_id PK
        STRING store PK
        STRING country PK
        FLOAT rating
        INTEGER ratings_count
    }
    reviews {
        STRING id PK
        STRING ext_id
        DATE date
        INTEGER rating
    }
```

***

## Available Reports

### Reviews

One row per app store review, with its rating, content and metadata.

#### Dimensions

| Column        | Type      | Description                                            |
| ------------- | --------- | ------------------------------------------------------ |
| `id`          | STRING    | Internal AppFollow review identifier (primary key)     |
| `review_id`   | STRING    | Store-native review identifier                         |
| `ext_id`      | STRING    | External app store identifier                          |
| `app_id`      | INTEGER   | Internal AppFollow app identifier                      |
| `date`        | DATE      | Review publication date in the store                   |
| `title`       | STRING    | Review headline title                                  |
| `content`     | STRING    | Full review text content                               |
| `author`      | STRING    | Reviewer display name                                  |
| `user_id`     | STRING    | Store-provided user identifier                         |
| `store`       | STRING    | App store where the review was posted (as/gp/ms/am/mc) |
| `app_version` | STRING    | App version the reviewer was using                     |
| `locale`      | STRING    | Two-letter country code of the reviewer                |
| `is_answer`   | BOOLEAN   | True if developer has replied to this review           |
| `was_changed` | BOOLEAN   | True if the review has been edited by the user         |
| `created`     | TIMESTAMP | Timestamp when AppFollow collected this review         |
| `updated`     | TIMESTAMP | Timestamp of the last update to this review            |

#### Metrics

| Column        | Type    | Description                                  |
| ------------- | ------- | -------------------------------------------- |
| `rating`      | INTEGER | Star rating given by the reviewer (1-5)      |
| `rating_prev` | INTEGER | Previous rating before the review was edited |

### Ratings History

Daily rating history, one row per day, app, store and country.

#### Dimensions

| Column    | Type   | Description                                                |
| --------- | ------ | ---------------------------------------------------------- |
| `date`    | DATE   | Date of the rating snapshot (primary key)                  |
| `ext_id`  | STRING | External app store identifier (primary key)                |
| `store`   | STRING | App store platform (as/gp/ms/am/mc) (primary key)          |
| `country` | STRING | Two-letter country code for the store market (primary key) |

#### Metrics

| Column          | Type    | Description                               |
| --------------- | ------- | ----------------------------------------- |
| `rating`        | FLOAT   | Average app rating for the day            |
| `ratings_count` | INTEGER | Number of new ratings received on the day |

***

## Scheduling

| Setting             | Default      | Options                                       |
| ------------------- | ------------ | --------------------------------------------- |
| **Frequency**       | Daily        | Daily, Weekly                                 |
| **Sync time**       | 4:00 AM      | —                                             |
| **Lookback window** | 3 days       | 1, 3, 7 days                                  |
| **Historical load** | Up to 1 year | 3 months, 6 months, 12 months or custom dates |

***

## Notes

* One connector syncs one app: the one whose external ID you enter at setup.
* Store codes: `as`, `gp`, `ms`, `am`, `mc`.