Credit Card Spend Pattern Clusters
This dataset contains anonymized credit card transaction records, enriched with behavioral cluster assignments and key transaction attributes such as merchant category, transaction type, and customer demographics. Designed for segmentation and marketing analytics, it enables organizations to identify spending patterns, target customer segments, and optimize marketing strategies.
Sample rows
preview · 8 of 200 rows · all 15 columns| transaction_idstring | card_typestring | amountfloat | is_onlineboolean | merchant_categorystring | customer_idstring | transaction_datetimedatetime | merchant_namestring | transaction_typestring | currencystring | countrystring | cluster_idinteger | cluster_labelstring | customer_age_groupstring | customer_genderstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TXN0001 | Visa | 87.54 | false | Grocery | CUST1001 | 2024-04-21T14:22:18Z | Fresh Foods | purchase | USD | US | 1 | Grocery Shopper | 26-35 | Female |
| TXN0002 | MasterCard | 23.99 | false | Dining | CUST1002 | 2024-05-02T19:44:03Z | Urban Eats | purchase | CAD | CA | 2 | Casual Diner | 26-35 | Male |
| TXN0003 | Discover | 0.01 | true | Fee | CUST1003 | 2024-05-09T08:15:59Z | blank | fee | EUR | NL | 11 | Credit Seeker | 51+ | Unknown |
| TXN0004 | Amex | 1500000 | false | Real Estate | CUST1004 | 2024-04-30T16:06:32Z | Prime Realty | purchase | USD | US | 7 | Ultra High Net Worth | 51+ | Male |
| TXN0005 | Visa | 59.9 | true | Digital Goods | CUST1005 | 2024-05-11T21:18:44Z | AppPlay | purchase | GBP | GB | 5 | Digital Enthusiast | 18-25 | Other |
| TXN0006 | MasterCard | 0 | true | Dining | CUST1006 | 2024-04-22T12:33:17Z | blank | refund | CAD | CA | 2 | Casual Diner | 26-35 | Female |
| TXN0007 | Visa | 32.8 | false | Grocery | CUST1007 | 2024-04-25T10:46:00Z | Market Lane | purchase | USD | US | 1 | Grocery Shopper | 26-35 | Male |
| TXN0008 | Visa | 75 | true | Electronics | CUST1008 | 2024-05-04T15:27:11Z | Tech Haven | purchase | USD | US | 3 | Tech Savvy | 18-25 | Female |
| TXN0009 | Amex | 5000 | false | Luxury | CUST1009 | 2024-05-10T11:39:49Z | Elite Jewelers | purchase | AUD | AU | 7 | Ultra High Net Worth | 51+ | Female |
| TXN0010 | MasterCard | 150 | false | Travel | CUST1010 | 2024-04-29T13:04:33Z | FlyAway | purchase | CNY | CN | 6 | Frequent Traveler | 36-50 | Female |
| TXN0011 | Visa | 39.49 | false | Dining | CUST1011 | 2024-05-08T17:43:12Z | Bistro Bay | purchase | USD | US | 2 | Casual Diner | 26-35 | Male |
| TXN0012 | Other | 350 | false | Automobile | CUST1012 | 2024-04-18T20:55:01Z | AutoElite | purchase | JPY | JP | 8 | Big Spender | 51+ | Female |
| TXN0013 | Discover | 29.99 | true | Entertainment | CUST1013 | 2024-04-26T09:11:23Z | Movie Magic | purchase | CHF | CH | 5 | Digital Enthusiast | 18-25 | Male |
| TXN0014 | Visa | 54.32 | false | Grocery | CUST1001 | 2024-05-06T18:20:14Z | Fresh Foods | purchase | USD | US | 1 | Grocery Shopper | 26-35 | Female |
| TXN0015 | Visa | 2050.5 | false | Travel | CUST1014 | 2024-05-01T06:02:05Z | SkyJet | purchase | USD | US | 6 | Frequent Traveler | 36-50 | Male |
| TXN0016 | MasterCard | 2.5 | true | Public Transport | CUST1015 | 2024-04-27T11:19:33Z | MetroCard | purchase | EUR | DE | 10 | Commuter | 18-25 | Female |
| TXN0017 | Other | 350 | false | Health | CUST1016 | 2024-05-07T23:47:58Z | Wellness Hub | purchase | USD | US | 9 | Health Focused | 51+ | Female |
| TXN0018 | Discover | 1.99 | true | Fee | CUST1017 | 2024-05-03T03:33:45Z | blank | fee | CAD | CA | 11 | Credit Seeker | 26-35 | Male |
| TXN0019 | Visa | 500 | true | Electronics | CUST1018 | 2024-04-20T13:55:16Z | Tech Haven | purchase | USD | US | 3 | Tech Savvy | 26-35 | Female |
| TXN0020 | MasterCard | 100 | false | Grocery | CUST1019 | 2024-04-19T08:00:00Z | Green Basket | purchase | USD | US | 1 | Grocery Shopper | 36-50 | Male |
What the 200 rows show
from the 200-row sampleAmex (card type) stands out: mean amount is 717,574, against 691.5 for the rest.
- 38%is_
online = true - 75.0median amount
- 4transaction types
- 4customer age groups
- 4customer genders
- 8currencies
Median 75.0, from 0.0 to 2,500,000.
- string 11
- integer 1
- float 1
- datetime 1
- boolean 1
Columns
15 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
transaction_id | string | Unique anonymized identifier for each credit card transactionunique | TXN0001 |
customer_id | string | Anonymized unique identifier for the credit card holder | CUST1001 |
merchant_category | string | Category of the merchant where the transaction took place (e.g., Grocery, Dining, Travel) | Grocery |
merchant_name | string | Anonymized or generic name of the merchantoptional | Fresh Foods |
transaction_type | string | Type of transaction (e.g., purchase, refund, cash_advance)purchase · refund · cash_advance · payment · fee | purchase |
currency | string | ISO 4217 currency code for the transaction (e.g., USD, EUR)8 currencies | USD |
country | string | Country where the transaction was made9 countries | US |
cluster_label | string | Descriptive label for the behavioral cluster (e.g., Frequent Traveler, Grocery Shopper)11 labels · optional | Grocery Shopper |
card_type | string | Type of credit card used (e.g., Visa, MasterCard, Amex, Discover)Visa · MasterCard · Amex · Discover · Other · optional | Visa |
customer_age_group | string | Anonymized age group of the customer (e.g., 18-25, 26-35, 36-50, 51+)18-25 · 26-35 · 36-50 · 51+ · optional | 26-35 |
customer_gender | string | Anonymized gender of the customer (e.g., Male, Female, Other, Unknown)Male · Female · Other · Unknown · optional | Female |
| Numbers 2 columns | |||
amount | float | Transaction amount in the local currency0 or more | 87.54 |
cluster_id | integer | Identifier for the behavioral cluster assigned to this transaction or customer1 or more | 1 |
| Dates and times 1 column | |||
transaction_datetime | datetime | Timestamp when the transaction occurred | 2024-04-21T14:22:18Z |
| True or false 1 column | |||
is_online | boolean | Indicates if the transaction was made online (true) or in-store (false) | false |
Use it for
A finance dashboard
The is_
online rate, amount by card_ type and a breakdown of merchant_ category. Excel, Power BI or Tableau. Why do the 25 Amex rows have a mean amount of 717,574?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Transactions200TXN000187.54VisaTXN00030.01DiscoverTXN000559.9Visa
A software demo
Believable transactions with customer_
id, transaction_ datetime and amount to fill a screen in front of a buyer.
blueprint · credit-card-spend-pattern-clusters
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 15 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Each transaction: amount, merchant, category
- Users grouped by spend cluster (labels)
- High-value and outlier clusters present
- Time-of-day and channel (online/offline) encoded
- Promotional impact observed per cluster
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- credit-card-spend-pattern-clusters