---
schema_version: "1"
id: a2cf342dd7d5b7e1dac27a327fcf2e050af7d1e9349446cdf5cd9248aea75762
title: Import Payment and Usage Data to Analytics for Communications - Consumer App
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_template_comms_cons_import_csv.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_template_comms_cons_import_csv.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 68411e39c8638af7ec3d15a9c2a6503bb7b8342bc7e65a20432e41bb48b3a05a
description: Add payment and usage data from an external source to the Analytics for Communications - Consumer App.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# 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

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Developer</strong> edition and for an extra cost in <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions</td></tr></tbody></table>

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](https://help.salesforce.com/articleView?id=analytics.bi_dataset_create.htm&type=5&language=en_US).
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)
    
    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.