Revenue Field Guide and Calculation Logic for the B2C Commerce Intelligence JDBC Driver
Understanding revenue calculations is critical for accurateA Key Performance Indicator (KPI) creation and ensuring consistency across different dashboards and analytics tools. This section provides definitive guidance based on actual CCAC implementation, addressing common customer concerns about revenue discrepancies and metric consistency.
This topic addresses revenue calculation discrepancies between different analytics tools, the need for detailed metric descriptions and business context, and understanding how data models connect to dashboard implementations.
This section provides the essential rules for selecting revenue fields in your analytics queries.
The system automatically handles currency complexity for you:
Any column with the prefix std refers to a monetary value that is converted to a common realm reporting currency.
std_revenue= Always in your site's configured base currency- Multi-currency transactions are automatically converted to
std_revenue - No complex business type decisions needed
| Field Name | Data Type | Definition | When to Use |
|---|---|---|---|
std_revenue | NUMERIC | Gross Merchandise Value (GMV) in the realm's reporting currency (auto-converted) | All KPIs, reporting, and analytics |
All revenue fields represent GROSS merchandise value (which includes certain discounts), not net revenue. This ensures consistent baselines across all analytics, matching Commerce Cloud Reports and Dashboard's approach.
Revenue Calculation:
GMV includes all orders placed on the storefront, converted to common reporting currency, and adjusted for reporting timezone.
GMV isn't adjusted by returns, cancellations, etc.
The std_li_gross_merchandise_value column in ccdw_fact_line_item represents GMV at the line item level in standard reporting currency.
In aggregate tables (like ccdw_aggr_sales_summary or ccdw_aggr_product_sales_summary), the std_revenue column is an aggregate of the std_li_gross_merchandise_value column.
These examples demonstrate common revenue analysis patterns using the standardized revenue fields.
Daily Revenue Trend:
Site Performance Comparison:
Product Performance Analysis:
This section shows how to analyze the impact of promotions on revenue using the standardized revenue calculations.
Example: Analyze promotion impact using revenue data: