Dark Mode
US E-commerce Profitability Analysis 2020
E-commerce & Online Transactions
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
This dataset provides a detailed collection of United States e-commerce records from the year 2020. Its primary purpose is to assist users in identifying overall trends and uncovering hidden patterns within the US e-commerce marketplace. The information contained is suitable for deep dives into sales performance, customer behaviour, and profitability across various segments and regions.
Columns
- Order Date: Represents the date of the order.
- Row ID: Identifies each unique row in the dataset.
- Order ID: Represents a unique identifier for each order.
- Ship Mode: Details the shipping method used for the order, such as Standard Class or Second Class.
- Customer ID: Represents a unique identifier for each customer.
- Segment: Indicates the customer segment, e.g., Consumer or Corporate.
- Country: Specifies the country where the transaction took place, which is consistently the United States.
- City: Represents the city of the transaction, with common locations including New York City and Los Angeles.
- State: Denotes the state of the transaction, such as California or New York.
- Postal Code: Represents the postal code associated with the transaction.
- Region: Indicates the geographical region within the United States, including West and East.
- Product ID: Represents a unique identifier for each product.
- Category: Indicates the product category, such as Office Supplies or Furniture.
- Sub-Category: Provides a more granular product sub-category, for instance, Binders or Paper.
- Product Name: Represents the specific name of the product.
- Sales: Represents the sales value for the given transaction, with a maximum value around £14,000.
- Quantity: Represents the number of items sold in the transaction, ranging from 1 to 14.
- Discount: Represents any discount applied to the transaction, ranging from 0 to 0.8.
- Profit: Represents the profit generated from the transaction, which can range from approximately -£3,840 to £6,720.
Distribution
The dataset is provided as a CSV file, named "US E-commerce records 2020.csv". It has a file size of 675.66 kB and consists of 19 columns with 3312 individual records. Data files are typically in CSV format and a sample file will be updated separately to the platform.
Usage
This dataset is ideally suited for data analysis, data visualisation, and market research initiatives. It can be used to explore overall trends in the US e-commerce market, identify top-performing products or regions, analyse sales and profit patterns, and understand the impact of discounts. It is particularly useful for developing predictive models or business intelligence dashboards related to online retail.
Coverage
The dataset's geographic scope is limited to the United States. All records pertain to e-commerce activities within this country. The time range covered is 2020, providing a snapshot of transactions for that specific year. There are no specific notes on data availability for particular demographic groups, but the data includes customer segments.
License
CC0: Public Domain
Who Can Use It
This dataset is useful for a variety of users, including:
- Data Analysts: For uncovering insights into e-commerce performance.
- Market Researchers: To understand consumer behaviour and market trends.
- Businesses: For strategic planning, identifying growth opportunities, and optimising sales.
- Students and Academics: For research projects or learning about e-commerce analytics.
- Data Scientists: For building and testing predictive models related to sales, profit, or customer segmentation.
Dataset Name Suggestions
- US E-commerce Sales Performance 2020
- United States Online Retail Transactions 2020
- 2020 USA E-commerce Records and Trends
- North American E-commerce Insights 2020
- US E-commerce Profitability Analysis 2020
Attributes
Original Data Source: US E-commerce Profitability Analysis 2020
QUALITY