{"id":3977,"date":"2017-02-09T11:12:10","date_gmt":"2017-02-09T11:12:10","guid":{"rendered":"http:\/\/www.phillconnell.com\/blog\/?p=3977"},"modified":"2017-02-09T11:31:01","modified_gmt":"2017-02-09T11:31:01","slug":"marketing-data-versus-information-my-challenge-to-you","status":"publish","type":"post","link":"https:\/\/www.phillconnell.com\/blog\/marketing-data-versus-information-my-challenge-to-you\/","title":{"rendered":"<b>Marketing Data versus Information: My Challenge to You.<\/b>"},"content":{"rendered":"<h2>This Marketer&#8217;s Looking For Answers. Can You Help?<\/h2>\n<p>(<em>This post was first published on Linked in, February 2016<\/em>)<\/p>\n<p>As a marketer, I&#8217;ve spent countless hours wrestling with Data to provide my stakeholders with Information. It&#8217;s a challenge that will never go away, for anyone who works in a role where things are routinely measured. Can you honestly say that you don&#8217;t face this challenge yourself? If not, you&#8217;re lucky and you can move on with your day. Don&#8217;t let me keep you!<\/p>\n<div id=\"attachment_3978\" style=\"width: 754px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/www.phillconnell.com\/blog\/wp-content\/uploads\/Marketing-Data-versus-Information-Phill-Connell.jpg\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3978\" data-attachment-id=\"3978\" data-permalink=\"https:\/\/www.phillconnell.com\/blog\/marketing-data-versus-information-my-challenge-to-you\/marketing-data-versus-information-phill-connell\/#main\" data-orig-file=\"https:\/\/i0.wp.com\/www.phillconnell.com\/blog\/wp-content\/uploads\/Marketing-Data-versus-Information-Phill-Connell.jpg?fit=744%2C400&amp;ssl=1\" data-orig-size=\"744,400\" data-comments-opened=\"1\" data-image-title=\"Marketing Data versus Information &amp;#8211; Phill Connell\" data-image-description=\"&lt;p&gt;Marketing Data versus Information &amp;#8211; Phill Connell&lt;\/p&gt;\n\" data-image-caption=\"&lt;p&gt;Marketing Data versus Information &amp;#8211; Phill Connell&lt;\/p&gt;\n\" data-large-file=\"https:\/\/i0.wp.com\/www.phillconnell.com\/blog\/wp-content\/uploads\/Marketing-Data-versus-Information-Phill-Connell.jpg?fit=300%2C161&amp;ssl=1\" class=\"size-full wp-image-3978\" src=\"https:\/\/i0.wp.com\/www.phillconnell.com\/blog\/wp-content\/uploads\/Marketing-Data-versus-Information-Phill-Connell.jpg?resize=744%2C400\" alt=\"Marketing Data versus Information - Phill Connell\" width=\"744\" height=\"400\" srcset=\"https:\/\/i0.wp.com\/www.phillconnell.com\/blog\/wp-content\/uploads\/Marketing-Data-versus-Information-Phill-Connell.jpg?w=744&amp;ssl=1 744w, https:\/\/i0.wp.com\/www.phillconnell.com\/blog\/wp-content\/uploads\/Marketing-Data-versus-Information-Phill-Connell.jpg?resize=400%2C215&amp;ssl=1 400w, https:\/\/i0.wp.com\/www.phillconnell.com\/blog\/wp-content\/uploads\/Marketing-Data-versus-Information-Phill-Connell.jpg?resize=300%2C161&amp;ssl=1 300w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/a><p id=\"caption-attachment-3978\" class=\"wp-caption-text\">Marketing Data versus Information &#8211; Phill Connell<\/p><\/div>\n<h2>Combining Multiple Data Sources Into One Report<\/h2>\n<p>When showing useful information about Marketing KPIs or performance to people who are interested, single Data sources are usually ok. On-board reporting tools from CRM systems like <a href=\"http:\/\/www.saleforce.com\" target=\"_blank\">Salesforce<\/a> (<em>or another<\/em>) are powerful and incredibly useful. Email delivery systems; webinar platforms; even social media tools all possess good on-board reporting. But what about combining these into one Marketing Dashboard which shows your true Marketing-to-Lead-to-Order supply chain?<\/p>\n<p>Excel, the dreaded Reporting Tool Of Last Resort, can be a wonderful thing. But not very often. I&#8217;ve tried that. It&#8217;s just so fickle. It&#8217;s not good for delivering repeatable, structured, sustainable reporting. Solve your problems in Excel, hand them to someone else and watch them break your spreadsheet. It just doesn&#8217;t work.<\/p>\n<p>Then just try to slice &amp; dice the Data into a different view. Got a nice view by campaign? Great, someone will ask for the same Data by the date leads were received. Bah! It&#8217;s not them, it&#8217;s you &#8211; or rather it&#8217;s your half-arsed report.<\/p>\n<h2>So, What Should I Do?<\/h2>\n<p>I need to combine data from multiple marketing channels into a single Marketing Dashboard. I&#8217;ve got a combined email and landing page platform, a webinar platform, tracked shortened urls to tell the sources of traffic to my landing pages, and common campaign names across these platforms to enable me to join the data. I need to be able to slice &amp; dice my Data into different Informative views: by date; by campaign; by geography; by Sales team&#8230;<\/p>\n<p>Here&#8217;s your challenge: Just tell me what I should use. I&#8217;m leaning towards <a href=\"https:\/\/www.tableau.com\" target=\"_blank\">Tableau<\/a> as a visualisation tool but only because I know my organisation already uses it elsewhere. As far as organising the basic Data goes, I could probably do it in Excel or Google Sheets using regular updates from my channel platforms. At least that gives me flat files to report from. Maybe in future I could move to real-time APIs, we can talk about that later. But I need the flat data sheets to combine into a repeatable, consistent, shareable format which makes sense and helps to tell our story of Marketing Excellence in a compelling way. That&#8217;s where you come in&#8230;<\/p>\n<h2>Can You Help?<\/h2>\n<p>Have you solved this conundrum in your organisation? Do you use a great Marketing Dashboard already? Did you find something off the peg or build it from the ground up?<\/p>\n<p>If you&#8217;ve got a good idea, tell me about it. I&#8217;m all ears. My stakeholders will be eternally grateful, but not as grateful as I will be. Comment here or <a href=\"https:\/\/www.linkedin.com\/in\/phillconnell\" target=\"_blank\">get in touch via LinkedIn<\/a>, I&#8217;d love to hear from you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This Marketer&#8217;s Looking For Answers. Can You Help? (This post was first published on Linked in, February 2016) As a marketer, I&#8217;ve spent countless hours wrestling with Data to provide my stakeholders with Information. It&#8217;s a challenge that will never go away, for anyone who works in a role where things are routinely measured. Can [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":3978,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_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":[297],"tags":[],"class_list":["post-3977","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-marketing"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p1KBwn-129","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.phillconnell.com\/blog\/wp-content\/uploads\/Marketing-Data-versus-Information-Phill-Connell.jpg?fit=744%2C400&ssl=1","_links":{"self":[{"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/posts\/3977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/comments?post=3977"}],"version-history":[{"count":2,"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/posts\/3977\/revisions"}],"predecessor-version":[{"id":3980,"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/posts\/3977\/revisions\/3980"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/media\/3978"}],"wp:attachment":[{"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/media?parent=3977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/categories?post=3977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.phillconnell.com\/blog\/wp-json\/wp\/v2\/tags?post=3977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}