2f:[{"id":"c52b9a0656385b4f28499a1eba374207d2fb65f18145035c6418f790c0ed61ce239585c73ea975dcb59453c1bd4a1b76670611b7198d35279f19b2f8cd98ddc9","href":"https://static.observableusercontent.com/files/c52b9a0656385b4f28499a1eba374207d2fb65f18145035c6418f790c0ed61ce239585c73ea975dcb59453c1bd4a1b76670611b7198d35279f19b2f8cd98ddc9","name":"aya-healthcare-by_day-2023-01-01-2023-08-14.csv","type":"text/csv","lastModified":1692037815560.472,"size":40845}] 2d:{"title":"Canada Weekly","cells":[{"id":1425,"value":"md `# Canada Weekly`","pinned":true,"hidden":false,"mode":"ojs"},{"id":1373,"value":"viewof file = Inputs.file({label: \"Data\", required: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1377,"value":"raw_indeed_rn = file.csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":824,"value":"viewof start_date = Inputs.date({label: \"Start date\", value: \"2023-01-01\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":830,"value":"viewof end_date = Inputs.date({label: \"End date\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1450,"value":"Plot.plot({\n height: 600,\n width: 300,\n marginTop: 50,\n x: { \n label: null\n },\n facet: {\n label: null\n },\n fy: {\n padding: 0.4\n },\n marks: [\n //Plot.gridX(),\n Plot.axisX({interval: 'month'}),\n Plot.rectY(clean, {\n x: \"week\", \n y: \"leads\", \n interval: d3.utcMonday, \n fy: 'title',\n sort: {fy: \"-x\", reduce: \"sum\"},\n insetRight: 3,\n fill: appcast_color_palette[7],\n tip: true\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1488,"value":"Plot.plot({\n height: 600,\n width: 300,\n marginTop: 50,\n x: {\n //nice: d3.utcMonth\n },\n facet: {\n label: null\n },\n fy: {\n padding: 0.4\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: 'CPL ↑', tickFormat: '$.0f'}),\n\n // data marks\n Plot.lineY(clean, {\n x: \"week\", \n y: \"leads\", \n strokeWidth: 1,\n fy: 'title',\n channels: {leads: {value: 'leads'}},\n sort: {fy: '-leads', reduce: 'sum'},\n stroke: appcast_color_palette[0]\n }),\n Plot.dot(clean, {\n x: \"week\", \n y: \"leads\", \n r: 2.25,\n stroke: 'white',\n fy: 'title',\n //channels: {leads: {value: 'leads'}},\n //sort: {y: '-leads', reduce: 'sum'},\n fill: appcast_color_palette[0]\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1520,"value":"viewof table = Inputs.table(spend_table, {\n layout: 'auto',\n width: 400,\n columns: ['week', 'title', 'spend'],\n format: {\n spend: d3.format('$,.0f')\n },\n header: {\n spend: 'Spend Last Week',\n title: 'Campaign'\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1508,"value":"last_monday = d3.utcMonday(d3.utcDay.offset(new Date(), -7))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1505,"value":"spend_table = clean\n .filter(aq.escape(d => +d3.utcDay(d.week) == +last_monday))\n .join(spend_sort_table, ['title', 'title'])\n .orderby(aq.desc('agg_leads'))\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1544,"value":"viewof spend_sort_table = clean \n .groupby('title')\n .rollup({\n leads: d => op.sum(d.leads)\n })\n .rename({leads: 'agg_leads'})\n .orderby(aq.desc('agg_leads'))\n .view('title')","pinned":true,"hidden":false,"mode":"ojs"},{"id":88,"value":"
\n
\n
\n

","pinned":false,"hidden":false,"mode":"html"},{"id":1565,"value":"md `## Budget increase`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1572,"value":"Plot.lineY(cleaner, Plot.binX({y: 'sum'},{x: 'week', y: 'leads', thresholds: d3.utcMonday})).plot()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1568,"value":"viewof cleaner = clean.view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1563,"value":"
\n
\n
\n

","pinned":false,"hidden":false,"mode":"html"},{"id":20,"value":"md `## Appendix\n\n_Implementation & data stuff_`","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"### *Data*","pinned":false,"hidden":false,"mode":"md"},{"id":1186,"value":"md `## Main data source`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1382,"value":"viewof clean = aq.from(raw_indeed_rn)\n .filter(aq.escape(d => d.date >= start_date && d.date <= end_date))\n .derive({\n week: aq.escape(d => d3.utcMonday(d.date))\n })\n .groupby('week', 'title')\n .rollup({\n spend: d => op.sum(d.spend),\n leads: d => op.sum(d.leads)\n })\n .derive({\n cpl: d => d.spend / d.leads\n })\n .filter(d => op.includes(d.title, 'Default') == false)\n .orderby('week')\n .view()","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":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":59,"value":"import { aq, op } from '@uwdata/arquero'","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":514,"value":"import {textcolor} from \"@observablehq/text-color-annotations-in-markdown\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":702,"value":"import {toc} from \"@nebrius/indented-toc\"","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":710,"value":"appcast_color_palette = ['#05062C', '#3138BB','#FF7D6F', '#AF9BFC', '#C7FFE2', '#127FFC', '#FF9B77', '#B7D8FE', '#DAE2FD', '#FAFAFA']","pinned":false,"hidden":false,"mode":"ojs"},{"id":717,"value":"Plot.cell(appcast_color_palette, {x: d => d, fill: d => d}).plot()","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":632,"value":"// sample of how to place html blocks in a grid\n\n// html `

\n// ${viewof spend}\n// ${viewof cpl}\n// ${viewof cpc}\n//

`","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}