Introduction
Model Clients contains comprehensive data about customers and their purchasing behaviors, used for conducting RFM (Recency, Frequency, Monetary) analysis and customer segmentation.
Requirements:
Online store engine: IdoSell. Q2 and Q3 2025 will see integrations with more engines.
โ
Structure and description of data:
Identification data
Client Email - Email address
Client Phone - Phone number
Client First Name - First name
Client Last Name - Last name
Anonymized data in Data Octopus app
Hashed Client Email - Anonymized email address
Hashed Client Phone - Anonymized phone number
Hashed Client First Name - Anonymized first name
Hashed Client Last Name - Anonymized last name
Address data
Client Delivery Address Zip Code - Postal code
Client Delivery Address Country Code - Country code
Order indicators
Days Since First Order - Number of days since first order
Days Since Last Order - Number of days since last order
Order Count - Number of unique orders
Unique Item Count - Number of unique purchased products
Financial indicators
Min Product Net Price - Net price of the cheapest purchased product
Max Product Net Price - Net price of the most expensive purchased product
Total Net Revenue - Total net value of all purchases
Has Invoice - Flag indicating if an invoice was issued (true/false)
RFM indicators and segmentation
Recency Score - Segment determining time since last purchase
Frequency Score - Purchase frequency rating on the RFM scale
Monetary Score - Purchase value segment
Customer Segment - Customer segment determined based on RFM analysis by Data Octopus
Purchase preference indicators
Quantity Of Purchased Brands - Number of unique purchased brands
Purchased Brands - List of names of all purchased brands
Quantity Of Purchased Categories - Number of unique purchased categories
Purchased Categories - List of all purchased categories
Customer Segments
The Clients Model uses RFM analysis to automatically categorize customers according to their value and purchasing behaviors. The exact characteristics of segments are available in the RFM Segments article.
โ
Use Cases
The data contained in the Clients model primarily serves to:
Conduct RFM analysis and customer segmentation based on recency, frequency, and monetary value of purchases
Analyze purchasing preferences regarding brands and product categories
Build audience groups who purchased specific brands or product categories for use in advertising activities (e.g., overselling)
Design retention strategies for high-value customers
Segments prepared based on the Clients model can be used as recipient lists or similar audience lists in advertising systems such as Google Ads, Meta Ads, or Programmatic. This allows for precise targeting of advertising campaigns to:
High-value and high-frequency customers (e.g., Champions)
Customers making regular, frequent purchases
Customers who recently made a purchase (New Customers)
Customers showing interest in specific categories or brands
Activation of customer segments such as Slipping Champions - valuable customers who haven't made a purchase for an extended period
The Clients model enables effective targeting of advertising messages directly to selected customer groups or creating similar audience groups in advertising systems based on them, which translates to better effectiveness of marketing activities.