• Other
  • 28 columns
  • 100 rows
  • 8 formats

Device Trade-In and Upgrade Eligibility

This dataset provides a detailed record of device trade-in and upgrade eligibility programs, capturing customer, device, contract, shipping, and financial credit information. It enables robust analysis of upgrade patterns, trade-in valuations, logistics efficiency, and customer satisfaction, supporting operational optimization and targeted marketing strategies.

  • last updated 1 Nov 2025
  • by GoMask
The brief that made it

Optimizing device upgrade and trade-in program operations

Sample rows

preview · 8 of 100 rows · all 28 columns
trade_in_idstringdevice_conditionstringtrade_in_valuationfloatupgrade_eligiblebooleannew_device_modelstringaccount_idstringcustomer_namestringcustomer_emailstringdevice_makestringdevice_modelstringdevice_serial_numberstringcontract_term_monthsintegercontract_start_datedatecontract_end_datedatenew_device_makestringnew_device_order_datedateshipping_tracking_numberstringshipping_carrierstringshipping_statusstringshipping_street_addressstringshipping_citystringshipping_statestringshipping_postal_codestringshipping_countrystringold_device_return_datedateold_device_return_statusstringaccount_credit_amountfloataccount_credit_datedate
TID_8aK9GvPqGood510trueiPhone 15 Pro MaxACC_001Jessica Millerjmiller_001@gmail.comAppleiPhone 13 ProSN_APP_001242022-03-102024-03-10Apple2024-03-12TRK_00001_USPSUSPSDelivered1122 Applewood LnSan JoseCA95123USA2024-03-16Inspected5102024-03-19
TID_7bH6RdVtFair320trueGalaxy S24 UltraACC_002Marcus Leemarcus_lee22@gmail.comSamsungGalaxy S21SN_SMS_002182022-09-012024-03-01Samsung2024-03-03TRK_00002_FEDEXFedExShipped47 Main StHoustonTX77002USA2024-03-09Received3202024-03-12
TID_4cL7PnWxGood420truePixel 8 ProACC_003Priya Anandpriya.anand@outlook.comGooglePixel 7SN_GGL_003122023-04-182024-04-18Google2024-04-19TRK_00003_UPSUPSPending5809 Oakridge AveSeattleWA98105USA2024-04-23Pendingblankblank
TID_9dM2QpSrBroken90trueiPhone 14ACC_004Ahmed Hassanahassan_004@yahoo.comAppleiPhone 12SN_APP_004242021-04-052023-04-05Apple2023-04-06TRK_00004_DHLDHLDelivered221 Baker StChicagoIL60616USA2023-04-11Received902023-04-12
TID_3eV4SkUwNew650trueGalaxy S24ACC_005Emily Johnsonemily.johnson123@gmail.comSamsungGalaxy S22SN_SMS_005122023-04-012024-04-01Samsung2024-04-02TRK_00005_USPSUSPSShipped88 Willow LnSan DiegoCA92101USA2024-04-07Inspected6502024-04-10
TID_2fN5TqXyPoor120trueiPhone 15ACC_006David Kimdkim_006@gmail.comAppleiPhone SE (2022)SN_APP_006182022-10-202024-04-20Apple2024-04-21TRK_00006_FEDEXFedExPending15 Maple StBostonMA02115USA2024-04-25Pendingblankblank
TID_6gJ3PwZbFair230trueGalaxy S24 UltraACC_007Linda Wulinda.wu77@gmail.comSamsungGalaxy S20 FESN_SMS_007242022-03-152024-03-15Samsung2024-03-18TRK_00007_UPSUPSDelivered701 Pine RdPhoenixAZ85004USA2024-03-21Inspected2302024-03-22
TID_1hK8QxCvGood370falseblankACC_008Carlos Riverac.rivera_008@hotmail.comGooglePixel 6 ProSN_GGL_008242022-08-112024-08-11blankblankblankblankblankblankblankblankblankblankblankblankblankblank

What the 100 rows show

from the 100-row sample

New (device condition) stands out: mean trade_in_valuation is 683.0, against 264.9 for the rest.

  • 75%upgrade_eligible = true
  • 297.5median trade_in_valuation
  • 3device makes
  • 3new device makes
  • 4shipping carriers
  • 4shipping statuses
Mean trade_in_valuation by device_condition100 rows
0400800683.0New15 rows453.1Good32 rows230.2Fair26 rows96.4Poor14 rows52.4Broken13 rows
trade_in_valuation100 rows, in bands of 100
01020201713121461080400800trade_in_valuation →

Median 297.5, from 10.0 to 800.0.

