Advertising Budget Forecast Dashboard

Global Settings

$

Channel Allocation & Assumptions

Google Ads

Facebook Ads

LinkedIn Ads

Total Forecast Summary

Projected Spend

$0

Projected Clicks

0

Projected Conversions

0

Projected Revenue

$0

Projected ROAS

0x

Visualizations

Forecast Breakdown by Channel

ChannelSpendClicksConversionsRevenueROASCPA

Required libraries (Chart.js, jsPDF) failed to load. Please check your internet connection and ad-blockers, then refresh.

`; errorWrapper.style.display = 'block'; contentWrapper.style.display = 'none'; return; } let allocationChart, roasChart; const channels = Array.from(document.querySelectorAll('.af-channel')); const allInputs = document.querySelectorAll('.af-inputs input'); const channelColors = { google: '#DB4437', facebook: '#4267B2', linkedin: '#0077B5' }; function initialize() { initCharts(); calculateAndRender(); attachEventListeners(); } function initCharts() { const commonOptions = { responsive: true, maintainAspectRatio: false }; allocationChart = new Chart(document.getElementById('allocationChart'), { type: 'doughnut', options: {...commonOptions, plugins: { title: { display: true, text: 'Budget Allocation' }}} }); roasChart = new Chart(document.getElementById('roasChart'), { type: 'bar', options: {...commonOptions, plugins: { title: { display: true, text: 'Projected ROAS by Channel' }}, scales: { y: { beginAtZero: true }}} }); } function attachEventListeners() { allInputs.forEach(input => { input.addEventListener('input', (e) => { if (e.target.classList.contains('alloc-slider')) { handleSliderInput(e.target); } else { calculateAndRender(); } }); }); } function handleSliderInput(changedSlider) { let total = 0; channels.forEach(ch => { total += parseFloat(ch.querySelector('.alloc-slider').value); }); const overkill = total - 100; if (overkill !== 0) { const otherSliders = channels .map(ch => ch.querySelector('.alloc-slider')) .filter(s => s !== changedSlider && !s.disabled && s.value > 0); distribute(-overkill, otherSliders); } calculateAndRender(); } function distribute(amount, sliders) { const totalValue = sliders.reduce((sum, s) => sum + parseFloat(s.value), 0); if (totalValue <= 0) { // Can't distribute among zero-value sliders // Fallback: take/give from the largest slider const allSliders = channels.map(ch => ch.querySelector('.alloc-slider')).filter(s => s !== event.target); if (allSliders.length > 0) { allSliders.sort((a,b) => b.value - a.value)[0].value = parseFloat(allSliders[0].value) + amount; } return; } let remainingAmount = amount; sliders.forEach(slider => { const proportion = parseFloat(slider.value) / totalValue; const share = Math.round(amount * proportion); slider.value = parseFloat(slider.value) + share; remainingAmount -= share; }); if(remainingAmount !== 0 && sliders.length > 0) { sliders[0].value = parseFloat(sliders[0].value) + remainingAmount; } } function calculateAndRender() { const totalBudget = parseFloat(document.getElementById('total-budget').value) || 0; let forecast = []; // Ensure sliders add up to 100% let currentTotalAlloc = 0; channels.forEach(ch => { currentTotalAlloc += parseFloat(ch.querySelector('.alloc-slider').value); }); if (Math.round(currentTotalAlloc) !== 100) { const diff = 100 - currentTotalAlloc; const lastSlider = channels[channels.length - 1].querySelector('.alloc-slider'); lastSlider.value = parseFloat(lastSlider.value) + diff; } channels.forEach(ch => { const channelId = ch.dataset.channel; const allocSlider = ch.querySelector('.alloc-slider'); const allocPercent = parseFloat(allocSlider.value); ch.querySelector('.alloc-percent').textContent = `${allocPercent.toFixed(0)}%`; const assumptions = { cpc: parseFloat(ch.querySelector('.assumption-cpc').value) || 0, cvr: (parseFloat(ch.querySelector('.assumption-cvr').value) || 0) / 100, aov: parseFloat(ch.querySelector('.assumption-aov').value) || 0 }; const spend = totalBudget * (allocPercent / 100); const clicks = assumptions.cpc > 0 ? spend / assumptions.cpc : 0; const conversions = clicks * assumptions.cvr; const revenue = conversions * assumptions.aov; const roas = spend > 0 ? revenue / spend : 0; const cpa = conversions > 0 ? spend / conversions : 0; forecast.push({ channelId, spend, clicks, conversions, revenue, roas, cpa }); }); renderResults(forecast, totalBudget); } function renderResults(forecast, totalBudget) { const totals = forecast.reduce((acc, curr) => { acc.spend += curr.spend; acc.clicks += curr.clicks; acc.conversions += curr.conversions; acc.revenue += curr.revenue; return acc; }, { spend: 0, clicks: 0, conversions: 0, revenue: 0 }); totals.roas = totals.spend > 0 ? totals.revenue / totals.spend : 0; document.getElementById('total-spend').textContent = formatCurrency(totals.spend); document.getElementById('total-clicks').textContent = Math.round(totals.clicks).toLocaleString(); document.getElementById('total-conversions').textContent = Math.round(totals.conversions).toLocaleString(); document.getElementById('total-revenue').textContent = formatCurrency(totals.revenue); document.getElementById('total-roas').textContent = `${totals.roas.toFixed(2)}x`; const tableBody = document.getElementById('forecast-table-body'); tableBody.innerHTML = ''; forecast.forEach(f => { tableBody.innerHTML += ` ${f.channelId.charAt(0).toUpperCase() + f.channelId.slice(1)} ${formatCurrency(f.spend)} ${Math.round(f.clicks).toLocaleString()} ${Math.round(f.conversions).toLocaleString()} ${formatCurrency(f.revenue)} ${f.roas.toFixed(2)}x ${formatCurrency(f.cpa)} `; }); // Update charts allocationChart.data = { labels: forecast.map(f => f.channelId.charAt(0).toUpperCase() + f.channelId.slice(1)), datasets: [{ data: forecast.map(f => f.spend), backgroundColor: forecast.map(f => channelColors[f.channelId]) }] }; allocationChart.update(); roasChart.data = { labels: forecast.map(f => f.channelId.charAt(0).toUpperCase() + f.channelId.slice(1)), datasets: [{ label: 'ROAS', data: forecast.map(f => f.roas), backgroundColor: forecast.map(f => channelColors[f.channelId]) }] }; roasChart.update(); } const formatCurrency = val => `$${val.toFixed(2).replace(/\B(?=(\d{3})+(?!\d))/g, ",")}`; async function generatePdf() { const { jsPDF } = window.jspdf; const doc = new jsPDF({ orientation: 'portrait' }); doc.setFontSize(18); doc.text("Advertising Budget Forecast Report", 14, 22); // Assumptions section doc.setFontSize(14); doc.text("Forecast Assumptions", 14, 35); const totalBudget = document.getElementById('total-budget').value; const assumptionsData = channels.map(ch => { const channelId = ch.dataset.channel; const assumptions = { alloc: ch.querySelector('.alloc-percent').textContent, cpc: formatCurrency(parseFloat(ch.querySelector('.assumption-cpc').value)), cvr: `${ch.querySelector('.assumption-cvr').value}%`, aov: formatCurrency(parseFloat(ch.querySelector('.assumption-aov').value)) }; return [channelId.charAt(0).toUpperCase() + channelId.slice(1), assumptions.alloc, assumptions.cpc, assumptions.cvr, assumptions.aov]; }); doc.autoTable({ startY: 40, head: [['Channel', 'Allocation', 'Avg. CPC', 'Conv. Rate', 'Avg. Conv. Value']], body: assumptionsData, didDrawPage: (data) => { doc.setFontSize(12); doc.text(`Total Budget: ${formatCurrency(parseFloat(totalBudget))}`, 14, data.cursor.y + 10); } }); // Results section doc.addPage(); doc.setFontSize(14); doc.text("Forecast Results", 14, 22); const tableBody = document.getElementById('forecast-table-body'); doc.autoTable({ startY: 30, html: tableBody.parentElement, headStyles: { fillColor: [0, 123, 255] } }); doc.save(`Ad_Forecast_${new Date().toISOString().slice(0,10)}.pdf`); } document.getElementById('download-pdf-btn').addEventListener('click', generatePdf); initialize(); });
Scroll to Top