We will dive into product data such as pricing, reviews, descriptions, and ratings, as well as revenue and website traffic, to produce recommendations for its marketing and sales teams.
| column | data type | description |
|---|---|---|
product_name |
varchar |
Name of the product |
product_id |
varchar |
Unique ID for product |
description |
varchar |
Description of the product |
| column | data type | description |
|---|---|---|
product_id |
varchar |
Unique ID for product |
listing_price |
float |
Listing price for product |
sale_price |
float |
Price of the product when on sale |
discount |
float |
Discount, as a decimal, applied to the sale price |
revenue |
float |
Amount of revenue generated by each product, in US dollars |
| column | data type | description |
|---|---|---|
product_name |
varchar |
Name of the product |
product_id |
varchar |
Unique ID for product |
rating |
float |
Product rating, scored from 1.0 to 5.0 |
reviews |
float |
Number of reviews for the product |
| column | data type | description |
|---|---|---|
product_id |
varchar |
Unique ID for product |
last_visited |
timestamp |
Date and time the product was last viewed on the website |
| column | data type | description |
|---|---|---|
product_id |
varchar |
Unique ID for product |
brand |
varchar |
Brand of the product |