Campaigns

Provides an overview of business with top KPIs, across geography and product.

ChartsChart DimensionsChart KPIsKPI Description
Contacted and responded by geographyevent_zone_tillContacted CustomersThe total number of customers whose communication hit the gateway during the campaign.


Responded CustomersCount of customers that responded to the campaign message. This includes the count of both the test and control groups.
Most Responding Productstop.itemResponse Product SalesThe sum of the line item amount of all response transactions.
Hit Rate-Hit RateThe ratio of the total customers that responded to the total targeted customers.
Voucher Redeemed-Coupon RedeemedThe total number of coupons that were redeemed during the campaign period.
Campaign Performancecampaign.nameContacted CustomersThe total number of customers whose communication hit the gateway during the campaign period.


Msg SentThe total number of messages that were sent to the gateway during the campaign period. This does not sum up the credits used.


Msg DeliveredThe total number of messages that were delivered to customers during the campaign period. This does not sum up credits.


Delivery RateThe ratio of the total number of messages delivered to the total number of messages sent.


Responding CustomersCount of customers that responded to the campaign message. This includes the count of both the test and control groups.


Hit RateThe ratio of the total number of customers that responded to the campaign to the total number of customers targeted for the campaign.


Responder SalesThe sum of all transaction amount of the responding customers of the campaign. This includes both taxes and discounts, but not returns.


Incremental Sales(Test Hit Rate - Control Hit Rate)(TEST Responders Spend per Customer)(Test Customers Contacted)/100


Uplift(Test Hit Rate - Control Hit Rate)/ Control Hit Rate


Coupon IssuedThe total number of coupons issued during the campaign period.


Coupon RedeemedThe total number of coupons redeemed during the campaign period.


Unique Open RateThe ratio of the total number of unique recipients that opened messages to the total number of delivered messages.

Communication Billing

ChartsChart DimensionsChart KPI(s)KPI Description
Gateway Billing Detailedgateway_account.full_name, nsadmin_priority.priority, communication_channel.channelCommunication Credits UsedThe total number of credits consumed while sending communication both campaigns and non-campaigns.
Gateway Billinggateway_account.full_name, communication_channel.channelCommunication Credits UsedThe total number of credits consumed while sending communication both campaigns and non-campaigns.
Communication Billingnsadmin_priority.priority, communication_channel.channelCommunication Credits UsedThe total number of credits consumed while sending communication both campaigns and non-campaigns.
Campaign Billingcampaign.name, gateway_account.full_name, communication_channel.channelCommunication Credits UsedThe total number of credits consumed while sending communication both campaigns and non-campaigns.

Points Credit

ChartsChart DimensionsChart KPIsKPI Description
Points Credit Debit Tableawarded_zone_till.store_name, event_zone_till.store_namePoints RedeemedThe total number of points redeemed by loyalty customers.

Return

ChartsChart DimensionsChart KPIsKPI Description
Most Returned Productstop.itemProduct Return SalesThe sum of all the line-items amount of return products.
Return Metrics-Net SalesThe sum of the final transaction amount including taxes, discounts, and returns.


Return SalesThe sum of transactions amount of all return transactions.


% Return SalesThe ratio of Return sales and the total sales 
Most Refunding Geographytop.event_zone_tillReturn SalesThe sum of transactions amount of all return transactions.
Return Sales Trendtop.event_dateReturn SalesThe sum of transactions amount of all return transactions.

Customers Transaction

ChartsChart DimensionsChart KPIsKPI Description
Repeat Customers Shopped
Repeat Customers ShoppedThe total number of unique days a repeat customer has shopped. A Repeat customer is one who made more than one transaction across stores of the org.
Customers
Customers ShoppedThe total number of unique customers that purchased in any store of the org and provided their contact details like email ID, and phone number.
Total Base
RegistrationsThe total number of customers registered in the org's loyalty program in the selected duration.
Customer Trendstop.event_dateRegistrationsThe total number of customers registered in the loyalty program in the selected duration.


