Analyze purchase of virtual currency

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

FOCUS Versions

v1.2

Context

Analyze virtual-currency purchase patterns (e.g., upfront) and actively monitor burn down to prevent overage charges.

FOCUS SQL Query

SELECT
    ProviderName,
    PublisherName,
    ChargeDescription,
    PricingUnit,
    BillingCurrency,
    SUM(PricingQuantity) AS TotalPricingQuantity,
    SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
    AND ChargeCategory = 'Purchase'
     AND PricingUnit = ?
GROUP BY
    ProviderName,
    PublisherName,
    ChargeDescription,
    PricingUnit,
    BillingCurrency