Invitation Sent Standard Export Template

This export template is base on the invitation_sent fact.

Lets you export details of events related to the sending of invitations during a referral campaign. They include fields such as the date and time at which the invitation was sent, identifiers for the campaign, client, and invitee, type of identifier and the status of the invitee.

Measures

Measure NameDescription
Client TypeReferrers to the client type from where the invitee came.
Identifier TypeType of identifier used for the invitee, such as email, or mobile.
Invitee IdentifierIdentifier for the invitee, such as mobile number.
Client CodeReferrers to the store code.
Auto Update TimeDate and time when the corresponding record in the invitation_sent table available at the source was last updated. It is in the Unix timestamp format.
Invitee NameName of the invitee.
Invitee IdUnique identifier for the invitee.

Dimensions

Dimension NameDescription
Latest Updated DateLatest date when the data is updated.
Latest Updated TimeLatest time when the data is updated.
DateDate when the invitation was sent.
TimeTime when the invitation was sent.
Store Hierarchy (zone till)Identifier for the store, till id.
Concept HierarchyIdentifier for the concept.
Ou HierarchyIdentifier for the organization unit.
CampaignIdentifier for the campaign under which the referral was made.
UserUser details such as user id, source, slab name, external id, fraud status, mobile, email, etc.
User SegmentsSegment details of the customers such as valued customer, lapsed customer.
User AttributesUser attributes such as total visits, recent view.