`;
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();
});
