Platform: Enolytics DTC

Summary:

## Σ Net Sales Rank

What it calculates: This measure ranks contacts by their total net sales from completed, paid orders, giving you a clear hierarchy of your most valuable customers by revenue contribution. It sums the quantity multiplied by sold price for each contact, filtering to only include orders with Order Status = 'Completed' and Payment Status IN ('Paid', 'Refunded', 'External').

Variants:
• Net Sales Rank All Time: Lifetime revenue ranking across all customers
• Net Sales Rank CP: Revenue ranking for the current period only
• Net Sales Rank PP: Revenue ranking for the previous period only

How to use it:
• Identify your top revenue-generating customers to prioritize for VIP experiences, exclusive releases, or personalized outreach
• Compare current period rankings to previous period to spot customers who are climbing or dropping in value
• Segment your customer base for targeted marketing campaigns based on revenue contribution tiers

Related measures: AOV (Incl $0), Bundles (Incl $0), Gross Sales (Incl $0), Net Sales, Net Sales %, Submitted Sales, Total Before Tax

Tip: This is a Build Beyond Limits enhanced measure, available only in the custom report builder. Use it alongside RFM scoring to create comprehensive customer value profiles that go beyond just monetary ranking.

Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.

Enhanced Measure

This measure is available exclusively in Build Beyond Limits — the advanced custom report builder. It is not available in standard dashboard modules.

Each measure in this group takes the Net Sales All Time base measure and computes the SUM per Contact.

Quick Stats:

Type: Sum/Total
Availability: Build Beyond Limits only
Build Beyond Limits Group: Σ Net Sales Rank

Net Sales Rank All Time

This measure disregards the date picker entirely, relying only on applied filters, including time-based filters.

🔢 Formula

m₁
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')

Output Format: $#,###.00

Net Sales Rank CP

🔢 Formula

m₁
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'

Output Format: $#,###.00

Net Sales Rank PP

🔢 Formula

m₁
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Order Items].[Order Completed Date] ≥ 'Start of Previous Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Previous Period'

Output Format: $#,###.00