p>This is a glossary page that describes technical and business terms used in Essential Insights including Export Framework, and Customer Segmentation.


ABCDEFGHIJKLMNOPQRSTUVWXYZ

A

DimensionAttributeValuesDescription
active_status
value
0, 1

admin_user
first_name, middle_name, last_name, is_active, is_deleted, id, email

Same as user dimension. Refer to the U table for more details

is_active
0, 1
Whether the user is active (1) or inactive (0)

is_deleted
0, 1
Whether the user is deleted (1) or not
awarded_points_promotion



awarded_typepointsPOINT_AWARDED, POINT_AWARDED_BILL_PROMOTION, POINT_AWARDED_LINEITEM, POINT_AWARDED_LINEITEM_PROMOTION, POINT_AWARDED_CUSTOMER_PROMOTIONPoints awarded through a loyalty program or promotional program.
  • Point awarded: Total number of points awarded
  • Point awarded bill promotion: Bill level promotional points awarded
  • Point awarded lineitem: Points awarded at lineitem level
  • Point awarded lineitem promotion: Lineitem level promotion points awarded
  • Point awarded customer promotion: Customer level promotion points awarded
Within a transaction it also highlights whether awarded type point was at a product level or not
awarded_zone_till
points
Till id
TILL id from which points are awarded. This works on the basis of store hierarchy




B

Dimension
Attribute
Values
Description
bill_type
value

REGULARNOT_INTERESTED
Type of bill based on loyalty status of customers.
Regular for transactions with customer tagging and not_interested for transactions without any customer tagging.
bill_outlier



bill_outlier_status



booking_type

booking_type
dine_in, delivery, pickup






C

DimensionAttributeValuesDescription
campaign_delivery_status
status_id, veneno_status_label, campaign_legend_status_id, campaign_legend_lebel
(attributes explained below)
-


status_id
-3 to 30


veneno_status_label
DELAYED_DELIVERY, CLICKED, OPENED, SENT, DELIVERED, NOT_DELIVERED, FAILED, SENT_TO_NSADMIN, SENT_TO_CALL_TASK, BLOCKED, DND_BLOCKED, NDNC_BLOCKED, CREDIT_LIMIT_EXCEEDED, RELEVENCE_TIMEOUT, PARTIAL_RESPONSE, RATE_LIMIT_EXCEEDED, IN_GTW, HARD_BOUNCED, SOFT_BOUNCED, TIMEOUT, RETRY_TIMEOUT, HANDLER_NOT_FOUND, OPENED_INTOUCH, CLICKED_INTOUCH, MARKED_SPAM, GTW_NOT_FOUND, ORG_DISABLED, MARKED_UNSUBSCRIBED, SUBSCRIPTION_SERVICE_ERROR, GTW_PROCESSED, MOBILE_WHITELISTED_BLOCKED


campaign_legend_status_id
0-13


campaign_legend_lebel
Not Delivered, Clicked, Opened, Sent, Delivered, Not Delivered, System Error, About to send, Customers cannot be targeted, Bounced, Marked Spam, Configuration issue, Marked Unsubscribe, Users not whitelisted

campaign_group
campaign start date, campaign end date, group type, name, campaign, group_version_number, roi_type, is_recurring

Consists of campaign level attributes

is_recurring
true, false
Whether the campaign is a recurring campaign or a one-time campaign

campaign start date
-
Start date of a campaign

campaign end date
-
End date of a campaign

group_type
test, control, all


name
campaign group name


campaign
campaign name
Name of the campaign

roi_type
onetime, birthday_comm


group_version_number

Version number of the campaign group as in the source




campaign_message
campaign_start_date, msg_type, id, is_recurring, guid, scheduled_type, status, auto_update_campaign, auto_update_msg, campaign, campaign_end_date



campaign_start_date



msg_type
NA
NA

id



is_recurring
true, false


guid



scheduled_type
SCHEDULED, PARTICULAR_DATE, IMMEDIATELY


status
OPEN, SENT, REJECTED


campaign
Campaign names
Name of a campaign as defined while creating

campaign_end_date

End date of a campaign




campaign_schedule_date
date-property

Date when the campaign is Scheduled (Date property). Refer to the D table for more details
cashier_discount_reason
reason,
auto_update_cashier
Reason: manager_discount, gift_card_discount, employee_discount, member_discount, incorrect_label, advertisement, wrong_display, bulk_customer, wrong_scan, customer, display, faulty, damage

category



channel_account
channel_account_id, auto_update_org_channel_accounts, account_name, auto_update_channels


communication_channel
channel, activity_name, id

The mode of communication with the customer

channel
sms, email, wechat, android and IOS


activity_name
SendSMSActivity, SendEmailActivity, Others

communication_type
typetrans, trans_emf, bulk_test, bulk_control
Communication category via. which a customer was contacted.
Trans for transaction message, trans_emf for transactions generated through emf, bulk_test for bulk messages sent to test group, and bulk_control for bulk messages sent to control group
Concept Hierarchy

It is a logical grouping of stores. For example, electronics, jewelry, apparels and so on


concept_nameConcept names as defined for the clientIf store require classification which are non-geographic, concepts are used,for example store in mall or store outside mall etc
contact_date



contact_time



conversion_date


conversion_time


coupon_event_type



coupon_issual_type
coupon
Single, Bulk, NCA
If multiple coupons are issued for a campaign, it is termed as bulk coupon issual type.
If a single coupon is issued as a response to a bounce back campaign, it is termed as single coupon issual type.

coupon_series




campaign

Name of a campaign

discount_value

Discount amount of a campaign

series_id



owner_valid_till_date



campaign_id



description



discount_code


series_type
campaign, goodwill, DVS, loyalty, timeline


client_handling_type



discount_type
ABS, PERC


valid_till_date



expiry_strategy_type
days, series_expiry


expiry_strategy_value


created_by



customer_merge_log 



customer_slab
slab_no, slab_name, serial_no

slab_name: Name of a loyalty tier as defined in the organization's loyalty program
slab_no: Tier number as per the source
serial_no: Order of a tier. For example, 1 for the lowest tier

D

DimensionAttributeValuesDescription
date

Denotes time range selection for events like transaction, registration and campaign communication


Year
Year in YYYY format

QuarterQ1, Q2, Q3, Q4 followed by year in YYYY forma
Quarter (Q1, Q2, Q3, Q4) along with the respective year. For example, Q3, 2019

Quarter_no
Quarter number starting from the year 1901

Year_quarter_no
Quarter number with respect to the calendar year- 1 for Q1, 2 for Q2, 3 for Q3, and 4 for Q4

Month
Month of the event along with the year. For example, Dec, 2019

Date
Date of the event in 'YYYY-MM-DD' format

week_of_year

deduction_type
PointsExpired, Migration, Redeemed, ReturnEntry through which points were deducted from customers account.
  • Redeemed: Points that were redeemed against transactions
  • Expired: Points that were expired as per expiry strategy
  • Migration:
  • Return: Points that were reverted due to transaction return
Delivery Status
campaign delivery status, NSAdmin delivery status

Delivery status of a communication sent to a customer.
campaign delivery status is the delivery status given by the final third party gateway which pushes the communication.
NSAdmin delivery status describes the delivery status given back by the internal gateway of Capillary.
device date



Device time



direction



dob


due_date



E

Dimension
Attribute
Value
Description
Email Open Date & Time
Email open date, Email open time

Date and time when email was opened

email_open_date

Date property when an email is first opened

email_open_time

Time property when an email is first opened
entry_type



event_date



event_time



event_user



event_zone_till



expiry_date



expiry_time



Entity Type



F

DimensionAttributeValueDescription
first_awarded_date


first_points_redemption_date


first_redemption_date


first_txn_date


G

Dimension
Attribute
Value
Description
gateway_account



group_size



H

I

Dimension
Attribute
Value
Description
internal_status



issual_campaign_group



issual_date



issual_time



issual_type



issued_to_user



issual_zone_till



J

K

L

Dimension
Attribute
Value
Description
lapsation_date


last_txn_date


last_points_redemption_date


last_purchased_store


last_redemption_date


latest_updated_dateDate property. Refer to the Date dimension in table D for details
Date property. Refer to the Date dimension in table D for details
Date when the event is recently updated. Refer to the Date dimension in D table for all attributes and values of date property
latest_updated_time


Line Item Outlier



line_item_outlier_status



Loyalty



loyalty_type
Loyalty, Non-loyalty

This represents to which loyalty type a customer belongs.

A customer that is part of the organization's loyalty program is a loyalty customer.
A customer that did not enroll in the organization's loyalty program but registered either mobile number or email id to receive transactional and promotional messages from the organization is a non-loyalty customer.




M

DimensionAttributeValueDescription

Membership Type
typeMember, Not-interested, loyalty not-interested

