Blinkit Marketing And Customer Feedback Dashboard by Kaggle | Ecommerce and Consumer Trends

About this Dataset

Blinkit Marketing And Customer Feedback Dashboard

Dataset Overview:
Contains sales data from Blinkit, including product details, order quantities, revenue, and timestamps.
Useful for demand forecasting, price optimization, trend analysis, and business insights.
Helps in understanding customer behavior and seasonal variations in online grocery shopping.
Potential Use Cases:

Time Series Analysis: Analyze sales trends over different periods.
Demand Forecasting: Predict future product demand based on historical data.
Price Optimization: Identify the impact of pricing on sales and revenue.
Customer Behavior Analysis: Understand buying patterns and preferences.
Market Trends: Explore how different factors affect grocery sales performance.
This dataset can be beneficial for data scientists, business analysts, and researchers looking to explore e-commerce and retail trends. Feel free to use it for analysis, machine learning models, and business intelligence projects.

Tables

Blinkit Orders

@kaggle.yashmotiani_blinkit_marketing_and_customer_powerbi_dashbord.blinkit_orders

301.08 KB
5000 rows
10 columns


CREATE TABLE blinkit_orders (
  "order_id" BIGINT,
  "customer_id" BIGINT,
  "order_date" TIMESTAMP,
  "promised_delivery_time" TIMESTAMP,
  "actual_delivery_time" TIMESTAMP,
  "delivery_status" VARCHAR,
  "order_total" DOUBLE,
  "payment_method" VARCHAR,
  "delivery_partner_id" BIGINT,
  "store_id" BIGINT
);

Blinkit Order Items

@kaggle.yashmotiani_blinkit_marketing_and_customer_powerbi_dashbord.blinkit_order_items

59.08 KB
5000 rows
4 columns


CREATE TABLE blinkit_order_items (
  "order_id" BIGINT,
  "product_id" BIGINT,
  "quantity" BIGINT,
  "unit_price" DOUBLE
);

Blinkit Customers

@kaggle.yashmotiani_blinkit_marketing_and_customer_powerbi_dashbord.blinkit_customers

214.01 KB
2500 rows
11 columns


CREATE TABLE blinkit_customers (
  "customer_id" BIGINT,
  "customer_name" VARCHAR,
  "email" VARCHAR,
  "phone" BIGINT,
  "address" VARCHAR,
  "area" VARCHAR,
  "pincode" BIGINT,
  "registration_date" TIMESTAMP,
  "customer_segment" VARCHAR,
  "total_orders" BIGINT,
  "avg_order_value" DOUBLE
);

Blinkit Marketing Performance

@kaggle.yashmotiani_blinkit_marketing_and_customer_powerbi_dashbord.blinkit_marketing_performance

171.41 KB
5400 rows
11 columns


CREATE TABLE blinkit_marketing_performance (
  "campaign_id" BIGINT,
  "campaign_name" VARCHAR,
  "date" TIMESTAMP,
  "target_audience" VARCHAR,
  "channel" VARCHAR,
  "impressions" BIGINT,
  "clicks" BIGINT,
  "conversions" BIGINT,
  "spend" DOUBLE,
  "revenue_generated" DOUBLE,
  "roas" DOUBLE
);

Blinkit Products

@kaggle.yashmotiani_blinkit_marketing_and_customer_powerbi_dashbord.blinkit_products

17.95 KB
268 rows
10 columns


CREATE TABLE blinkit_products (
  "product_id" BIGINT,
  "product_name" VARCHAR,
  "category" VARCHAR,
  "brand" VARCHAR,
  "price" DOUBLE,
  "mrp" DOUBLE,
  "margin_percentage" DOUBLE,
  "shelf_life_days" BIGINT,
  "min_stock_level" BIGINT,
  "max_stock_level" BIGINT
);

Blinkit Customer Feedback

@kaggle.yashmotiani_blinkit_marketing_and_customer_powerbi_dashbord.blinkit_customer_feedback

118.89 KB
5000 rows
8 columns


CREATE TABLE blinkit_customer_feedback (
  "feedback_id" BIGINT,
  "order_id" BIGINT,
  "customer_id" BIGINT,
  "rating" BIGINT,
  "feedback_text" VARCHAR,
  "feedback_category" VARCHAR,
  "sentiment" VARCHAR,
  "feedback_date" TIMESTAMP
);