Data schema

A field-level reference for the data Ario delivers. Every field below comes with its type, a plain-language description, and a real example value — so your team knows exactly what to expect before a single account is connected.

Purchase data

Transaction-level records of what a consumer actually bought. Fields are organized by availability: baseline fields are present across virtually all sources; enhanced and browse fields are source-dependent and confirmed per engagement.

01

Baseline fields

Retrieved across virtually all sources.

FieldTypeDescriptionExample
order_datedateDate the order was placed2024-04-15
product_namestringFull product name as listed on the source platformGaggia Classic Pro Espresso Machine
product_idstringPlatform-native product identifier (e.g., ASIN, UPC)B07WQBQJ5X
quantitydecimalUnits purchased in this line item1.0 / 0.8
unit_pricedecimalPrice per unit before discounts543.29
order_totaldecimalTotal amount charged for the order543.29
order_idstringPlatform order identifier112-3456789-0123456
channelenumFulfillment channel on the source platformAmazon.com / Whole Foods Market
02

Enhanced fields

Source-dependent; coverage confirmed per engagement.

FieldTypeDescriptionExample
payment_method_typeenumInstrument type only — never the account or card numberVisa / Gift Card
refund_statusenumReturn or refund state for this line itemRefunded / Delivered
refund_amountdecimalAmount credited back to the consumer139.95
product_categorystringRetailer-assigned product categoryKitchen & Dining
product_urlstringURL of the product listing at time of purchaseamazon.com/dp/B07WQBQJ5X
shipment_statusenumLast known shipping stateDelivered
subscription_typeenumRecurring purchase program, if applicableSubscribe & Save
03

Browse & intent

Enhanced; where the source exposes it.

FieldTypeDescriptionExample
viewed_product_namestringProduct viewed but not purchasedBreville Barista Express Impress
viewed_product_idstringPlatform identifier for the viewed itemB07KC5DWCC

Sample purchase data

order_dateproduct_nameproduct_idquantityunit_priceorder_totalorder_idchannelpayment_method_typerefund_statusrefund_amountproduct_categoryproduct_urlshipment_status
2025-01-05Dawn Platinum Plus PowerSuds Liquid Dish Soap, 17.4 oz. EZ-Squeeze BottleB0DPXT543314.9462.62112-1159882-8484010Amazon.comVisaDeliveredHealth & Personal Careamazon.com/dp/B0DPXT5433
2025-01-05WD-40 Specialist White Lithium Grease Spray with SMART STRAW SPRAYS 2 WAYS, 10 OZB00L35DAWQ17.9862.62112-1159882-8484010Amazon.comVisaDeliveredAutomotiveamazon.com/dp/B00L35DAWQDelivered
2025-01-09Jet-Puffed Mini Marshmallows (10 oz Marshmallow Bag)B000VDWXT2119.9919.99112-7086128-9179607Amazon.comGift CardRefunded19.99Grocery & Gourmet Foodamazon.com/dp/B000VDWXT2Returned
2025-01-14365 by Whole Foods Market, Organic Broccoli Florets, 10 Ouncet:40025c3a14eb397513.329.37112-1557640-3787220Amazon FreshMastercardDeliveredGrocery & Gourmet FoodDelivered
2025-03-10Whole Foods Market, Organic Spring Mix, 5 OZB07PHP7CKY12.916.9112-8498270-4423522Whole Foods MarketMastercardDeliveredGrocery & Gourmet Foodamazon.com/dp/B07PHP7CKYPurchased in store
2025-01-16Vibrant Life 24 Piece Value Pack Cat Toyst:walmart:bc94675f5842a0a515.2415.81INV-2135031768WalmartDeliveredPet Supplies
2025-02-26Samsung 23 cu. ft. Bespoke Counter Depth 4-Door French Door Refrigerator with Beverage Center, White Glasst:costco:be7430b327ead7e712099.992164.59INV-8468555669CostcoDeliveredAppliances
2025-03-02Grade A Large Eggs - 18ct - Good & Gather™ (Packaging May Vary)t:target:bb455b376f99391f12.199.17ORD-1121894538TargetDeliveredGrocery & Gourmet Food
2025-08-23Unreal Dark Chocolate Coconut Minis, 15.3 ozt:costco:2c92a929411877b1226.0852.16TXN-4554177379Costco Same-DayDeliveredGrocery & Gourmet Food
2025-07-19SIGNATURE SELECT ANGEL HAIR PASTA 16 OUNCEt:safeway:a8a77c7279da22d810.986.73SWY-8959781593SafewayDiscoverDeliveredGrocery & Gourmet Food
2025-08-15GENERAL MILLS LUCKY CHARMS CEREAL 10.5 OUNCEt:safeway:a6a01ab9be9efd7711.971.97SWY-2027269440Pak 'n SaveMastercardDeliveredGrocery & Gourmet Food
2025-08-30HERSHEYS MILK CHOCOLATE CANDY BARt:safeway:0f60050384d3d2fc12.292.29SWY-7912518361Jewel-OscoMastercardDeliveredGrocery & Gourmet Food
2025-11-23SIGNATURE SELECT/FARMS POTATOES RUSSET 5LB BAGt:safeway:29751f132972651210.880.88SWY-4841165143Tom ThumbVisaDeliveredGrocery & Gourmet Food
2025-12-09SNICKERS MILK CHOCOLATE PEANUTS CARAMEL NOUGAT BARt:safeway:306770b12575c43511.9917.83SWY-9729122501AlbertsonsVisaDeliveredGrocery & Gourmet Food
2026-03-10LUCERNE CHEESE MOZZARELLA FINE SHREDt:safeway:49197881fb713d1211.661.66SWY-1031788281VonsMastercardDeliveredGrocery & Gourmet Food