Repeat Customers ShoppedThe total number of unique days a repeat customer has shopped. A Repeat customer is one who made more than one transaction across stores of the org.
Customer Insightsevent_user.slab_nameCustomers ShoppedThe total number of unique customers that purchased in any store of the org and provided their contact details like email ID, and phone number.


Total SalesThe sum of all final bill amounts (after taxes, and discounts) excluding returns. This includes transactions of both members and non-members.


Repeat SalesThe total sales generated by repeat customers (sum of final bill amounts after taxes, discounts). This excludes returns that are made after the end date of the selected date range


Total TxnsThe total number of transactions made by both members and non-members.  This will not exclude return transactions.


Repeat TxnsThe total number of transactions made by repeat customers in the given transaction date range.


ATVAverage Transaction Value is the ratio of the sum of all transactions to the number of transactions.


ABSAverage Basket Size is the ratio of the sum of item quantity of all transactions to the total number of transactions. Return transactions are not excluded.
First Timer Customers
First Timer CustomersThe total number of loyalty customers who shopped for the first time with the brand.

Daily Report

ChartDimensionsKPIsKPI Description
Daily Report
RegistrationsThe total number of customers registered in the loyalty program in the selected duration.


Total TxnsThe total number of transactions made by both members and non-members. This will not exclude return transactions.


Member TxnsThe total number of transactions made by members (who provided their contact details). This does not exclude transactions that are returned.


Non-Member TxnsThe total number of transactions made by not-interested customers. This does not exclude transactions that are returned.


Repeat TxnsThe total number of transactions made by repeat customers in the given transaction date range.


Points IssuedThe total number of points issued to loyalty customers.


Points RedeemedThe total number of points redeemed by the Loyalty customers.


Coupon IssuedThe total number of coupon issued during the campaign


Coupon RedeemedThe total number of coupons redeemed during the campaign.


Loyalty SalesThe sum of final bill amount of all Loyalty Transactions including taxes, and discounts (does not exclude returns)


Total SalesThe sum of all final bill amounts (after taxes, and discounts) excluding returns. This includes transactions of both members and non-members.


Customers ShoppedThe total number of unique customers that purchased in any store of the org and provided their contact details like email ID, and phone number.


Repeat Customers ShoppedThe total number of unique days a repeat customer has shopped. A Repeat customer is one who made more than one transaction across stores of the org.
Store Wise - Daily reportevent_zone_till.store_name-Same as the Daly Report-

Org Newsletter

ChartDimension(s)KPIsKPI Description
Avg Latency_YTD
Avg LatencyThe average number of days between consecutive visits.
Base Overview
RegistrationsThe total number of customers registered in the loyalty program in the selected duration.


UnsubscribedThe total number of customers that unsubscribed from a specific channel.
Member vs Non-Member
Member ATVThe ratio of member sales to the member transactions


Non-Member ATVThe ratio of not-interested sales to not-interested transactions.
Store Performanceevent_zone_till.store_nameRegistrationsThe total number of customers registered in the loyalty program in the selected duration.


Total SalesThe sum of all final bill amounts (after taxes, and discounts) excluding returns. This includes transactions of both members and non-members.


ATVAverage Transaction Value is the ratio of the sum of all transactions to the number of transactions.


% Member TxnsThe percentage ratio of the total number of member transactions to the total number of transactions.
Repeat Snapshot
% Repeat CustomersThe ratio of the total number of repeat customers to the total number of customers shopped.


% Repeat Among NewThe percentage ratio of Customers who made multiple transactions and joined in a date range to the Total customers who joined and transacted in the same date range.
Campaign Snapshot
Active CampaignsThe total number of campaigns that were executed in a given time frame.


 Contacted CustomersThe total number of customers whose communication hit the gateway during the campaign.


Hit RateThe ratio of the total number of customers responded to the total number of customers contacted.


