Campaign Calculated Effect Result

The file displays the calculated results of the campaign's execution.

A sample file is provided below:

416KB

campaigns_calculated_effects_results_all_until_2023_09_01.csv

Available Data:

• calculatedEffectResultId: ID of the calculated effect result for the campaign's rule

• tenantId: ID of the tenant where the campaign was created

• campaignExecutionId: ID of the campaign execution

• status: Status of the calculated effect result (success, skipped, failed)

• targetId: Member's ID generated in Open Loyalty (memberId)

• type: Type of campaign effect (e.g., give_points, give_reward)

• createdAt: Date when the entry was created

• updatedAt: Date when the entry was last updated

• points: Number of units calculated as part of the campaign effect

• couponValue: Value of the coupon granted (for dynamic coupons)

• rewardId: ID of the reward granted

• walletCode: Code of the wallet to which the units were granted

• error: Error message for failed executions