15 of 300 records shown — download the full sample above. Scroll horizontally to see all fields.

How product category is defined

Retailers label the same item inconsistently — one espresso machine might read "Kitchen & Dining" on one source and "Small Appliances" on another. Ario resolves every line item to one canonical set of product categories, so the product_category field means the same thing across every source you connect.

These are the 41 top-level product categories.

#Category
1Appliances
2Arts, Crafts & Sewing
3Automotive
4Baby
5Beauty
6Books
7Collectibles & Fine Arts
8Electronics
9Clothing, Shoes & Jewelry
10Clothing, Shoes & Jewelry — Baby
11Clothing, Shoes & Jewelry — Boys
12Clothing, Shoes & Jewelry — Girls
13Clothing, Shoes & Jewelry — Men
14Clothing, Shoes & Jewelry — Women
15Gift Cards
16Grocery & Gourmet Food
17Handmade
18Health & Personal Care
19Home & Kitchen
20Industrial & Scientific
21Kindle Store
22Patio, Lawn & Garden
23Luggage & Travel Gear
24Magazine Subscriptions
25Apps & Games
26Movies & TV
27Digital Music
28CDs & Vinyl
29Musical Instruments
30Office Products
31Computers
32Pet Supplies
33Software
34Sports & Outdoors
35Tools & Home Improvement
36Toys & Games
37Amazon Instant Video
38Vehicles
39Video Games
40Wine
41Cell Phones & Accessories

Demographic data

Verified attributes appended at panel enrollment, joinable to purchase history. Core fields are present for virtually all panelists; extended fields depend on survey completion and are confirmed per engagement.

04

Core demographics

Present for virtually all panelists.

FieldTypeDescriptionExample
ageintegerAge in years34
genderenumSelf-reported genderFemale / Male
household_incomeenumAnnual household income, granular bands$50,000 to $74,999
marital_statusenumMarital statusMarried / Single, never married
education_levelenumHighest level of education completedBachelor's degree (BA, BS)
employment_statusenumCurrent employment statusEmployed full-time
parental_statusbooleanWhether the panelist has childrenYes / No
05

Household & identity

Source-dependent; coverage confirmed per engagement.

FieldTypeDescriptionExample
raceenumSelf-reported raceWhite / Black, or African American
hispanic_originenumHispanic, Latino, or Spanish originYes, of Hispanic Origin
children_agesstringAge and gender of children in household (pipe-delimited)Girl age 4|Boy age 7
military_statusbooleanMilitary affiliation (active or veteran)No
06

Geography

Derived from verified address at PII-safe granularity.

FieldTypeDescriptionExample
postal_codestring5-digit ZIP code78701
countystringCounty and state of residenceTravis, TX
countryenumCountry of residenceUnited States

Sample demographic data

agegenderhousehold_incomemarital_statuseducation_levelemployment_statusparental_statusracehispanic_originchildren_agesmilitary_statuspostal_codecountycountry
29Female$30,000 to $34,999Single, never marriedSome college - no degreeEmployed full-timeNoBlack, or African AmericanNo, not of Hispanic, Latino, or Spanish originNo30310Fulton, GAUnited States
41Female$75,000 to $99,999MarriedBachelor's degree (BA, BS)Employed full-timeYesWhiteNo, not of Hispanic, Latino, or Spanish originGirl age 4|Boy age 7No78745Travis, TXUnited States
34Male$50,000 to $74,999MarriedAssociates degree (AA, AS, AB)Self-employed full-timeYesWhiteYes, of Hispanic OriginBoy age 2Yes85705Pima, AZUnited States
56Female$100,000 to $124,999Separated, divorced or widowedMaster's degree (MA, MS, MEng, MEd, MSW, MBA)Employed full-timeNoAsianNo, not of Hispanic, Latino, or Spanish originNo98008King, WAUnited States
23Female$15,000 to $19,999Single, never marriedHigh school graduateStudentNoWhiteNo, not of Hispanic, Latino, or Spanish originNo43055Licking, OHUnited States
47Male$125,000 to $149,999MarriedProfessional degree beyond a bachelors degree (MD, DDS, DVM, LLB, JD)Employed full-timeYesWhiteNo, not of Hispanic, Latino, or Spanish originGirl age 12|Girl age 15No60201Cook, ILUnited States
28Male$50,000 to $74,999Single, never marriedBachelor's degree (BA, BS)Employed full-timeNoWhiteNo, not of Hispanic, Latino, or Spanish originNo96813Honolulu, HIUnited States
50Female$35,000 to $39,999Separated, divorced or widowedHigh school graduatePrefer not to answerNoWhiteNo, not of Hispanic, Latino, or Spanish originNo70118Orleans, LAUnited States
45Male$150,000 to $199,999MarriedProfessional degree beyond a bachelors degree (MD, DDS, DVM, LLB, JD)Temporarily unemployedYesWhiteNo, not of Hispanic, Latino, or Spanish originGirl age 17|Girl age 14No98501Thurston, WAUnited States
58Female$50,000 to $74,999MarriedAssociates degree (AA, AS, AB)Employed full-timeNoWhiteNo, not of Hispanic, Latino, or Spanish originNo50310Polk, IAUnited States

10 of 200 synthetic records shown — download the full sample above. Scroll horizontally to see all fields.

Data handling & PII

PII defaults

Name, email address, and street address are not transmitted to the enterprise unless explicitly scoped in the engagement contract. Geography is delivered at ZIP and county granularity by default.

Payment instrument details — card numbers, bank account numbers, and full account credentials — are never retrieved or transmitted under any configuration. The payment_method_type field captures the instrument type only (e.g. "Visa").

Enterprise inquiries: enterprise@ariodata.com  ·  Privacy inquiries: privacy@ariodata.com