2f:[] 2d:{"title":"SC2 - Indeed Budget viewer","cells":[{"id":0,"value":"md `# SC2 - Indeed Budget viewer`","pinned":false,"hidden":false,"mode":"ojs"},{"id":574,"value":"md `### *Indeed*\n\n- At the beginning of the month, it is good practice to evaluate and/or \"give more budget\" to campaigns, and\n- At or toward the end of the month, it is a good practice to adjust Indeed budgets so that the projection and the goal spend are aligned.\n\nBelow, load the file that you can get from the ***Publishers > Campaigns*** tab for the current month (if you have a date range that is not for the current month, it won't work)\n

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":503,"value":"viewof file = Inputs.file({label: \"Load .csv\", required: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":582,"value":"html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":591,"value":"md `## Difference between projected goal and spend goal

\n\nThe ${textcolor('reds', d3.schemeRdBu[5][0])} need more budget and the ${textcolor('blues', d3.schemeRdBu[5][4])} need less\n

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":530,"value":"Plot.plot({\n insetLeft: 10,\n marginLeft: 60,\n color: {\n scheme: 'RdBu'\n },\n x: {\n grid: true,\n //domain: [d3.min(clean, d => d.difference), d3.max(clean, d => d.difference)],\n nice: true\n },\n marks: [\n Plot.ruleX([0]),\n Plot.barX(clean, {\n x: 'difference',\n y: 'Campaign',\n sort: {y: 'x', reverse: true},\n fill: 'difference',\n title: d => `For ${d.Campaign} the difference between the Goal and the Projection is: $${d.difference.toFixed(2)}`\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":667,"value":"html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":670,"value":"viewof file1 = Inputs.file({label: \"Data\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":673,"value":"raw_indeed_hot = file1.csv()","pinned":true,"hidden":false,"mode":"ojs"},{"id":676,"value":"aq.from(raw_indeed_hot)\n .derive({\n spend: d => +d.Actual,\n Impressions: d => +op.replace(d.Impressions, ',','')\n })\n .orderby(aq.desc('spend'))\n .select(0,'spend', 'Impressions')\n .view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":88,"value":"
\n
\n
\n
\n
\n
\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":561,"value":"sc2_indeed_budgets = Inputs.table(clean)","pinned":true,"hidden":false,"mode":"ojs"},{"id":198,"value":"### *Data*","pinned":false,"hidden":false,"mode":"md"},{"id":508,"value":"viewof clean = aq.from(raw_data)\n //.filter(d => d.Campaign == 'MCO')\n .derive({\n Projected: d => op.replace(d.Projected, ',',''),\n 'Spend Goal': d => op.replace(d['Spend Goal'], ',',''),\n })\n .filter(d => d.Status == 'Active')\n .derive({\n difference: d => d['Spend Goal'] - d.Projected\n })\n .select('Campaign', 'difference', 'Spend Goal', 'Projected')\n .orderby(aq.desc('difference'))\n .view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":505,"value":"raw_data = file.csv({typed: true})","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":626,"value":"import {textcolor} from \"@observablehq/text-color-annotations-in-markdown\"","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"}