OpenKPIs
Leaderboard
Sign in
← Back to KPIs

Revenue

Also known as: Sales Revenue, Income

RevenuesalesincomefinancialRetailE-commerceSaaSFinance

Revenue measures the total income generated from sales of goods or services. It is a key indicator of business success and financial health.

Business Use Case

Finance teams use Revenue to assess overall business performance and make strategic decisions.

Business Criticality

High

Journey / Navigation Area

Business Intelligence

Scope

Global

Formula

SUM(Transaction Amount)

Calculation Notes

Ensure currency conversion is applied if necessary; exclude refunds.

Technical Details

Measure Typecurrency
Aggregation WindowTime based - Daily/Monthly/Yearly

Events

PlatformEvent
Google Analytics 4purchase
AdobescPurchase

Data Mappings

W3 Data Layer
{
  "event": "purchase",
  "transaction": {
    "transactionID": "T123",
    "total": 100,
    "currency": "USD"
  }
}
GA4 Data Layer
{
  "event": "purchase",
  "ecommerce": {
    "transaction_id": "T123",
    "value": 100,
    "currency": "USD"
  }
}
Adobe Client Data Layer
{
  "event": "purchaseCompleted",
  "eventInfo": {
    "eventName": "purchaseCompleted"
  },
  "transaction": {
    "transactionID": "T123",
    "total": 100
  }
}
XDM Mapping
{
  "eventType": "commerce.purchases",
  "commerce": {
    "purchases": {
      "value": 100
    }
  }
}

SQL Queries

Google Analytics 4 (BigQuery)
SELECT SUM(CAST(ep.value.string_value AS FLOAT64)) AS revenue FROM `your_project.your_dataset.events_*`, UNNEST(event_params) AS ep WHERE ep.key = 'transaction_amount' AND event_name = 'purchase' AND _TABLE_SUFFIX BETWEEN '20230101' AND '20231231'
Adobe Experience Platform (AEP Query Service)
SELECT SUM(cast(commerce.purchases.value AS DOUBLE)) AS revenue FROM your_dataset.your_table WHERE eventType = 'commerce.purchases' AND timestamp BETWEEN '2023-01-01T00:00:00Z' AND '2023-12-31T23:59:59Z'

Source Data

ERP, CRM

Dependencies

purchase

Report Attributes

Revenue, Transaction ID, Date

Recommended Reporting Views

Views
Financial OverviewSales Performance

Segment Eligibility

true

Governance

Data Sensitivityconfidential

Governance

Created bydevyendarm
Created on5/26/2026
Last modified bydevyendarm
Last modified on5/30/2026
StatusPUBLISHED

GitHub

View related Pull Requestcatalog/kpis/revenue.yml

Community Discussion