E-commerce Delivery Address Validation Logs
This dataset provides granular logs of delivery address entry and validation attempts across e-commerce platforms, including error codes, resolution status, and logistics region mapping. It enables detailed analysis of address quality, user correction behavior, and operational bottlenecks, supporting both logistics optimization and improvements to user experience.
Sample rows
preview · 8 of 200 rows · all 17 columns| log_idstring | resolution_statusstring | is_final_addressboolean | error_codestring | user_idstring | platform_idstring | entry_timestampdatetime | validation_attemptinteger | address_streetstring | address_citystring | address_statestring | address_postal_codestring | address_countrystring | validation_statusstring | resolution_timestampdatetime | delivery_region_codestring | error_messagestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cA92kL1p | not-required | true | blank | userA102 | shopify | 2020-03-11T10:14:28Z | 1 | 1501 Broadway | New York | NY | 10036 | US | success | blank | NYC-01 | blank |
| eJ82pKmV | corrected | false | INV_POSTAL | userB203 | amazon | 2021-05-23T15:41:17Z | 1 | 245 Market St | San Francisco | CA | 94105 | US | failed | 2021-05-23T15:43:10Z | SF-03 | Invalid postal code entered for address. |
| gL90rN2b | not-required | true | blank | userC305 | ebay | 2022-09-12T09:22:50Z | 1 | 1010 W Madison St | Chicago | IL | 60607 | US | success | blank | CHI-02 | blank |
| ZpB71hQv | not-required | true | blank | userD406 | walmart | 2023-02-14T13:08:32Z | 1 | 1 Infinite Loop | Cupertino | CA | 95014 | US | success | blank | CUP-01 | blank |
| MdT82jKr | unresolved | false | NOSTREETNUM | userE507 | etsy | 2020-07-19T16:03:19Z | 1 | 221B Baker Street | London | ENG | NW1 6XE | GB | failed | 2020-07-19T16:04:01Z | LDN-ZONE1 | Street number missing from address entry. |
| NfG62zLp | not-required | true | blank | userF608 | rakuten | 2024-01-08T11:25:44Z | 1 | Sumida Riverside 23 | Sumida | TKY | 131-0045 | JP | success | blank | TKY-EAST | blank |
| VkL71mQb | not-required | true | blank | userG709 | flipkart | 2021-11-27T08:55:14Z | 1 | A-55 Sector 62 | Noida | UP | 201301 | IN | success | blank | NOI-NORTH | blank |
| PkB81jQv | auto-corrected | false | MANUAL_REVIEW | userH810 | shopify | 2022-06-21T18:23:09Z | 1 | 300 Yonge Street | Toronto | ON | M5B 2H1 | CA | pending | 2022-06-21T18:24:48Z | TOR-02 | Address flagged for manual review by system. |
| LpC11kNv | not-required | true | blank | userI911 | amazon | 2023-08-17T20:12:35Z | 1 | 45 King St W | Toronto | ON | M5H 1J1 | CA | success | blank | TOR-01 | blank |
| QfN93wLs | not-required | true | blank | userJ012 | ebay | 2021-04-05T09:37:04Z | 1 | 8 Rue de la Paix | Paris | IDF | 75002 | FR | success | blank | PAR-08 | blank |
| VhS41kDp | unresolved | false | BLANK_STREET | userK113 | walmart | 2020-12-28T14:41:12Z | 1 | blank | Houston | TX | 77002 | US | failed | 2020-12-28T14:42:20Z | HOU-03 | Street field left blank in address entry. |
| TnW52zLb | not-required | true | blank | userL214 | shopify | 2023-03-13T12:55:45Z | 1 | 456 South Grand Ave | Los Angeles | CA | 90071 | US | success | blank | LA-02 | blank |
| bJx93mLp | not-required | true | blank | userM315 | amazon | 2021-08-16T17:39:24Z | 1 | 350 Fifth Avenue | New York | NY | 10118 | US | success | blank | NYC-02 | blank |
| rQj72nMb | auto-corrected | false | ADDR_TOO_LONG | userN416 | ebay | 2022-05-09T16:27:18Z | 1 | Kärntner Straße 10 | Vienna | WI | 1010 | AT | failed | 2022-05-09T16:28:50Z | VIE-CENT | Entered address exceeds allowed length. |
| wKp12vRt | not-required | true | blank | userO517 | rakuten | 2023-07-26T10:19:11Z | 1 | 1 Chome-1-2 Oshiage | Sumida | TKY | 131-0045 | JP | success | blank | TKY-01 | blank |
| aLr22kLp | unresolved | false | SUSP_REGION | userP618 | flipkart | 2022-10-02T19:12:34Z | 1 | 101 Marine Drive | Mumbai | MH | 400001 | IN | pending | 2022-10-02T19:14:05Z | MUM-SOUTH | Suspicious region detected for address entry. |
| mJv32gLp | not-required | true | blank | userQ719 | shopify | 2024-04-04T09:13:27Z | 1 | 233 S Wacker Dr | Chicago | IL | 60606 | US | success | blank | CHI-03 | blank |
| xLp12kRv | not-required | true | blank | userR820 | ebay | 2022-02-23T07:56:21Z | 1 | Rua de Santa Catarina 112 | Porto | PRT | 4050-265 | PT | success | blank | POR-01 | blank |
| nJk12rLp | auto-corrected | false | ALT_FORMAT | userS921 | amazon | 2021-10-10T11:17:48Z | 1 | 123 Queen St | Toronto | ON | M5H 2M9 | CA | failed | 2021-10-10T11:18:31Z | TOR-03 | Address format differs from standard expected. |
| vLp81kRv | not-required | true | blank | userT022 | walmart | 2020-06-18T15:30:13Z | 1 | 1200 Main St | Houston | TX | 77001 | US | success | blank | HOU-01 | blank |
What the 200 rows show
from the 200-row sampleNot-required (resolution status) stands out: 129 of its 129 rows have is_
- 73%is_
final_ address = true - 3validation statuses
- 7platforms
- 10address countries
- 18address states
- 22address cities
- string 13
- integer 1
- datetime 2
- boolean 1
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
log_id | string | Unique identifier for each address validation log entryunique | cA92kL1p |
user_id | string | Unique identifier for the user attempting address entry | userA102 |
platform_id | string | Identifier for the e-commerce platform where the address was entered7 platforms | shopify |
address_street | string | Street portion of the delivery address entered by the user | 1501 Broadway |
address_city | string | City portion of the delivery address entered by the user | New York |
address_state | string | State or region portion of the delivery address entered by the user | NY |
address_postal_code | string | Postal or ZIP code of the delivery address entered by the user | 10036 |
address_country | string | Country portion of the delivery address entered by the user10 countries | US |
validation_status | string | Result of the validation attempt (e.g., success, failed, pending)success · failed · pending | success |
error_code | string | Error code returned during validation attempt, if any8 codes · optional | INV_POSTAL |
error_message | string | Human-readable description of the error encountered during validationoptional | Invalid postal code enter… |
resolution_status | string | Indicates if and how the validation error was resolved (e.g., corrected, unresolved, auto-corrected)corrected · unresolved · auto-corrected · not-required | not-required |
delivery_region_code | string | Internal code representing the logistics region for delivery optimizationoptional | NYC-01 |
| Numbers 1 column | |||
validation_attempt | integer | Sequential number of the validation attempt for this address entry1 or more | 1 |
| Dates and times 2 columns | |||
entry_timestamp | datetime | Timestamp when the delivery address was entered | 2020-03-11T10:14:28Z |
resolution_timestamp | datetime | Timestamp when the validation issue was resolved, if applicableoptional | 2021-05-23T15:43:10Z |
| True or false 1 column | |||
is_final_address | boolean | Indicates whether this address entry is the final version used for delivery | true |
Use it for
A logistics dashboard
The is_
final_ address rate, is_ final_ address by resolution_ status and a breakdown of error_ code. Excel, Power BI or Tableau. Why do 145 of 200 rows have is_
final_ address = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs200cA92kL1pnot-requ…eJ82pKmVcorrectedgL90rN2bnot-requ…
A software demo
Believable logs with user_
id, platform_ id and entry_ timestamp to fill a screen in front of a buyer.
blueprint · e-commerce-delivery-address-validation-logs
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 17 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.
- Address entry and validation status
- Error code and resolution event tracking
- Anonymize user and location info
- Flag repeat address failures
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
- e-commerce-delivery-address-validation-logs