---
schema_version: "1"
id: cdda9fd44c694f96183cafcfac05ceffa3f462852efe1d7ced435ecee0322e5d
title: Import Payment Data to Analytics for Subscriber Lifecycle Management App
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_template_import_payment_data_subscriber_lifecycle_analytics.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_template_import_payment_data_subscriber_lifecycle_analytics.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: cc9e1076ee026d468fd3024908e931d776c3a7d851dc80039c0fa5056a53ce07
description: Import payment data from an external source to the Analytics for Subscriber Lifecycle Management app to show payment metrics in relevant dashboards.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Import Payment Data to Analytics for Subscriber Lifecycle Management App

Import payment data from an external source to the Analytics for Subscriber Lifecycle Management app to show payment metrics in relevant dashboards.

1. Create a CSV file with these fields (Field Name), in this order, with these exact names.
    
    Field names are case-sensitive.
    
    | Field Name | Contents |
    | --- | --- |
    | AccountId | (Text) Unique Id to identify an account that owns the subscription. |
    | Product2Id | (Text) Unique Id to identify the product. |
    | Bill\_Period\_Start | (Date) Start date of the billing period in mm-dd-yy format. |
    | Bill\_Period\_End | (Date) End date of the billing period in mm-dd-yy format. |
    | PaymentMode | (Text) Method that's used to make the payment. |
    | Invoice\_ID | (Text) Unique ID to identify the invoice. |
    | Amount | (Numeric) Amount paid. |
    | Currency | (Text) Currency in which the payment is made. |
    | Date\_of\_Payment | (Date) Date on which the payment is made. |
    
    Use only a UTF-8-compliant text editor to create and open CSV files. Opening CSV files in non-compliant text editors, such as Microsoft Excel, reformats the CSV files and makes them unusable in CRM Analytics. To review the format requirements, such as date formats, see the [CRM Analytics External Data Format Developer Guide](https://developer.salesforce.com/docs/analytics/bi-dev-guide-ext-data/guide/bi-ext-data-schema-overview.html).
2. Save the CSV file.
3. Create the app.
    
    For information on how to create the app, see [Create and Share the Analytics for Subscriber Lifecycle Management App](https://help.salesforce.com/s/articleView?id=analytics.bi_template_create_subscriber_lifecycle_analytics.htm&release=264.0.0&type=5 "Create an app from the Analytics for Subscriber Lifecycle Management template and then share the app with your users.").
4. Open the app, click **Datasets**, and then locate the Media\_Payment dataset.
5. Click **Edit**.
6. Click the Replace Data icon.
7. Click **Select a file** or drag the file.
8. Select the CSV file that you created, and then click **Open**.
9. Click **Next** | **Next**, and then click **Upload File and Replace**.
    
    The next time the dataflow for your app runs, CRM Analytics adds Media\_Payment to relevant dashboards. For more information on uploading a CSV file, see [Upload a CSV File to Create a Dataset](https://help.salesforce.com/s/articleView?id=analytics.bi_dataset_create.htm&type=5&language=en_US).