Skip to main content
Updated Nov 8, 2026
Zu Wei
4 min read
7 views

What Customer Demographic Data You Have and How to Use It

What Is This?

Pixalink collects basic demographic data on every customer — gender, date of birth, joined date, and outlet. You can filter, view, and export this data today. Full gender-split charts are not built in yet, so this article shows you what's possible now and how to get deeper insights.

Real-Life Example

Aishah runs a cafe in Bangsar. She wants to run a Mother's Day promotion but doesn't know how many of her 1,200 customers are women. She opens her customer list, turns on the Gender filter, and picks Female — the count updates instantly. She then exports that filtered list to a CSV file and drops it into Google Sheets. In under ten minutes she has 740 qualifying customers, knows 35% were born in April or May, and launches a targeted WhatsApp broadcast. Two weeks later, her Mother's Day special pulls in 3x the usual foot traffic.

Every customer record can hold:

  • Name — full name
  • Gender — Male or Female
  • Date of Birth — full date, used to calculate age and birthday month
  • Joined at — when the customer first signed up
  • Outlet (Space) — which branch they first registered with
  • Source — how the customer joined, for example Direct, Loyalty (signed up on your customer portal), WhatsApp, Reservation, or your POS system. See What Are Customer Sources?
  • Tags — any labels you or your team added

Gender and Date of Birth are optional on the registration form. If customers skip them, that row stays blank in your data.

Video Walkthrough

How to See Demographics in Your Customer List

  1. Go to Admin Panel → CRM → Customers

    Admin Panel with CRM expanded, Customers highlighted and its landing page visible.

  2. Click the column toggle icon above the table and turn on Gender and Date of Birth. These columns are hidden by default to keep the table clean

    Customers list with the column toggle icon highlighted and the Gender and Date of Birth columns turned on and highlighted

  3. Click the Filters button to narrow the list by Gender or Birthday Month. The row count at the bottom updates to show how many customers match

    Customers list with the Filters button and the Filters panel open, the Gender and Birthday Month filters highlighted

  4. Combine filters to find highly specific groups — for example, all female customers born in June who joined after January this year

    Step 4: Customers list with two active filters highlighted, Gender: Female and Birthday Month: January, and the matching customer count below

Native Analytics You Have Today

Your dashboard shows up to six stat cards out of the box:

  • New Customers — how many joined this month, with a trend arrow against last month
  • Pending Reservations — bookings waiting for your approval (shows only if you have reservations set up)
  • Active Members — customers who made a transaction in the last 30 days
  • Points Redeemed — total points your customers redeemed this month
  • Total Reservation — past reservations (status: reserved, scheduled for today or earlier) (shows only if you have reservations set up)
  • App installs: customers who added your app to their home screen (shows only if your customer portal can be installed as an app)

Dashboard with the stat cards row highlighted: New Customers, Active Members, Points Redeemed and App installs

Pixalink does not currently show a gender split chart, age breakdown, or location heat map inside the admin panel. For those views, export your data and analyse it in Excel or Google Sheets.

How to Export and Analyse in Excel

  1. On the Customers page, click the ⋮ menu at the top right, then click Export Customers

    Step 1: Customers page with the more actions menu open at the top right and Export Customers highlighted

  2. Tick the columns you want — you can choose to include Gender and Date of Birth in the export

  3. Click Export — you'll get an email with the CSV file once it's ready

  4. Open the file in Excel or Google Sheets. From there you can:

    • Use a pivot table to count customers by Gender
    • Use the =YEAR(TODAY()) - YEAR(B2) formula to calculate age from Date of Birth
    • Group ages into buckets (18-24, 25-34, 35-44, 45+) with an IF formula
    • Filter by Joined at date to see demographic shifts over time

How to Request a Custom Report

If you need something the admin panel doesn't give you — age-bracket breakdowns, outlet-by-outlet gender split, spending patterns by demographic — reach out to the Pixalink team.

  • Send your request to our support team with: what you want to know, what decision it will help you make, and the time range
  • Standard turnaround is 3 to 5 working days
  • Most demographic reports are free for active Pixalink plans

Good to Know

  • Gender and Date of Birth are optional fields. Encourage customers to fill them in by offering a small birthday reward — it often lifts completion rates by 40% or more
  • The Birthday Month filter makes it easy to preview your monthly birthday audience before launching a campaign
  • Data you add through POS integrations (Storehub, Loyverse, Shopify) may not include gender or date of birth. Those fields need to be filled in manually or through the customer portal
  • Exports respect the filters on your customer list — so you can export only female customers, or only those born in June, and keep the file small

Need Help?

Reach out to our support team — we're happy to help you set up filters, export your data, or scope a custom report.

What's Next?

Video transcript: What Customer Demographic Data You Have and How to Use It
Pixalink keeps each customer's gender, date of birth and join date. This video shows how to see them, filter by them, and export them. In the Admin Panel, open CRM in the left menu, then select Customers. Gender and Date of Birth are hidden at first. Click the Column manager icon. Tick Gender. Then tick Date of Birth. Click Apply columns. Both columns now show. To narrow the list, click the filter icon. In Gender, choose who you want to see. You can combine these filters. Gender is Male or Female. Birthday Month shows everyone born in a month, handy for birthday promos. Age takes a From Age and a To Age. And Joined At finds customers who joined in a date range. In Birthday Month, pick a month to see whose birthday is coming up. To work in Excel or Google Sheets, open the Actions menu. Click Export Customers, and include Gender and Date of Birth in the columns. When the file is ready, its download link appears under the bell at the top of the Admin Panel. The export only includes the customers your filters show, so your filters carry over. There are no gender or age charts in the Admin Panel yet, so use a pivot table to count by gender, and work out age from the date of birth. Now you can find the right customers for every promotion. Need a report the Admin Panel doesn't have? Contact our support team.

Was this article helpful?

Thank you for your feedback!

0 found this helpful 0 did not

Search