PostgreSQL logo

Data source integration

PostgreSQL reporting & data

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

What you can do with PostgreSQL in Maven

Maven models PostgreSQL into 55 governed metrics from the semantic layer. Track Key Events, Acquisition Active Users, Acquisition Conversions, Acquisition Engaged Sessions and Acquisition Engagement Duration, 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

55 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.

Key Events

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

Acquisition Active Users

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

Acquisition Conversions

Conversions by source/medium/channel/campaign acquisition scope

Acquisition Engaged Sessions

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

Acquisition Engagement Duration

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

Acquisition Events

Events by source/medium/channel/campaign acquisition scope

Acquisition New Users

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

Acquisition Pageviews

Pageviews by source/medium/channel/campaign acquisition scope

Acquisition Sessions

Sessions by source/medium/channel/campaign acquisition scope

Show all 55 metrics

Acquisition Users

Users by source/medium/channel/campaign acquisition scope

Acquisition Unique New Users

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

Acquisition Unique Users

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

Active Users

Active web analytics users

Bounce Rate

Share of sessions that were not engaged (1 - engaged sessions / sessions) from the primary web provider. Aggregate (GA4 Data API / grouped import) definition that serves web_bounce_rate for workspaces whose web analytics source is data_api.

Web Conversions

Web conversion events from GA4 or mapped Piwik Pro lead and form events. Aggregate (GA4 Data API / grouped import) definition that serves web_conversions for workspaces whose web analytics source is data_api.

Engaged Sessions

Engaged web analytics sessions. Aggregate (GA4 Data API / grouped import) definition that serves web_engaged_sessions for workspaces whose web analytics source is data_api.

Engagement Duration

User engagement duration in seconds from the primary web provider. Aggregate (GA4 Data API / grouped import) definition that serves web_engagement_duration for workspaces whose web analytics source is data_api.

Engagement Rate

Engaged sessions divided by sessions from the primary web provider. Aggregate (GA4 Data API / grouped import) definition that serves web_engagement_rate for workspaces whose web analytics source is data_api.

Web Events

Web analytics events from the primary provider unless grouped by platform. Aggregate (GA4 Data API / grouped import) definition that serves web_events for workspaces whose web analytics source is data_api.

New Users

First-time users from the primary web analytics provider. Aggregate (GA4 Data API / grouped import) definition that serves web_new_users for workspaces whose web analytics source is data_api.

Pageviews

Page views from the primary web analytics provider unless grouped by platform. Aggregate (GA4 Data API / grouped import) definition that serves web_pageviews for workspaces whose web analytics source is data_api.

Sessions

Sessions from the primary web analytics provider unless grouped by platform. Aggregate (GA4 Data API / grouped import) definition that serves web_sessions for workspaces whose web analytics source is data_api.

Purchase Revenue

GA4 purchase revenue in reporting_currency from the primary web analytics provider

Purchases

GA4 ecommerce purchase events from the primary web analytics provider

Web Total Revenue

GA4 total revenue in reporting_currency from the primary web analytics provider

Users

Users from the primary web analytics provider unless grouped by platform

Transactions

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

Unique New Users

Re-aggregatable distinct first-time users via HLL sketch

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

Web Shipping Amount

Analytics-observed transaction shipping in reporting_currency, from the primary web provider. GA4 Data API only today; null for raw-event and unsupported sources. This is tracked transaction shipping, not operational order-system shipping. Matomo ecommerceOrder is a follow-up candidate; abandoned carts are excluded.

Web Tax Amount

Analytics-observed transaction tax in reporting_currency, from the primary web provider. GA4 Data API only today; null for raw-event and unsupported sources. This is tracked transaction tax, not operational order-system tax. Matomo ecommerceOrder is a follow-up candidate; abandoned carts are excluded.

Ecommerce Purchases

Funnel Opt-in Rate

Opt-ins divided by unique page views

Funnel Opt-ins

Opt-ins attributed to ClickFunnels pages

Funnel Page Views

All ClickFunnels page views

Funnel Recurring Sales

Recurring sales attributed to ClickFunnels pages

Funnel Recurring Sales Value

Recurring sales value attributed to ClickFunnels pages

Funnel Sales

Sales attributed to ClickFunnels pages

Funnel Sales Conversion Rate

Sales divided by unique page views

Funnel Sales Value

Sales value attributed to ClickFunnels pages

Funnel Unique Page Views

Unique ClickFunnels page views

Purchase Revenue

Total Revenue

Transactions

Page Active Users

Active users by page or landing-page context

Page Conversions

Conversions by page or landing-page context

Page Engaged Sessions

Engaged sessions by page or landing-page context

Page Engagement Duration

Engagement duration by page or landing-page context

Page Events

Events by page or landing-page context

Page New Users

New users by page or landing-page context

Page Sessions

Sessions by page or landing-page context

Page Users

Users by page or landing-page context

Page Unique New Users

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

Page Unique Users

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

Page Views by Page

Page views by page or landing-page context

Connection and sync

What Maven pulls from PostgreSQL

Each PostgreSQL sync takes a fresh copy of the current records, so the workspace always reflects what is in PostgreSQL now.

Web analytics

Normalized customer-provided analytics rows.

Fields: account name, source, medium, channel, campaign name, landing page, device category, country, city, sessions, and 13 more

How it works

Connect PostgreSQL to a client’s workspace

No SQL or warehouse setup. Connect the source, then build the client’s report by asking Claude or ChatGPT.

Step 1

Connect PostgreSQL

In the client’s workspace, open Sources, add PostgreSQL and choose the account to sync. If you don’t have access to the account, send the client a connect link where the platform supports one.

Step 2

Maven syncs and models the data

Maven pulls the client’s PostgreSQL data and models it into documented tables. No SQL, warehouse or pipeline setup.

Step 3

Report, ask and automate

Build the client’s report or deck by asking Claude or ChatGPT through the MCP, set alerts on what matters, and publish to the client’s portal once you approve it.

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 55 governed PostgreSQL metrics, including Key Events, Acquisition Active Users, Acquisition Conversions, Acquisition Engaged Sessions, Acquisition Engagement Duration and Acquisition Events — 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 sits in the same client workspace as sources like Google Analytics 4, Google Ads, Shopify and HubSpot, so one report or question can use them together.

What PostgreSQL metrics are available in Maven?

Maven exposes 55 PostgreSQL metrics, including Key Events, Acquisition Active Users, Acquisition Conversions, Acquisition Engaged Sessions and Acquisition Engagement Duration.

How often does PostgreSQL data sync to Maven?

Maven refreshes PostgreSQL on a schedule after the source is connected, and shows each source’s last sync time in the client’s workspace, so you can check the data is current before a report goes out.

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.

Start your 14-day trial

Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.

  • Free for 14 days, no credit card
  • Your first client workspace and portal
  • Every report template, ready to clone
Start a 14-day trial

Nothing is charged unless you subscribe.

Prefer a walkthrough? Book a demo on one of your own clients.