Analyze purchase of virtual currency

FOCUS Versions

v1.3 v1.4

Context

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

FOCUS SQL Query

v1-3

SELECT
    ServiceProviderName,
    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
    ServiceProviderName,
    PublisherName,
    ChargeDescription,
    PricingUnit,
    BillingCurrency

v1-4

SELECT
    ServiceProviderName,
    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
    ServiceProviderName,
    ChargeDescription,
    PricingUnit,
    BillingCurrency

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail

FOCUS Columns

Service Provider Name Host Provider Name Charge Description Pricing Unit Billing Currency Pricing Quantity Billed Cost Charge Period Start Charge Period End Charge Category Billed Cost

Previous Analyze effective cost by pricing currency Next Analyze tag coverage