Unique open rateThe ratio of the total number of messages opened (at least once) to the total number of messages delivered.


Unique Click RateThe ratio of the total number of messages that were clicked at least once to the total number of messages delivered.


Responder SalesThe sum of all transaction amount of the customers targetted for the campaign. This includes both taxes and discounts, but not returns.


Incremental Sales[(Test Hit Rate - Control Hit Rate) *(TEST Responders Spend per Customer) * (Test Customers Contacted)]/100


Responder TxnsThe total number of transactions made by targetted customers of the campaign during the campaign period.


Redemption RateThe ratio of the total number of coupons issued to the total number of coupons redeemed in the specified duration.


Coupon Redemption SalesThe sum of all transaction amount (after taxes and discounts) that involved coupon redemption. This will not exclude return transactions.
Points Program Snapshot
Extra SalesThe sales (after discounts and taxes) generated by customers against redeeming points. This will not exclude transactions that are returned.


Current PointsThe total number of active points of loyalty customers that are available for redemption.


Earn To Burn RatioThe ratio of the total number of points earned to the total number of points redeemed by loyalty customers.


Points IssuedThe total number of points issued to loyalty customers.


Points RedeemedThe total number of points redeemed by loyalty customers.
Monthly Trendsevent_date.monthTotal SalesThe sum of all final bill amounts (after taxes, and discounts) excluding returns. This includes transactions of both members and non-members.


ATVAverage Transaction Value is the ratio of the sum of all transactions to the number of transactions.


RegistrationsThe total number of customers registered in the loyalty program in the selected duration.


% Sign UpsThe ratio of the number of registered customers to the total number of registered customers and non-member transactions.


Active CustomersThe total number of customers who are currently active (purchased within lapsation period). The default lapsation period is 90 days from the recently purchased date.


Winback CustomersThe total number of lapsed customers who made transactions with the brand in the given date range.


Points IssuedThe total number of points issued to loyalty customers


Points RedeemedThe total number of points redeemed by loyalty customers.

Sales

ChartDimensionsKPIsKPI Description
ATV across User Slabsevent_user.slab_nameATVAverage Transaction Value is the ratio of the sum of all transactions to the number of transactions.
User Slabsevent_user.slab_nameTotal SalesThe sum of all final bill amounts (after taxes, and discounts) excluding returns. This includes transactions of both members and non-members.
Product performancetop.itemProduct SalesThe sum of all line item amounts of transactions.
Net Sales
Net SalesThe sum of final transaction amount of all transactions including taxes, discounts, and returns.
Total Sales
Total SalesThe sum of the final bill amount of all transactions of members and non-members including taxes, discounts and not including returns.
Discount Percentage
% DiscountThe ratio of the total discount amount to the total sales generated.
Return %
% ReturnThe ratio of return sales to the total sales generated.
ATV
ATVAverage Transaction Value is the ratio of the sum of all transactions to the number of transactions.
ABS
ABSAverage Basket Size is the ratio of the sum of item quantity of all transactions to the total number of transactions. Return transactions are not excluded.
% Loyalty
Loyalty ConversionThe ratio of the number of loyalty transactions to the total number of transactions.
Loyalty Sales
Loyalty SalesThe sum of the final bill amount of all loyalty transactions (after taxes, and discounts). This does not exclude return transactions.
Sales Distribution Across Geographytop.event_zone_tillTotal SalesThe sum of the final bill amount ( after taxes, and discounts) of both member and non-member transactions. This does not exclude transactions returned.

Points

ChartDimensionsKPIKPI Description
Points Issued and Points Redeemed Trendtop.event_datePoints IssuedThe total number of points issued to loyalty customers.


Points RedeemedThe total number of points redeemed by loyalty customers.
Sales vs Extra Sales across Geographytop.event_zone_tillTotal SalesThe sum of all final bill amounts (after taxes, and discounts) excluding returns. This includes transactions of both members and non-members.


