Badges Standard Export Templates

There are 3 export templates for badges data.

Badges Earn

This template is based on the Badges Earn fact table.

It lets you export data related to the badges earned by customers. This includes the badge ID, customer ID, earning date, expiry date, and whether the badge is active or revoked.

Measures

MeasureDescription
Owner reference idOrchestrated ID assigned to the module responsible for awarding the badge, e.g., milestone id, journey id, campaign id, loyalty id, etc.
Is activeIndicates if the badge is currently active or not.
Auto Update Time Badges EarnDate and time when the badges_earn table was last updated. It is in the Unix timestamp format. The update takes place only when the badge deactivation occurs.
Last updated byIdentifier of the user who last updated the badge. It could be a brand representative, a Customer Success Manager (CSM), or someone similar.
Earn idUnique identifier assigned to each row of the earn badges facts table. It is the primary key of this table. It is useful in accessing information related to the customer, badge earn date, badge expiration details, etc.

Dimensions

Latest Updated Date; Latest Updated Time; Badgemeta; Customer; Badges Owner Type; Date; Time; Badges Earn Active

Badges Issue

This template is based on the Badges Issue fact table.

It lets you export data of the event where the customer has enrolled in a badge before earning it. This includes the badge ID, customer ID, issuance date, expiry date, and whether the badge is active or revoked.

Measures

MeasureDescription
Request idIt is a request ID generated during the issue of a badge. This ID serves as a reference point for tracking and managing the issuance of badges.
Owner Reference IdOrchestrated ID assigned to the module responsible for awarding the badge, e.g., milestone id, journey id, campaign id, loyalty id, etc.
Is activeIndicates whether the badge is currently active or not.
Created byIdentifier of the user who issued the badge, such as a brand representative.
Last Updated ByIdentifier of the user who last updated the badge. It could be a brand representative, a Customer Success Manager (CSM), or someone similar.
Auto Update Time Badges IssueDate and time when the badges_issue table was last updated. It is in the Unix timestamp format. The update takes place only when the badge deactivation occurs.
Badges Issued IdIt is a unique identifier for the 'badges issued' facts table. As a primary key, it uniquely identifies each record or entry within the table. It allows tracking and analysis of individual badge issuance events.

Dimensions

Latest Updated Date; Latest Updated Time; Badgemeta; ; Customer; Badges Owner Type; Date; Time; Badges Issue Active

Badges Earned Benefits

This template is based on the Badges Earned Benefits fact table.

It lets you export data of the promotions or benefits earned by the customers, that are linked to the badge. This includes the benefit type, coupon code, points earned, and validity of the benefit that comes along.

Measures

MeasureDescription
Earn idUnique identifier for the badges_earn table.
Benefit TypeType of benefit linked to the badge. The benefit types are: coupons and points.
Coupon codeThe coupon code associated with the benefit. It is generated by the coupons system.
DescriptionDescription of the coupon.
Discount CodeDiscount code associated with the coupon series.
Discount TypeType of discount. Can be ABS - absolute discount type where the discount value is fixed, or percent discount or a fixed discount.
Points EarnedPoints earned by the customer.
Program idThe Loyalty program ID is the identifier assigned to the loyalty program linked to the allocated points.
Promotion idUnique id assigned to a particular promotion.
Allocation Strategy IdDenotes the strategy selected to allocate points for badges. In case of tier-based allocation, points are allocated according to predefined tiers or categories.
Expiration strategy idDenotes the strategy used for deciding how points expire for the customer, such as fixed expiry date, or no expiry, etc.
Status codeStatus code for the action (used for internal purposes).
NotesProvides additional information or remarks related to badges.
Promo IdentifierUnique identifier assigned to a promotion.
Promotion NameRefers to the name of the promotion to which points were allocated, redeemed, or expired.
Auto Update Time Badges Benefits EarnDate and time when the badges_benefits_earn table was last updated. It is in the Unix timestamp format. The update takes place only when the badge deactivation occurs.
Unique idUnique identifier for the table. As a primary key, it uniquely identifies each record or entry within the table. It allows tracking and analysis of individual badge benefits events.

Dimensions

Latest Updated Date; Latest Updated Time; Badgemeta; Customer; Coupon Series, Date, Time