Summary CSV Description

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 NameDescription
Report IDCatch’s unique identifier for this report.
Start TimestampThe inclusive starting timestamp of the reporting period.
End TimestampThe exclusive ending timestamp of the reporting period.
Purchase AmountThe total value of purchases during the reporting period, prior to Catch Fees and reward adjustments.
Refund AmountThe total value of refunds during the reporting period, prior to reward adjustments.
Catch FeesThe total amount paid in Catch Fees during the reporting period.
Net Redeemed RewardsThe 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.
Transaction Adjustment AmountThe impact of transaction adjustments on the Net Transaction Amount.
Net Transaction AmountThe 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 BalanceThe 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 PeriodThe 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 GrantedThe 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 CanceledThe 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 ExpiredThe 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.
Beginning of Period Outstanding RewardsNew field in reporting version 2.2. The amount of unredeemed reward balance that was held by consumers at the beginning of the reporting period.

Beginning of Period Outstanding Rewards = Total Outstanding Rewards - Change in Outstanding Rewards.
Merchant IDCatch identifier for brand; This can be used to distinguish between brand reports when managing multiple Catch integrated brands.