Membership type can be described as Member or Non Member. Customers who shared their personal identifier (mobile, email) with the organization are members and who did not share their personal identifier are non-members (not-interested customers)


membership



merge by till 



merge by admin user 



merge_status
status
unmerged, merged

mongo_event_button_state
state
normal, deleted
-Internal-
mongo_event_button_type
type
view, click

N

Dimension
Attribute
Value
Description
ndnc_status
status
NDNC, INVALID, DND, UNKNOWN

nps_score
score
0-7





nsadmin_priority
priority
high, default, bulk

O

Dimension
Attribute
Value
Description
old_category



org_level_repeat_bill_status



Organization



P

DimensionAttributeValueDescription
parent_bill_outlier_status



parent_line_item_outlier_status



payment_mode



points_awarded_type
typePoints awarded, points awarded bill promotion, points awarded customer promotion, points awarded line-item , points awarded line-item promotion

Source from which points are allocated to customers.

For example, bill promotion, product promotion, or customer promotion (on birthdays)
Points Category
points
Redeemable, Non-redeemable
Redeemable points are the issued points that can be redeemed by a customer.
Non-redeemable points are tracker points that can neither be redeemed by a customer nor expired.
points_event_type
typePoints awarded, Points deducted
Points allocated to a customer will reflect as points awarded
and points were taken off from a customer account (as redeemed, expired, or returned) will reflect as points deducted 
points_promotion
type, name
The promotional event through which points are issued to customers

typeVaries based on the promotion setup

nameUser defined name of the promotion program
points_redemption_status






preferred_store


Previous Customer Slab



Product

This is a product hierarchy dimension which has a drill down and roll up feature for every department to drill down on the basis of product category, available only after category mapping from configuration page

categoryUser defined values

sub categoryUser defined values

departmentUser defined values

sub departmentUser defined values
Product Attributes



Promotion Type
points
Customer promo, Bill promo
Represents the source of promotional points awarded to customers - customer level promotion or transaction level promotion

Q

R





Registration Entity Type



repeat


repeat_status



reported_by



returned_by



returned_type 






S

DimensionAttributeValuesDescription




source






scd_type



Slab Upgrade Event Type



Store Hierarchy

-


A hierarchical store level attribute used to get store level information of KPIs.



till_nameTill names as defined in Capillary systemName of the till, this is the lowest entity at a store level, a till is named after a point of sale in a store

is_billablebillable, non billable If a store is charged by Capillary to the client , it is termed as billable otherwise its non billable

store_cityCity namesCity corresponding to a store

store_nameStore names as defined in Capillary systemOne level above till, this name pertains to the single store

typeadmin, generalGeneral stores are the stores which are actually present with the client, admin stores are virtual or actual stores but 100% used for testing out Capillary process, data from these stores are removed from analysis and reporting

till
Name of the till, this is the lowest entity at a store level, a till is named after a point of sale in a store

zone_namezones to which store belongThese are geographic zones that are used to categorize stores for Zonal Manager's view

storeClient defined store nameThis is the store name as per the client naming convention used and serves the same purpose as store_name

zoneZone to which a store belongsGeographical zones used to categorize stores
source_type



T

DimensionAttributeValuesDescription
task



time--

Timestamp of events like transaction, registration, and campaign communication


Day_shiftMorning, afternoon, night, midnight>=06:00:00 to <12:00:00 - Morning,
>=12:00:00 to <16:00:00 - Afternoon,
>=16:00:00 to <20:00:00 - Evening,
>=20:00:00 to <00:00:00 - Night,
>=00:00:00 to <06:00:00 - Midnight

Day_shift_no1, 2, 3, 4, 5Sequence number of the day-shift - 1 for morning, 2 for afternoon, 3 for evening, 4 for Night, and 5 for Midnight

Hour_of_day1, 2, 3, ... 24Hour of a day from 1-24

Minute_of_day1 to 60

Time_id-Unique id, or primary key, associated to the time

Time-Time in HH:MM:SS format

Hour_range-Hours range in HH-HH format. For example, 02-05




U

Dimension
Attribute
Value
Description
Unsubscribe Status
Unsubscription status

Whether a customer has unsubscribed from a communication
updated_by_user



updated_date



updated_time



user


user segments (optional)






V

Dimension
Attribute
Value
Description
voucher_redemption_status


victim user 







W

Dimension
Attribute
Value
Description
walkin_type



wedding date






X

Y

Z