<% var daily = (d.daily || []).filter(function(r){ return r && r.date; }); var weeks = []; if (daily.length) { var bucket = {}; daily.forEach(function(r){ var dt = new Date(r.date); var k = new Date(dt); k.setDate(dt.getDate() - ((dt.getDay() + 6) % 7)); var key = k.toISOString().slice(0, 10); bucket[key] = bucket[key] || { label: k, cost: 0, conv: 0 }; bucket[key].cost += r.cost || 0; bucket[key].conv += r.conversions || 0; }); weeks = Object.keys(bucket).sort().map(function(k){ return bucket[k]; }).slice(-12) .map(function(b){ return { label: b.label, cost: b.cost, conv: b.conv, cpa: b.conv ? b.cost / b.conv : null }; }); } var enough = weeks.filter(function(w){ return w.cpa !== null; }).length >= 3; %>

Cost per conversion vs conversions

<%= weeks.length ? 'last ' + weeks.length + ' weeks' : 'weekly' %>
<% if (!enough) { %>
The trend appears after three weeks with conversions (<%= weeks.length %> week<%= weeks.length === 1 ? '' : 's' %> so far). <% if (!(d.availability || {}).daily && locals.showStaff) { %> The export is not writing a daily tab; add it to the Ads Script and this fills in on the next sync.<% } %>
<% } else { var cpas = weeks.map(function(w){ return w.cpa; }).filter(function(v){ return v !== null; }); var convs = weeks.map(function(w){ return w.conv; }); var loC = Math.min.apply(null, cpas), hiC = Math.max.apply(null, cpas); if (cfg.targetCpa) { loC = Math.min(loC, cfg.targetCpa); hiC = Math.max(hiC, cfg.targetCpa); } var padC = Math.max(1, (hiC - loC) * 0.15); loC -= padC; hiC += padC; var hiV = Math.max.apply(null, convs.concat([1])); var X0 = 60, X1 = 700, Y0 = 190, Y1 = 40; var n = weeks.length; var px = function(i){ return n < 2 ? X0 : X0 + i * ((X1 - X0) / (n - 1)); }; var pyC = function(v){ return Y0 - ((v - loC) / (hiC - loC)) * (Y0 - Y1); }; var pyV = function(v){ return Y0 - (v / hiV) * (Y0 - Y1); }; var lineC = weeks.map(function(w, i){ return w.cpa === null ? null : (Math.round(px(i)) + ',' + Math.round(pyC(w.cpa) * 10) / 10); }).filter(Boolean).join(' '); var lineV = weeks.map(function(w, i){ return Math.round(px(i)) + ',' + Math.round(pyV(w.conv) * 10) / 10; }).join(' '); var first = weeks.find(function(w){ return w.cpa !== null; }); var last = weeks.slice().reverse().find(function(w){ return w.cpa !== null; }); var cpaChange = (first && last && first.cpa) ? Math.round((last.cpa - first.cpa) / first.cpa * 100) : null; var convChange = (weeks[0].conv) ? Math.round((weeks[n-1].conv - weeks[0].conv) / weeks[0].conv * 100) : null; %>
Cost per conversion (left) Conversions (right) <% if (cfg.targetCpa) { %> Target CPA <%= m(cfg.targetCpa) %><% } %> <% if (cpaChange !== null && convChange !== null) { %> CPA <%= cpaChange > 0 ? '+' : '' %><%= cpaChange %>% ยท conversions <%= convChange > 0 ? '+' : '' %><%= convChange %>% <% } %>
<% if (cfg.targetCpa) { var ty = pyC(cfg.targetCpa); %> <% } %> <% [0,1,2,3,4].forEach(function(i){ var v = hiC - (hiC - loC) * (i / 4); %> <%= m(v) %> <% }) %> <% [0,1,2,3,4].forEach(function(i){ var v = hiV - hiV * (i / 4); %> <%= Math.round(v).toLocaleString('en-US') %> <% }) %>
<% weeks.forEach(function(w, i){ if (i % Math.ceil(n / 6) === 0 || i === n - 1) { %><%= h.date(w.label) %><% } }) %>
Why CPA and conversions Why CPA and conversions. CPA falling while conversions rise shows the account getting more efficient. Weeks with no conversions are left out of the CPA line.
<% } %>