{"id":1346,"date":"2014-09-20T13:55:09","date_gmt":"2014-09-20T17:55:09","guid":{"rendered":"http:\/\/ibit.temple.edu\/analytics\/?p=1346"},"modified":"2020-10-27T12:06:45","modified_gmt":"2020-10-27T16:06:45","slug":"finding-political-spending-hot-spots","status":"publish","type":"post","link":"https:\/\/ibit.temple.edu\/analytics\/finding-political-spending-hot-spots\/","title":{"rendered":"Finding &#8220;Hot Spots&#8221; for Election Spending"},"content":{"rendered":"<h4>NBCUniversal Challenge<\/h4>\n<hr \/>\n<h3><b>Problem<\/b><\/h3>\n<p>The 2014 Federal midterm elections may deliver a new record for midterm spending.\u00a0 Messaging and engagement of voters in crucial races will take priority.\u00a0 NBCUniversal (NBCU) would like to better understand the distribution of spending across Congressional Districts and Nielsen\u00ae DMAs (Designated Market Areas), as well as how they relate to markets with NBC owned-and-operated (O&amp;O) and affiliate stations.<\/p>\n<p>NBCU would like to use this data to better understand:<\/p>\n<ul>\n<li>Which key markets (DMA) present the greatest opportunities for engagement through advertising spending (e.g. \u2013 \u201ctight-races\u201d, \u201chighest ratios of funds raised vs. funds spent in key races\u201d, etc.)?<\/li>\n<li>What demographics are represented in those key markets (DMA) and how they relate to NBCU\u2019s audience segments?<\/li>\n<li>Based on understanding the fundraising and spending patterns of the mid-term elections and the subsequent results, how best should NBCU posture for the upcoming mid-term and Presidential elections (2016)?<\/li>\n<\/ul>\n<p>Develop a visualization (static or interactive) that reflects campaign spending, as provided the Federal Election Commission (FEC), by Committee, Candidate, and total Contributions by Individual for each Congressional District of the 113<sup>th<\/sup> Congress.\u00a0 This information should be triangulated with Nielsen\u00ae DMA and local station information.<\/p>\n<p>Potentially relevant information for individual candidates may include:<\/p>\n<ul>\n<li>Spending by PAC (Political Action Committee)<\/li>\n<li>Party, PAC affiliation<\/li>\n<li>Individual contributions<\/li>\n<li>Ratio of funds raised and spent by PAC, Party<\/li>\n<li>Demographic data for candidates\u2019 respective Congressional District<\/li>\n<\/ul>\n<h3><b>Data<\/b><\/h3>\n<ul>\n<li>NBCU\u2019s Owned &amp; Operated (O&amp;O) and Affiliates Stations by Designated Market Area: [NBCU-Provided File]<\/li>\n<li>Zip Codes by Market: [NBCU-Provided File]<br \/>\n<em>Note 10\/3\/14: In the file, Philadelphia is misspelled as &#8220;Philadeplphia&#8221;<\/em><\/li>\n<li>The Federal Election Commission provides <a href=\"http:\/\/www.fec.gov\/finance\/disclosure\/ftpdet.shtml#a2013_2014\" target=\"_blank\" rel=\"noopener noreferrer\">detailed information about candidates, parties, and committees<\/a>.<\/li>\n<li>The United States Census Bureau provides <a href=\"http:\/\/www2.census.gov\/geo\/relfiles\/cdsld13\/natl\/natl_zccd_delim.txt\" target=\"_blank\" rel=\"noopener noreferrer\">Congressional Districts Relationship Files by ZIP Code<\/a>.<\/li>\n<li>The United States Census Bureau provides demographic information by Congressional District <a href=\"http:\/\/www.census.gov\/fastfacts\" target=\"_blank\" rel=\"noopener noreferrer\">based on the on-going American Community Survey (ACS)<\/a>.<\/li>\n<\/ul>\n<h5>Want more data related to this challenge?\u00a0Check out the Temple Library Analytics Challenge guide.<\/h5>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.flickr.com\/photos\/donkeyhotey\/6261650491\" target=\"_blank\" rel=\"noopener noreferrer\">Front page photo credit<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>NBCUniversal Challenge Problem The 2014 Federal midterm elections may deliver a new record for midterm spending.\u00a0 Messaging and engagement of voters in crucial races will take priority.\u00a0 NBCUniversal (NBCU) would like to better understand the distribution of spending across Congressional Districts and Nielsen\u00ae DMAs (Designated Market Areas), as well as how they relate to markets [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[26],"tags":[],"class_list":{"0":"post-1346","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-26","7":"entry"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3ROyF-lI","_links":{"self":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts\/1346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/comments?post=1346"}],"version-history":[{"count":12,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts\/1346\/revisions"}],"predecessor-version":[{"id":4578,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/posts\/1346\/revisions\/4578"}],"wp:attachment":[{"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/media?parent=1346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/categories?post=1346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibit.temple.edu\/analytics\/wp-json\/wp\/v2\/tags?post=1346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}