Integrations
PostgreSQL datasets and fields
The dataset Maven lands from PostgreSQL, every field in it, and how the connection syncs.
Maven lands 1 dataset from PostgreSQL in each client workspace. This page lists it with all of its fields. For the metrics, reports and setup steps, see the PostgreSQL integration page.
Connection and sync#
Each PostgreSQL sync takes a fresh copy of the current records, so the workspace always reflects what is in PostgreSQL now.
Datasets#
Web analytics#
Normalized customer-provided analytics rows.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| account name | Text |
| source | Text |
| medium | Text |
| channel | Text |
| campaign name | Text |
| landing page | Text |
| device category | Text |
| country | Text |
| city | Text |
| sessions | Integer |
| total users | Integer |
| new users | Integer |
| active users | Integer |
| engaged sessions | Integer |
| pageviews | Integer |
| event count | Integer |
| key events | Text |
| conversions | Number |
| user engagement duration | Text |
| total revenue | Text |
| purchase revenue | Text |
| transactions | Text |
| ecommerce purchases | Text |