2f:[] 2d:{"title":"Applies per Campaign - Two methods compared","cells":[{"id":0,"value":"md `# Applies per Campaign - Two methods compared`","pinned":false,"hidden":false,"mode":"ojs"},{"id":503,"value":"viewof file = Inputs.file({label: \"Data\", required: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":626,"value":"md `*(using the performance file from dash)*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":553,"value":"md `

\n## Distinct`","pinned":false,"hidden":false,"mode":"ojs"},{"id":523,"value":"Plot.plot({\n insetTop: 50,\n marginLeft: 75,\n grid: true,\n height: 200,\n width,\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(distinct, {x: \"week_date\", y: \"dist_campaigns\", marker: true, title: d => `${d.dist_campaigns}`}),\n Plot.text(distinct, {x: 'week_date', y: 'dist_campaigns', text: 'dist_campaigns', dy: -10})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":597,"value":"Plot.plot({\n insetTop: 50,\n marginLeft: 75,\n grid: true,\n height: 200,\n width,\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(distinct, {x: \"week_date\", y: \"apps\", marker: true, title: d => `${d.apps}`}),\n Plot.text(distinct, {x: 'week_date', y: 'apps', text: 'apps', dy: -10})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":511,"value":"viewof distinct = aq.from(clean)\n .groupby('week_date')\n .rollup({\n dist_campaigns: d => op.distinct(d.job_req_id),\n dist_job_id: d => op.array_agg_distinct(d.job_req_id),\n apps: d => op.sum(d.applies)\n })\n .derive({ apps_p_campaign: d => d.apps/d.dist_campaigns})\n .orderby('week_date')\n //.orderby(aq.desc('week_date'))\n .view()","pinned":false,"hidden":false,"mode":"ojs"},{"id":556,"value":"md `

\n## All`","pinned":false,"hidden":false,"mode":"ojs"},{"id":530,"value":"Plot.plot({\n insetTop: 50,\n grid: true,\n height: 200,\n width,\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(all, {x: \"week_date\", y: \"all_campaigns\", marker: true, title: d => `${d.all_campaigns}`}),\n Plot.text(all, {x: 'week_date', y: 'all_campaigns', text: 'all_campaigns', dy: -10})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":600,"value":"Plot.plot({\n insetTop: 50,\n grid: true,\n height: 200,\n width,\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(all, {x: \"week_date\", y: \"apps\", marker: true, title: d => `${d.apps}`}),\n Plot.text(all, {x: 'week_date', y: 'apps', text: 'apps', dy: -10})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":516,"value":"viewof all = aq.from(clean)\n .groupby('week_date')\n .rollup({\n all_campaigns: d => op.count(),\n all_job_id_array: d => op.array_agg(d.job_req_id),\n apps: d => op.sum(d.applies)\n })\n .derive({ apps_p_campaign: d => d.apps/d.all_campaigns})\n .orderby('week_date')\n //.orderby(aq.desc('week_date'))\n .view()","pinned":false,"hidden":false,"mode":"ojs"},{"id":579,"value":"md `

\n## Apps/Campaign comparison\n
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":588,"value":"Swatches(d3.scaleOrdinal([\"Distinct\", \"All\"], ['steelBlue','firebrick']))","pinned":false,"hidden":false,"mode":"ojs"},{"id":547,"value":"Plot.plot({\n insetTop: 50,\n grid: true,\n height: 600,\n x: {\n tickFormat: 'W' + '%U'\n },\n width,\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(distinct, {x: \"week_date\", y: \"apps_p_campaign\", marker: true, title: d => `${d.apps_p_campaign.toFixed(1)}`, stroke: 'steelBlue'}),\n // Plot.lineY(distinct, Plot.windowY({x: 'week_date', y: 'apps_p_campaign', k: 7, reduce: 'mean', stroke: 'lightGreen', strokeOpacity: 0.5})),\n Plot.text(distinct, {x: \"week_date\", y: \"apps_p_campaign\", text: d => d.apps_p_campaign.toFixed(1), dy: -10}),\n Plot.lineY(all, {x: \"week_date\", y: \"apps_p_campaign\", marker: true, title: d => `${d.apps_p_campaign.toFixed(1)}`, stroke: 'firebrick'}),\n Plot.text(all, {x: \"week_date\", y: \"apps_p_campaign\", text: d => d.apps_p_campaign.toFixed(1), dy: -10}),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":88,"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":508,"value":"clean = aq.from(data)\n .derive({date: d => op.parse_date(d.date)})\n .derive({week_date: aq.escape(d => d3.utcWeek(d.date))})\n .filter(d => d.spend > 0)\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":505,"value":"data = file.csv()","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":139,"value":"// fips state codes for maps\n\nimport {fips_clean} from \"c5c9011d48f448f6\"","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":"$W2f","stdlib":"1","titling":"auto"}