# Analytics Dashboard Configuration
# Sets up comprehensive analytics dashboard with KPIs and reporting

# Create analytics dashboards
INSERT_UPDATE AnalyticsDashboard;code[unique=true];name[lang=en];description[lang=en];dashboardType(code);active
;EXECUTIVE_DASHBOARD;Executive Dashboard;High-level executive dashboard;EXECUTIVE;true
;SALES_DASHBOARD;Sales Dashboard;Sales performance dashboard;SALES;true
;MARKETING_DASHBOARD;Marketing Dashboard;Marketing performance dashboard;MARKETING;true
;CUSTOMER_DASHBOARD;Customer Dashboard;Customer analytics dashboard;CUSTOMER;true
;OPERATIONS_DASHBOARD;Operations Dashboard;Operations performance dashboard;OPERATIONS;true
;FINANCIAL_DASHBOARD;Financial Dashboard;Financial performance dashboard;FINANCIAL;true
;PRODUCT_DASHBOARD;Product Dashboard;Product performance dashboard;PRODUCT;true
;INVENTORY_DASHBOARD;Inventory Dashboard;Inventory management dashboard;INVENTORY;true

# Create analytics widgets
INSERT_UPDATE AnalyticsWidget;code[unique=true];name[lang=en];description[lang=en];widgetType(code);dataSource(code);active
;TOTAL_REVENUE_WIDGET;Total Revenue Widget;Total revenue display widget;KPI;REVENUE_DATA;true
;ORDER_COUNT_WIDGET;Order Count Widget;Total order count widget;KPI;ORDER_DATA;true
;CUSTOMER_COUNT_WIDGET;Customer Count Widget;Total customer count widget;KPI;CUSTOMER_DATA;true
;CONVERSION_RATE_WIDGET;Conversion Rate Widget;Conversion rate widget;KPI;CONVERSION_DATA;true
;AVERAGE_ORDER_VALUE_WIDGET;Average Order Value Widget;Average order value widget;KPI;ORDER_DATA;true
;TOP_PRODUCTS_WIDGET;Top Products Widget;Top selling products widget;CHART;PRODUCT_DATA;true
;SALES_TREND_WIDGET;Sales Trend Widget;Sales trend over time widget;CHART;SALES_DATA;true
;CUSTOMER_SEGMENT_WIDGET;Customer Segment Widget;Customer segmentation widget;CHART;CUSTOMER_DATA;true
;GEOGRAPHIC_SALES_WIDGET;Geographic Sales Widget;Sales by geography widget;MAP;SALES_DATA;true
;INVENTORY_LEVELS_WIDGET;Inventory Levels Widget;Current inventory levels widget;TABLE;INVENTORY_DATA;true

# Create analytics KPIs
INSERT_UPDATE AnalyticsKPI;code[unique=true];name[lang=en];description[lang=en];kpiType(code);calculationMethod(code);targetValue;active
;TOTAL_REVENUE_KPI;Total Revenue KPI;Total revenue key performance indicator;REVENUE;SUM;1000000;true
;ORDER_COUNT_KPI;Order Count KPI;Total order count key performance indicator;VOLUME;COUNT;10000;true
;CUSTOMER_COUNT_KPI;Customer Count KPI;Total customer count key performance indicator;VOLUME;COUNT;5000;true
;CONVERSION_RATE_KPI;Conversion Rate KPI;Conversion rate key performance indicator;PERCENTAGE;CALCULATED;3.5;true
;AVERAGE_ORDER_VALUE_KPI;Average Order Value KPI;Average order value key performance indicator;VALUE;AVERAGE;150;true
;CUSTOMER_LIFETIME_VALUE_KPI;Customer Lifetime Value KPI;Customer lifetime value key performance indicator;VALUE;CALCULATED;500;true
;CART_ABANDONMENT_RATE_KPI;Cart Abandonment Rate KPI;Cart abandonment rate key performance indicator;PERCENTAGE;CALCULATED;70;true
;RETURN_RATE_KPI;Return Rate KPI;Product return rate key performance indicator;PERCENTAGE;CALCULATED;5;true
;INVENTORY_TURNOVER_KPI;Inventory Turnover KPI;Inventory turnover key performance indicator;RATIO;CALCULATED;6;true
;PROFIT_MARGIN_KPI;Profit Margin KPI;Profit margin key performance indicator;PERCENTAGE;CALCULATED;25;true

# Create analytics reports
INSERT_UPDATE AnalyticsReport;code[unique=true];name[lang=en];description[lang=en];reportType(code);schedule;active
;DAILY_SALES_REPORT;Daily Sales Report;Daily sales performance report;SALES;daily;true
;WEEKLY_CUSTOMER_REPORT;Weekly Customer Report;Weekly customer analytics report;CUSTOMER;weekly;true
;MONTHLY_FINANCIAL_REPORT;Monthly Financial Report;Monthly financial performance report;FINANCIAL;monthly;true
;QUARTERLY_PRODUCT_REPORT;Quarterly Product Report;Quarterly product performance report;PRODUCT;quarterly;true
;YEARLY_EXECUTIVE_REPORT;Yearly Executive Report;Yearly executive summary report;EXECUTIVE;yearly;true
;REAL_TIME_OPERATIONS_REPORT;Real-time Operations Report;Real-time operations monitoring report;OPERATIONS;real-time;true
;INVENTORY_ALERT_REPORT;Inventory Alert Report;Inventory level alert report;INVENTORY;daily;true
;MARKETING_CAMPAIGN_REPORT;Marketing Campaign Report;Marketing campaign performance report;MARKETING;weekly;true

