2f:[{"id":"03cd7a9bdcf47af111755f434c5e1a1e16fe439d368a7528f32302a732997696b7633c219aa9e46e9d73c46b508c81eed3a0ec02a86eec99404e4660f7560dd7","href":"https://static.observableusercontent.com/files/03cd7a9bdcf47af111755f434c5e1a1e16fe439d368a7528f32302a732997696b7633c219aa9e46e9d73c46b508c81eed3a0ec02a86eec99404e4660f7560dd7","name":"Lyft Repository - Title testing 1_24.csv","type":"text/csv","lastModified":1675366785824.346,"size":1905}] 2d:{"title":"Alyssa's question","cells":[{"id":0,"value":"md `# Alyssa's question\n(about impressions)\n
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":503,"value":"viewof file = Inputs.file({label: \"Data\", required: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":766,"value":"md `The last file you loaded was: **${fileLog.slice(-1)}**`","pinned":false,"hidden":false,"mode":"ojs"},{"id":528,"value":"vl.markRect({tooltip: true})\n .data(not_test_markets_clean)\n .title('not test markets')\n .encode(\n vl.x().fieldT('date')\n .timeUnit('utcmonthdate'),\n vl.y().fieldN('title'),\n vl.color().fieldQ('impressions')\n .scale({\n scheme: 'blues'\n })\n )\n .config(clean_heat)\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":572,"value":"aq.from(not_test_markets_clean)\n .derive({\n segment: d => d.date <= op.utcdatetime(2023,0,24) ? 'pre' : 'post'\n })\n //.orderby(aq.desc('date'))\n .groupby('segment')\n .rollup({\n t_impressions: d => op.sum(d.impressions)\n })\n .view()","pinned":false,"hidden":false,"mode":"ojs"},{"id":534,"value":"vl.markRect({tooltip: true})\n .data(test_markets_clean)\n .title('test markets')\n .encode(\n vl.x().fieldT('date')\n .timeUnit('utcmonthdate'),\n vl.y().fieldN('title'),\n vl.color().fieldQ('impressions')\n .scale({\n scheme: 'blues',\n //type: 'quantize'\n })\n )\n .config(clean_heat)\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":591,"value":"aq.from(test_markets_clean)\n .derive({\n segment: d => d.date <= op.utcdatetime(2023,0,24) ? 'pre' : 'post'\n })\n //.orderby(aq.desc('date'))\n .groupby('segment')\n .rollup({\n t_impressions: d => op.sum(d.impressions)\n })\n .view()","pinned":false,"hidden":false,"mode":"ojs"},{"id":623,"value":"vl.markArc({tooltip: true})\n .data(percent_campaign)\n .encode(\n vl.theta().fieldQ('percent'),\n vl.color().fieldN('other')\n .scale({\n scheme: 'category20'\n })\n //.sort(vl.fieldQ('percent').order('descending'))\n )\n // .width(900)\n // .height(100)\n .config({\n view: {stroke: null}\n })\n .render()","pinned":false,"hidden":false,"mode":"ojs"},{"id":615,"value":"viewof percent_campaign = aq.from(test_markets_clean)\n .derive({\n group: d => op.match(d.title, 'CHI') ? 'CHI' : 'Not CHI'\n })\n .groupby('title')\n .rollup({\n total_impressions: d => op.sum(d.impressions)\n })\n .derive({\n percent: d => d.total_impressions / op.sum(d.total_impressions)\n })\n .derive({\n other: d => d.percent < 0.03 ? 'Other' : d.title\n })\n .orderby(aq.desc('percent'))\n .view()","pinned":false,"hidden":false,"mode":"ojs"},{"id":548,"value":"clean_heat = ({\n view: {stroke: null, step: 11},\n axis: {domain: false, grid: false},\n rect: {width: {band: 0.95}, height: {band: 0.95}},\n axisY: {labelFontSize: 7}\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":525,"value":"viewof not_test_markets_clean = aq.from(raw_data.filter(d => !test_market_list.includes(d.title)))\n .filter(d => d.master_publisher_aggregated != 'Craigslist Official Posting')\n .filter(d => d.master_publisher_aggregated == 'Indeed CPC')\n .view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":508,"value":"viewof test_markets_clean = aq.from(raw_data.filter(d => test_market_list.includes(d.title)))\n .filter(d => d.master_publisher_aggregated != 'Craigslist Official Posting')\n .filter(d => d.master_publisher_aggregated == 'Indeed CPC')\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":515,"value":"raw_test_markets = FileAttachment(\"Lyft Repository - Title testing 1_24.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs"},{"id":544,"value":"//table to export the list of test markets \nInputs.table(test_market_list)","pinned":true,"hidden":false,"mode":"ojs"},{"id":517,"value":"test_market_list = aq.from(raw_test_markets)\n .select('Test markets')\n .dedupe()\n .array('Test markets')\n // .objects()","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":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":761,"value":"import {viewof fileLog} from \"5b757a31fd4f7329\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":456,"value":"md `### *Functions*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":764,"value":"// first (top) file name\n{\n if (file !== null) {\n viewof fileLog.addFilename(file.name);\n }\n}","pinned":true,"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"},{"id":648,"value":"html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":651,"value":"viewof pre = Inputs.file({label: \"Data\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":660,"value":"raw_pre = pre.csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":654,"value":"viewof post = Inputs.file({label: \"Data\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":662,"value":"raw_post = post.csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":676,"value":"md `### Pre`","pinned":true,"hidden":false,"mode":"ojs"},{"id":678,"value":"// title test markets\nt_pre = aq.from(raw_pre.filter(d => test_market_list.includes(d.Campaign)))\n .derive({\n spend: d => +op.replace(d.Actual, ',',''),\n clicks: d => +op.replace(d['Total Clicks'], ',',''),\n leads: d => +op.replace(d['Total Leads'], ',','')\n })\n .rollup({\n total_spend: d => op.sum(d.spend),\n total_clicks: d => op.sum(d.clicks),\n total_leads: d => op.sum(d.leads)\n })\n .derive({\n segment: d => 'pre',\n group: d => 'title test markets'\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":697,"value":"// no title test markets\nnt_pre = aq.from(raw_pre.filter(d => !test_market_list.includes(d.Campaign)))\n .derive({\n spend: d => +op.replace(d.Actual, ',',''),\n clicks: d => +op.replace(d['Total Clicks'], ',',''),\n leads: d => +op.replace(d['Total Leads'], ',','')\n })\n .rollup({\n total_spend: d => op.sum(d.spend),\n total_clicks: d => op.sum(d.clicks),\n total_leads: d => op.sum(d.leads)\n })\n .derive({\n segment: d => 'pre',\n group: d => 'NO title test markets'\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":704,"value":"md `### Post`","pinned":true,"hidden":false,"mode":"ojs"},{"id":706,"value":"// title test markets\nt_post = aq.from(raw_post.filter(d => test_market_list.includes(d.Campaign)))\n .derive({\n spend: d => +op.replace(d.Actual, ',',''),\n clicks: d => +op.replace(d['Total Clicks'], ',',''),\n leads: d => +op.replace(d['Total Leads'], ',','')\n })\n .rollup({\n total_spend: d => op.sum(d.spend),\n total_clicks: d => op.sum(d.clicks),\n total_leads: d => op.sum(d.leads)\n })\n .derive({\n segment: d => 'post',\n group: d => 'title test markets'\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":710,"value":"// no title test markets\nnt_post = aq.from(raw_post.filter(d => !test_market_list.includes(d.Campaign)))\n .derive({\n spend: d => +op.replace(d.Actual, ',',''),\n clicks: d => +op.replace(d['Total Clicks'], ',',''),\n leads: d => +op.replace(d['Total Leads'], ',','')\n })\n .rollup({\n total_spend: d => op.sum(d.spend),\n total_clicks: d => op.sum(d.clicks),\n total_leads: d => op.sum(d.leads)\n })\n .derive({\n segment: d => 'post',\n group: d => 'NO title test markets'\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":713,"value":"md `## Master table`","pinned":false,"hidden":false,"mode":"ojs"},{"id":716,"value":"master_table = aq.from(t_pre)\n .concat(aq.from(nt_pre))\n .concat(aq.from(t_post))\n .concat(aq.from(nt_post))\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":730,"value":"Inputs.table(master_table)","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}