Singular

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.

Learn more

Connect Singular to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Enter your Singular API key to sync campaign reports into the PostHog Data warehouse. You can find the key in Singular under Developer Tools > API Keys.

The daily_report table has one row per day for each combination of the dimensions you choose. Leave the dimensions and metrics empty to sync network campaign data: cost, impressions, clicks, and installs by app, source, OS, country, and campaign.

Every row counts toward your Singular daily row limit (3 million rows by default), so each dimension you add uses more of it.

Configuration

Option	Description
`API key` Type: password Required: True
`Dimensions` Type: text Required: False	Comma-separated dimension names from the Singular Reporting API. For a custom dimension, use its ID. If you change the dimensions later, run a full resync of the `daily_report` table.
`Metrics` Type: text Required: False	Comma-separated metric names from the Singular Reporting API. For a conversion event, use its name from the `conversion_metrics` table, not its display name.
`Cohort metrics` Type: text Required: False	Comma-separated cohort metric names from the `cohort_metrics` table, such as `revenue`. Cohort metrics need at least one cohort period.
`Cohort periods` Type: text Required: False

Linking Singular to PostHog

Go to the Data pipeline page in PostHog
Click New source and select Singular
Fill in the required configuration fields
Click Next, select the tables you want to sync, and then press Import

Supported tables

Table	Description	Sync method	Incremental field	Primary key
`daily_report`	Daily campaign statistics, one row per day and combination of the dimensions you chose.	Incremental, Full refresh	date	—
`custom_dimensions`	The custom dimensions defined in your Singular account.	Full refresh	—	—
`cohort_metrics`	The cohort metrics and events you can add to a report.	Full refresh	—	—
`conversion_metrics`	The conversion events you can add to a report as metrics.	Full refresh	—	—