Salesforce Docs Portal

Import Payment and Usage Data to Analytics for Communications - Consumer App

Add payment and usage data from an external source to the Analytics for Communications - Consumer App.

Required Editions

Available in: Developer edition and for an extra cost in Enterprise, Performance, and Unlimited Editions
  1. Create a CSV file with columns that lists these field names in the exact order shown in this table. Column names are case-sensitive.
    Name Description
    SubscriptionID The identifier of the subscription.
    ActivityDate The activity date.
    DataUsageInGB The total data usage on the activity date.
    DataThresholdFlag Determines whether the subscriber exceeded the data usage threshold for the day.
    VoiceUsageinMinutes Total duration of voice calls on the activity in minutes.
    VoiceThresholdFlag Determines whether the subscriber exceeded the voice call threshold for the day.
    SMSUsage Total SMS sent on the activity date.
    SMSThresholdFlag Determines whether the subscriber exceeded the SMS threshold for the day.
    TopUpAmount Total payment made on the activity date.
  2. Save the CSV file to a location you can easily remember.
  3. Upload the CSV file according to the instructions provided at Upload a CSV File to Create a Dataset.
    Note
    Note To make the data available to all the users creating the app, save the dataset to your Shared App.

The next time the recipe for your app runs, CRM Analytics adds payment and usage metrics to relevant dashboards.