E-commerce KPI Dashboard

E-commerce KPI Dashboard

Overall E-commerce Performance

Daily/Product Performance Data

Date Product/Category Revenue ($) Orders Visitors Conversion Rate (%) AOV ($) Cost ($) Profit ($) Actions

${totalOrders.toLocaleString()}

Total Visitors

${totalVisitors.toLocaleString()}

Conversion Rate

${overallConversionRate.toFixed(2)}%

Average Order Value

${overallAOV.toLocaleString('en-US', { style: 'currency', currency: 'USD' })}

Total Profit

${totalProfit.toLocaleString('en-US', { style: 'currency', currency: 'USD' })}

`; overallKpiSummaryDiv.innerHTML = summaryHtml; } /** * Renders the table of all E-commerce KPI data. */ function renderKpiDataTable() { if (!kpiDataTableBody) return; // Null check kpiDataTableBody.innerHTML = ''; // Clear existing rows // Sort data by date in descending order for display const sortedData = [...kpiData].sort((a, b) => new Date(b.date) - new Date(a.date)); sortedData.forEach(entry => { const conversionRate = calculateConversionRate(entry.orders, entry.visitors); const aov = calculateAOV(entry.revenue, entry.orders); const profit = calculateProfit(entry.revenue, entry.cost); const row = kpiDataTableBody.insertRow(); row.innerHTML = ` ${entry.date || 'N/A'} ${entry.productCategory} ${entry.revenue.toLocaleString('en-US', { style: 'currency', currency: 'USD' })} ${entry.orders.toLocaleString()} ${entry.visitors.toLocaleString()} ${conversionRate.toFixed(2)}% ${aov.toLocaleString('en-US', { style: 'currency', currency: 'USD' })} ${entry.cost.toLocaleString('en-US', { style: 'currency', currency: 'USD' })} ${profit.toLocaleString('en-US', { style: 'currency', currency: 'USD' })} `; }); } /** * Renders the entire dashboard content. */ function renderDashboard() { renderOverallKpiSummary(); renderKpiDataTable(); } // --- Data Configuration Logic --- /** * Generates a unique ID for a new KPI entry. * @returns {string} A unique ID. */ function generateUniqueId() { return 'kpi' + Date.now() + Math.floor(Math.random() * 1000); } // Add/Update KPI Form Submission if (addUpdateKpiForm) { addUpdateKpiForm.addEventListener('submit', function(event) { event.preventDefault(); // Prevent default form submission const id = document.getElementById('kpiId').value; const dataDate = document.getElementById('dataDate').value; const productCategory = document.getElementById('productCategory').value; const revenue = parseFloat(document.getElementById('revenue').value); const orders = parseInt(document.getElementById('orders').value); const visitors = parseInt(document.getElementById('visitors').value); const cost = parseFloat(document.getElementById('cost').value); // Basic validation if (!productCategory.trim()) { showCustomModal('Input Error', 'Product/Category cannot be empty.'); return; } if (isNaN(revenue) || revenue < 0 || isNaN(orders) || orders < 0 || isNaN(visitors) || visitors < 0 || isNaN(cost) || cost < 0) { showCustomModal('Input Error', 'Please ensure all numerical fields are filled correctly with non-negative numbers.'); return; } if (orders > visitors) { showCustomModal('Input Error', 'Orders cannot be greater than Visitors.'); return; } const newKpiEntry = { id: id || generateUniqueId(), // Use existing ID if editing, otherwise generate new date: dataDate, productCategory: productCategory, revenue: revenue, orders: orders, visitors: visitors, cost: cost }; if (id) { // Update existing entry const index = kpiData.findIndex(entry => entry.id === id); if (index > -1) { kpiData[index] = newKpiEntry; } else { console.error('KPI data entry not found for update:', id); } } else { // Add new entry kpiData.push(newKpiEntry); } renderDashboard(); // Re-render dashboard with new/updated data addUpdateKpiForm.reset(); // Clear the form kpiIdInput.value = ''; // Clear hidden ID formSubmitBtn.textContent = 'Add KPI Data'; // Reset button text switchTab('dashboard'); // Switch back to dashboard to see changes }); } /** * Populates the form for editing an existing KPI entry. * @param {string} id - The ID of the KPI entry to edit. */ window.editKpiEntry = function(id) { const entryToEdit = kpiData.find(entry => entry.id === id); if (!entryToEdit) { console.error('KPI data entry not found for editing:', id); return; } document.getElementById('kpiId').value = entryToEdit.id; document.getElementById('dataDate').value = entryToEdit.date; document.getElementById('productCategory').value = entryToEdit.productCategory; document.getElementById('revenue').value = entryToEdit.revenue; document.getElementById('orders').value = entryToEdit.orders; document.getElementById('visitors').value = entryToEdit.visitors; document.getElementById('cost').value = entryToEdit.cost; formSubmitBtn.textContent = 'Update KPI Data'; // Change button text switchTab('data-config'); // Switch to data config tab }; /** * Deletes a KPI entry from the array after confirmation. * @param {string} id - The ID of the KPI entry to delete. */ window.deleteKpiEntry = function(id) { showCustomModal('Confirm Deletion', 'Are you sure you want to delete this KPI data entry?', () => { kpiData = kpiData.filter(entry => entry.id !== id); renderDashboard(); // Re-render dashboard }); }; // --- Custom Modal Logic (replaces alert/confirm) --- let currentConfirmCallback = null; /** * Shows a custom modal with a message and optional confirmation. * @param {string} title - The title of the modal. * @param {string} message - The message to display. * @param {function} [onConfirm] - Callback function to execute on confirm. If null, it's an alert. */ function showCustomModal(title, message, onConfirm = null) { if (!confirmModal || !modalTitle || !modalMessage || !confirmActionBtn) return; modalTitle.textContent = title; modalMessage.textContent = message; if (onConfirm) { confirmActionBtn.style.display = 'inline-block'; // Show confirm button confirmActionBtn.textContent = 'Confirm'; confirmActionBtn.classList.remove('btn-primary'); confirmActionBtn.classList.add('btn-danger'); currentConfirmCallback = onConfirm; } else { confirmActionBtn.style.display = 'none'; // Hide confirm button for alerts currentConfirmCallback = null; } confirmModal.style.display = 'flex'; // Show modal } /** * Closes the specified modal. * @param {string} modalId - The ID of the modal to close. */ window.closeModal = function(modalId) { const modal = document.getElementById(modalId); if (modal) { modal.style.display = 'none'; } }; // Event listener for the custom modal's confirm button if (confirmActionBtn) { confirmActionBtn.addEventListener('click', function() { if (currentConfirmCallback) { currentConfirmCallback(); } closeModal('confirmModal'); }); } // Close modal when clicking outside of it window.onclick = function(event) { if (event.target === confirmModal) { closeModal('confirmModal'); } }; // --- PDF Download Logic --- /** * Downloads the dashboard content as a PDF. */ if (downloadPdfBtn) { downloadPdfBtn.addEventListener('click', function() { const input = document.getElementById('dashboardTabContent'); // Target the dashboard content if (!input) { console.error('Dashboard content element not found for PDF generation.'); return; } // Temporarily hide elements that should not be in the PDF const elementsToHide = input.querySelectorAll('.no-print'); elementsToHide.forEach(el => el.style.display = 'none'); // Use html2canvas to capture the content as an image html2canvas(input, { scale: 2, // Increase scale for better quality useCORS: true, // Needed if external images are used (not in this case, but good practice) logging: false // Disable logging for cleaner console }).then(canvas => { const imgData = canvas.toDataURL('image/png'); const pdf = new window.jspdf.jsPDF('p', 'mm', 'a4'); // 'p' for portrait, 'mm' for units, 'a4' for size const imgWidth = 210; // A4 width in mm const pageHeight = 297; // A4 height in mm const imgHeight = canvas.height * imgWidth / canvas.width; let heightLeft = imgHeight; let position = 0; // Add image to PDF pdf.addImage(imgData, 'PNG', 0, position, imgWidth, imgHeight); heightLeft -= pageHeight; // If content spans multiple pages, add new pages while (heightLeft >= 0) { position = heightLeft - imgHeight; pdf.addPage(); pdf.addImage(imgData, 'PNG', 0, position, imgWidth, imgHeight); heightLeft -= pageHeight; } pdf.save('E-commerce_KPI_Dashboard.pdf'); // Restore visibility of hidden elements elementsToHide.forEach(el => el.style.display = ''); }).catch(error => { console.error('Error generating PDF:', error); // Restore visibility of hidden elements in case of error elementsToHide.forEach(el => el.style.display = ''); }); }); } // Initial render of the dashboard when the page loads renderDashboard(); });
Scroll to Top