Extra SalesThe sales generated (after taxes and discounts) by customers against redeeming points.  This does not exclude returned transactions.

Coupons

ChartDimensionsKPIKPI Description
Redemption Rate Trendevent_date.dateRedemption RateThe ratio of the total number of coupons issued to the total number of coupons redeemed in the specified duration.
Redemption Rate Trendevent_date.date
Redemption Rate
The ratio of the total number of coupons issued to the total number of coupons redeemed in the specified duration.
Coupons ROIcoupon_series.description, coupon_series.series_typeCoupon IssuedThe total number of coupons issued during the campaign period.


Coupon RedeemedThe total number of coupons redeemed during the campaign period.


Coupon Redemption SalesThe sum of bill amounts (after taxes and discounts) of all transactions that involved coupon redemption. This does not exclude transactions that are returned.


Coupon RedeemerThe total number of customers that redeemed coupons.


Redemption RateThe ratio of the total number of coupons issued to the total number of coupons redeemed in the specified duration.
Store Wise Coupon ROIcoupon_series.description, coupon_series.series_type, event_zone_till.store_nameCoupon IssuedThe total number of coupons issued during the campaign period.


Coupon RedeemedThe total number of coupons redeemed during the campaign duration.


Coupon RedeemerThe total number of customers that redeemed coupons.


Coupon Redemption SalesThe sum of bill amounts (after taxes and discounts) of all transactions that involved coupon redemption. This does not exclude transactions that are returned.

Footfall Audit Report

ChartDimensionsKPIKPI Dimensions
Footfall Countevent_zone_till.store_nameIn Footfall CountThe total number of in count of visitors (excluding staff switch events)


Out Footfall CountThe total number of out count of visitors (excluding staff switch events)


 Footfall CountThe total number of In count


Net Footfall CountThe maximum value of in footfall count and out footfall count after eliminating staff count, that is, max (in count, out count).


