Member Growth
- “How many new members joined during [specify time period, e.g. last month, last 7 days]?”
- “How many total members are currently in the system?”
- “What is the growth rate of new members over the last [specify number] months?”
- “How many members were truly Active (made a purchase) during [specify time period]?”
- “Give me a list of customers who have not been Active for [specify number] months or more.”
- “What is the member growth rate this quarter compared with [specify reference period, e.g. last quarter]?”
- “How many unexpired coupons does member ID [specify member ID] currently have?”
- “Segment customers based on [specify criteria, e.g. RFM Score, CLV] and provide the number of customers in each segment.”
Purchase Behavior
- “Who are the Top [specify number] spenders during [specify time period], and how much did each spend?”
- “Which customer made the most purchases during [specify time period], and how many purchases did they make?”
- “What time of day does member ID [specify member ID] most frequently make purchases?”
- “How many customers made their first purchase during [specify time period]?”
Campaign, Loyalty, Finance & Point Liability
- “How many customers redeemed [specify point name, e.g. Point, Coin, Star] during [specify time period]?”
- “How many [specify point name] were redeemed in total during [specify time period]?”
- “How many members currently belong to Tier [specify tier name, e.g. Gold, VIP, Super Bear]?”
- “What is the current total Point Liability in THB when the Cost per [specify point name] is [specify amount] THB?”
- “What was the total Point Liability during [specify time period] when the Cost per [specify point name] was [specify amount] THB?”
- “What is the current Point Liability, along with the average monthly change, when the Cost per [specify point name] is [specify amount] THB?”
- “Estimate the value of [specify point name] that will expire by [specify time period, e.g. the end of this year, the end of next month], and explain how the calculation is made.”
Behavior Insight (Web View / Usage), Segmentation, Intent & Web Analytics
- “How many users opened the Web View but did not perform any transaction during [specify time period]?”
- “During [specify time period], how many members opened the Web View but did not make a purchase or redeem any points?”
- “How many Web View sessions were opened without any transaction during [specify time period]?”
- “Segment members by [specify criteria, e.g. Generation (Gen Z, Gen Y, Gen X)] during [specify time period] and show the percentage distribution.”
- “How many customers made more than [specify number] purchases during [specify time period, e.g. within a single month]?”
- “Intent Segmentation: How many customers are likely to churn within the next [specify number] days?”
- “What types of products do Top Spender customers purchase most frequently?”
- “Which page on the Web View received the most views during [specify time period]?”
- “How many total clicks did campaign [specify campaign name] receive?”