2f:T6ee,single_chart = { const ch1 = vl .markArea({ line: { color: color_selector, strokeWidth: 2 }, point: { size: 60, color: 'white', filled: false, fill: color_selector }, color: color_selector, opacity: opacity - 0.3 }) .title(name_map[1]) .encode( vl.x().fieldT("date").timeUnit("utcmonthdate"), // .axis({format: '%A %b %d'}), -- this format is yielding the wrong weekday vl.y().fieldQ(metric_selector).axis({ format: ".0f", minExtent: 20 }).title(metric_selector) ) .height(110) .width(900); const ch2 = vl .markLine({ tooltip: false, color: color_selector2, point: { size: 60, color: 'white', filled: false, fill: color_selector2 }, strokeWidth: 2, }) .encode( vl.x().fieldT("date").timeUnit("utcmonthdate"), vl.y().fieldQ(metric_selector2).title(metric_selector2) ) .height(110) .width(900); return vl .vconcat(ch1, ch2) .spacing(25) .data(clean_nodeFL.filter((d) => d.job_req_id == req_selector)) .config({ view: { stroke: null }, axis: { gridOpacity: 0.5, labelFontWeight: 75, domain: false, offset: 5, titleFontWeight: 200, titleFontSize: 12, titlePadding: 20, labelOpacity: 0.6 }, axisX: { tickCount: 5, titlePadding: 10, labelPadding: 4, title: null }, axisY: { ticks: false, labelLimit: 300, labelFontSize: 8 }, title: { fontWeight: 300, fontSize: 26, offset: 80, anchor: 'start' } }) .padding({ top: 25, bottom: 25, left: 100, right: 50 }) .resolve({ scale: { y: "independent" } }) .render(); }30:T92b,all_node_chart = { const ch1 = vl .markArea({ line: { color: color_selector, strokeWidth: 2 }, point: { size: 60, color: 'white', filled: false, fill: color_selector }, color: color_selector, opacity: opacity - 0.3 }) .title('All Node Campaigns') .data(node_summary) .encode( vl.x().fieldT("date").timeUnit("utcmonthdate"), // .axis({format: '%A %b %d'}), -- this format is yielding the wrong weekday //vl.y().sum("applies").axis({ format: ".0f", minExtent: 20 }).title('Applies') vl.y().fieldQ(metric_selector).axis({ format: ".0f", minExtent: 20 }).title(metric_selector) ) .height(50) .width(900); const ch2 = vl .markLine({ tooltip: false, color: color_selector2, point: { size: 60, color: 'white', filled: false, fill: color_selector2 }, strokeWidth: 2, }) .data(node_summary) .encode( vl.x().fieldT("date").timeUnit("utcmonthdate"), //vl.y().fieldQ('calc_cpa').title('CPA'), vl.y().fieldQ(metric_selector2).axis({ format: ".0f", minExtent: 20 }).title(metric_selector2) ) .height(50) .width(900); const ch3 = vl.markText({fontSize: 12.5, fontWeight: 75, opacity: 0.6}) .data(node_summary) .encode( vl.x().fieldT('date').timeUnit('utcmonthdate') .axis({ title: 'Each number represents the total active campaigns for each day', titleOpacity: 0.3, labels: false }), vl.text().fieldQ('active_campys') ) .width(900); return vl .vconcat(ch1, ch2, ch3) .spacing(25) .config({ view: { stroke: null }, axis: { gridOpacity: 0.5, labelFontWeight: 75, domain: false, offset: 5, titleFontWeight: 200, titleFontSize: 12, titlePadding: 20, labelOpacity: 0.6 }, axisX: { tickCount: 5, titlePadding: 10, labelPadding: 4, title: null }, axisY: { ticks: false, labelLimit: 300, labelFontSize: 8 }, title: { fontWeight: 300, fontSize: 20, offset: 40, anchor: 'start' } }) .padding({ top: 25, bottom: 25, left: 100, right: 50 }) .resolve({ scale: { y: "independent" } }) .render(); }31:T94b,all_node_chart_v2 = { const ch1 = vl .markArea({ line: { color: color_selector, strokeWidth: 2 }, point: { size: 60, color: 'white', filled: false, fill: color_selector }, color: color_selector, opacity: opacity - 0.3 }) .title('All Node Campaigns') .data(node_summary) .encode( vl.x().fieldT("date").timeUnit("utcmonthdate"), // .axis({format: '%A %b %d'}), -- this format is yielding the wrong weekday //vl.y().sum("applies").axis({ format: ".0f", minExtent: 20 }).title('Applies') vl.y().fieldQ(metric_selector).axis({ format: ".0f", minExtent: 20 }).title(metric_selector) ) .height(50) .width(900); const ch2 = vl .markLine({ tooltip: false, color: color_selector2, point: { size: 60, color: 'white', filled: false, fill: color_selector2 }, strokeWidth: 2, }) .data(node_summary) .encode( vl.x().fieldT("date").timeUnit("utcmonthdate"), //vl.y().fieldQ('calc_cpa').title('CPA'), vl.y().fieldQ(metric_selector2).axis({ format: ".0f", minExtent: 20 }).title(metric_selector2) ) .height(50) .width(900); const ch3 = vl.markArea({ color: '#d9d9d9', line: {stroke: '#d9d9d9', strokeWidth: 2}, opacity: opacity - 0.3, point: { size: 60, color: 'white', filled: false, fill: '#d9d9d9' }, strokeWidth: 2, }) .data(node_summary) .encode( vl.x().fieldT('date').timeUnit('utcmonthdate'), vl.y().fieldQ('active_campys').title('active campaigns') ) .width(900).height(35); return vl .vconcat(ch1, ch2, ch3) .spacing(25) .config({ view: { stroke: null }, axis: { gridOpacity: 0.5, labelFontWeight: 75, domain: false, offset: 5, titleFontWeight: 200, titleFontSize: 12, titlePadding: 20, labelOpacity: 0.6 }, axisX: { tickCount: 5, titlePadding: 10, labelPadding: 4, title: null }, axisY: { ticks: false, labelLimit: 300, labelFontSize: 8 }, title: { fontWeight: 300, fontSize: 20, offset: 40, anchor: 'start' } }) .padding({ top: 25, bottom: 25, left: 100, right: 50 }) .resolve({ scale: { y: "independent" } }) .render(); }32:T6b6,all_chart = { const ch1 = vl .markArea({ line: { color: color_selector, strokeWidth: 2 }, point: { size: 60, color: 'white', filled: false, fill: color_selector }, color: color_selector, opacity: opacity - 0.3 }) .title('All Campaigns') .data(clean) .encode( vl.x().fieldT("date").timeUnit("utcmonthdate"), // .axis({format: '%A %b %d'}), -- this format is yielding the wrong weekday vl.y().sum("applies").axis({ format: ".0f", minExtent: 20 }).title('Applies') ) .height(110) .width(900); const ch2 = vl .markLine({ tooltip: false, color: color_selector2, point: { size: 60, color: 'white', filled: false, fill: color_selector2 }, strokeWidth: 2, }) .data(net_summary) .encode( vl.x().fieldT("date").timeUnit("utcmonthdate"), vl.y().fieldQ('calc_cpa').title('CPA') ) .height(110) .width(900); return vl .vconcat(ch1, ch2) .spacing(25) .config({ view: { stroke: null }, axis: { gridOpacity: 0.5, labelFontWeight: 75, domain: false, offset: 5, titleFontWeight: 200, titleFontSize: 12, titlePadding: 20, labelOpacity: 0.6 }, axisX: { tickCount: 5, titlePadding: 10, labelPadding: 4, title: null }, axisY: { ticks: false, labelLimit: 300, labelFontSize: 8 }, title: { fontWeight: 300, fontSize: 20, offset: 40, anchor: 'start' } }) .padding({ top: 25, bottom: 25, left: 100, right: 50 }) .resolve({ scale: { y: "independent" } }) .render(); }33:T40b,viewof week_summary_node = html `

${Inputs.table(aq.from(clean_nodeFL) .derive({spending: d => d.spend > 0 ? d.job_req_id : 0}) .derive({ week_num: d => op.utcweek(d.date), week_date: aq.escape( d => d3.utcWeek(d.date) )}) .groupby('week_num', 'week_date') .rollup({ total_apps: d => op.sum(d.applies), total_clicks: d => op.sum(d.clicks), total_spend: d => op.sum(d.spend), total_campys: d => op.distinct(d.spending) }) .derive({ cr: d => d.total_apps/d.total_clicks, calc_cpa: d => d.total_spend/d.total_apps }) .orderby('week_date') .objects(), { width: 375, layout: "auto", columns: ["week_num", "cr", "calc_cpa","total_apps", "total_clicks", "total_campys"], header: { week_num: "Week", cr: "CR", calc_cpa: "CPA", total_apps: "Applies", total_clicks: "Clicks", total_campys: "Active" }, format: { cr: d3.format(".2%"), calc_cpa: d3.format("$.1f") } })}`34:[] 2d:{"title":"Europe Campaign Overview for Market Reports","cells":[{"id":0,"value":"title1 = md `# Europe Campaign Overview for Market Reports`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1772,"value":"### *Using Perfomance File*","pinned":false,"hidden":false,"mode":"md"},{"id":734,"value":"break1 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1405,"value":"title8 = md `**Campaign Master File**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1400,"value":"viewof file1 = Object.assign(Inputs.file({label: \"Load Campaign Master\", required: true}), {style: '--label-width: 200px'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1041,"value":"title5 = md `**Performance File**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":652,"value":"viewof file = Object.assign(Inputs.file({label: \"Load Performance report from Dash\", required: true}), {style: '--label-width: 200px'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1061,"value":"req_date_range_text = md `Date range from **${formatter(data_date_range[0])}** to **${formatter(data_date_range[1])}**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1044,"value":"title6 = md `**Title Report**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":890,"value":"viewof file2 = Object.assign(Inputs.file({label: \"Load title report\", required: true}), {style: '--label-width: 200px'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1025,"value":"date_range_text = md `Date range from **${formatter(data2_date_range[0])}** to **${formatter(data2_date_range[1])}**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1329,"value":"snippet_text = md `(*If you need a sample of the script to pull the title data, I've placed one above the appendix*)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":581,"value":"break2 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":682,"value":"title3 = md `### One Chart per Job ID`","pinned":false,"hidden":false,"mode":"ojs"},{"id":586,"value":"break3 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":405,"value":"viewof node_selector = Inputs.select(clean.map(d => d.node), {label: \"Filter by Node\", unique: true, sort: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":691,"value":"viewof req_selector = Inputs.select(clean_nodeFL.map(d => d.job_req_id), {label: \"Select a Req ID\", unique: true, sort: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":670,"value":"break4 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1376,"value":"viewof metric_selector = Inputs.radio(['applies','spend','cpa', 'cpc', 'clicks', 'cr'], {label: \"Top Chart\", value: 'applies'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1796,"value":"viewof metric_selector2 = Inputs.radio(['applies','spend','cpa', 'cpc', 'clicks', 'cr'], {label: \"Bottom Chart\", value: 'clicks'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1212,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":987,"value":"break9 = html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1491,"value":"viewof combined_table = html`

${viewof table2}

${viewof top_title_table}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1901,"value":"html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":954,"value":"viewof top_cr_title_table = html `

${Inputs.table(top_cr_title, {\n header: {\n job_title: \"Top Title(s) by Conversion Rate\",\n cr: \"Conversion Rate\"\n },\n format: {\n cr: d3.format('.1%')\n },\n align: {\n total_apps: \"right\"\n },\n layout: 'auto',\n width: 525\n})}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1904,"value":"html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":928,"value":"viewof top_title_table = html`

${Inputs.table(\n top_title,\n {\n header: {\n job_title: \"Top Title(s) by Applies\",\n total_apps: \"Applies\"\n },\n align: {\n total_apps: \"right\"\n },\n layout: \"auto\",\n width: 550\n }\n)}

`\n\n//

${table2} ---- this did not work","pinned":false,"hidden":false,"mode":"ojs"},{"id":1428,"value":"viewof table2 = html `

${Inputs.table(week_summary, {\n width: 375,\n layout: \"auto\",\n columns: [\"week_num\", \"cr\", \"calc_cpa\",\"total_apps\", \"total_clicks\"],\n header: {\n week_num: \"Week\",\n cr: \"Conversion Rate\",\n calc_cpa: \"CPA\",\n total_apps: \"Applies\",\n total_clicks: \"Clicks\"\n },\n format: { \n cr: d3.format(\".2%\"),\n calc_cpa: d3.format(\"$.1f\")\n }\n})}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1934,"value":"md `# #wip`","pinned":true,"hidden":false,"mode":"ojs"},{"id":1943,"value":"Inputs.bind(Inputs.select(clean.map(d => d.node), {label: \"Filter by Node\", unique: true, sort: true}), viewof node_selector)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1954,"value":"Inputs.bind(Inputs.radio(['applies','spend','cpa', 'cpc', 'clicks', 'cr'], {label: \"Top Chart\", value: 'applies'}), viewof metric_selector)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1958,"value":"Inputs.bind(Inputs.radio(['applies','spend','cpa', 'cpc', 'clicks', 'cr'], {label: \"Top Chart\", value: 'applies'}), viewof metric_selector2)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1985,"value":"md `# v1\n\nAdded a number below the charts that represents the number of campaigns that had spend > 0 that day for the node selected\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1946,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":2040,"value":"viewof combined_table_node = html`

${viewof week_summary_node}

${viewof weekly_top_title_node}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2048,"value":"viewof node_top_cr_title_table = html `

${Inputs.table(node_top_cr_title, {\n header: {\n job_title: \"Top Title(s) by Conversion Rate\",\n cr: \"Conversion Rate\"\n },\n format: {\n cr: d3.format('.1%')\n },\n align: {\n total_apps: \"right\"\n },\n layout: 'auto',\n width: 525\n})}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1989,"value":"md `
\n# v2\n\nAdded a chart that represents the number of campaigns that had spend > 0 that day for the node selected\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1993,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":2115,"value":"//html `${viewof combined_table_node}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2122,"value":"//html `${viewof node_top_cr_title_table}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2098,"value":"md `

\n# All campaigns in the files`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1663,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":1726,"value":"viewof combined_table_all = html`

${viewof table2_all}

${viewof top_title_all_table}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1915,"value":"html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1711,"value":"viewof top_cr_title_table_all = html `

${Inputs.table(top_cr_title_all, {\n header: {\n job_title: \"Top Title(s) by Conversion Rate\",\n cr: \"CR\"\n },\n format: {\n cr: d3.format('.1%')\n },\n align: {\n total_apps: \"right\"\n },\n layout: 'auto',\n width: 600\n})}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1918,"value":"html `
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1706,"value":"viewof top_title_all_table = html`

${Inputs.table(\n top_title_all,\n {\n header: {\n job_title: \"Top Title(s) by Applies\",\n total_apps: \"Applies\"\n },\n align: {\n total_apps: \"right\"\n },\n layout: \"auto\",\n width: 625\n }\n)}

`\n\n//

${table2} ---- this did not work","pinned":false,"hidden":false,"mode":"ojs"},{"id":1722,"value":"viewof table2_all = html `

${Inputs.table(week_summary_all, {\n width: 315,\n layout: \"auto\",\n columns: [\"week_num\", \"cr\", \"calc_cpa\",\"total_apps\", \"total_clicks\"],\n header: {\n week_num: \"Week\",\n cr: \"CR\",\n calc_cpa: \"CPA\",\n total_apps: \"Applies\",\n total_clicks: \"Clicks\"\n },\n format: { \n cr: d3.format(\".2%\"),\n calc_cpa: d3.format(\"$.1f\")\n }\n})}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":88,"value":"break7 = html `
\n
\n
\n

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":576,"value":"title4 = md `### Control panel for the charts:`","pinned":false,"hidden":false,"mode":"ojs"},{"id":531,"value":"viewof color_selector = Object.assign(Inputs.radio(appcast_color_palette, {\n value: appcast_color_palette[2],\n label: html` Appcast Colors Applies `,\n format: (x) => html`${x}`\n}), {style: '--label-width: 185px'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":545,"value":"viewof color_selector2 = Object.assign(Inputs.radio(appcast_color_palette, {\n value: appcast_color_palette[1],\n label: html`Appcast Colors 2nd Metric`,\n format: (x) => html`${x}`\n}),\n {style: '--label-width: 185px'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":567,"value":"viewof opacity = Object.assign(Inputs.range([0,1], {label: \"opacity for applies chart\", step: 0.05}), {style: '--label-width: 185px'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1269,"value":"break11 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1660,"value":"### Other Possible Charts","pinned":false,"hidden":false,"mode":"md"},{"id":722,"value":"vl.markBar({width: {band: 0.2}, color: color_selector})\n .title('Total Apps by Week')\n .data(week_summary)\n .encode(\n vl.x().fieldO('week_num')\n .axis({labelAngle: 0})\n .title('Week'),\n vl.y().fieldQ('total_apps')\n )\n .width(400).height(150)\n .config(clean_config)\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1321,"value":"title7 = md `#### Sample Script for Title data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1272,"value":"code_snippet = md `\n\n~~~sql\n# Athena sample script to get title data\n# Replace the \"date_str\" fields with the date range you need\n\nSELECT date, campaign_name, labor_order_node, job_title, SUM(clicks_paid) AS \"Clicks\", SUM(applies_paid) AS \"Applies\", SUM(spend) AS \"Spend\", job_req_id\nFROM jobstats\nWHERE employer_id = 8984 AND date_str >= '2022-04-24' AND date_str <= '2022-04-30'\nGROUP BY date, campaign_name, labor_order_node, job_req_id, spend, job_title\n~~~\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":674,"value":"break8 = html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"md `## Appendix\n\n_Implementation & data stuff_`","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"### *Performance Data (Req Daily)*","pinned":false,"hidden":false,"mode":"md"},{"id":402,"value":"Inputs.table(clean)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1821,"value":"# John's Playground 🌈 ","pinned":false,"hidden":false,"mode":"md"},{"id":1823,"value":"**Make changes below...**","pinned":false,"hidden":false,"mode":"md"},{"id":399,"value":"clean = aq.from(data)\n .join(aq.from(campaigns), ['job_req_id','Job Req ID'])\n .derive({date: d => op.parse_date(d.date)}, {before: 'node'})\n .derive({applies: d => op.parse_int(d.applies)}, {before: 'clicks'})\n .derive({clicks: d => op.parse_int(d.clicks)}, {before: 'impressions'})\n .derive({spend: d => op.parse_int(d.spend)}, {before: 'applies'})\n .derive({cr: d => op.parse_int(d.cr)}, {before: 'applies'})\n //.filter(d => d.clicks > 0) // JOHNNY BOY, YOU MAY COMMENT THIS OUT IF YOU'D LIKE\n //.filter(d => d.spend > 0) // THIS ONE TOO!\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1825,"value":"**...don't go beyond this point**","pinned":false,"hidden":false,"mode":"md"},{"id":656,"value":"data = file.csv()","pinned":true,"hidden":false,"mode":"ojs"},{"id":687,"value":"clean_nodeFL = clean.filter(d => d.node === node_selector)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2082,"value":"md `## Node level data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2011,"value":"md `**Daily by node**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1964,"value":"viewof node_summary = aq.from(clean_nodeFL)\n .derive({spending: d => d.spend > 0 ? 1 : 0})\n .groupby('date')\n .rollup({\n applies: d => op.sum(d.applies),\n spend:d => op.sum(d.spend),\n clicks: d => op.sum(d.clicks),\n active_campys: d => op.sum(d.spending)\n })\n .derive({\n cpa: d => d.spend / d.applies,\n cpc: d => d.spend / d.clicks,\n cr: d => d.clicks / d.applies,\n })\n .view()","pinned":false,"hidden":false,"mode":"ojs"},{"id":2014,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":2028,"value":"viewof weekly_top_title_node = html`

${Inputs.table(aq.from(clean2_nodeFL)\n .filter(d => d.Applies > 0) \n .groupby('job_title')\n .rollup({total_apps: d => op.sum(d.Applies)})\n .orderby(aq.desc('total_apps'))\n .filter(d => op.rank() <= 5) // **JOHN, YOU CAN CHANGE THIS!**\n .dedupe()\n .objects(), \n \n {\n header: {\n job_title: \"Top Title(s) by Applies\",\n total_apps: \"Applies\"\n },\n align: {\n total_apps: \"right\"\n },\n layout: \"auto\",\n width: 550\n }\n )}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2035,"value":"viewof node_top_cr_title = Inputs.table(aq.from(clean2_nodeFL)\n .filter(d => d.Clicks > 0) // exclude titles with 0 apps\n .groupby('job_title')\n .rollup({cr: d => op.sum(d.Applies)/op.sum(d.Clicks)})\n .orderby(aq.desc('cr'))\n .filter(d => op.rank() <= 5) // **JOHN, YOU CAN CHANGE THIS!**\n //.filter(d => d.cr > 0) // exclude conversion rate of 0 // **JOHN, YOU CAN REMOVE THE \"//\" FROM THE BEGINNING TO FILTER 0% CR\n .dedupe()\n .objects())","pinned":false,"hidden":false,"mode":"ojs"},{"id":894,"value":"### *Title Data (athena file)*","pinned":false,"hidden":false,"mode":"md"},{"id":902,"value":"clean2 = aq.from(data2)\n .derive({date: d => op.parse_date(d.date)})\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":900,"value":"data2 = file2.csv()","pinned":true,"hidden":false,"mode":"ojs"},{"id":910,"value":"clean2_nodeReqFL = clean2_nodeFL.filter((d) => d.job_req_id == req_selector)","pinned":true,"hidden":false,"mode":"ojs"},{"id":908,"value":"clean2_nodeFL = clean2.filter(d => d.labor_order_node == node_selector)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1698,"value":"#### Per req","pinned":false,"hidden":false,"mode":"md"},{"id":1097,"value":"Inputs.table(top_title, {layout: 'auto'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":915,"value":"// this is the top apps title data\ntop_title = aq.from(clean2_nodeReqFL)\n .filter(d => d.Applies > 0) \n .groupby('job_title')\n .rollup({total_apps: d => op.sum(d.Applies)})\n .orderby(aq.desc('total_apps'))\n //.filter(d => op.rank() <= 10) // **JOHN, YOU CAN CHANGE THIS!**\n .dedupe()\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":992,"value":"Inputs.table(top_cr_title, {layout: 'auto'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":941,"value":"top_cr_title = aq.from(clean2_nodeReqFL)\n .filter(d => d.Clicks > 0) // exclude titles with 0 apps\n .groupby('job_title')\n .rollup({cr: d => op.sum(d.Applies)/op.sum(d.Clicks)})\n .orderby(aq.desc('cr'))\n .filter(d => op.rank() <= 10) // **JOHN, YOU CAN CHANGE THIS!**\n //.filter(d => d.cr > 0) // exclude conversion rate of 0 // **JOHN, YOU CAN REMOVE THE \"//\" FROM THE BEGINNING TO FILTER 0% CR\n .dedupe()\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1700,"value":"#### All campaigns","pinned":false,"hidden":false,"mode":"md"},{"id":1703,"value":"// this is the top apps title data\ntop_title_all = aq.from(clean2)\n .filter(d => d.Applies > 0) \n .groupby('job_title')\n .rollup({total_apps: d => op.sum(d.Applies)})\n .orderby(aq.desc('total_apps'))\n .filter(d => op.rank() <= 10) // **JOHN, YOU CAN CHANGE THIS!**\n .dedupe()\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1709,"value":"top_cr_title_all = aq.from(clean2)\n .filter(d => d.Clicks > 0) // exclude titles with 0 apps\n .groupby('job_title')\n .rollup({cr: d => op.sum(d.Applies)/op.sum(d.Clicks)})\n .orderby(aq.desc('cr'))\n .filter(d => op.rank() <= 10) // **JOHN, YOU CAN CHANGE THIS!**\n //.filter(d => d.cr > 0) // exclude conversion rate of 0 // **JOHN, YOU CAN REMOVE THE \"//\" FROM THE BEGINNING TO FILTER 0% CR\n .dedupe()\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1418,"value":"### *Weekly Summary*","pinned":false,"hidden":false,"mode":"md"},{"id":1713,"value":"#### Per req","pinned":false,"hidden":false,"mode":"md"},{"id":1420,"value":"week_summary = aq.from(clean_nodeFL.filter((d) => d.job_req_id == req_selector))\n .derive({week_num: d => op.utcweek(d.date)})\n .groupby('Name', 'week_num')\n .rollup({\n total_apps: d => op.sum(d.applies),\n total_clicks: d => op.sum(d.clicks),\n total_spend: d => op.sum(d.spend)\n })\n .derive({\n cr: d => d.total_apps/d.total_clicks,\n calc_cpa: d => d.total_spend/d.total_apps \n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1715,"value":"#### All campaigns","pinned":false,"hidden":false,"mode":"md"},{"id":1719,"value":"week_summary_all = aq.from(clean)\n .derive({week_num: d => op.utcweek(d.date)})\n .groupby('week_num')\n .rollup({\n total_apps: d => op.sum(d.applies),\n total_clicks: d => op.sum(d.clicks),\n total_spend: d => op.sum(d.spend)\n })\n .derive({\n cr: d => d.total_apps/d.total_clicks,\n calc_cpa: d => d.total_spend/d.total_apps \n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1013,"value":"#### Dates","pinned":false,"hidden":false,"mode":"md"},{"id":1059,"value":"data_date_range = d3.extent(clean, d => d.date)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1009,"value":"data2_date_range = d3.extent(clean2, d => d.date)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1034,"value":"formatter(data2_date_range[1])","pinned":true,"hidden":false,"mode":"ojs"},{"id":1018,"value":"formatter = d3.utcFormat ('%A %b %d, %Y')","pinned":true,"hidden":false,"mode":"ojs"},{"id":1682,"value":"### *Network Summary*","pinned":false,"hidden":false,"mode":"md"},{"id":1686,"value":"net_summary = aq.from(clean)\n .groupby('date')\n .rollup({\n total_apps: d => op.sum(d.applies),\n total_spend: d => op.sum(d.spend)\n })\n .derive({\n calc_cpa: d => d.total_spend/d.total_apps\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":187,"value":"### *Secondary data sources*","pinned":false,"hidden":false,"mode":"md"},{"id":607,"value":"campaigns = file1.csv()","pinned":true,"hidden":false,"mode":"ojs"},{"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":528,"value":"appcast_color_palette = ['#3138BB', '#FF7D6F', '#AF9BFC', '#C7FFE2', '#127FFC', '#FF9B77']","pinned":true,"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":"// object containing all of the FIPS us state codes\n\nimport {statemap} from \"@d3/choropleth\"","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":151,"value":"import {countyShapes} from \"@enjalot/us-county-datasets\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"//example to use the file above\ncountyShapes.features[0].properties.name","pinned":true,"hidden":false,"mode":"ojs"},{"id":208,"value":"### *Chart configuration*","pinned":false,"hidden":false,"mode":"md"},{"id":865,"value":"name_map = clean_nodeFL.filter(d => d.job_req_id == req_selector).map(d => d.Name)","pinned":false,"hidden":false,"mode":"ojs"},{"id":202,"value":"clean_config = ({\n view: { stroke: null },\n headerRow: {\n title: null,\n labelOrient: 'top',\n labelPadding: 35,\n labelFontSize: 20,\n labelFontWeight: 200,\n labelAlign: 'left'\n },\n axis: {\n gridOpacity: 0.5,\n labelFontWeight: 75,\n domain: false,\n offset: 5,\n titleFontWeight: 200,\n titleFontSize: 12,\n titlePadding: 20,\n labelOpacity: 0.6\n },\n axisX: {\n tickCount: 5,\n titlePadding: 10,\n labelPadding: 4,\n title: null\n },\n axisY: {\n ticks: false,\n labelLimit: 300,\n labelFontSize: 8\n },\n title: {\n fontWeight: 300,\n fontSize: 13,\n offset: 25\n }\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1641,"value":"## Test to understand template literals","pinned":false,"hidden":false,"mode":"md"},{"id":1625,"value":"// viewof test = html`

\n//

${viewof table2}

\n//

${viewof top_title_table}

\n//

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