Staff CountThe maximum of in staff count and out staff count, that is, Max( In staff count, out staff count


Total Group CountThe sum of all group counts (total of groups single, double, triple and four or more)


% Group WalkingThe percentage ratio of visitors walked in groups (more than 1) to the net footfall count.

Product

ChartDimensionsKPI(s)KPI  Definition
Product Performacetop.item Product SalesThe sum of the line-items amount of the specific of all transactions
Detailed Product Performancetop.itemAPP
Average Products Purchased is the ratio of the sum of the line-items amount of the specific product to the total quantity of the product purchased.
  % Product Discount
The ratio of sum of discount (amount) given for each line-item to the total line-item sales.
  Total Qty
The total quantity of items sold in all transactions. This also includes items returned.
  Product Sales
The sum of the line-items amount of all transactions
  Total Txns
The total number of transactions made by both members and non-members. This does not exclude return items
  Product Return Sales
The sum of the line-items amount of all return products.
  Returns
The total number of transactions returned by customers.
  ABS
Average Basket Size is the ratio of the sum of item quantity and the total number of transactions. This does not consider returns
  Customers Shopped
The total number of customers shopped with the brand who provided their contact details (such as email, and phone number).
 
Category Wise Customers Shopped
 top.itemCustomers Shopped
The total number of customers shopped with the brand who provided their contact details (such as email, and phone number).
  Repeat Customers Shopped
The total number of customers who made more than one transaction (on different days). Such customers will remain repeat for all future transactions.
 Category Purchase Qty Trend top.itemTotal Qty
The total quantity of items sold in all transactions. This also includes items returned.
  Member Qty
The total quantity of all items purchased by Members (who provided their contact details). does not exclude transactions returned.
Category Repeat Transaction Trend top.item% Repeat Txns
The ratio of the total number of repeat transactions to the total number of member transactions.
Category Transaction Trend top.itemTotal TransactionsThe total number of transactions made.
  Member Txns
The total number of transactions made by Members (who provided their contact details). This does not exclude transactions returned.
Category Repeat Sales Trend top.item% Product Repeat Sales
The ratio of total sales generated by repeat customers to the total line-item sales generated by members.
Category Sales Trend top.itemProduct Sales
The sum of the line-items amount of all transactions.
  Member Product Sales
The sum of the final bill amount of all member line-items excluding returns.

Customer Summary

ChartDimension(s)KPIsKPI Description
Customer Summaryevent_user.slab_name Registrations
The total number of customers registered in the loyalty program in the selected duration.
  Repeat Customer Count
The total number of customers that joined in a specified duration and did more than one transaction (in unique days) with the brand.
  Customer Purchase
Total sales generated by customers.
  Customer Txns
The total number of transactions made by members who joined in the specified duration.
  Customer ATV
Average Transaction Value is the ratio of the total purchases amount to the total number of transactions. This does not consider transactions returned (at the customer level).
  Customer ABS
Average Basket Size is the ratio of total SKUs purchased to the total number of Transactions. This does not consider transactions returned (at the customer level).
  Customer Returns
The total number of customers who returned at lease one product.
  Customer Return Sales
The total bill amount returned by customers.
  Customer Loyalty Points
The total points that can be redeemed by customers until the current date. Current points should be at least {{marginValue}}.
  Customer Redeemed Points
The total points that are redeemed by customers until the current date.
  Customer Coupon Redeemed
The total number of coupons redeemed by customers until the current date.
Registrations Registrations
The total number of customers registered in the loyalty program in the selected duration.
Active Customers Active Customers
The total number of customers who joined in a given date range that are active (purchased in recent months) and yet to get lapsed. 
The default lapsation period is 90 days from the last purchased date.
Lapsed Customers Lapsed Customers
The total number of customers whose recency has exceeded the lapsation threshold in the loyalty program
Repeat Customers Repeat Customer Count
The total number of repeat customers of the brand who joined in the specified duration.
Registrations Trend top.event_dateRegistrations
The total number of customers registered in loyalty program in the selected duration

Store

 ChartDimensions KPIs KPI Description
 Sales Trend  top.event_date Total Sales
The sum of all final bill amounts (after taxes, and discounts) excluding returns. This includes transactions of both members and non-members. 
 Store top.event_zone_till Total Txns
The total number of transactions made by both members and non-members. This will not exclude return transactions. 
  Customers Shopped
The total number of customers shopped with the brand who provided their contact details (such as email, and phone number). 
  Total Sales
The sum of all final bills amount (after taxes, and discounts) excluding returns. This includes transactions of both members and non-members. 
  % Repeat Sales
The ratio of total repeat sales to total member sales.
  % Repeat Txns
The ratio of the total number of repeat transactions to the total number of member transactions. 
  ATV
Average Transaction Value is the ratio of the sum of all transactions to the number of transactions.
  ABS
Average Basket Size is the ratio of the sum of item quantity of all transactions to the total number of transactions. Return transactions are not excluded. 
  % Discount
The ratio of the total discount amount to the total sales generated. 
  % Loyalty Txns
The ratio of the total number of loyalty transactions to the total number of transactions.
  Member Txns
The total number of transactions made by Members (who provided their contact details). This does not exclude transactions returned.
  Non Member Txns
The total number of transactions made by non-members or not-interested customers (who did not provide their contact details). This does not exclude transactions returned.
  Member Sales
The sum of the final bill amount of all member transactions after taxes, discounts and not including returns.
  Non Member Sales
The sum of the all net bill amount of non-member or not-interested transactions (after taxes, discounts). This does not exclude transactions returned.
  Registrations
The total number of customers who registered in the loyalty program in the selected duration.
  Points Redeemers
The number of loyalty customers who redeemed their loyalty points at least once.
  Txn Redeem Points
The points redeemed at the transaction level. The value might not match with total points redeemed as all transactions are not captured post redemption.