> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bango.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Content provider correlation file format

> Input and output CSV formats for content provider entitlement correlation.

Use this format when submitting content provider entitlement data for correlation with DVM.

<Note>
  Optional columns must still be present in the CSV header even when no value is supplied.
</Note>

## Input file format

| Column name | Type | Required | Description |
| - | - | :-: | - |
| `ExternalEntitlementId` | String | Yes | Your unique entitlement identifier |
| `BangoUserId` | String | No | DVM user identifier associated with the entitlement |
| `EntitlementId` | UUID | Yes | Unique entitlement identifier |
| `Status` | String | Yes | Current entitlement status |
| `ResellerKey` | String | No | Identifier of the reseller providing the entitlement |
| `ProductKey` | String | Yes | Product identifier used for correlation |
| `OfferKey` | String | No | Offer identifier |
| `CreatedDate` | RFC 3339 timestamp | No | Entitlement creation date |
| `ActivatedDate` | RFC 3339 timestamp | No | Activation date |
| `SuspendedDate` | RFC 3339 timestamp | No | Suspension date |
| `ResumedDate` | RFC 3339 timestamp | No | Resume date following suspension |
| `EndDate` | RFC 3339 timestamp | No | Entitlement end date |

## Correlation processing

DVM uses `ExternalEntitlementId` to identify the corresponding entitlement. In API calls, this identifier is also known as `merchantEntitlementId`.

The following values are then compared:

* `ProductKey`
* `Status`

## Output file format

The output contains both the values supplied by you and the corresponding values held by DVM.

| Column name | Description |
| - | - |
| `ExternalEntitlementId` | Your entitlement identifier |
| `BangoUserId` | DVM user identifier supplied in your input file, if provided |
| `EntitlementId` | Entitlement identifier supplied in your input file |
| `ResellerKey` | Reseller identifier supplied in your input file |
| `Status` | Status supplied in your input file |
| `ProductKey` | Product supplied in your input file |
| `OfferKey` | Offer supplied in your input file |
| `CorrelationResult` | Overall correlation outcome |
| `CorrelationResultReason` | Detailed explanation of the correlation outcome |
| `BangoEntitlementId` | Matching entitlement identifier held by DVM |
| `BangoCustomerIdentifier` | Customer identifier held by DVM |
| `BangoStatus` | Status held by DVM |
| `BangoProductKey` | Product key held by DVM |

Depending on your configuration, additional attributes can be supported.

## Related documentation

<CardGroup cols={2}>
  <Card title="Correlation reports" icon="arrows-left-right" href="/reconciliation/correlation-reports">
    Upload, processing, results, and output options.
  </Card>

  <Card title="Reseller correlation file format" icon="file-csv" href="/reconciliation/reseller-correlation-input-file-format">
    Input and output format for reseller correlation.
  </Card>
</CardGroup>