Merchant Transaction Risk Scoring
This dataset provides granular records of merchant transactions scored for risk, including transaction details, merchant and customer identifiers, risk assessment metrics, and compliance/fraud flags. It enables financial institutions to identify suspicious activity, support regulatory compliance, and optimize fraud detection workflows with actionable insights.
Sample rows
preview · 8 of 200 rows · all 19 columns| transaction_idstring | risk_levelstring | transaction_amountfloat | compliance_flagboolean | reviewed_bystring | merchant_idstring | merchant_namestring | merchant_categorystring | transaction_datetimedatetime | currencystring | payment_methodstring | customer_idstring | customer_countrystring | risk_scorefloat | fraud_flagboolean | review_statusstring | review_datetimedatetime | merchant_countrystring | risk_reasonstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TX0000001 | low | 15.99 | false | system_auto | MRC001 | BrightMart | retail | 2024-05-03T10:16:29Z | USD | credit_card | CUST1001 | US | 0.08 | false | cleared | 2024-05-03T10:18:45Z | US | Transaction amount within typical range; no suspicious activity. |
| TX0000002 | low | 34.25 | false | system_auto | MRC002 | Gourmet Foods | food | 2024-05-03T12:09:54Z | USD | debit_card | CUST1002 | US | 0.13 | false | cleared | 2024-05-03T12:12:13Z | US | Regular debit card purchase; same-country customer. |
| TX0000003 | high | 1200.75 | true | review_team_east | MRC003 | TechZone | electronics | 2024-05-03T14:22:38Z | USD | bank_transfer | CUST1003 | CA | 0.75 | false | escalated | 2024-05-03T14:38:12Z | US | Large electronics purchase; cross-border bank transfer. |
| TX0000004 | high | 899.99 | true | global_review_team | MRC004 | TravelNow | travel | 2024-05-03T07:10:05Z | GBP | bank_transfer | CUST1004 | DE | 0.81 | false | escalated | 2024-05-03T07:26:30Z | GB | High-value travel booking; cross-border transaction. |
| TX0000005 | high | 120.5 | true | review_team_france | MRC005 | FuelExpress | fuel | 2024-05-04T18:44:20Z | EUR | debit_card | CUST1005 | FR | 0.71 | false | escalated | 2024-05-04T19:01:19Z | DE | High fuel spend; foreign customer detected. |
| TX0000006 | critical | 49999.99 | true | fraud_team_global | MRC006 | SoftLogic | software | 2024-05-04T09:53:42Z | USD | bank_transfer | CUST1006 | IN | 0.96 | true | confirmed_fraud | 2024-05-04T10:28:33Z | US | Exceptionally high bank transfer; flagged for manual review. |
| TX0000007 | low | 22 | false | system_auto | MRC001 | BrightMart | retail | 2024-05-04T11:21:53Z | USD | debit_card | CUST1007 | US | 0.09 | false | cleared | 2024-05-04T11:23:17Z | US | Routine retail purchase using debit card. |
| TX0000008 | low | 62.45 | false | system_auto | MRC007 | FreshMart | grocery | 2024-05-04T08:06:40Z | USD | credit_card | CUST1008 | US | 0.12 | false | cleared | 2024-05-04T08:09:11Z | US | Grocery purchase; regular customer profile. |
| TX0000009 | medium | 0.99 | true | blank | MRC008 | CafeGrind | food | 2024-05-05T09:19:02Z | USD | mobile_payment | CUST1009 | US | 0.23 | false | pending | blank | US | Micro-payment; first-time customer. |
| TX0000010 | critical | 99999.99 | true | fraud_team_europe | MRC009 | ElexWorld | electronics | 2024-05-05T15:39:38Z | EUR | bank_transfer | CUST1010 | RU | 1 | true | confirmed_fraud | 2024-05-05T16:20:01Z | DE | Maximum allowed transaction; flagged as critical risk. |
| TX0000011 | low | 0 | false | system_auto | MRC010 | QuickFuel | fuel | 2024-05-05T20:01:43Z | USD | cash | CUST1011 | US | 0 | false | cleared | 2024-05-05T20:04:37Z | US | Zero amount test case for system validation. |
| TX0000012 | high | 350 | true | review_team_france | MRC011 | GlobalComm | communications | 2024-05-06T13:03:17Z | GBP | other | CUST1012 | FR | 0.78 | false | escalated | 2024-05-06T13:24:02Z | GB | High value and less common payment method. |
| TX0000013 | low | 7.25 | false | system_auto | MRC012 | VeggieMarket | grocery | 2024-05-06T08:40:09Z | EUR | credit_card | CUST1013 | FR | 0.05 | false | cleared | 2024-05-06T08:42:23Z | FR | Low-value grocery transaction. |
| TX0000014 | high | 1000 | true | global_review_team | MRC013 | FastTravel | travel | 2024-05-07T16:55:51Z | USD | bank_transfer | CUST1014 | CA | 0.85 | false | escalated | 2024-05-07T17:20:18Z | US | High-value travel booking; cross-border transfer. |
| TX0000015 | medium | 299.99 | false | blank | MRC014 | SmartSoft | software | 2024-05-07T11:23:38Z | USD | credit_card | CUST1015 | US | 0.47 | false | pending | blank | US | Medium-value software purchase; regular customer. |
| TX0000016 | high | 250 | true | review_team_germany | MRC015 | GlobalFuel | fuel | 2024-05-08T08:09:12Z | EUR | debit_card | CUST1016 | DE | 0.68 | false | escalated | 2024-05-08T08:34:10Z | DE | Above-average fuel spend; flagged country. |
| TX0000017 | low | 0.01 | false | system_auto | MRC016 | FreshCafe | food | 2024-05-08T15:42:50Z | USD | cash | CUST1017 | US | 0.16 | false | cleared | 2024-05-08T15:43:32Z | US | Micro-payment for system edge-case validation. |
| TX0000018 | low | 19.99 | false | system_auto | MRC017 | BookBarn | retail | 2024-05-08T14:20:36Z | USD | debit_card | CUST1018 | US | 0.11 | false | cleared | 2024-05-08T14:23:19Z | US | Routine book retail purchase. |
| TX0000019 | low | 55.9 | false | system_auto | MRC018 | ShopSmart | retail | 2024-05-09T11:15:11Z | USD | credit_card | CUST1019 | US | 0.17 | false | cleared | 2024-05-09T11:19:14Z | US | Retail transaction; regular customer. |
| TX0000020 | high | 505 | true | review_team_north | MRC019 | TechHive | electronics | 2024-05-09T16:31:54Z | USD | bank_transfer | CUST1020 | US | 0.79 | false | escalated | 2024-05-09T16:59:27Z | US | Large electronics spend; bank transfer flagged. |
What the 200 rows show
from the 200-row sampleCritical (risk level) stands out: mean transaction_
- 45%compliance_
flag = true - 44.4median transaction_
amount - 4review statuses
- 6currencies
- 6payment methods
- 8merchant categories
Median 44.4, from 0.0 to 100,000.
- string 13
- float 2
- datetime 2
- boolean 2
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
transaction_id | string | Unique identifier for each merchant transactionunique | TX0000001 |
merchant_id | string | Unique identifier for the merchant involved in the transaction | MRC001 |
merchant_name | string | Name of the merchant | BrightMart |
merchant_category | string | Category or industry of the merchant (e.g., retail, food, electronics)8 categories | retail |
currency | string | Currency code used for the transaction (ISO 4217 format, e.g., USD, EUR)6 currencies | USD |
payment_method | string | Method of payment used for the transaction (e.g., credit_card, debit_card, bank_transfer, cash)6 values | credit_card |
customer_id | string | Unique identifier for the customer making the transaction | CUST1001 |
customer_country | string | Country of the customer involved in the transaction | US |
risk_level | string | Categorical risk level assigned to the transaction (e.g., low, medium, high, critical)low · medium · high · critical | low |
risk_reason | string | Short description or reason for the assigned risk score (e.g., suspicious pattern, large amount, flagged merchant)optional | Routine grocery purchase |
review_status | string | Status of transaction review (e.g., pending, cleared, escalated, confirmed_fraud)pending · cleared · escalated · confirmed_fraud | cleared |
reviewed_by | string | Identifier for the analyst or system that reviewed the transactionoptional | system_auto |
merchant_country | string | Country where the merchant is registered or operates8 countries | US |
| Numbers 2 columns | |||
transaction_amount | float | Total monetary value of the transaction0 or more | 15.99 |
risk_score | float | Calculated risk score for the transaction (e.g., 0.0 to 1.0, where higher indicates greater risk)0 to 1 | 0.08 |
| Dates and times 2 columns | |||
transaction_datetime | datetime | Date and time when the transaction occurred | 2024-05-03T10:16:29Z |
review_datetime | datetime | Date and time when the transaction was reviewedoptional | 2024-05-03T10:18:45Z |
| True or false 2 columns | |||
compliance_flag | boolean | Indicates if the transaction triggered a compliance alert or requires review | false |
fraud_flag | boolean | Indicates if the transaction is suspected or confirmed as fraudulent | false |
Use it for
A finance dashboard
The compliance_
flag rate, transaction_ amount by risk_ level and a breakdown of reviewed_ by. Excel, Power BI or Tableau. Why do the 25 critical rows have a mean transaction_
amount of 51,350? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Transactions200TX000000115.99lowTX00000031200.75highTX0000004899.99high
A software demo
Believable transactions with merchant_
id, merchant_ name and merchant_ category to fill a screen in front of a buyer.
blueprint · merchant-transaction-risk-scoring
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 19 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.
- Log transaction amount and location
- Include merchant category
- Flag repeat high-value transactions
- Score based on historical risk
- Exclude government merchants
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- merchant-transaction-risk-scoring