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
refund_datedateDate the refund was processed2024-05-02
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_amountrefund_dateproduct_categoryproduct_urlshipment_statussubscription_typeviewed_product_nameviewed_product_id
2024-04-15Gaggia Classic Pro Espresso MachineB07WQBQJ5X1543.29543.29112-3456789-0123456Amazon.comVisaDeliveredKitchen & Diningamazon.com/dp/B07WQBQJ5XDeliveredBreville Barista Express ImpressB07KC5DWCC
2024-04-18365 by Whole Foods Market Organic Whole Milk, 64 fl ozWF-099876123424.498.98112-3456789-0987654Whole Foods MarketMastercardDeliveredGroceryDelivered
2024-04-22Nature Made Vitamin D3 2000 IU, 250 SoftgelsB004U3Y9FU112.7412.74114-2233445-0011223Amazon.comVisaDeliveredHealth & Householdamazon.com/dp/B004U3Y9FUDeliveredSubscribe & Save
2024-04-25Brooks Ghost 15 Running Shoes, Women's 8.5B0B2P5J9TT1139.95139.95112-9988776-0554433Amazon.comGift CardRefunded139.952024-05-02Shoesamazon.com/dp/B0B2P5J9TTReturnedHoka Clifton 9B0BWZT8R4Q
2024-05-01Hanes Men's ComfortSoft T-Shirt, 4-PackB07MGVJP1Q118.018.0113-5566778-0099887Amazon.comMastercardDeliveredClothingamazon.com/dp/B07MGVJP1QDelivered
2024-05-03Anker USB-C to USB-C Cable, 6ft 2-PackB08D6FQHX9215.9931.98114-7788990-0223344Amazon.comVisaDeliveredElectronicsamazon.com/dp/B08D6FQHX9Delivered
2024-05-09Blue Buffalo Life Protection Adult Dog Food, 30 lbB0017JEUW4164.9864.98112-1122334-0667788Amazon.comVisaDeliveredPet Suppliesamazon.com/dp/B0017JEUW4DeliveredSubscribe & SaveHill's Science Diet Adult Dog FoodB000NSGNUK
2024-05-12Atomic Habits by James Clear (Hardcover)B07RFSSYBH111.9811.98113-4455667-0889900Amazon.comMastercardDeliveredBooksamazon.com/dp/B07RFSSYBHDelivered

Representative synthetic records — no real consumer data. Scroll horizontally to see all fields.

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_agespostal_codecounty
29Female$30,000 to $34,999Single, never marriedSome college - no degreeEmployed full-timeNoBlack, or African AmericanNo, not of Hispanic, Latino, or Spanish origin30310Fulton, GA
41Female$75,000 to $99,999MarriedBachelor's degree (BA, BS)Employed full-timeYesWhiteNo, not of Hispanic, Latino, or Spanish originGirl age 4|Boy age 778745Travis, TX
34Male$50,000 to $74,999MarriedAssociates degree (AA, AS, AB)Self-employed full-timeYesWhiteYes, of Hispanic OriginBoy age 285705Pima, AZ
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 origin98008King, WA
23Female$15,000 to $19,999Single, never marriedHigh school graduateStudentNoWhiteNo, not of Hispanic, Latino, or Spanish origin43055Licking, OH
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 1560201Cook, IL

Representative synthetic records — no real consumer data. 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