{"id":2162,"date":"2023-05-11T14:46:39","date_gmt":"2025-10-07T13:31:29","guid":{"rendered":"https:\/\/www.elixirr.com\/en-gb\/?post_type=case_study&p=2162"},"modified":"2025-11-04T13:57:39","modified_gmt":"2025-11-04T13:57:39","slug":"boston-red-sox-making-data-clean-and-valuable","status":"publish","type":"case_study","link":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/","title":{"rendered":"Boston Red Sox: making data clean and valuable"},"content":{"rendered":"\n
\n
\n

The Boston Red Sox, an American Major League Baseball team, came to iOLAP (now Elixirr Digital), our specialist data and technology team, with a challenge. Their customer data was disorganized and incomplete, which was prohibiting the organization from using it to target its database with offerings, and requiring additional time from employees when handling customer support, among other limitations. iOLAP established a model to sort the data and clean it at the source.<\/p>\n

\n
    \n
  • Outcome 1: Created a process whereby operators can easily identify customers from different data systems<\/li>\n
  • Outcome 2: Implemented the same dataset within the client\u2019s enterprise data warehouse (EDW) to make sure that data from different target systems are in sync<\/li>\n
  • Outcome 3: Increased customer support efficiency and targeted campaign responses<\/li>\n<\/ul>\n

    \"\"<\/p>\n<\/div>\n <\/div>\n <\/div>\n<\/section>\n\n\n\n

    \n
    \n

    \n The challenge<\/h2>
    \n
    \n

    The Boston Red Sox organization was having difficulty matching contacts in its source data systems, including ticketing, MLB data feeds and customer relationship management (CRM) leads, which left them unknowing how many touchpoints a fan received and meant customer profiles were incomplete. They came to iOLAP to help identify bad data and duplicate accounts and design a process to clean the data at the source.<\/p>\n <\/div>\n <\/div>\n <\/div> <\/div>\n<\/section>\n\n\n\n

    \n
    \n

    \n The approach<\/h2>
    \n
    \n

    In order to successfully correlate data between EDW, facility management (FM) and CRM systems, iOLAP established a data governance baseline. This would streamline the process of adding new sources by automatically pushing the data into the established table formats within the model. Once matched in the master data management system (MDM), all touchpoints for a given contact could be easily identified. Within the MDM, reports can be written to identify inconsistent data across systems where the same contact exists in multiple locations. This will allow the team to clean the data at the source on an ongoing basis as issues are flagged.<\/p>\n <\/div>\n <\/div>\n <\/div> <\/div>\n<\/section>\n\n\n\n

    \n
    \n

    \n The value delivered<\/h2>
    \n
    \n

    With records from various source systems now combined into a single MDM system, operators are able to easily identify customers that were created from any of the other systems. All systems within their EDW now utilize the same dataset, ensuring that data is in sync between various target systems.\u00a0As a result of this, the Boston Red Sox organization is able to build out its customer profiles and better target offerings which has led to improved campaign response rates. Customer support time decreased due to quick access to accurate customer history, assets and background. Moreover, MDM created a framework that can be expanded to improve quality of other master data elements for the entire organization.<\/p>\n <\/div>\n <\/div>\n <\/div> <\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":55391,"template":"","related_service":[66],"related_industry":[356],"class_list":["post-2162","case_study","type-case_study","status-publish","has-post-thumbnail","hentry"],"acf":[],"yoast_head":"\nBoston Red Sox: making data clean and valuable - Elixirr<\/title>\n<meta name=\"description\" content=\"The Boston Red Sox teamed up with Elixirr Digital to clean and unify fan and ticketing data\u2014boosting campaign accuracy and support-team efficiency.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Boston Red Sox: making data clean and valuable\" \/>\n<meta property=\"og:description\" content=\"The Boston Red Sox teamed up with Elixirr Digital to clean and unify fan and ticketing data\u2014boosting campaign accuracy and support-team efficiency.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/\" \/>\n<meta property=\"og:site_name\" content=\"Elixirr\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-04T13:57:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"820\" \/>\n\t<meta property=\"og:image:height\" content=\"492\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/\",\"url\":\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/\",\"name\":\"Boston Red Sox: making data clean and valuable - Elixirr\",\"isPartOf\":{\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2.jpg\",\"datePublished\":\"2025-10-07T13:31:29+00:00\",\"dateModified\":\"2025-11-04T13:57:39+00:00\",\"description\":\"The Boston Red Sox teamed up with Elixirr Digital to clean and unify fan and ticketing data\u2014boosting campaign accuracy and support-team efficiency.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/#primaryimage\",\"url\":\"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2.jpg\",\"contentUrl\":\"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2.jpg\",\"width\":820,\"height\":492,\"caption\":\"xr:d:DAFhJO0wyYQ:4,j:4473118414,t:23051113\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.elixirr.com\/en-gb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Case Studies\",\"item\":\"https:\/\/www.elixirr.com\/en-gb\/case-studies\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Boston Red Sox: making data clean and valuable\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/#website\",\"url\":\"https:\/\/www.elixirr.com\/en-gb\/\",\"name\":\"Elixirr\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.elixirr.com\/en-gb\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/#organization\",\"name\":\"Elixirr\",\"alternateName\":\"Elixirr International PLC\",\"url\":\"https:\/\/www.elixirr.com\/en-gb\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/11\/elixirr-logo.png\",\"contentUrl\":\"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/11\/elixirr-logo.png\",\"width\":200,\"height\":200,\"caption\":\"Elixirr\"},\"image\":{\"@id\":\"https:\/\/www.elixirr.com\/en-gb\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Boston Red Sox: making data clean and valuable - Elixirr","description":"The Boston Red Sox teamed up with Elixirr Digital to clean and unify fan and ticketing data\u2014boosting campaign accuracy and support-team efficiency.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/","og_locale":"en_US","og_type":"article","og_title":"Boston Red Sox: making data clean and valuable","og_description":"The Boston Red Sox teamed up with Elixirr Digital to clean and unify fan and ticketing data\u2014boosting campaign accuracy and support-team efficiency.","og_url":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/","og_site_name":"Elixirr","article_modified_time":"2025-11-04T13:57:39+00:00","og_image":[{"width":820,"height":492,"url":"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/","url":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/","name":"Boston Red Sox: making data clean and valuable - Elixirr","isPartOf":{"@id":"https:\/\/www.elixirr.com\/en-gb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/#primaryimage"},"image":{"@id":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/#primaryimage"},"thumbnailUrl":"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2.jpg","datePublished":"2025-10-07T13:31:29+00:00","dateModified":"2025-11-04T13:57:39+00:00","description":"The Boston Red Sox teamed up with Elixirr Digital to clean and unify fan and ticketing data\u2014boosting campaign accuracy and support-team efficiency.","breadcrumb":{"@id":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/#primaryimage","url":"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2.jpg","contentUrl":"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2.jpg","width":820,"height":492,"caption":"xr:d:DAFhJO0wyYQ:4,j:4473118414,t:23051113"},{"@type":"BreadcrumbList","@id":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.elixirr.com\/en-gb\/"},{"@type":"ListItem","position":2,"name":"Case Studies","item":"https:\/\/www.elixirr.com\/en-gb\/case-studies\/"},{"@type":"ListItem","position":3,"name":"Boston Red Sox: making data clean and valuable"}]},{"@type":"WebSite","@id":"https:\/\/www.elixirr.com\/en-gb\/#website","url":"https:\/\/www.elixirr.com\/en-gb\/","name":"Elixirr","description":"","publisher":{"@id":"https:\/\/www.elixirr.com\/en-gb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.elixirr.com\/en-gb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.elixirr.com\/en-gb\/#organization","name":"Elixirr","alternateName":"Elixirr International PLC","url":"https:\/\/www.elixirr.com\/en-gb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.elixirr.com\/en-gb\/#\/schema\/logo\/image\/","url":"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/11\/elixirr-logo.png","contentUrl":"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/11\/elixirr-logo.png","width":200,"height":200,"caption":"Elixirr"},"image":{"@id":"https:\/\/www.elixirr.com\/en-gb\/#\/schema\/logo\/image\/"}}]}},"card":"<article class=\"wp-component-card edwp-component wp-component-card--case_study wp-component-card--link js-card-link\n edwp-fade-in\">\n <figure class=\"wp-component-card__image-wrapper\">\n <img width=\"820\" height=\"492\" src=\"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2.jpg\" class=\"wp-component-card__image\" alt=\"\" decoding=\"async\" srcset=\"https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2.jpg 820w, https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2-300x180.jpg 300w, https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2-768x461.jpg 768w, https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2-87x52.jpg 87w, https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2-319x191.jpg 319w, https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2-479x287.jpg 479w, https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2-567x340.jpg 567w, https:\/\/www.elixirr.com\/en-gb\/wp-content\/uploads\/2025\/10\/Red-Sox-Featured-Image-2-767x460.jpg 767w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/> <div class=\"wp-component-card__preview-icon\">\n <span class='edwp-svg '><svg width=\"47\" height=\"47\" viewBox=\"0 0 47 47\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n<g>\n<path d=\"M23.4141 0.539062C36.1232 0.539183 46.4258 10.8416 46.4258 23.5508C46.4257 36.2599 36.1231 46.5624 23.4141 46.5625C10.7049 46.5625 0.402465 36.2599 0.402344 23.5508C0.402344 10.8415 10.7048 0.539062 23.4141 0.539062ZM23.4141 1.68945C11.3606 1.68945 1.55273 11.4974 1.55273 23.5508C1.55286 35.6041 11.3607 45.4111 23.4141 45.4111C35.4673 45.411 45.2743 35.604 45.2744 23.5508C45.2744 11.4974 35.4674 1.68957 23.4141 1.68945Z\" fill=\"currentColor\"\/>\n<path d=\"M19.2841 33.6992C18.9579 33.6986 18.6374 33.6111 18.3543 33.4454C17.7167 33.0759 17.3203 32.3585 17.3203 31.5797V15.8189C17.3203 15.0379 17.7167 14.3227 18.3543 13.9531C18.6442 13.7827 18.9735 13.6951 19.3078 13.6994C19.6421 13.7037 19.9692 13.7998 20.2548 13.9776L33.4237 22.0406C33.6981 22.2166 33.9244 22.461 34.0812 22.751C34.238 23.0409 34.3203 23.3668 34.3203 23.6982C34.3203 24.0295 34.238 24.3555 34.0812 24.6454C33.9244 24.9353 33.6981 25.1798 33.4237 25.3558L20.2527 33.421C19.9604 33.6017 19.6256 33.6979 19.2841 33.6992Z\" fill=\"currentColor\"\/>\n<\/g>\n<\/svg>\n<\/span> <\/div>\n <\/figure>\n <div class=\"wp-component-card__content edwp-row-load\">\n <p class=\"wp-component-card__eyebrow\">\n Data Strategy <\/p>\n <a href='https:\/\/www.elixirr.com\/en-gb\/case-studies\/boston-red-sox-making-data-clean-and-valuable\/' class='wp-component-card__title'>\n <h2>\n Boston Red Sox: making data clean and valuable\n <\/h2>\n <\/a> <div class=\"wp-component-card__meta\">\n <p class=\"wp-component-card__date\">\n 11 May 2023 <\/p>\n <div class=\"wp-component-card__terms\">\n <div class=\"wp-component-tags edwp-component\">\n <div class=\"wp-component-tags__tag\">\n Sports <\/div>\n <div class=\"wp-component-tags__tag\">\n Data Strategy <\/div>\n <\/div>\n <\/div>\n <\/div>\n <div class=\"wp-component-card__button-wrapper\">\n <button class=\"btn btn--link arrow wp-component-card__button\">\n Read more <span class='edwp-svg '><svg width=\"20\" height=\"20\" viewBox=\"0 0 20 20\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n<g id=\"Lg\">\n<path id=\"Vector\" d=\"M1.12509 9.50162H15.8648L9.43259 3.06941C9.374 3.0113 9.3275 2.94216 9.29576 2.86599C9.26403 2.78981 9.24769 2.70811 9.24769 2.62559C9.24769 2.54307 9.26403 2.46137 9.29576 2.38519C9.3275 2.30902 9.374 2.23988 9.43259 2.18177C9.54971 2.06535 9.70814 2 9.87328 2C10.0384 2 10.1969 2.06535 10.314 2.18177L17.8151 9.6829C17.8737 9.74101 17.9202 9.81014 17.9519 9.88632C17.9837 9.96249 18 10.0442 18 10.1267C18 10.2092 17.9837 10.2909 17.9519 10.3671C17.9202 10.4433 17.8737 10.5124 17.8151 10.5705L10.314 18.0717C10.1975 18.1871 10.0404 18.2522 9.87641 18.2529C9.79414 18.2534 9.71259 18.2376 9.63643 18.2065C9.56027 18.1754 9.491 18.1296 9.43259 18.0717C9.374 18.0135 9.3275 17.9444 9.29576 17.8682C9.26403 17.7921 9.24769 17.7104 9.24769 17.6278C9.24769 17.5453 9.26403 17.4636 9.29576 17.3874C9.3275 17.3113 9.374 17.2421 9.43259 17.184L15.8711 10.7518H1.12509C0.959309 10.7518 0.800312 10.686 0.683084 10.5687C0.565857 10.4515 0.5 10.2925 0.5 10.1267C0.5 9.96093 0.565857 9.80193 0.683084 9.68471C0.800312 9.56748 0.959309 9.50162 1.12509 9.50162Z\" fill=\"#1D0F25\"\/>\n<\/g>\n<\/svg>\n<\/span> <\/button>\n <\/div>\n <\/div>\n<\/article>\n","_links":{"self":[{"href":"https:\/\/www.elixirr.com\/en-gb\/wp-json\/wp\/v2\/case_study\/2162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.elixirr.com\/en-gb\/wp-json\/wp\/v2\/case_study"}],"about":[{"href":"https:\/\/www.elixirr.com\/en-gb\/wp-json\/wp\/v2\/types\/case_study"}],"author":[{"embeddable":true,"href":"https:\/\/www.elixirr.com\/en-gb\/wp-json\/wp\/v2\/users\/1"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.elixirr.com\/en-gb\/wp-json\/wp\/v2\/media\/55391"}],"wp:attachment":[{"href":"https:\/\/www.elixirr.com\/en-gb\/wp-json\/wp\/v2\/media?parent=2162"}],"wp:term":[{"taxonomy":"related_service","embeddable":true,"href":"https:\/\/www.elixirr.com\/en-gb\/wp-json\/wp\/v2\/related_service?post=2162"},{"taxonomy":"related_industry","embeddable":true,"href":"https:\/\/www.elixirr.com\/en-gb\/wp-json\/wp\/v2\/related_industry?post=2162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}