Determine target of virtual currency usage

This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.

FOCUS Versions

v1.2

Context

Identify and rank the top charge categories driving virtual-currency consumption to target optimization efforts.

FOCUS SQL Query

SELECT 
    ProviderName,
    PublisherName,
    ServiceName,
    ChargeDescription,
    SUM(PricingCurrencyEffectiveCost) AS TotalPricingCurrencyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
AND PricingCurrency = ?
GROUP BY
    ProviderName,
    PublisherName,
    ServiceName,
    ChargeDescription
ORDER BY TotalPricingCurrencyEffectiveCost DESC
LIMIT 10