3f:null 40:["$","title",null,{"children":"Top N Users by Revenue Generated | Homam Hosseini | Observable"}] 46:T531,interesting_facts = R.pipe( data => R.zipWith( (d, x) => R.merge(d, {x1:x}), data, R.pipe(R.reverse, R.scan((a, b) => (a + b) , 0), R.drop(1), R.reverse) (data.map(share_of_revenue_getter)) ) , data => R.zipWith( (d, x) => R.merge(d, {x2:x}), data, R.pipe(R.reverse, R.scan((a, b) => (a + b) , 0), R.drop(1), R.reverse) (data.map(d => d.share_of_total_users)) ) , R.map(d => R.merge({rho: d.x1 / d.x2}, d)) , data => [R.merge({deltaRho: 0}, data[0])].concat( R.zipWith((a, b) => R.merge({deltaRho: Math.abs(b.rho - a.rho)}, a), R.drop(1, data), R.drop(0, data)) ) , R.filter(x => x.x1 > 0.1) , data => data.concat([{rho: 0, deltaRho: 0}]) , R.reduce( ({lastTwo, result}, a) => lastTwo.length < 2 ? { lastTwo: lastTwo.concat([a]), result: [] } : { lastTwo: R.drop(1, lastTwo).concat([a]), result: lastTwo[1].deltaRho >= lastTwo[0].deltaRho && lastTwo[1].deltaRho >= a.deltaRho ? result.concat(lastTwo[1]) : result } , {lastTwo: [], result: []}) , x => x.result , data => R.reduce( (acc, a) => acc.length === 0 ? [a] : acc.concat( Math.abs( R.last(acc).x1 / a.x1) >= (data.length > 3 ? 2 : 1.5) ? [a] : []) , [], data) )(raw_data)47:Tbd6,function draw_pyramid(div, mode) { var data = raw_data const xt = mode == 'NORMAL' ? x => x : R.pipe(R.reverse, R.scan((a, b) => (a + b) , 0), R.drop(1), R.reverse) const maxARPU = R.reduce(R.max, -Infinity, data.map(arpu_getter)) data = R.zipWith((d, x) => R.merge(d, {x1:x}), data, xt(data.map(d => -1 * share_of_revenue_getter(d)))) data = R.zipWith((d, x) => R.merge(d, {x1n:x}), data, xt(data.map(d => -1 * revenue_getter(d)))) data = R.zipWith((d, x) => R.merge(d, {x2:x}), data, xt(data.map(d => d.share_of_total_users))) data = R.zipWith((d, x) => R.merge(d, {x2n:x}), data, xt(data.map(d => d.count_of_users_in_this_bucket))) const trimText = t => t.split("\n").map(l => l.trim()).join('\n') data = data.map(d => R.merge(d, { text1: trimText(mode == 'NORMAL' ? `Of Total: ${d3.format('0.1%')(share_of_revenue_getter(d))}
Revenue ${ylabel}: $${d3.format(',.0f')(revenue_getter(d))} ` : `${d3.format('0.1%')(Math.abs(d.x1))}
$ ${d3.format(',.0f')(Math.abs(d.x1n))}`), text2: trimText(mode == 'NORMAL' ? `Of Total Users: ${d3.format('0.1%')(d.share_of_total_users)}
Count: ${d3.format(',.0f')(d.count_of_users_in_this_bucket)}
ARPU ${ylabel}: ${formatARPU(arpu_getter(d))} ` : `${d3.format('0.1%')(Math.abs(d.x2))}
${d3.format(',.0f')(d.x2n)}
ARPU ${ylabel}≥ ${formatARPU(min_revenue_getter(d))}
${d.bucket}`) })) const trace1 = { name: `Share of Revenue ${ylabel}`, type: 'bar', x: data.map(d => d.x1), y: data.map(d => d.bucket), text: data.map(d => d.text1), marker: {color: 'powderblue'}, hoverinfo: 'text', orientation: 'h' }; const trace2 = { name: 'Share of Total Users', type: 'bar', x: data.map(d => d.x2), y: data.map(d => d.bucket), marker: {color: 'seagreen'}, text: data.map(d => d.text2), hoverinfo: 'text', orientation: 'h' }; const datap = [trace1, trace2]; const layout = { xaxis: { type: 'linear', range: R.pipe( ([x, y]) => R.max(x,y), x => [-1 * x, x] )([R.reduce(R.min, Infinity, trace1.x) - 0.05, R.reduce(R.max, -Infinity, trace2.x) + 0.05 ].map(x => Math.abs(x))), title: {text: ''}, ticktext: ["100%", "75%", "50%", "25%", 0, "25%", "50%", "75%", "100%"], tickvals: [-1, -0.75, -0.50, -0.25, 0, 0.25, 0.50, 0.75, 1] }, yaxis: { type: 'linear', range: [-1, 20], title: {text: mode === 'CUMSUM' ? '' : `ARPU ${ylabel}`}, autorange: !true, ticktext: mode === 'CUMSUM' ? [] : R.range(0, 5).map(i => 5 * i * maxARPU / 20).map(formatARPU), tickvals: mode === 'CUMSUM' ? [] : [0, 5, 10, 15, 20] }, bargap: 0.1, barmode: 'relative', autosize: true, margin: {l: mode === 'CUMSUM' ? 5 : 50, t:10, r:10, b:0}, legend: {"orientation": "h", x: 0.5, xanchor: 'center'} }; Plotly.newPlot(div, datap, layout, {responsive: true}); return div; }48:T17ad,draw_funnel = () => { const svg = d35.select(DOM.svg(width + margin.left + margin.right, height + margin.top + margin.bottom)) const percent_format = p => p > 0.1 ? d35.format('.0%')(p) : d35.format('.1%')(p) const g = svg .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom) .append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); const tooltip = d35.select("body").append("div") .attr("class", "svg-tooltip") .style("position", "absolute") .style("visibility", "hidden") g.selectAll("path.link") .data(R.drop(2, plot_data)) .enter() .append("path") .classed('link catted', true) .attr('data-cat', d => d.cat) .style('fill', d => d.fill) .style('stroke', d => d35.rgb(d.fill).darker(1).toString()) .attr('tooltip', d => d.cat) .attr("d", d => link(d)) .on("mouseover", d => { tooltip .style("visibility", "visible") .html(`${d.source.node.cat} → ${d.cat}
${percent_format(d.share_of_rev)} of ${period_to_text(d.period)} revenue comes from
${percent_format(d.sales / d.source.node.sales)} of users in ${d.source.node.cat}

`) // this tooltip was not very useful // ${d35.format('.1%')( // d.sales / R.pipe( // R.filter(c => c.p == d.p - 1), // R.map(c => c.sales), // R.sum // )(plot_data) // )} of users that are still paying.
d35.selectAll(`.catted`) .each(function(t, e) { if(!!t && (t.cat.startsWith(d.cat) || d.cat.startsWith(t.cat))) d35.select(this).style('stroke-width', 2) }) }) .on("mousemove", () => tooltip.style("top", (d35.event.pageY-10)+"px").style("left",(d35.event.pageX+10)+"px") ) .on("mouseout", () => { tooltip.style("visibility", "hidden") d35.selectAll(`.catted`).style('stroke-width', 1) }); g.selectAll("rect.node") .data(R.drop(0, plot_data)) .enter() .append("rect") .classed('node catted', true) .attr('data-cat', d => d.cat) .style('fill', d => d35.rgb(d.fill).darker(0.5).toString()) .style('stroke', d => d35.rgb(d.fill).darker(0.5).toString()) .attr('x', d => d.target.x + 4) .attr('y', d => d.target.y) .attr('width', d => d.target.dx - 8 ) .attr('height', d => d.target.dy ) .on("mouseover", d => tooltip .style("visibility", "visible") .html(` ${percent_format(d.share_of_rev)} of revenue ${period_to_text(d.period)} comes from
${percent_format( d.sales / R.pipe( R.filter(c => c.p == 0), R.map(c => c.sales), R.sum )(plot_data))} of total users `) ) .on("mousemove", () => tooltip.style("top", (d35.event.pageY-10)+"px").style("left",(d35.event.pageX + 10) + "px") ) .on("mouseout", () => tooltip.style("visibility", "hidden") ); // period labels g.selectAll("text.label-period") .data(R.pipe(R.drop(0), R.filter(d => d.cat.startsWith('H')) )(plot_data)) .enter() .append("text") .classed('label-period', true) .attr('x', d => d.target.x ) .attr('y', d => d.target.y - 5) .text(d => period_to_text(d.period)) // cat labels g.selectAll("g.label-cat") .data(R.pipe(R.drop(0), R.filter(x => x.target.dy > 0))(plot_data)) .enter() .append("g") .attr("transform", d => `translate( ${d.target.x + NODE_WIDTH/2 - 5}, ${d.target.dy === 0 ? HEIGHT : d.target.dy <= (HEIGHT / 4) ? (d.target.y + 10) : d.target.y + (d.target.dy)/2 - 10})` ) .classed('label-cat', true) .append('text') .attr('dx', '0').attr('dy', 0) .text(d => d.cat) .style("text-anchor", "center") .attr("transform", d => `rotate(${d.target.dy > (HEIGHT / 9) ? 90 : 0})` ); // link labels g.selectAll("text.label-link") .data(R.pipe(R.drop(2), R.filter(x => x.target.dy > HEIGHT / 5))(plot_data)) .enter() .append("text") .classed('label-link', true) .style('z-index', 100000) .attr('width', SPACE - NODE_WIDTH) .attr('height', 100) .attr('x', d => (d.source.x + NODE_WIDTH) ) .attr('y', d => d.target.dy < HEIGHT / 3 ? (d.target.y + 10) : (d.target.dy === 0 ? HEIGHT : d.target.y + (d.target.dy)/2) ) .html(d => `${d.source.node.cat} → ${d.cat} ${percent_format(d.share_of_rev)} of ${period_to_text(d.period)} revenue comes from ${percent_format(d.sales / d.source.node.sales)} of users in ${d.source.node.cat} `) //borrowed from sankey.js, draws one a line from top of source to top of target, top of target to bottom of target, bottom of target to bottom of source, bottom of source to top of source function link(d) { var curvature = .6; var x0 = d.source.x + d.source.dx, x1 = d.target.x, xi = d35.interpolateNumber(x0, x1), x2 = xi(curvature), x3 = xi(1 - curvature), y0 = d.source.y + d.sy + d.dy / 2, y1 = d.target.y + d.ty + d.dy / 2; return "M" + x0 + "," + y0 + "C" + x2 + "," + y0 + " " + x3 + "," + y1 + " " + x1 + "," + y1 + "L" + x1 + "," + (y1+d.target.dy) + "C" + x3 + "," + (y1+d.target.dy) + " " + x2 + "," + (y0+d.source.dy) + " " + x0 + "," + (y0+d.source.dy) + "L" + x0 + "," + y0; } function period_to_text(period) { return period == 7 ? 'Week 1' : period == 30 ? 'Month 1' : period == 61 ? 'Month 2' : period == 92 ? 'Month 3' : 'Unknown' } return svg.node() }49:[] 44:{"id":"59b6f4eeae094e6a","slug":"top-n-users-by-revenue-generated","title":"Top N Users by Revenue Generated","thumbnail":"998eff1884f62e757e7904b10ee4ad722e9849313937c33acead5792555da56c","access_level":"public","create_time":"$D2019-12-28T13:22:17.280Z","update_time":"$D2022-08-16T16:42:05.279Z","view_time":null,"first_public_time":"$D2019-12-30T09:03:36.746Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"94cdb8fcfaa70289","login":"homam","name":"Homam Hosseini","avatar_url":"https://avatars-next.observableusercontent.com/e0def13806509253b7525280313ec25e10226ac9e6db096f202ba32c26977e45","tier":"starter_2024","bio":"","following":false},"version":714,"publish_version":714,"role":null,"authored":false,"authors":[{"type":"individual","id":"2dc4aa8d6c8e9871","login":"homam","name":"Homam Hosseini","avatar_url":"https://avatars-next.observableusercontent.com/e0def13806509253b7525280313ec25e10226ac9e6db096f202ba32c26977e45","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"2dc4aa8d6c8e9871","login":"homam","name":"Homam Hosseini","avatar_url":"https://avatars-next.observableusercontent.com/e0def13806509253b7525280313ec25e10226ac9e6db096f202ba32c26977e45","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":4,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Top N Users by Revenue Generated","cells":[{"id":0,"value":"md`# Top N Users by Revenue Generated`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"md`## Parameters:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"viewof country = select({\n title: \"Country\",\n description: \"\",\n options: [\"AE\", \"BH\", \"CI\", \"DE\", \"EE\", \"EG\", \"GH\", \"GR\", \"ID\", \"IE\", \"IQ\", \"KW\", \"MY\", \"NL\", \"NO\", \"OM\", \"QA\", \"SE\", \"TH\", \"ZA\"],\n value: \"OM\",\n submit: 'Set'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":215,"value":"viewof operator_code = select({\n title: \"Operator\",\n description: \"\",\n options: operators,\n value: \"-\",\n submit: 'Set',\n multiple: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"viewof gateway = select({\n title: \"Gateway\",\n description: \"\",\n options: gateways,\n value: \"-\",\n submit: 'Set',\n multiple: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"viewof affiliate = select({\n title: \"Affiliate\",\n description: \"\",\n options: affiliates.map(x => ({label: x.name || '-', value: x.id || '-'})),\n value: \"-\",\n submit: 'Set',\n multiple: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"viewof from = slider({\n min: -7 * 30, \n max: -7, \n step: -7, \n value: -7 * 20, \n title: \"From\", \n description: \"N days ago\",\n submit: 'Set'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"viewof bucket = select({\n title: \"Analyzing ARPU ... (for Pyramid Report)\",\n description: \"\",\n options: [\"week_1\", \"month_1\", \"month_2\", \"month_3\"],\n value: \"week_1\",\n submit: 'Set'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":68,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"md`\\`\\`\\`\n Country: ${country}, \n From: ${from} days ago,\n Operators: ${operator_code.join(', ')},\n Gateways: ${gateway.join(', ')}, \n Affiliates: ${affiliate.join(', ')}, \n Analyzing: ${bucket},\n \\`\\`\\`\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"{\n \n const f = Plotly.d3.format('.1%')\n const fn = Plotly.d3.format(',.0f')\n \n const facts = interesting_facts.map(one => `* ${f(one.x1)} of ${ylabel} revenue comes from top ${f(one.x2)} of users`).join(\"\\n\")\n \n return md`\n* Total Users in this Report: ${fn(R.pipe(R.map(d => d.count_of_users_in_this_bucket), R.sum)(raw_data))}\n\n---\n${facts}\n---\n* ${bucket === 'week_1' ? `${f(raw_data[0].count_of_revenue_month_1_gt_revenue_week_1 / raw_data[0].count_of_users_in_this_bucket)} of users that originally generated 0 revenue in W1, contributed to ${f(raw_data[0].share_of_revenue_month_1)} of M1 revenue` : ''}\n`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"{\n const div = DOM.element('div');\n div.style.flexDirection = 'row'\n const left = DOM.element('div');\n const right = DOM.element('div');\n div.appendChild(left)\n div.appendChild(right)\n div.style.display = 'flex'\n // left.style.width = '50%';\n // right.style.width = '50%';\n left.style.flex = '1'\n right.style.flex = '1'\n left.style.maxWidth = '50%'\n right.style.maxWidth = '50%'\n draw_pyramid(left, 'NORMAL')\n draw_pyramid(right, 'CUMSUM')\n Plotly.Plots.resize(right)\n Plotly.Plots.resize(left)\n return div;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":507,"value":"draw_funnel()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":688,"value":"md`\\`H\\` for Hero, \\`Z\\` for Zero`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":437,"value":"md`----\n### Pyramid Math`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":355,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":473,"value":"md`---- \n### Funnel Math`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":477,"value":"colors = d35.scaleOrdinal(d35.schemePastel1.reverse())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":480,"value":"styles = html`\n `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":486,"value":"margin = ({top: 20, right: 20, bottom: 30, left: 5})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":489,"value":"height = HEIGHT + margin.bottom + margin.top","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":492,"value":"NODE_WIDTH = 40\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"HEIGHT = 350\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":498,"value":"SPACE = width / 3.3\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":500,"value":"find_source = (acc, a) => acc.find(c => c.p === a.p - 1 && a.cat.startsWith(c.cat)) || {target: {dy: 0, x: 0, y: 0}}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":483,"value":"plot_data = R.pipe(\n R.map(d => R.merge({p: d.cat.split('-').length - 1}, d))\n// , R.filter(d => d.p > 0)\n, R.reduce((acc, a) => acc.concat([ \n R.merge(\n {\n cat: a.cat,\n dy: 0, //link height, same as source.dy?\n source: {\n dx: NODE_WIDTH, //node width\n dy: find_source(acc, a).target.dy, //link height\n x: find_source(acc, a).target.x, //node position\n y: find_source(acc, a).target.y,\n node: find_source(acc, a)\n },\n sy: 0, //y-offset of link from top of source node\n target: {\n dx: NODE_WIDTH, //node width\n dy: a.share_of_rev * HEIGHT, //node height\n x: SPACE * a.p, //node position\n y: 10 + R.pipe(n => n.target.y + n.target.dy)(R.last(acc.filter(c => c.p === a.p)) || {target: {dy: 0, x: 0, y: 0}})\n },\n ty: 0, //y-offset of link from top of target node\n value: 2,\n fill: find_source(acc, a).share_of_rev > 0 ? find_source(acc, a).fill : colors(a.cat)\n }, a)\n ]), [])\n)(funnel_raw_data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":505,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"md`### Fetch`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"PROJECT_ID = new URL(location.href).searchParams.get('project-id')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"get_dimension_values = dimension => fetch(`https://pipe.sam-media.com/apis/projects/${PROJECT_ID}/documents/rDVUH68/versions/10/execute/7200/query?from=${from}&dimension=${dimension}&countries=${country}&operators=-&gateways=-&affiliates=-&services1=-`).then(x => x.json()).then(xs => ['-'].concat(xs.map(x => x.dimension)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"affiliates = get_dimension_values('affiliate_id').then(xs => xs.map(x => {\n const [name, id] = x.split(':')\n return {name, id}\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"operators = get_dimension_values('operator_code')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":231,"value":"gateways = get_dimension_values('gateway')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":709,"value":"raw_data_url = `https://pipe.sam-media.com/apis/projects/${PROJECT_ID}/documents/rLWu7kj/versions/16/execute/7200/query?from=${from}&bucket=${bucket}&countries=${country}&gateways=${gateway.join(',')}&affiliates=${affiliate.join(',')}&operators=${operator_code.join(',')}&service1=-`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"raw_data = fetch(raw_data_url).then(x => x.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":459,"value":"funnel_raw_data = fetch(`https://pipe.sam-media.com/apis/projects/${PROJECT_ID}/documents/rM4AfhJ/versions/4/execute/7200/query?from=${from}&bucket=${bucket}&countries=${country}&gateways=${gateway.join(',')}&affiliates=${affiliate.join(',')}&operators=${operator_code.join(',')}&service1=-`).then(x => x.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":210,"value":"md`---- \n### Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"import {select, input, slider, text, number} from \"@jashkenas/inputs\"\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"Plotly = require(\"https://cdn.plot.ly/plotly-latest.min.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"R = require('ramda@0.25.0/dist/ramda.min.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"d3 = Plotly.d3","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":468,"value":"d35 = require(\"d3@5\", \"d3-sankey@0.7\", \"d3-scale-chromatic\", \"d3-color\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"md`----`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"ylabel = bucket == 'week_1' ? 'W1' : \n bucket == 'week_2' ? 'W2' : \n bucket == 'month_1' ? 'M1' : \n bucket == 'month_2' ? 'M2' :\n bucket == 'month_3' ? 'M3' : '?'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"formatARPU = d3.format(',.2f')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":180,"value":"arpu_getter = R.prop(`arpu_${bucket}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"share_of_revenue_getter = R.prop(`share_of_revenue_${bucket}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"revenue_getter = R.prop(`revenue_${bucket}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"min_revenue_getter = R.prop(`min_revenue_${bucket}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 45:"$44:body"