PostgreSQL logo

Data source integration

PostgreSQL reporting & data

Turn read-only analytics tables from PostgreSQL into 41 governed metrics for dashboards, agent answers, and cross-channel reporting.

What you can do with PostgreSQL in Maven

Maven models PostgreSQL into 41 governed metrics from the semantic layer. Track Sessions, Users, New Users, Active Users and Engaged Sessions, break results down by Account, Source, Medium and Channel, and report PostgreSQL alongside Google Analytics 4, Google Ads and Shopify without rebuilding exports or metric logic for every report.

What you can measure

41 PostgreSQL metrics you can use consistently

Maven keeps PostgreSQL numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.

Sessions

Sessions from the primary web analytics provider unless grouped by platform

Users

Users from the primary web analytics provider unless grouped by platform

New Users

First-time users from the primary web analytics provider

Active Users

Active web analytics users

Engaged Sessions

Engaged web analytics sessions

Pageviews

Page views from the primary web analytics provider unless grouped by platform

Web Events

Web analytics events from the primary provider unless grouped by platform

Web Conversions

Web conversion events from GA4 or mapped Piwik Pro lead and form events

Purchases

GA4 ecommerce purchase events from the primary web analytics provider

Show all 41 metrics

Purchase Revenue

GA4 purchase revenue from the primary web analytics provider

Web Total Revenue

GA4 total revenue from the primary web analytics provider

Transactions

GA4 transaction events with purchase revenue from the primary web analytics provider

Engagement Duration

User engagement duration in seconds from the primary web provider

Unique Users

Re-aggregatable distinct users via HLL sketch (Piwik and GA4-export workspaces) that stays correct across dates and dimensions unlike the non-additive web_total_users

Unique New Users

Re-aggregatable distinct first-time users via HLL sketch

Key Events

GA4 key events; for Piwik Pro this mirrors mapped lead/form-submit conversion events.

Web Event Count

Event-grain web analytics event count from GA4 or Piwik Pro

Web Event Conversions

Event-grain web key/conversion event count inferred from event names

Web Event Value

Event-grain web event value where the provider reports one

Page Sessions

Sessions by page or landing-page context

Page Users

Users by page or landing-page context

Page New Users

New users by page or landing-page context

Page Active Users

Active users by page or landing-page context

Page Engaged Sessions

Engaged sessions by page or landing-page context

Page Views by Page

Page views by page or landing-page context

Page Events

Events by page or landing-page context

Page Conversions

Conversions by page or landing-page context

Page Engagement Duration

Engagement duration by page or landing-page context

Page Unique Users

Re-aggregatable distinct users by page or landing-page context via HLL sketch

Page Unique New Users

Re-aggregatable distinct first-time users by page or landing-page context via HLL sketch

Acquisition Sessions

Sessions by source/medium/channel/campaign acquisition scope

Acquisition Users

Users by source/medium/channel/campaign acquisition scope

Acquisition New Users

New users by source/medium/channel/campaign acquisition scope

Acquisition Active Users

Active users by source/medium/channel/campaign acquisition scope

Acquisition Engaged Sessions

Engaged sessions by source/medium/channel/campaign acquisition scope

Acquisition Pageviews

Pageviews by source/medium/channel/campaign acquisition scope

Acquisition Events

Events by source/medium/channel/campaign acquisition scope

Acquisition Conversions

Conversions by source/medium/channel/campaign acquisition scope

Acquisition Engagement Duration

Engagement duration by source/medium/channel/campaign acquisition scope

Acquisition Unique Users

Re-aggregatable distinct users by source/medium/channel/campaign acquisition scope via HLL sketch

Acquisition Unique New Users

Re-aggregatable distinct first-time users by acquisition scope via HLL sketch

Questions you can ask

Just ask Maven about PostgreSQL

Maven’s agent answers in plain language with the right metric definitions applied automatically. These are real, verified questions it can run today.

How many sessions did each channel drive in the last 30 days?

Show web events by channel

Show web engagement duration by landing page

How it works

Connect PostgreSQL, then map the first workflow

No SQL, no warehouse setup, no data engineer. Connect the source, then Maven models the fields needed for the first trusted workflow.

Step 1

Connect PostgreSQL

Authorize or configure Maven from the Data Sources screen, then pick the account and workspace to sync.

Step 2

Maven syncs and models the data

Maven pulls your PostgreSQL data and models it into governed, conformed tables — no SQL, warehouse, or pipeline setup required.

Step 3

Report, ask, and automate

Ask questions in natural language with the Maven agent, drop the metrics into dashboards, set alerts on what matters, and schedule deliveries to your team.

Works well with

Report PostgreSQL alongside the rest of your stack

FAQ

PostgreSQL reporting questions

What PostgreSQL metrics can I report on in Maven?

Maven exposes 41 governed PostgreSQL metrics, including Sessions, Users, New Users, Active Users, Engaged Sessions and Pageviews — each defined once so it means the same thing in every report.

What can I break PostgreSQL performance down by?

You can break PostgreSQL metrics down by Account, Source, Medium, Channel, Campaign, Landing page, Device and Country, and more.

Can I combine PostgreSQL with other data sources?

Yes. PostgreSQL reports alongside sources like Google Analytics 4, Google Ads, Shopify and HubSpot. Maven models every source into one governed layer, so you can blend them in a single dashboard, report, or question.

What PostgreSQL metrics are available in Maven?

Maven exposes 41 governed PostgreSQL metrics from its semantic layer, including Sessions, Users, New Users, Active Users and Engaged Sessions.

How often does PostgreSQL data sync to Maven?

Maven keeps PostgreSQL data on scheduled refreshes after the source is connected, with sync status visible in the workspace before reports are shared.

Is my PostgreSQL data secure with Maven?

Yes. Maven encrypts integration credentials and tokens, scopes access to the workspace, and uses the connection only to sync the reporting data needed for governed analytics.

Ready to see the first report your team can trust?

Bring one report where the numbers do not match. We'll map the sources, identify what can be trusted now, and show the first Maven workflow.

We'll map your first trusted reporting workflow

You'll see what Maven handles now: sources, definitions, refreshes, and outputs

No pitch deck. No pressure. 20 minutes.

Map Your First Workflow