2f:T609,According to an [Ipsos](https://www.ipsos.com/en-ca/Affordability-and-Healthcare-top-Issues-influencing-Canadians-voting-decision) poll, the top issues facing Canadians are: 1. Cost of living 2. Health care 3. The economy 4. Housing affordability 5. Inflation 6. Taxes 7. Climate change 8. Poverty 9. Government deficits and debt 10. COVID-19 As a demonstration of the Meta Graph API, I used a [Python Script](https://github.com/dsartori/explore_fb_ads) to retrieve data from the Graph API related to political and issue ads in Canada. Meta has [special rules](https://www.facebook.com/business/help/167836590566506?id=288762101909005) for this type of ad. Advertisers who want to place these ads need to be authorized by Facebook to do so, and this type of advertising is subject to public disclosure of the approximate amount of money spent on each ad as well as the approximate number of impressions the ad achieved. The API can return a variety of data fields. For my purposes, I was interested in impressions and spending. Each of these is available in the result set, but Meta puts a bit of fuzz into the numbers by specifying a range of 100 dollars rather than the exact price paid. A similar approach is taken with impression counts. For this analysis I used the upper bound number for both impressions and spending. The data series used in this notebook begins January 1, 2023 and ends October 20, 2023. This bar chart shows the relative spending on public interest ads related to each of the top 10 issues identified by Canadians.30:T636,{ // create and select an svg element that is the size of the bars plus margins const svg = d3.create('svg') .attr('width', barwidth) // we could also put visHeight + margin.top + margin.bottom instead of totalHeight .attr('height', barheight); // append a group element and move it left and down to create space // for the left and top margins const g = svg.append("g") .attr('transform', `translate(${margin.left}, ${margin.top})`); // bind our data to rectangles g.selectAll('rect') .data(adSummary) .join('rect') // set attributes for each bar .attr('x', 0) // each bar starts at the same x position .attr('y', d => y(d["Search Term"])) // pass the name to the y-scale to get y position .attr('width', d => x(d.Spend)) // pass the score to the x-scale to get width of the bar .attr('height', y.bandwidth()) // get the width of each band in the scale .attr('fill', 'steelblue'); // add a group for the y-axis g.append('g') .call(yAxis) // remove the baseline .call(g => g.select('.domain').remove()); // add a group for the x-axis g.append('g') // we have to move this group down to the bottom of the vis .attr('transform', `translate(0, ${barvisHeight})`) .call(xAxis) .call(g => g.select('.domain').remove()) // add a label for the x-axis .append('text') .attr('fill', 'black') .attr('font-family', 'sans-serif') .attr('x', barvisWidth / 2) .attr('y', 40) .text("Population"); return svg.node(); }31:T7da,chart = { // Specify the chart’s dimensions. const width = 928; const height = Math.min(width, 500); // Create the color scale. const color = d3.scaleOrdinal() .domain(data.map(d => d.name)) .range(d3.quantize(t => d3.interpolateSpectral(t * 0.8 + 0.1), data.length).reverse()) // Create the pie layout and arc generator. const pie = d3.pie() .sort(null) .value(d => d.value); const arc = d3.arc() .innerRadius(0) .outerRadius(Math.min(width, height) / 2 - 1); const labelRadius = arc.outerRadius()() * 0.8; // A separate arc generator for labels. const arcLabel = d3.arc() .innerRadius(labelRadius) .outerRadius(labelRadius); const arcs = pie(data); // Create the SVG container. const svg = d3.create("svg") .attr("width", width) .attr("height", height) .attr("viewBox", [-width / 2, -height / 2, width, height]) .attr("style", "max-width: 100%; height: auto; font: 10px sans-serif;"); // Add a sector path for each value. svg.append("g") .attr("stroke", "white") .selectAll() .data(arcs) .join("path") .attr("fill", d => color(d.data.name)) .attr("d", arc) .append("title") .text(d => `${d.data.name}: ${d.data.value.toLocaleString("en-US")}`); // Create a new arc generator to place a label close to the edge. // The label shows the value if there is enough room. svg.append("g") .attr("text-anchor", "middle") .selectAll() .data(arcs) .join("text") .attr("transform", d => `translate(${arcLabel.centroid(d)})`) .call(text => text.append("tspan") .attr("y", "-0.4em") .attr("font-weight", "bold") .text(d => d.data.name)) .call(text => text.filter(d => (d.endAngle - d.startAngle) > 0.25).append("tspan") .attr("x", 0) .attr("y", "0.5em") .attr("fill-opacity", 0.7) .text(d => d.data.value.toLocaleString("en-US"))); return svg.node(); }32:[{"id":"c99751d636680714c59edc357545508db364ab6d5ee1e0133eba318fc68701d1894fa4ad8101d0a811d8cb44ed501ee6313efca1eedcd1eae81139fab85f27d6","href":"https://static.observableusercontent.com/files/c99751d636680714c59edc357545508db364ab6d5ee1e0133eba318fc68701d1894fa4ad8101d0a811d8cb44ed501ee6313efca1eedcd1eae81139fab85f27d6","name":"detail_ad_data@1.csv","type":"text/csv","lastModified":1697498048416.165,"size":177792},{"id":"47832ec0d6edd3159d420b3d67f9eb59761c38fe502112c80c6bc0db41ea8e847f2ff8ef9c707e66b11f3d9b1d80731f5267a3b86f4849a1b751815968f5d79e","href":"https://static.observableusercontent.com/files/47832ec0d6edd3159d420b3d67f9eb59761c38fe502112c80c6bc0db41ea8e847f2ff8ef9c707e66b11f3d9b1d80731f5267a3b86f4849a1b751815968f5d79e","name":"ad_data@2.csv","type":"text/csv","lastModified":1698878126739.485,"size":301},{"id":"aa40cf79275a0fae2a41964f05fb40fc0a293a547570f39700802c00a2a55e8cc80f52271a125960af531332d66fd61380150cb0720a980bd353b9a406353234","href":"https://static.observableusercontent.com/files/aa40cf79275a0fae2a41964f05fb40fc0a293a547570f39700802c00a2a55e8cc80f52271a125960af531332d66fd61380150cb0720a980bd353b9a406353234","name":"detail_ad_data@2.csv","type":"text/csv","lastModified":1698878142491.868,"size":133209},{"id":"fb31600d5b50bbcfca5658a417ef617aad4af9ce04bc8cbf797b21acbcf4da71c53e9911d30314c7971d0c69cf760837848b13e67ea2194f560d58744068872f","href":"https://static.observableusercontent.com/files/fb31600d5b50bbcfca5658a417ef617aad4af9ce04bc8cbf797b21acbcf4da71c53e9911d30314c7971d0c69cf760837848b13e67ea2194f560d58744068872f","name":"ad_data@3.csv","type":"text/csv","lastModified":1698878344736.979,"size":299},{"id":"1d6006c8631ea1e17ee96bc5763790725c593ad1261ff51d2d4158a34394993cb132b7fc878403057191c58e1287c231ca93f8ecf35b8f8d7d09810abb2c8600","href":"https://static.observableusercontent.com/files/1d6006c8631ea1e17ee96bc5763790725c593ad1261ff51d2d4158a34394993cb132b7fc878403057191c58e1287c231ca93f8ecf35b8f8d7d09810abb2c8600","name":"detail_ad_data@3.csv","type":"text/csv","lastModified":1698878354332.556,"size":130207},{"id":"5cf5a3bd38117897bb5fa68699481d66a679654980b77eae68a3aaba6fd2fa8a71cb88db0c8fb0295020095e6d430d75812a711a7061c0c3bc528aca986b2904","href":"https://static.observableusercontent.com/files/5cf5a3bd38117897bb5fa68699481d66a679654980b77eae68a3aaba6fd2fa8a71cb88db0c8fb0295020095e6d430d75812a711a7061c0c3bc528aca986b2904","name":"ad_data@1.csv","type":"text/csv","lastModified":1697574567833.654,"size":340}] 2d:{"title":"Facebook Ads","cells":[{"id":0,"value":"# Facebook Ads","pinned":false,"hidden":false,"mode":"md"},{"id":250,"value":"$2f","pinned":false,"hidden":false,"mode":"md"},{"id":150,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":259,"value":"This pie chart shows the top five pages in terms of either ad spend or impressions for the selected search term. Use the drop downs to change the displayed data.","pinned":false,"hidden":false,"mode":"md"},{"id":37,"value":"viewof currentCategory = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":78,"value":"viewof displaySum = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":3,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":268,"value":"Browse the entire data set:","pinned":false,"hidden":false,"mode":"md"},{"id":211,"value":"await FileAttachment(\"detail_ad_data@3.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":105,"value":"data = {\n var tempData = Alldata.toSorted(function(a, b) { return b.value - a.value });\n var output = []\n for (var i=0; i< 5; i++){\n output.push(tempData[i]);\n }\n \n var totalWithTop = tempData.reduce((a, obj) => a += obj.value,0)\n \n var totalOfTop = output.reduce((a, obj) => a += obj.value ,0) \n\n output.push({\"name\": \"Others\",\"value\":(totalWithTop - totalOfTop)})\n return output;\n}\n ","pinned":false,"hidden":false,"mode":"ojs"},{"id":83,"value":"Alldata = {\n var output = []\n for (var i = 0; i < filteredAdData.length; ++i) {\n output.push({\"name\": filteredAdData[i][\"Page Name\"], \"value\": parseInt(filteredAdData[i][displaySum])});\n }\n return output\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":55,"value":"filteredAdData = adData.filter(function(obj){\n if (obj['Search Term']==currentCategory){\n return true\n }else{\n return false}\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"color = d3\n .scaleOrdinal()\n .domain([\n \"Lorem ipsum\",\n \"dolor sit\",\n \"amet\",\n \"consectetur\",\n \"adipisicing\",\n \"elit\",\n \"sed\",\n \"do\",\n \"eiusmod\",\n \"tempor\",\n \"incididunt\"\n ])\n .range([\n \"#98abc5\",\n \"#8a89a6\",\n \"#7b6888\",\n \"#6b486b\",\n \"#a05d56\",\n \"#d0743c\",\n ])","pinned":false,"hidden":false,"mode":"ojs"},{"id":97,"value":"height = 1000","pinned":false,"hidden":false,"mode":"ojs"},{"id":99,"value":"width = 928 ","pinned":false,"hidden":false,"mode":"ojs"},{"id":228,"value":"barheight = 1000","pinned":true,"hidden":false,"mode":"ojs"},{"id":233,"value":"barwidth = 800","pinned":true,"hidden":false,"mode":"ojs"},{"id":101,"value":"html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":154,"value":"format = d3.format('~s')","pinned":false,"hidden":false,"mode":"ojs"},{"id":169,"value":"margin = ({top: 20, bottom: 45, left: 75, right: 10})","pinned":false,"hidden":false,"mode":"ojs"},{"id":207,"value":"visWidth = width - margin.left - margin.right","pinned":true,"hidden":false,"mode":"ojs"},{"id":230,"value":"barvisWidth = 700","pinned":true,"hidden":false,"mode":"ojs"},{"id":237,"value":"barvisHeight = 950","pinned":true,"hidden":false,"mode":"ojs"},{"id":173,"value":"visHeight = height - margin.top - margin.bottom","pinned":false,"hidden":false,"mode":"ojs"},{"id":162,"value":"categories = adSummary.map(d=> d['Search Term'])","pinned":false,"hidden":false,"mode":"ojs"},{"id":166,"value":"maxSpend = d3.max(adSummary, d=>parseInt(d.Spend))","pinned":false,"hidden":false,"mode":"ojs"},{"id":180,"value":"q = d3.max([3,1,3,2,4])","pinned":false,"hidden":false,"mode":"ojs"},{"id":164,"value":"x = d3.scaleLinear()\n .domain([0, maxSpend])\n .range([0, visWidth])","pinned":false,"hidden":false,"mode":"ojs"},{"id":160,"value":"y = d3.scaleBand()\n .domain(categories)\n .range([0, visHeight])\n .padding(0.2)","pinned":false,"hidden":false,"mode":"ojs"},{"id":158,"value":"yAxis = d3.axisLeft(y)","pinned":false,"hidden":false,"mode":"ojs"},{"id":152,"value":"xAxis = d3.axisBottom(x).tickFormat(format)","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"adData = FileAttachment(\"detail_ad_data@3.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":147,"value":"adSummary = FileAttachment(\"ad_data@3.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}