Cost Prediction On Acquiring Customers.
Cost to run a media campaign for US FoodMarts according to Income,Store Data
@kaggle.ramjasmaurya_medias_cost_prediction_in_foodmart
Cost to run a media campaign for US FoodMarts according to Income,Store Data
@kaggle.ramjasmaurya_medias_cost_prediction_in_foodmart
ABOUT FOODMART:
Food Mart (CFM) is a chain of convenience stores in the United States. The private company's headquarters are located in Mentor, Ohio, and there are currently approximately 325 stores located in the US. Convenient Food Mart operates on the franchise system.
Food Mart was the nation's third-largest chain of convenience stores as of 1988.
The NASDAQ exchange dropped Convenient Food Mart the same year when the company failed to meet financial reporting requirements.
Carden & Cherry advertised Convenient Food Mart with the Ernest character in the 1980s.
...KNOW MORE FROM WIKI .
CREATE TABLE media_prediction_and_its_cost (
"food_category" VARCHAR,
"food_department" VARCHAR,
"food_family" VARCHAR,
"store_sales_in_millions" DOUBLE -- Store Sales(in Millions),
"store_cost_in_millions" DOUBLE -- Store Cost(in Millions),
"unit_sales_in_millions" DOUBLE -- Unit Sales(in Millions),
"promotion_name" VARCHAR,
"sales_country" VARCHAR,
"marital_status" VARCHAR,
"gender" VARCHAR,
"total_children" DOUBLE,
"education" VARCHAR,
"member_card" VARCHAR,
"occupation" VARCHAR,
"houseowner" VARCHAR,
"avg_cars_at_home_approx" DOUBLE -- Avg Cars At Home(approx),
"avg_yearly_income" VARCHAR -- Avg. Yearly Income,
"num_children_at_home" DOUBLE,
"avg_cars_at_home_approx_1" DOUBLE -- Avg Cars At Home(approx).1,
"brand_name" VARCHAR,
"srp" DOUBLE,
"gross_weight" DOUBLE,
"net_weight" DOUBLE,
"recyclable_package" DOUBLE,
"low_fat" DOUBLE,
"units_per_case" DOUBLE,
"store_type" VARCHAR,
"store_city" VARCHAR,
"store_state" VARCHAR,
"store_sqft" DOUBLE,
"grocery_sqft" DOUBLE,
"frozen_sqft" DOUBLE,
"meat_sqft" DOUBLE,
"coffee_bar" DOUBLE,
"video_store" DOUBLE,
"salad_bar" DOUBLE,
"prepared_food" DOUBLE,
"florist" DOUBLE,
"media_type" VARCHAR,
"cost" DOUBLE
);Anyone who has the link will be able to view this.