new_device_model75 rows with a value · 25 left blank
  1. iPhone 15 Pro10
  2. Galaxy S24 Ultra9
  3. Galaxy S249
  4. iPhone 158
  5. Pixel 8 Pro7
  6. Pixel 87
  7. iPhone 146
  8. iPhone 15 Pro Max4
  9. iPhone 14 Pro3
  10. Pixel 72
28 columns by typefrom the column list below
  • string 19
  • integer 1
  • float 2
  • date 5
  • boolean 1

Columns

28 columns in four groups
blueprint · 28 columns
columntypedescriptionexample
Text 19 columns
trade_in_idstringUnique identifier for each device trade-in transaction.uniqueTID_8aK9GvPq
account_idstringUnique identifier for the customer account associated with the trade-in.ACC_001
customer_namestringFull name of the customer participating in the upgrade program.Jessica Miller
customer_emailstringEmail address of the customer.jmiller_001@gmail.com
device_makestringManufacturer of the device being traded in (e.g., Apple, Samsung).3 makesApple
device_modelstringModel of the device being traded in (e.g., iPhone 12, Galaxy S21).iPhone 13 Pro
device_serial_numberstringSerial number of the device being traded in.uniqueSN_APP_001
device_conditionstringAssessed condition of the device (e.g., New, Good, Fair, Poor, Broken).New · Good · Fair · Poor · BrokenGood
new_device_makestringManufacturer of the new device being ordered.3 makes · optionalApple
new_device_modelstringModel of the new device being ordered.optionaliPhone 15 Pro Max
shipping_tracking_numberstringTracking number for the shipment of the new device.unique · optionalTRK_00001_USPS
shipping_carrierstringShipping carrier used for the new device delivery.4 carriers · optionalUSPS
shipping_statusstringCurrent status of the new device shipment (e.g., Pending, Shipped, Delivered, Returned).Pending · Shipped · Delivered · Returned · optionalDelivered
shipping_street_addressstringStreet address for shipping the new device.optional1122 Applewood Ln
shipping_citystringCity for shipping the new device.optionalSan Jose
shipping_statestringState for shipping the new device.optionalCA
shipping_postal_codestringPostal code for shipping the new device.optional95123
shipping_countrystringCountry for shipping the new device.4 countries · optionalUSA
old_device_return_statusstringStatus of the old device return (e.g., Pending, Received, Inspected, Rejected).Pending · Received · Inspected · Rejected · optionalInspected
Numbers 3 columns
trade_in_valuationfloatMonetary value assigned to the traded-in device based on its condition.0 or more510
contract_term_monthsintegerLength of the device contract or financing term in months.1 to 3624
account_credit_amountfloatAmount credited to the customer's account for the trade-in.0 or more · optional510
Dates and times 5 columns
contract_start_datedateStart date of the device contract or financing agreement.2022-03-10
contract_end_datedateEnd date of the device contract or financing agreement.2024-03-10
new_device_order_datedateDate the new device was ordered.optional2024-03-12
old_device_return_datedateDate the old device was returned by the customer.optional2024-03-16
account_credit_datedateDate the account credit was processed.optional2024-03-19
True or false 1 column
upgrade_eligiblebooleanIndicates if the customer is eligible for a device upgrade based on contract status.true

Use it for

  • upgrade eligib…75%75 of 100 rowsmean trade in valuati…683.0New453.1Good230.2Fair96.4Poor

    A dashboard

    The upgrade_eligible rate, trade_in_valuation by device_condition and a breakdown of new_device_model. Excel, Power BI or Tableau.

  • Why do the 15 New rows have a mean trade_in_valuation of 683.0?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable trade_in_id values with account_id, customer_name and customer_email to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 28 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset100 rows28 columns
Yours1,000 rows28 columnsshipping_street_address: UK only

blueprint · device-trade-in-and-upgrade-eligibility

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 28 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.

Rules it was built with
  • Subscriber MSISDN and current device IMEI
  • Upgrade eligibility: months since last upgrade, contract term, financing balance
  • Trade-in program: old device make/model, condition (excellent, good, fair, poor)
  • Trade-in valuation: market value, promotional bonus, instant credit
  • Device financing: installment plan, monthly payment, remaining balance
  • New device order: make/model/color/storage, order date, shipping status
  • Old device return: return kit sent, device received, inspection, account credit
  • Early upgrade programs: annual upgrade for high-tier plans
Rows
Open the blueprint in Data Factory

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
device-trade-in-and-upgrade-eligibility

More in Other

Browse all
Also in OtherRetail Payment Method AdoptionSmall Retailer Sales TransactionsRetail In-Store Foot Traffic CountsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.