30:T50a,CL_cpl_plot = Plot.plot({ marginTop: 45, marginRight: 70, //insetLeft: 10, height: chart_height, width: chart_width, x: { nice: d3.utcMonth }, marks: [ //axes Plot.axisX({anchor: 'top', ticks: 'quarter', tickSize: 0, tickFormat: 'Q' + '%q', opacity: 0.25, label: null}), Plot.gridX({interval: 'quarter', opacity: 0.05}), Plot.gridY({opacity: 0.05}), Plot.axisX({anchor: 'bottom', label: null}), Plot.axisY({label: 'CPL ↑', tickFormat: '$.0f'}), // data marks Plot.line(clean_cpl, { x: 'week_date', y: 'CPL', stroke: appcast_color_palette[6], strokeWidth: 1 }), Plot.dot(clean_cpl, { x: 'week_date', y: 'CPL', fill: appcast_color_palette[6], r: 2.5, stroke: 'white' }), Plot.text(clean_cpl, Plot.selectLast({ x: 'week_date', y: 'CPL', dx: -10, dy: 12, fontSize: 11, textAnchor: 'start', text: d => `${d3.format('+.1%')(d['WoW CPL Difference (%)'])} WoW` })), Plot.text(clean_cpl, Plot.selectLast({ x: 'week_date', y: 'CPL', dx: 0, dy: 22, fontSize: 11, opacity: 0.5, textAnchor: 'start', text: d => `\n (${d3.format('$.1f')(d.CPL)})` })), Plot.ruleY([0]) ] })31:T537,CL_cpbgc_plot = Plot.plot({ marginTop: 45, marginRight: 70, height: chart_height, width: chart_width, x: { nice: d3.utcMonth }, marks: [ //axes Plot.axisX({anchor: 'top', ticks: 'quarter', tickSize: 0, tickFormat: 'Q' + '%q', opacity: 0.25, label: null}), Plot.gridX({interval: 'quarter', opacity: 0.05}), Plot.gridY({opacity: 0.05}), Plot.axisX({anchor: 'bottom', label: null}), Plot.axisY({label: 'CPBGC ↑', tickFormat: '$.0f'}), // data marks Plot.text(clean_cpl, Plot.selectLast({ x: 'week_date', y: 'CPBGC', dx: 0, // black text left/right dy: -20, // black text up/down fontSize: 11, textAnchor: 'start', text: d => `${d3.format('+.1%')(d['WoW CPBGC Difference (%)'])} WoW` })), Plot.text(clean_cpl, Plot.selectLast({ x: 'week_date', y: 'CPBGC', dx: 10, dy: -10, fontSize: 11, opacity: 0.5, textAnchor: 'start', text: d => `\n (${d3.format('$.1f')(d.CPBGC)})` })), Plot.line(clean_cpl, { x: 'week_date', y: 'CPBGC', stroke: appcast_color_palette[6], strokeWidth: 1 }), Plot.dot(clean_cpl, { x: 'week_date', y: 'CPBGC', fill: appcast_color_palette[6], r: 2.5, stroke: 'white' }), Plot.ruleY([0]) ] })32:T5e9,vl.hconcat( vl.layer( vl.markLine() .data(clean) .encode( vl.x().fieldT('week_date') .axis({format: '%B', tickCount: 'month'}) .title(null), vl.y().sum('BGC'), //vl.color().fieldN('Craigslist Category') ), // vl.markRule() // .data(date_line) // .encode( // vl.x().fieldT('date') // ), // vl.markText() // .data(date_line) // .encode( // vl.x().fieldT('date'), // vl.y().value(-'height'), // vl.text().value('Title swap') // ) ) .height(chart_height), vl.layer( vl.markLine() .data(clean) .encode( vl.x().fieldT('week_date') .axis({format: '%B', tickCount: 'month'}) .title(null), vl.y().sum('Leads'), //vl.color().fieldN('Craigslist Category') ), // vl.markRule() // .data(date_line) // .encode( // vl.x().fieldT('date') // ), // vl.markText() // .data(date_line) // .encode( // vl.x().fieldT('date'), // vl.y().value(-'height'), // vl.text().value('Title swap') // ) ) .height(chart_height) ) .padding({bottom: 50}) .config({ view: {stroke: null}, line: {point: {stroke: 'white', size: 35}, strokeWidth: 1}, //axisX: {grid: null}, axisY: {domain: null, titlePadding: 15, grid: true}, axis: {grid: false, gridOpacity: 0.5}, rule: {stroke: 'firebrick', strokeDash: [1,3]}, text: {color: 'firebrick', angle: 90, fontSize: 9, dy: -6, dx: 25, fontWeight: 200} }) .render()33:T44a,viewof clean_perc_change = Inputs.table( clean .groupby('week_date') .rollup({ Spend: d => op.sum(d.Spend), Leads: d => op.sum(d.Leads), BGC: d => op.sum(d.BGC), Activations: d => op.sum(d.Activations) }) .derive({ 'WoW Spend Difference': d => d.Spend - op.lag(d.Spend,1), 'WoW Lead Difference': d => d.Leads - op.lag(d.Leads,1), 'WoW BGC Difference': d => d.BGC - op.lag(d.BGC,1), 'WoW Activation Difference': d => d.Activations - op.lag(d.Activations,1), }) .derive({ 'WoW Lead Difference (%)': d => d['WoW Lead Difference'] / op.lag(d.Leads,1), 'WoW BGC Difference (%)': d => d['WoW BGC Difference'] / op.lag(d.BGC,1) }) .objects(), { layout: 'auto', format: { Spend: d3.format('$,.0f'), "Wow Spend Difference": d3.format('$'), "WoW Lead Difference (%)": d3.format('.1%'), "WoW BGC Difference (%)": d3.format('+.1%') }, columns: ['week_date', 'Leads', 'BGC', 'WoW Lead Difference', 'WoW Lead Difference (%)', 'WoW BGC Difference', 'WoW BGC Difference (%)'], width: 900, height: 450 } )34:T44d,viewof clean_cpl = clean .groupby('week_date') .rollup({ Spend: d => op.sum(d.Spend), Leads: d => op.sum(d.Leads), BGC: d => op.sum(d.BGC), Activations: d => op.sum(d.Activations) }) .derive({ CPL: d => d.Spend / d.Leads, CPBGC: d => d.Spend / d.BGC, CPA: d => d.Spend / d.Activations, LtoBGC: d => d.BGC / d.Leads }) .derive({ 'WoW Spend Difference': d => d.Spend - op.lag(d.Spend,1), 'WoW Lead Difference': d => d.Leads - op.lag(d.Leads,1), 'WoW BGC Difference': d => d.BGC - op.lag(d.BGC,1), 'WoW Activation Difference': d => d.Activations - op.lag(d.Activations,1), 'WoW CPL Difference': d => d.CPL - op.lag(d.CPL,1), 'WoW CPBGC Difference': d => d.CPBGC - op.lag(d.CPBGC,1), }) .derive({ 'WoW Lead Difference (%)': d => d['WoW Lead Difference'] / op.lag(d.Leads,1), 'WoW BGC Difference (%)': d => d['WoW BGC Difference'] / op.lag(d.BGC,1), 'WoW CPL Difference (%)': d => d['WoW CPL Difference'] / op.lag(d.CPL,1), 'WoW CPBGC Difference (%)': d => d['WoW CPBGC Difference'] / op.lag(d.CPBGC,1), }) .view()35:[] 2e:{"title":"Lyft Craigslist","cells":[{"id":0,"value":"md `# Lyft Craigslist \n*Weekly Report*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1119,"value":"md `
\n## Step 1\n\nGo to this [page](https://lyft.appcast.io/cc/employer/4972/reports/by_cl_category?params=%7B%22devise%22:%22all%22,%22jobGroupStatsSource%22:%22data%22,%22jobGroupStatus%22:%22all%22,%22traffic%22:%22all_wo_organic%22,%22status%22:%5B%22sponsored%22,%22unsponsored%22,%22expired%22,%22aggregated%22,%22suspended%22%5D,%22sort%22:%22spent-desc%22,%22publisherType%22:%22all%22,%22job_group_types%22:%5B%5D,%22job_boards%22:%5B%5D,%22job_groups%22:%5B%5D,%22month%22:%222023-06%22,%22jobBoardId%22:%22%22,%22startDate%22:%222023-6-5%22,%22endDate%22:%222023-6-11%22%7D&s=actualSpend.value-desc) and set the date range to the previous week. Copy the contents of the table.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1122,"value":"md `## Step 2\n\nGo to this [spreadsheet](https://stepstonecore.sharepoint.com/:x:/s/AppcastServiceDeliveryTraining/sckc/EVRwcsSfahBPhnrifg71_P8Bz2cLDmNfEPnCqSJghikONQ?e=TWjQZA) and add the data from the table you accessed in the UI above. Then download the file as an \".xlsx\"`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1125,"value":"md `## Step 3`","pinned":false,"hidden":false,"mode":"ojs"},{"id":503,"value":"viewof file = Inputs.file({label: \"Load the data\", required: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":598,"value":"md `

\n## Craigslist\n*WoW - January to date*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":952,"value":"CL_leads_plot = Plot.plot({\n marginTop: 30,\n marginRight: 75,\n x: {\n //nice: d3.utcMonth\n },\n height: chart_height,\n width: chart_width,\n marks: [\n //axes\n Plot.axisX({anchor: 'bottom', label: null}),\n Plot.axisY({label: 'Leads ↑'}),\n // data marks\n Plot.text(clean_perc_change, Plot.selectLast({\n x: 'week_date',\n y: 'Leads',\n dx: -10,\n dy: -12,\n fontSize: 11,\n textAnchor: 'start',\n text: d => `${d3.format('+.1%')(d['WoW Lead Difference (%)'])} WoW`\n })),\n Plot.rectY(clean, Plot.binX({y: 'sum'},{\n x: 'week_date',\n y: 'Leads',\n thresholds: d3.utcMonday,\n insetRight: barChart_inset,\n insetLeft: barChart_inset,\n fill: appcast_color_selector,\n })),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":967,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":913,"value":"CL_bgc_plot = Plot.plot({\n marginTop: 30,\n marginRight: 75,\n height: chart_height,\n width: chart_width,\n x: {\n //nice: d3.utcMonth\n },\n marks: [\n //axes\n Plot.axisX({anchor: 'bottom', label: null}),\n Plot.axisY({label: 'BGC ↑'}),\n // data marks\n Plot.text(clean_perc_change, Plot.selectLast({\n x: 'week_date',\n y: 'BGC',\n dx: 0, // text left/right\n dy: -9, // text up/down\n fontSize: 11,\n textAnchor: 'start',\n text: d => `${d3.format('+.1%')(d['WoW BGC Difference (%)'])} WoW`\n })),\n Plot.rectY(clean, Plot.binX({y: 'sum'},{\n x: 'week_date',\n y: 'BGC',\n thresholds: d3.utcMonday,\n insetRight: barChart_inset,\n insetLeft: barChart_inset,\n fill: appcast_color_selector,\n })),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":984,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":1004,"value":"Plot.plot({\n marginTop: 45,\n marginRight: 70,\n height: chart_height,\n width: chart_width,\n x: {\n nice: d3.utcMonth\n },\n marks: [\n //axes\n Plot.axisX({anchor: 'top', ticks: 'quarter', tickSize: 0, tickFormat: 'Q' + '%q', opacity: 0.25, label: null}),\n Plot.gridX({interval: 'quarter', opacity: 0.05}),\n Plot.gridY({opacity: 0.05}),\n Plot.axisX({anchor: 'bottom', label: null}),\n Plot.axisY({label: 'Lead to BGC CR ↑', tickFormat: '.0%'}),\n // data marks\n Plot.line(clean_cpl, {\n x: 'week_date',\n y: 'LtoBGC',\n stroke: appcast_color_palette[6],\n strokeWidth: 1\n }),\n Plot.dot(clean_cpl, {\n x: 'week_date',\n y: 'LtoBGC',\n fill: appcast_color_palette[6],\n r: 2.5,\n stroke: 'white'\n }),\n Plot.text(clean_cpl, Plot.selectLast({\n x: 'week_date',\n y: 'LtoBGC',\n dx: -10,\n dy: 15,\n fontSize: 11,\n textAnchor: 'start',\n text: d => `${d3.format('.1%')(d.LtoBGC)}`\n })),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1130,"value":"md `

\n\n### *Control Panel for Charts*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":896,"value":"viewof chart_height = Inputs.range([0, 400], {label: \"chart height\", step: 1})","pinned":false,"hidden":false,"mode":"ojs"},{"id":926,"value":"viewof chart_width = Inputs.range([400, 1000], {label: \"Chart Width\", step: 10, value: 400})","pinned":false,"hidden":false,"mode":"ojs"},{"id":929,"value":"viewof barChart_inset = Inputs.range([0, 10], {label: \"Bar chart inset\", step: 1, value: 2})","pinned":false,"hidden":false,"mode":"ojs"},{"id":933,"value":"viewof appcast_color_selector = Inputs.radio(appcast_color_palette, {\n label: \"Chart Fill/Stroke Color\", \n value: appcast_color_palette[5],\n format: (x) => html`${x}`\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1133,"value":"md `

\n# Historical View\n\n*(not for the weekly report)*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":584,"value":"md `## CL - by Category\n*WoW - January to date*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":675,"value":"vl.layer(\n // line charts\n vl.markLine()\n .data(clean)\n .encode(\n vl.x().fieldT('week_date')\n .axis({format: '%b-%d', tickCount: 'week'})\n .title(null),\n vl.y().fieldQ('BGC'),\n vl.color().fieldN('category')\n ),\n\n vl.markRule()\n .data(date_line)\n .encode(\n vl.x().fieldT('date')\n ),\n\n vl.markText()\n .data(date_line)\n .encode(\n vl.x().fieldT('date'),\n vl.y().value(-'height'),\n vl.text().value('Title swap')\n )\n )\n .height(100)\n .config({\n view: {stroke: null},\n line: {point: {stroke: 'white', size: 35}, strokeWidth: 1},\n //axisX: {grid: null},\n axisY: {domain: null, titlePadding: 15},\n axis: {gridOpacity: 0.5},\n rule: {stroke: 'firebrick', strokeDash: [1,3]},\n text: {color: 'firebrick', angle: 90, fontSize: 9, dy: -6, dx: 25, fontWeight: 200}\n })\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":527,"value":"vl.layer(\n // line charts\n vl.markLine()\n .data(clean)\n .encode(\n vl.x().fieldT('week_date')\n .axis({format: '%b-%d', tickCount: 'week'})\n .title(null),\n vl.y().fieldQ('Leads'),\n vl.color().fieldN('category')\n ),\n\n vl.markRule()\n .data(date_line)\n .encode(\n vl.x().fieldT('date')\n ),\n\n vl.markText()\n .data(date_line)\n .encode(\n vl.x().fieldT('date'),\n vl.y().value(-'height'),\n vl.text().value('Title swap')\n )\n )\n .height(100)\n .config({\n view: {stroke: null},\n line: {point: {stroke: 'white', size: 35}, strokeWidth: 1},\n //axisX: {grid: null},\n axisY: {domain: null, titlePadding: 15},\n axis: {gridOpacity: 0.5},\n rule: {stroke: 'firebrick', strokeDash: [1,3]},\n text: {color: 'firebrick', angle: 90, fontSize: 9, dy: -6, dx: 25, fontWeight: 200}\n })\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":744,"value":"vl.layer(\n // line charts\n vl.markLine()\n .data(clean)\n .encode(\n vl.x().fieldT('week_date')\n .axis({format: '%b-%d', tickCount: 'week'})\n .title(null),\n vl.y().fieldQ('Activations'),\n vl.color().fieldN('category')\n ),\n\n vl.markRule()\n .data(date_line)\n .encode(\n vl.x().fieldT('date')\n ),\n\n vl.markText()\n .data(date_line)\n .encode(\n vl.x().fieldT('date'),\n vl.y().value(-'height'),\n vl.text().value('Title swap')\n )\n )\n .height(100)\n .config({\n view: {stroke: null},\n line: {point: {stroke: 'white', size: 35}, strokeWidth: 1},\n //axisX: {grid: null},\n axisY: {domain: null, titlePadding: 15},\n axis: {gridOpacity: 0.5},\n rule: {stroke: 'firebrick', strokeDash: [1,3]},\n text: {color: 'firebrick', angle: 90, fontSize: 9, dy: -6, dx: 25, fontWeight: 200}\n })\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":792,"value":"vl.layer(\n // line charts\n vl.markLine({tooltip: true})\n .data(clean)\n .encode(\n vl.x().fieldT('week_date')\n .axis({format: '%b-%d', tickCount: 'week'})\n .title(null),\n vl.y().fieldQ('Spend'),\n vl.color().fieldN('category')\n ),\n\n vl.markRule()\n .data(date_line)\n .encode(\n vl.x().fieldT('date')\n ),\n\n vl.markText()\n .data(date_line)\n .encode(\n vl.x().fieldT('date'),\n vl.y().value(-'height'),\n vl.text().value('Title swap')\n )\n )\n .height(100)\n .config({\n view: {stroke: null},\n line: {point: {stroke: 'white', size: 35}, strokeWidth: 1},\n //axisX: {grid: null},\n axisY: {domain: null, titlePadding: 15},\n axis: {gridOpacity: 0.5},\n rule: {stroke: 'firebrick', strokeDash: [1,3]},\n text: {color: 'firebrick', angle: 90, fontSize: 9, dy: -6, dx: 25, fontWeight: 200}\n })\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":610,"value":"md `
\n### CPL, CPBGC, CPA`","pinned":false,"hidden":false,"mode":"ojs"},{"id":605,"value":"vl.layer(\n // line charts\n vl.markLine()\n .data(clean)\n .encode(\n vl.x().fieldT('week_date')\n .axis({format: '%b-%d', tickCount: 'week'})\n .title(null),\n vl.y().fieldQ('CPL'),\n vl.color().fieldN('category')\n ),\n\n vl.markRule()\n .data(date_line)\n .encode(\n vl.x().fieldT('date')\n )\n )\n .height(100)\n .config({\n view: {stroke: null},\n line: {point: {stroke: 'white', size: 35}, strokeWidth: 1},\n //axisX: {grid: null},\n axisY: {domain: null, titlePadding: 15},\n axis: {gridOpacity: 0.5},\n rule: {stroke: 'firebrick', strokeDash: [1,3]}\n })\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":682,"value":"vl.layer(\n // line charts\n vl.markLine()\n .data(clean)\n .encode(\n vl.x().fieldT('week_date')\n .axis({format: '%b-%d', tickCount: 'week'})\n .title(null),\n vl.y().fieldQ('CPBGC'),\n vl.color().fieldN('category')\n ),\n\n vl.markRule()\n .data(date_line)\n .encode(\n vl.x().fieldT('date')\n )\n )\n .height(100)\n .config({\n view: {stroke: null},\n line: {point: {stroke: 'white', size: 35}, strokeWidth: 1},\n //axisX: {grid: null},\n axisY: {domain: null, titlePadding: 15},\n axis: {gridOpacity: 0.5},\n rule: {stroke: 'firebrick', strokeDash: [1,3]}\n })\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":747,"value":"vl.layer(\n // line charts\n vl.markLine()\n .data(clean)\n .encode(\n vl.x().fieldT('week_date')\n .axis({format: '%b-%d', tickCount: 'week'})\n .title(null),\n vl.y().fieldQ('CPA'),\n vl.color().fieldN('category')\n ),\n\n vl.markRule()\n .data(date_line)\n .encode(\n vl.x().fieldT('date')\n )\n )\n .height(100)\n .config({\n view: {stroke: null},\n line: {point: {stroke: 'white', size: 35}, strokeWidth: 1},\n //axisX: {grid: null},\n axisY: {domain: null, titlePadding: 15},\n axis: {gridOpacity: 0.5},\n rule: {stroke: 'firebrick', strokeDash: [1,3]}\n })\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":617,"value":"md `
\n### CPL, CPBGC, CPA`","pinned":false,"hidden":false,"mode":"ojs"},{"id":613,"value":"vl.data(clean_cpl)\n .layer(\n vl.markLine()\n .encode(\n vl.x().fieldT('week_date')\n .axis({format: '%b-%d', tickCount: 'week'})\n .title(null),\n vl.y().fieldQ(vl.repeat('row')),\n ),\n vl.markRule({stroke: 'red'})\n .encode(\n vl.x().fieldT(title_change_date)\n )\n )\n .height(100)\n .repeat({row: ['CPL', 'CPBGC', 'CPA', 'Spend']})\n .config({\n view: {stroke: null},\n line: {point: {stroke: 'white', size: 35, fill: 'firebrick'}, strokeWidth: 1, stroke: 'firebrick'},\n //axisX: {grid: null},\n axisY: {domain: null, titlePadding: 15},\n axis: {gridOpacity: 0.5}\n })\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":88,"value":"
\n
\n
\n

","pinned":false,"hidden":false,"mode":"html"},{"id":860,"value":"md `## by Region`","pinned":false,"hidden":false,"mode":"ojs"},{"id":863,"value":"viewof file1 = Inputs.file({label: \"Data\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":865,"value":"raw_athena = file1.csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":868,"value":"aq.from(raw_athena)\n .rename({'master_publisher_aggregated': 'publisher'})\n .filter(d => d.publisher === 'Craigslist Official Posting')\n .view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":858,"value":"
\n
\n
\n

","pinned":false,"hidden":false,"mode":"html"},{"id":1047,"value":"md `## Legacy Charts`","pinned":false,"hidden":false,"mode":"ojs"},{"id":789,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":687,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"md `## Appendix\n\n_Implementation & data stuff_`","pinned":false,"hidden":false,"mode":"ojs"},{"id":935,"value":"appcast_color_palette = ['#05062C', '#3138BB','#FF7D6F', '#AF9BFC', '#C7FFE2', '#127FFC', '#FF9B77', '#B7D8FE', '#DAE2FD', '#FAFAFA']","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"### *Data*","pinned":false,"hidden":false,"mode":"md"},{"id":508,"value":"viewof clean = aq.from(excel_parsed)\n .derive({\n CPL: d => +op.replace(d.CPL, '$',''),\n CPBGC: d => +op.replace(d.CPBGC, '$',''),\n CPA: d => op.replace(d.CPA, '$',''),\n Spend: d => op.replace(d.Spend, '$','')\n })\n .derive({\n Spend: d => +op.replace(d.Spend, ',',''),\n CPA: d => +op.replace(d.CPA, ',',''),\n week_date: d => op.parse_date(d.from)\n })\n .derive({\n category: d => op.match(d['Craigslist Category'], /general/,0) == 'general' ? 'Jobs' : 'Gigs'\n })\n //.slice(0,-5) // use to remove the last rows\n .view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":874,"value":"$34","pinned":true,"hidden":false,"mode":"ojs"},{"id":505,"value":"raw_data = file.xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":631,"value":"excel_parsed = raw_data.sheet('in', {headers: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":664,"value":"md `### *Date of change*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":550,"value":"viewof title_change_date = Inputs.date({label: \"CL Title Change\", value: \"2023-01-28\", readonly: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":883,"value":"viewof campaign_count_change_date = Inputs.date({label: \"CL Title Change\", value: \"2023-04-03\", readonly: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":667,"value":"date_line = [\n {date: title_change_date},\n //{date: campaign_count_change_date}\n]","pinned":true,"hidden":false,"mode":"ojs"},{"id":187,"value":"### *Secondary data sources*","pinned":false,"hidden":false,"mode":"md"},{"id":69,"value":"// all vega data-sets\n\n// to 'extract' a dataset as an array (only for .csv and .json)\n// use this format: football = v_data['football.json']()\n// for some .csv, it's better to use the url format: zipcodes = v_data['zipcodes.csv'].url\n// this is due to the fact that parsing it as an array of objects results in zipcodes of the form \"00313\" turning into \"313\"\n\nv_data = require('vega-datasets@2')","pinned":false,"hidden":false,"mode":"ojs"},{"id":98,"value":"zips = v_data['zipcodes.csv'].url","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"us_holidays_2021 = USholidays.filter(d => op.utcyear(date_parser(d.date)) == 2021)","pinned":false,"hidden":false,"mode":"ojs"},{"id":193,"value":"### *Libraries*","pinned":false,"hidden":false,"mode":"md"},{"id":4,"value":"import {vl} from '@vega/vega-lite-api-v5'","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"import {uniqueValid} from '@uwdata/data-utilities'","pinned":false,"hidden":false,"mode":"ojs"},{"id":59,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs"},{"id":137,"value":"// object containing all of the FiPS us county codes\n\nimport {counties} from \"@d3/choropleth\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":391,"value":"// list of US Holidays\n\nimport {USholidays} from \"@observablehq/microsoft-reactor-hackathon\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":480,"value":"import {Legend, Swatches} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":483,"value":"import {DuckDBClient} from \"@cmudig/duckdb\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":486,"value":"import { palettes } from '@makio135/give-me-colors'","pinned":false,"hidden":false,"mode":"ojs"},{"id":496,"value":"// this is a really cool way of displaying tables. Much more aesthetically pleasing than the defaults of arquero and input.table\n\nimport { formatTable } from \"@saneef/pretty-tables\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":456,"value":"md `### *Functions*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":409,"value":"date_parser = d3.utcParse('%m/%d/%Y')","pinned":true,"hidden":false,"mode":"ojs"},{"id":208,"value":"### *Chart configuration*","pinned":false,"hidden":false,"mode":"md"},{"id":202,"value":"clean_config = ({\n view: { stroke: null },\n axis: {\n gridOpacity: 0.5,\n labelFontWeight: 75,\n domain: false,\n offset: 5,\n titleFontWeight: 350,\n titleFontSize: 10\n },\n axisX: {\n tickCount: 5,\n titlePadding: 10,\n labelPadding: 4\n },\n axisY: {\n ticks: false,\n labelLimit: 300,\n labelFontSize: 7\n },\n title: {\n fontWeight: 300,\n fontSize: 13,\n offset: 25\n }\n})","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W35","stdlib":"1","titling":"auto"}