2f:T5d4,viewof indeed_ctr = Plot.plot({ height: 225, insetTop: 25, marginBottom: 60, marginRight: 200, marginTop: 40, y: { percent: false }, x: { //nice: d3.utcMonth }, marks: [ //Plot.frame(), Plot.ruleY([0]), Plot.ruleX([non_incentive_date], {stroke: appcast_color_palette[2]}), Plot.ruleX([indeed_budgets_date], {stroke: appcast_color_palette[3]}), // axis annotation Plot.axisX([non_incentive_date], {stroke: appcast_color_palette[2], fill: appcast_color_palette[2], tickSize: 25}), Plot.axisX([indeed_budgets_date], {tickFormat: '%B %_d (%a)', anchor: 'top', stroke: appcast_color_palette[3], fill: appcast_color_palette[3], tickSize: 15}), // axes Plot.axisX({interval: d3.utcMonday}), Plot.gridX({interval: d3.utcMonday}), Plot.gridY(), Plot.lineY(indeed, { x: "date", y: "CTR", //tip: true, marker, strokeWidth: 1, stroke: appcast_color_palette[1] }), //annotation (text) Plot.text(["Incentives Removed"], { x: non_incentive_date, frameAnchor: 'bottom', textAnchor: 'start', dx: -18, dy: 47, fontSize: 10, stroke: 'white', fill: appcast_color_palette[2] }), Plot.text(["Indeed Budgets"], { x: indeed_budgets_date , frameAnchor: 'top', textAnchor: 'start', dx: -31, dy: -37, fontSize: 10, stroke: 'white', fill: appcast_color_palette[3] }), ] })30:T54d,click_to_lead_plot = Plot.plot({ insetTop: 25, marginBottom: 60, marginRight: 50, marginTop: 50, y: { //percent: true, clamp: true, grid: true }, facet: { data: CtoL, y: 'Publisher', marginRight: 150, label: null }, fy: { padding: 0.2, domain: ['Indeed CPC', 'Appcast Exchange', 'ZipRecruiter'] }, marks: [ Plot.frame({strokeWidth: 0.5, opacity: 1}), Plot.ruleX([non_incentive_date], {stroke: appcast_color_palette[2]}), Plot.lineY(CtoL, { x: "date", y: "Click to Lead CR", strokeOpacity: 1, marker: true, strokeWidth: 1, stroke: appcast_color_palette[1] }), Plot.axisX([non_incentive_date], {stroke: appcast_color_palette[2], fill: appcast_color_palette[2], tickSize: 25}), // indeed annotation Plot.ruleX([indeed_budgets_date], {stroke: appcast_color_palette[3], fy: ['Indeed CPC']}), Plot.axisX([indeed_budgets_date], {tickFormat: '%B %_d (%a)', anchor: 'top', stroke: appcast_color_palette[3], fill: appcast_color_palette[3], tickSize: 15}), Plot.text(["Indeed Budgets"], { x: indeed_budgets_date , frameAnchor: 'top', textAnchor: 'start', dx: -31, dy: -37, fontSize: 10, stroke: 'white', fill: appcast_color_palette[3], fy: ['Indeed CPC'], }), ] })31:T6ac,lead_to_bgc_plot = Plot.plot({ insetTop: 25, marginBottom: 60, marginRight: 50, marginTop: 50, y: { clamp: true, grid: true }, facet: { data: CtoL, y: 'Publisher', marginRight: 150, label: null }, fy: { padding: 0.2, domain: ['Indeed CPC', 'Appcast Exchange', 'ZipRecruiter'] }, marks: [ Plot.frame({strokeWidth: 0.5, opacity: 1}), //Plot.ruleY([0]), Plot.ruleX([non_incentive_date], {stroke: appcast_color_palette[2]}), Plot.lineY(CtoL, { x: "date", y: "Lead to BGC CR", strokeOpacity: 1, marker: true, strokeWidth: 1, stroke: appcast_color_palette[1] }), Plot.axisX({interval: d3.utcMonday}), Plot.gridX({interval: 'monday'}), Plot.text(["Incentives Removed"], { fy: ['ZipRecruiter'], x: non_incentive_date, frameAnchor: 'bottom', textAnchor: 'start', dx: -18, dy: 47, fontSize: 10, stroke: 'white', fill: appcast_color_palette[2] }), Plot.axisX([non_incentive_date], {stroke: appcast_color_palette[2], fill: appcast_color_palette[2], tickSize: 25}), // indeed annotation Plot.ruleX([indeed_budgets_date], {stroke: appcast_color_palette[3], fy: ['Indeed CPC']}), Plot.axisX([indeed_budgets_date], {tickFormat: '%B %_d (%a)', anchor: 'top', stroke: appcast_color_palette[3], fill: appcast_color_palette[3], tickSize: 15}), Plot.text(["Indeed Budgets"], { x: indeed_budgets_date , frameAnchor: 'top', textAnchor: 'start', dx: -31, dy: -37, fontSize: 10, stroke: 'white', fill: appcast_color_palette[3], fy: ['Indeed CPC'], }), ] })32:T439,bgc_volume_plot = Plot.plot({ insetTop: 25, marginBottom: 60, marginRight: 50, y: { clamp: true, grid: false, //type: 'sqrt' }, facet: { data: volume, y: 'Publisher', marginRight: 150, label: null }, fy: { padding: 0.2 }, marks: [ Plot.frame({strokeWidth: 0.5, opacity: 1}), //Plot.ruleY([0]), Plot.ruleX([non_incentive_date], {stroke: appcast_color_palette[2]}), Plot.rectY(volume, { x: "date", y: "bgc", fill: appcast_color_palette[3], interval: d3.utcDay, insetRight: 1, insetLeft: 1 }), Plot.axisX({interval: d3.utcMonday}), Plot.gridX({interval: 'monday'}), Plot.text(["Incentives Removed"], { fy: ['ZipRecruiter'], x: non_incentive_date, frameAnchor: 'bottom', textAnchor: 'start', dx: -18, dy: 47, fontSize: 10, stroke: 'white', fill: appcast_color_palette[2] }), Plot.axisX([non_incentive_date], {stroke: appcast_color_palette[2], fill: appcast_color_palette[2], tickSize: 25}) ] })33:T4e4,'lead volume chart if needed' // lead_volume_plot = Plot.plot({ // insetTop: 25, // marginBottom: 60, // marginRight: 50, // y: { // //percent: true, // clamp: true, // grid: true // }, // facet: { // data: volume, // y: 'Publisher', // marginRight: 150, // label: null // }, // fy: { // padding: 0.2 // }, // marks: [ // Plot.frame({strokeWidth: 0.5, opacity: 1}), // //Plot.ruleY([0]), // Plot.ruleX([non_incentive_date], {stroke: appcast_color_palette[2]}), // Plot.rectY(volume, { // x: "date", // y: "leads", // fill: appcast_color_palette[3], // interval: d3.utcDay, // insetRight: 2, // insetLeft: 2 // }), // Plot.axisX({interval: d3.utcMonday}), // Plot.gridX({interval: 'monday'}), // Plot.text(["Incentives Removed"], { // fy: ['ZipRecruiter'], // x: non_incentive_date, // frameAnchor: 'bottom', // textAnchor: 'start', // dx: -18, // dy: 47, // fontSize: 10, // stroke: 'white', // fill: appcast_color_palette[2] // }), // Plot.axisX([non_incentive_date], {stroke: appcast_color_palette[2], fill: appcast_color_palette[2], tickSize: 25}) // ] // })34:T5ba,landing_page_leads_plot = Plot.plot({ width: chart_width, height: chart_height, insetTop: 25, x: { type: 'utc' }, color: { title: 'Group', legend: true, range: [appcast_color_palette[1], appcast_color_palette[3]] }, // y: { // label: null // }, marks: [ Plot.frame(), Plot.ruleY([0]), Plot.gridY(), Plot.gridX({interval: d3.utcMonday}), Plot.axisX({interval: d3.utcMonday}), Plot.ruleX([landing_page_date], {stroke: appcast_color_palette[2]}), Plot.text(["Landing Page Test Starts"], { x: landing_page_date, frameAnchor: 'top', textAnchor: 'end', dx: 3, dy: 5, fontSize: 8, rotate: 270, fill: appcast_color_palette[2] }), Plot.lineY(landing_page_clean, { x: "date", y: "leads", stroke: appcast_color_palette[1], strokeWidth: 1, marker: true, // thresholds: d3.utcDay, tip: true }), // Plot.ruleX(landing_page_clean, Plot.pointerX({x: "date", py: "leads"})), // Plot.dot(landing_page_clean, Plot.pointer({x: "date", y: "leads", stroke: 'landing_page_group'})), // Plot.text(landing_page_clean, Plot.pointerX({ // px: "date", // py: "leads", // dy: -17, // frameAnchor: "top-left", // fontVariant: "tabular-nums", // text: (d) => [`Date ${Plot.formatIsoDate(d.date)}`, `leads ${d.leads.toFixed(2)}`].join(" ") // })) ] })35:T5b3,landing_page_bgc_plot = Plot.plot({ width: chart_width, height: chart_height, insetTop: 25, x: { type: 'utc' }, color: { title: 'Group', legend: true, range: [appcast_color_palette[1], appcast_color_palette[3]] }, // y: { // label: null // }, marks: [ Plot.frame(), Plot.ruleY([0]), Plot.gridY(), Plot.gridX({interval: d3.utcMonday}), Plot.axisX({interval: d3.utcMonday}), Plot.ruleX([landing_page_date], {stroke: appcast_color_palette[2]}), Plot.text(["Landing Page Test Starts"], { x: landing_page_date, frameAnchor: 'top', textAnchor: 'end', dx: 3, dy: 5, fontSize: 8, rotate: 270, fill: appcast_color_palette[2] }), Plot.lineY(landing_page_clean, { x: "date", y: "bgc", stroke: appcast_color_palette[1], strokeWidth: 1, marker: true, // thresholds: d3.utcDay, tip: true }), // Plot.ruleX(landing_page_clean, Plot.pointerX({x: "date", py: "leads"})), // Plot.dot(landing_page_clean, Plot.pointer({x: "date", y: "leads", stroke: 'landing_page_group'})), // Plot.text(landing_page_clean, Plot.pointerX({ // px: "date", // py: "leads", // dy: -17, // frameAnchor: "top-left", // fontVariant: "tabular-nums", // text: (d) => [`Date ${Plot.formatIsoDate(d.date)}`, `leads ${d.leads.toFixed(2)}`].join(" ") // })) ] })36:T5b9,landing_page_LtoBGC_plot = Plot.plot({ width: chart_width, height: chart_height, insetTop: 25, x: { type: 'utc' }, color: { title: 'Group', legend: true, range: [appcast_color_palette[1], appcast_color_palette[3]] }, // y: { // label: null // }, marks: [ Plot.frame(), Plot.ruleY([0]), Plot.gridY(), Plot.gridX({interval: d3.utcMonday}), Plot.axisX({interval: d3.utcMonday}), Plot.ruleX([landing_page_date], {stroke: appcast_color_palette[2]}), Plot.text(["Landing Page Test Starts"], { x: landing_page_date, frameAnchor: 'top', textAnchor: 'end', dx: 3, dy: 5, fontSize: 8, rotate: 270, fill: appcast_color_palette[2] }), Plot.lineY(landing_page_clean, { x: "date", y: "LtoBGC", stroke: appcast_color_palette[1], strokeWidth: 1, marker: true, // thresholds: d3.utcDay, tip: true }), // Plot.ruleX(landing_page_clean, Plot.pointerX({x: "date", py: "leads"})), // Plot.dot(landing_page_clean, Plot.pointer({x: "date", y: "leads", stroke: 'landing_page_group'})), // Plot.text(landing_page_clean, Plot.pointerX({ // px: "date", // py: "leads", // dy: -17, // frameAnchor: "top-left", // fontVariant: "tabular-nums", // text: (d) => [`Date ${Plot.formatIsoDate(d.date)}`, `leads ${d.leads.toFixed(2)}`].join(" ") // })) ] })37:[] 2d:{"title":"Lyft - No incentive Experiment","cells":[{"id":0,"value":"md `# Lyft - No incentive Experiment \n*& Landing Page A/B test*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":725,"value":"## Background \n### Non-Incentive experiment\n\nAll US markets are included in this experiment\n- Run across all publishers\n- The guarantees have been removed from columns H through J on the \"Active Markets & Bids\" tab in the repository \n- This change is also reflected on the \"Titles, Copy, URLs\" tab\n- The descriptions in column N have been updated to remove the first line that previously included the incentive\n- The Ref= parameter should be blank, the URL will default to the DWL control page\n- Measurement: Pre/Post performance for 2 weeks\n - View results by publisher and aggregate\n - I'll be monitoring our standard down funnel metrics (I can create a shared doc if that's useful like we did for the spend reduction test?)\n - It will also be important to measure upper funnel metrics, I'd like to measure CTR (Indeed only) and CR%. Any other metrics you think will be useful?","pinned":false,"hidden":false,"mode":"md"},{"id":1659,"value":"md `

\n\n# For Weekly Report`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1653,"value":"md `## Step 1`","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":735,"value":"md `## Step 2\nSet the date range. The pre/post segments should be of equal length (i.e. 10-days before & 10-days after) with regards to the date the change was made (change was made on ${d3.utcFormat('%B %d, %Y')(non_incentive_date)}).`","pinned":false,"hidden":false,"mode":"ojs"},{"id":751,"value":"viewof start_date = Inputs.date({label: \"Start date\", value: \"2023-05-15\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":984,"value":"viewof end_date = Inputs.date({label: \"End date\", value: d3.utcDay.offset(new Date(), -1)})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1500,"value":"md `Days before **${days_before_incentive}**, days after **${days_after_incentive}**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1675,"value":"md `

\n\n# Visuals for weekly report`","pinned":false,"hidden":false,"mode":"ojs"},{"id":740,"value":"md `## Indeed CTR`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1244,"value":"viewof marker = Inputs.toggle({label: \"Dot on line chart\", value: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":749,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":1012,"value":"viewof incentive_pre_post = Inputs.table( aq.from(indeed)\n .derive({\n segment: aq.escape( d => d.date < non_incentive_date ? 'pre' : 'post' )\n })\n .groupby('segment')\n .rollup({\n impressions: d => op.sum(d.impressions),\n clicks: d => op.sum(d.clicks),\n leads: d => op.sum(d.leads)\n })\n .derive({\n CTR: d => d.clicks / d.impressions,\n ['Click to Lead CR']: d => d.leads / d.clicks \n })\n .select(0,4)\n .pivot('segment', 'CTR')\n .relocate('post', {after: 'pre'})\n .derive({\n Difference: d => d.post - d.pre\n })\n .objects(), {\n width: 300,\n layout: 'auto'\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":738,"value":"indeed = clean\n .filter(aq.escape( d => d.date >= start_date && d.date <= end_date ))\n .filter(d => d.Publisher == 'Indeed CPC')\n .groupby('date')\n .rollup({\n impressions: d => op.sum(d.impressions),\n clicks: d => op.sum(d.clicks),\n leads: d => op.sum(d.leads)\n })\n .derive({\n CTR: d => d.clicks / d.impressions\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":761,"value":"md `

\n## Click to Lead CR\n*by publisher*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":774,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":1078,"value":"Inputs.table(click_to_lead_output_table, {\n width: 400,\n layout: 'auto', \n format: {\n pre: d3.format('.2f'),\n post: d3.format('.2f'),\n Difference: d3.format('+.2f')\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":771,"value":"CtoL = clean\n .filter(aq.escape(d => d.date >= start_date && d.date <= end_date))\n .filter(d => d.Publisher != null && d.Publisher != 'Jobcase CPC' && op.includes(op.lower(d.Publisher), 'craig') == false)\n .groupby('date', 'Publisher')\n .rollup({\n clicks: d => op.sum(d.clicks),\n leads: d => op.sum(d.leads),\n bgc: d => op.sum(d.bgc)\n })\n .derive({\n ['Click to Lead CR']: d => d.leads / d.clicks,\n ['Lead to BGC CR']: d => d.bgc / d.leads\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1056,"value":"incentive_pre_post_by_pub = aq.from(CtoL)\n .derive({\n segment: aq.escape( d => d.date < non_incentive_date ? 'pre' : 'post' )\n })\n //.filter(d => d.Publisher == 'Indeed CPC')\n .groupby('segment', 'Publisher')\n .rollup({\n //impressions: d => op.sum(d.impressions),\n clicks: d => op.sum(d.clicks),\n leads: d => op.sum(d.leads),\n bgc: d => op.sum(d.bgc)\n })\n .derive({\n ['Click to Lead CR']: d => d.leads / d.clicks,\n ['Lead to BGC CR']: d => d.bgc / d.leads\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1264,"value":"click_to_lead_output_table = aq.from(incentive_pre_post_by_pub)\n .groupby('Publisher')\n .pivot('segment', 'Click to Lead CR')\n .relocate('pre', {before: 'post'})\n .derive({\n Difference: d => d.post - d.pre\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1284,"value":"md `
\n\n## Lead to BGC\n*by publisher*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":907,"value":"Inputs.bind(Inputs.date({label: \"Start date\", value: \"2023-01-01\"}), viewof start_date)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1226,"value":"Inputs.bind(Inputs.date({label: \"End date\"}), viewof end_date)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1577,"value":"md `Days before **${days_before_incentive}**, days after **${days_after_incentive}**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1289,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":1305,"value":"Inputs.table(lead_to_bgc_output_table, {\n width: 400,\n layout: 'auto', \n format: {\n pre: d3.format('.2f'),\n post: d3.format('.2f'),\n Difference: d3.format('+.2f')\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1294,"value":"lead_to_bgc_output_table = aq.from(incentive_pre_post_by_pub)\n .groupby('Publisher')\n .pivot('segment', 'Lead to BGC CR')\n .relocate('pre', {before: 'post'})\n .derive({\n Difference: d => d.post - d.pre\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1311,"value":"md `

\n\n## BGC Volume\n*by publisher*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1600,"value":"Inputs.bind(Inputs.date({label: \"Start date\", value: \"2023-01-01\"}), viewof start_date)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1603,"value":"Inputs.bind(Inputs.date({label: \"End date\"}), viewof end_date)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1604,"value":"md `Days before **${days_before_incentive}**, days after **${days_after_incentive}**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1336,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":1353,"value":"Inputs.table(bgc_volume_output_table, {\n width: 450,\n layout: 'auto',\n format: {\n 'Difference %': d3.format('+.1%'),\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1620,"value":"Inputs.table(aq.from(bgc_volume_output_table)\n .rollup({\n pre: d => op.sum(d.pre),\n post: d => op.sum(d.post)\n })\n .derive({\n Difference: d => d.post - d.pre,\n 'Difference %': d => (d.post - d.pre) / d.pre\n })\n .objects(), {\n width: 450,\n layout: 'auto',\n format: {\n 'Difference %': d3.format('+.1%')\n }\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1314,"value":"volume = clean\n .filter(aq.escape( d => d.date >= start_date && d.date < end_date ))\n .filter(d => d.Publisher != null && d.Publisher != 'Jobcase CPC' && op.includes(op.lower(d.Publisher), 'craig') == false)\n .groupby('date', 'Publisher')\n .rollup({\n leads: d => op.sum(d.leads),\n bgc: d => op.sum(d.bgc)\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1344,"value":"volume_pre_post = aq.from(volume)\n .derive({\n segment: aq.escape( d => d.date < non_incentive_date ? 'pre' : 'post' )\n })\n .groupby('segment', 'Publisher')\n .rollup({\n leads: d => op.sum(d.leads),\n bgc: d => op.sum(d.bgc)\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1350,"value":"bgc_volume_output_table = aq.from(volume_pre_post)\n .groupby('Publisher')\n .pivot('segment', 'bgc')\n .relocate('pre', {before: 'post'})\n .derive({\n Difference: d => d.post - d.pre,\n ['Difference %']: d => (d.post - d.pre) / d.pre\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1320,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":1193,"value":"md `### Incentive dates`","pinned":false,"hidden":false,"mode":"ojs"},{"id":891,"value":"viewof non_incentive_date = Inputs.date({label: \"Non-incentive date\", value: \"2023-05-24\", disabled: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1484,"value":"viewof indeed_budgets_date = Inputs.date({label: \"Indeed Budgets Date\", value: \"2023-06-01\", disabled: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1140,"value":"days_after_incentive = d3.utcDay.count(non_incentive_date, end_date)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1506,"value":"days_before_incentive = d3.utcDay.count(start_date, non_incentive_date)","pinned":false,"hidden":false,"mode":"ojs"},{"id":838,"value":"md `## Landing Page`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1135,"value":"end_date_value = d3.utcDay.offset(new Date(), -1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":898,"value":"viewof landing_page_date = Inputs.date({label: \"Landing page date\", value: \"2023-05-26\", disabled: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":841,"value":"landing_page_treatment_group = [\"DFW\", \"IAH\", \"MIA\"]","pinned":true,"hidden":false,"mode":"ojs"},{"id":847,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":958,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":982,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"id":843,"value":"landing_page_clean = clean\n .filter(aq.escape(d => d.date >= start_date && d.date < end_date))\n .derive({\n landing_page_group: aq.escape( d => landing_page_treatment_group.includes(d.title) == true ? true : false)\n })\n .filter(d => d.landing_page_group == true)\n .groupby('date')\n .rollup({\n impressions: d => op.sum(d.impressions),\n clicks: d => op.sum(d.clicks),\n leads: d => op.sum(d.leads),\n bgc: d => op.sum(d.bgc)\n })\n .derive({\n LtoBGC: d => d.bgc / d.leads\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":990,"value":"viewof chart_width = Inputs.range([0, 800], {label: \"Chart Width\", step: 10, value: 500})","pinned":false,"hidden":false,"mode":"ojs"},{"id":998,"value":"viewof chart_height = Inputs.range([0, 600], {label: \"Chart Height\", step: 10, value: 200})","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":1363,"value":"md `Query used:\n\n\n~~~sql\n\nselect jd.date, e.name employer, jb.master_publisher_aggregated, jb.master_publisher, jb.id jb_id, jd.job_group_id, jg.title title, sum(jd.impressions) impressions, sum(jd.clicks_paid) clicks, sum(jd.applies_paid) leads, round(sum(jd.spend),2) spend, sum(jd.qualified) bgc, sum(hired) activations\nfrom cc_warehouse.jobdata jd\nleft join cc_warehouse.employers e\non e.id = jd.employer_id\nleft join cc_warehouse.job_boards jb\non jb.id = jd.job_board_id\nleft join cc_warehouse.job_groups jg\non jg.id = jd.job_group_id\nwhere jd.employer_id in (4972,6140)\n--and jb.id in (14658, 30409) \nand jd.date between cast('2023-01-01' as date) and cast('2023-06-01' as date)\ngroup by jd.date, e.name, jb.master_publisher_aggregated, jb.master_publisher, jb.id, jd.job_group_id, jg.title\norder by jd.date asc\n\n\n~~~`","pinned":false,"hidden":false,"mode":"ojs"},{"id":865,"value":"d3.extent(clean, d => d.date)","pinned":true,"hidden":false,"mode":"ojs"},{"id":508,"value":"viewof clean = aq.from(raw_data)\n .rename({master_publisher_aggregated: 'Publisher'})\n .filter(d => d.Publisher != 'Upward.net CPA' &&\n d.Publisher != 'Jobs2Careers CPA' &&\n d.Publisher != 'Google Test CPC' &&\n d.Publisher != 'Facebook Jobs Sponsored (TIER0 only)' &&\n d.Publisher != 'Jobcase CPA' &&\n d.Publisher != 'CareerBuilder CPA' &&\n d.Publisher != 'Birddog CPA'\n )\n .derive({\n Publisher: d => d.jb_id == 14658 || d.jb_id == 30409 || d.Publisher == 'ZipRecruiter CPA' || d.Publisher == 'ZipRecruiter CPC' ? 'ZipRecruiter' : d.Publisher\n })\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":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":"$W37","stdlib":"1","titling":"auto"}