document.addEventListener('DOMContentLoaded', function() {
// Data from the provided table
const campaignData = [
{
period: "July 16 – Aug 21",
duration: 37,
totalSpend: 14427.76,
installs: 10524,
avgCPI: 1.37,
installsPerDay: 285,
spendPerDay: 390
},
{
period: "Aug 22 – Sept 22",
duration: 32,
totalSpend: 43367.81,
installs: 50887,
avgCPI: 0.85,
installsPerDay: 1590,
spendPerDay: 1355
},
{
period: "Sept 24 – Oct 6",
duration: 12,
totalSpend: 35931.32,
installs: 68994,
avgCPI: 0.52,
installsPerDay: 5750,
spendPerDay: 2994
},
{
period: "Oct 7 - Oct 27",
duration: 21,
totalSpend: 122436.10,
installs: 423612,
avgCPI: 0.29,
installsPerDay: 20170,
spendPerDay: 5830
},
{
period: "Oct 28 - Nov 03",
duration: 7,
totalSpend: 68447.60,
installs: 281859,
avgCPI: 0.24,
installsPerDay: 40270,
spendPerDay: 9780
},
{
period: "Nov 04 - Nov 12",
duration: 14,
totalSpend: 75875.47,
installs: 339909,
avgCPI: 0.22,
installsPerDay: 24280,
spendPerDay: 5420
}
];
// Populate data table
const tableBody = document.getElementById('dataTableBody');
campaignData.forEach(data => {
const row = document.createElement('tr');
row.innerHTML = `
${data.period} |
${data.duration} days |
$${data.totalSpend.toLocaleString('en-US', {minimumFractionDigits: 2, maximumFractionDigits: 2})} |
${data.installs.toLocaleString()} |
$${data.avgCPI.toFixed(2)} |
${data.installsPerDay.toLocaleString()} |
$${data.spendPerDay.toLocaleString('en-US', {minimumFractionDigits: 2, maximumFractionDigits: 2})} |
`;
tableBody.appendChild(row);
});
// Extract labels and data for charts
const labels = campaignData.map(item => item.period);
const installsData = campaignData.map(item => item.installs);
const spendData = campaignData.map(item => item.totalSpend);
const installsPerDayData = campaignData.map(item => item.installsPerDay);
const spendPerDayData = campaignData.map(item => item.spendPerDay);
// Create Installs Chart
const installsCtx = document.getElementById('installsChart').getContext('2d');
new Chart(installsCtx, {
type: 'bar',
data: {
labels: labels,
datasets: [{
label: 'Installs',
data: installsData,
backgroundColor: '#6366F1',
borderColor: '#4F46E5',
borderWidth: 1
}]
},
options: {
responsive: true,
maintainAspectRatio: false,
scales: {
y: {
beginAtZero: true,
ticks: {
callback: function(value) {
return value.toLocaleString();
}
}
}
},
plugins: {
tooltip: {
callbacks: {
label: function(context) {
return context.dataset.label + ': ' + context.raw.toLocaleString();
}
}
}
}
}
});
// Create Spend Chart
const spendCtx = document.getElementById('spendChart').getContext('2d');
new Chart(spendCtx, {
type: 'line',
data: {
labels: labels,
datasets: [{
label: 'Spend ($)',
data: spendData,
backgroundColor: '#8B5CF6',
borderColor: '#7C3AED',
borderWidth: 2,
tension: 0.1,
fill: false
}]
},
options: {
responsive: true,
maintainAspectRatio: false,
scales: {
y: {
beginAtZero: true,
ticks: {
callback: function(value) {
return ' + value.toLocaleString();
}
}
}
},
plugins: {
tooltip: {
callbacks: {
label: function(context) {
return context.dataset.label + ': + context.raw.toLocaleString('en-US', {minimumFractionDigits: 2});
}
}
}
}
}
});
// Create Combined Chart
const combinedCtx = document.getElementById('combinedChart').getContext('2d');
new Chart(combinedCtx, {
type: 'bar',
data: {
labels: labels,
datasets: [
{
label: 'Installs',
data: installsData,
backgroundColor: '#6366F1',
borderColor: '#4F46E5',
borderWidth: 1,
yAxisID: 'y'
},
{
label: 'Spend ($)',
data: spendData,
backgroundColor: '#8B5CF6',
borderColor: '#7C3AED',
borderWidth: 2,
type: 'line',
yAxisID: 'y1'
}
]
},
options: {
responsive: true,
maintainAspectRatio: false,
scales: {
y: {
type: 'linear',
display: true,
position: 'left',
title: {
display: true,
text: 'Installs'
},
ticks: {
callback: function(value) {
return value.toLocaleString();
}
}
},
y1: {
type: 'linear',
display: true,
position: 'right',
title: {
display: true,
text: 'Spend ($)'
},
grid: {
drawOnChartArea: false
},
ticks: {
callback: function(value) {
return ' + value.toLocaleString();
}
}
}
},
plugins: {
tooltip: {
callbacks: {
label: function(context) {
let label = context.dataset.label || '';
if (label) {
label += ': ';
}
if (context.datasetIndex === 0) {
label += context.raw.toLocaleString();
} else {
label += ' + context.raw.toLocaleString('en-US', {minimumFractionDigits: 2});
}
return label;
}
}
}
}
}
});