Inbound files contain batch processing files comprised of records that the Publisher sends to Fidel.
For processing, publishers should transmit batch processing files to Fidel on a consistent basis. Those files can be submitted to Fidel in any of the following intervals:
- Daily (recommended)
- Weekly
- Monthly
In order for Fidel to monitor file transfers, publishers should follow the selected schedule. In cases where there is no transaction data, no file needs to be sent.
Publishers should adhere to the following general requirements when sending files to Fidel:
- File header must be present
- Required fields in the file must be populated
New and established publishers that want to offer a rewards program to the cardholders, must send batch processing files according to the following:
- File Format:
CSV - Property Delimiter:
|
The Fidel Inbound Transaction Record and Fidel Inbound CardHolder Record structure can be found on the next section of this document.
Inbound Transaction Record
File Naming Convention (recommended): transaction_oaas_${date}_${publisherName}_v1.csv
| Field | Description | Required | Example |
|---|---|---|---|
| Transaction External Id | Transaction unique identifier | Required | 7c1fd29b-6eb2-4c53-8b0b-78d1af03e2d7 |
| Transaction Amount | Transaction Amount | Required | 12.64 |
| Transaction Currency | Transaction Currency | Required | USD |
| Datetime | Datetime in UTC when transaction was made | Required | 2024-01-01T09:00:00.000Z |
| Cashback | Amount of the reward cashback to the cardholder | Required | 1.26 |
| Offer Id | Offer unique identifier | Required | 91397a52-f440-41d1-8eef-d2d781bc75cb |
| Last 4 | Last 4 digits of the card | Required | 3032 |
| Merchant Name | Merchant Name where transaction was made | Optional | Brand B |
| Address | Address of the merchant location | Optional | 1849 2nd Ave |
| City | City of the merchant location | Optional | New York |
| State Code | State Code of the merchant location Format: ISO 3166-2 code | Optional | NY |
| Country Code | Country Code of the merchant location Format: ISO 3166 Alpha-3 | Optional | USA |
| MID | Merchant ID where transaction was made, can be used to match transactions | Optional NOTE: 1. Required for matching offers with linked MIDs 2. It is recommended to use MID Id field instead | 3055657 |
| MID Id | Fidel unique identifier of the MID entity | Optional NOTE: 1.Required for matching offers with linked MIDs 2. Preferable method over usage of MID field | 7518f53e-98df-4687-8153-a9ecd70fc352 |
| Descriptor | Merchant descriptor that can be used to match transactions | Optional | STARBUCKS 12345 NEW YORK NY |
| Publisher Name | Publisher name. | Optional | Publisher Name |
| Card External Id | Card unique identifier | Optional NOTE: Required for Incrementality Reporting | 07a8d178-2d88-4421-a502-0534ff477474 |
| Scheme | Scheme of the transaction | Optional | Mastercard |
| Type | Transaction Type | Optional | Clearing |
| AuthCode | Transaction Auth Code | Optional | A1B2C3 |
| Issuing BIN | Issuing Bank Identification Number | Optional | 411111 |
| ARN | Acquiring Reference Number, Unique identifier assigned to a transaction by the acquirer or payment processor | Optional | 74659483729384716283920 |
| Custom {1...N} | Custom fields as free text for passthrough | Optional | 'Custom 1': 'value1', 'Custom 2': 1234, 'Custom 3': true |
| Activation Date | Activation Date to be used on offers with activation enabled | Optional | 2025-05-28T12:53:45 |
Inbound CardHolder Record
File Naming Convention (recommended): cardholder_oaas_${date}_${publisherName}_v1.csv
| Field | Description | Required | Example |
|---|---|---|---|
| Offer Id | Offer unique identifier | Required | 91397a52-f440-41d1-8eef-d2d781bc75cb |
| Card External Id | Card unique identifier | Required | 07a8d178-2d88-4421-a502-0534ff477474 |
| Incrementality Group | Incrementality Group Possible values: - holdout - treatment | Required | holdout |
Inbound Aggregated CardHolder Record
File Naming Convention (recommended): aggregated_cardholder_oaas_${date}\_${publisherName}_v1.csv
| Field | Description | Required | Example |
|---|---|---|---|
| Offer Id | Offer unique identifier | Required | 91397a52-f440-41d1-8eef-d2d781bc75cb |
| Incrementality Group | Incrementality Group Possible values: - holdout - treatment | Required | holdout |
| Eligible Users | Number of users that are part of the incrementality group | Required | 1000000 |
| Total Transactions | Number of total transactions made by the users of this incrementality group | Required | 10000000 |
| Total Transactions Amount | Total transactions spend amount by users of this incrementality group | Required | 50000000 |
| Transacted Users | Number of unique users that are part of this incrementality group and have transacted at least once | Optional NOTE: Without this, Fidel is not able to calculate the incremental number of users that a given Offer brought to the brand | 500000 |