Description
The summary CSV is a summary of important figures for the reporting period. It consists of a single row of rolled-up values for each of its columns. As mentioned above, we recommend starting with the summary report and then diving into the other more detailed reports as needed.
Columns
Column Name | Description |
---|---|
Report ID | Catch’s unique identifier for this report. |
Start Timestamp | The inclusive starting timestamp of the reporting period. |
End Timestamp | The exclusive ending timestamp of the reporting period. |
Purchase Amount | The total value of purchases during the reporting period, prior to Catch Fees and reward adjustments. |
Refund Amount | The total value of refunds during the reporting period, prior to reward adjustments. |
Catch Fees | The total amount paid in Catch Fees during the reporting period. |
Net Redeemed Rewards | The impact of reward redemptions on the net transaction amount. In addition to reward redemptions, this also includes previous reward redemptions that were ‘unredeemed’ upon a refund. |
Net Transaction Amount | The net amount owed to the merchant based on transactions that occurred in this reporting period. Net Transaction Amount = Purchase Amount + Refund Amount + Catch Fees + Net Redeemed Rewards. |
Unsettled Balance | The amount that remains unsettled at the end of the reporting window. Catch doesn’t pull funds, so this value might be negative if refunds exceed purchases. A negative balance will impact the “Total Settled in Period” on a future report. |
Total Settled in Period | The total amount that Catch sent to the merchant in settlements during the reporting period. This amount should match the sum total of the settlements in the settlements csv, as well as the sum total of the individual transactions in the settlement_events csv. |
Rewards Granted | The value of new rewards granted in the reporting period. Itemized reward granted details can be found in the reward_events report by filtering for “granted” events. |
Rewards Canceled | The value of previously granted rewards which were canceled during the period (e.g. because the purchase the rewards were earned on became refunded). Itemized reward cancellation details can be found in the reward_events report by filtering for “canceled” events. |
Rewards Expired | The value of rewards that expired in the reporting period. Itemized reward expiration details can be found in the reward_events report by filtering for “expired” events. |
Change in Outstanding Rewards | The change in amount of outstanding rewards in the reporting period. Change in Outstanding Rewards = Rewards Granted + Rewards Canceled + Rewards Expired +Net Redeemed Rewards. |
Total Outstanding Rewards | Total amount of unredeemed reward balance held by consumers. Total Outstanding Rewards = Total Outstanding Rewards from previous report + Change in Outstanding Rewards. |