# Create analytics data sources
INSERT_UPDATE AnalyticsDataSource;code[unique=true];name[lang=en];description[lang=en];dataSourceType(code);connectionString;active
;ORDER_DATABASE;Order Database;Order data from database;DATABASE;jdbc:mysql://localhost:3306/orders;true
;PRODUCT_DATABASE;Product Database;Product data from database;DATABASE;jdbc:mysql://localhost:3306/products;true
;CUSTOMER_DATABASE;Customer Database;Customer data from database;DATABASE;jdbc:mysql://localhost:3306/customers;true
;WEB_ANALYTICS_API;Web Analytics API;Web analytics data from API;API;https://api.analytics.com/v1;true
;EMAIL_MARKETING_API;Email Marketing API;Email marketing data from API;API;https://api.emailmarketing.com/v1;true
;SOCIAL_MEDIA_API;Social Media API;Social media data from API;API;https://api.socialmedia.com/v1;true
;PAYMENT_GATEWAY_API;Payment Gateway API;Payment data from gateway API;API;https://api.paymentgateway.com/v1;true
;INVENTORY_SYSTEM_API;Inventory System API;Inventory data from system API;API;https://api.inventory.com/v1;true

# Create analytics filters
INSERT_UPDATE AnalyticsFilter;code[unique=true];name[lang=en];description[lang=en];filterType(code);filterValue;active
;DATE_RANGE_FILTER;Date Range Filter;Filter data by date range;DATE_RANGE;last_30_days;true
;PRODUCT_CATEGORY_FILTER;Product Category Filter;Filter data by product category;CATEGORY;electronics;true
;CUSTOMER_SEGMENT_FILTER;Customer Segment Filter;Filter data by customer segment;SEGMENT;vip_customers;true
;GEOGRAPHIC_FILTER;Geographic Filter;Filter data by geography;GEOGRAPHY;north_america;true
;SALES_CHANNEL_FILTER;Sales Channel Filter;Filter data by sales channel;CHANNEL;online;true
;PAYMENT_METHOD_FILTER;Payment Method Filter;Filter data by payment method;PAYMENT_METHOD;credit_card;true
;ORDER_STATUS_FILTER;Order Status Filter;Filter data by order status;ORDER_STATUS;completed;true
;PRICE_RANGE_FILTER;Price Range Filter;Filter data by price range;PRICE_RANGE;100-500;true

# Create analytics alerts
INSERT_UPDATE AnalyticsAlert;code[unique=true];name[lang=en];description[lang=en];alertType(code);threshold;condition;active
;LOW_INVENTORY_ALERT;Low Inventory Alert;Alert when inventory levels are low;THRESHOLD;10;<;true
;HIGH_CART_ABANDONMENT_ALERT;High Cart Abandonment Alert;Alert when cart abandonment is high;THRESHOLD;80;>;true
;LOW_CONVERSION_RATE_ALERT;Low Conversion Rate Alert;Alert when conversion rate is low;THRESHOLD;2;<;true
;HIGH_RETURN_RATE_ALERT;High Return Rate Alert;Alert when return rate is high;THRESHOLD;10;>;true
;REVENUE_TARGET_ALERT;Revenue Target Alert;Alert when revenue target is not met;THRESHOLD;800000;<;true
;ORDER_VOLUME_ALERT;Order Volume Alert;Alert when order volume is low;THRESHOLD;100;<;true
;CUSTOMER_ACQUISITION_ALERT;Customer Acquisition Alert;Alert when customer acquisition is low;THRESHOLD;50;<;true
;PROFIT_MARGIN_ALERT;Profit Margin Alert;Alert when profit margin is low;THRESHOLD;20;<;true

# Create analytics user permissions
INSERT_UPDATE AnalyticsUserPermission;code[unique=true];name[lang=en];description[lang=en];userGroup(code);dashboard(code);permissionType(code);active
;EXECUTIVE_DASHBOARD_ACCESS;Executive Dashboard Access;Access to executive dashboard;executive_group;EXECUTIVE_DASHBOARD;READ;true
;SALES_DASHBOARD_ACCESS;Sales Dashboard Access;Access to sales dashboard;sales_group;SALES_DASHBOARD;READ_WRITE;true
;MARKETING_DASHBOARD_ACCESS;Marketing Dashboard Access;Access to marketing dashboard;marketing_group;MARKETING_DASHBOARD;READ_WRITE;true
;CUSTOMER_DASHBOARD_ACCESS;Customer Dashboard Access;Access to customer dashboard;customer_service_group;CUSTOMER_DASHBOARD;READ;true
;OPERATIONS_DASHBOARD_ACCESS;Operations Dashboard Access;Access to operations dashboard;operations_group;OPERATIONS_DASHBOARD;READ_WRITE;true
;FINANCIAL_DASHBOARD_ACCESS;Financial Dashboard Access;Access to financial dashboard;finance_group;FINANCIAL_DASHBOARD;READ;true
;PRODUCT_DASHBOARD_ACCESS;Product Dashboard Access;Access to product dashboard;product_group;PRODUCT_DASHBOARD;READ_WRITE;true
;INVENTORY_DASHBOARD_ACCESS;Inventory Dashboard Access;Access to inventory dashboard;inventory_group;INVENTORY_DASHBOARD;READ_WRITE;true