> AI agents: this is one page from PostHog's docs. Full index of Markdown docs for LLMs: https://posthog.com/llms.txt

# Linking Adapty as a source

**Alpha release**

This source is currently in **alpha**. The interface and available tables may change.

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_9608fcca70)

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_dark_a92b0e022d)

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

`npx @posthog/wizard warehouse`

![PostHog Wizard hedgehog](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)

![](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)Let AI connect your sources for you

> **Alpha:** This connector is in alpha. Features and table schemas may change.

The Adapty connector syncs your mobile subscription analytics and paywalls into the PostHog data warehouse, so you can analyze in-app purchase revenue, subscriptions, retention, and funnels alongside your product data.

## Prerequisites

You need an Adapty account with a secret API key for the app you want to sync. A secret key (starting with `secret_live_` or `secret_test_`) is required – public SDK keys don't work.

## Adding a data source

1.  In PostHog, go to the [Sources tab](https://app.posthog.com/data-management/sources) of the data pipeline section.
2.  Click **\+ New source** and click **Link** next to this source.
3.  Enter your credentials (see [Configuration](#configuration) below) and click **Next**.
4.  Select the tables you want to sync, choose a sync method and frequency, then click **Import**.

Once the syncs are complete, you can start querying this data in PostHog.

When linking Adapty, you'll need:

-   **Secret API key** – in your Adapty dashboard, go to **App settings** > **API keys** and copy your secret API key. It starts with `secret_live_` (production) or `secret_test_` (sandbox).
-   **Report start date** – the earliest date to pull reports from, in `YYYY-MM-DD` format. All reports refresh from this date on each sync. Earlier dates require more API requests.

## Sync modes

All Adapty tables use **full refresh**. Historical aggregates can change after renewals and refunds, so PostHog re-downloads all data on each sync.

Reports use UTC dates and exclude the current day.

## Configuration

| Option | Description |
| --- | --- |
| `Secret API key` **Type:** password **Required:** True | Get the app's secret key from Adapty Dashboard > App settings > API keys. |
| `Report start date` **Type:** text **Required:** True | All reports refresh from this date. Earlier dates need more API requests. |

## Supported tables

| Table | Description | Sync method | Incremental field | Primary key |
| --- | --- | --- | --- | --- |
| `Analytics` | Daily analytics for revenue, subscriptions, trials, refunds, and installs, with one row per chart and metric. | Full refresh | — | — |
| `Cohorts` | Daily revenue cohort reports with renewal values preserved in nested data. | Full refresh | — | — |
| `Conversions` | Daily conversion reports from the first paid period to more than six months. | Full refresh | — | — |
| `Funnels` | Daily funnel reports with absolute and relative values for each step. | Full refresh | — | — |
| `LTV` | Daily lifetime value reports for revenue, proceeds, and net revenue, with nested renewal values. | Full refresh | — | — |
| `Retention` | Daily subscription retention reports without the trial step. | Full refresh | — | — |
| `Paywalls` | Paywalls for the connected app, including products, state, and deletion status. | Full refresh | — | — |

## Synced tables

The Adapty connector syncs the following tables:

| Table | Description |
| --- | --- |
| Analytics | Daily analytics across 19 charts including revenue, MRR, ARR, ARPPU, active/new/cancelled/expired subscriptions and trials, grace period, billing issues, refunds, non-subscriptions, ARPU, and installs. One row per chart and metric. |
| Cohorts | Daily revenue cohort reports with renewal values preserved in nested data. |
| Conversions | Daily conversion reports from the first paid period through 6+ months. |
| Funnels | Daily funnel reports with absolute and relative values for each step. |
| LTV | Daily lifetime value reports for revenue, proceeds, and net revenue with nested renewal values. |
| Retention | Daily subscription retention reports without the trial step. |
| Paywalls | Paywalls configured in your app, including products, state, and deletion status. |

## Troubleshooting

-   If you see an authentication error, your API key is invalid or has been revoked. Create a new secret API key in your Adapty dashboard under **App settings** > **API keys**, then reconnect.
-   If you see a permissions error, ensure you're using a secret API key (not a public SDK key) with the correct app permissions.
-   If the start date is rejected, check that it's in `YYYY-MM-DD` format and is before today.

If your sync is failing or data looks wrong, see the [Data warehouse troubleshooting guide](/docs/data-warehouse/troubleshooting.md). If that doesn't help, [contact support](https://us.posthog.com/#panel=support%3Asupport%3Adata_warehouse%3A%3Atrue) – we're happy to help.

### Still have questions?

Ask PostHog AI

### Was this page useful?

HelpfulCould be better