{"id":229,"date":"2021-11-16T18:07:28","date_gmt":"2021-11-16T15:07:28","guid":{"rendered":"https:\/\/quecst.qcri.org\/blog\/?p=229"},"modified":"2021-11-21T09:41:37","modified_gmt":"2021-11-21T06:41:37","slug":"silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns","status":"publish","type":"post","link":"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/","title":{"rendered":"SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns"},"content":{"rendered":"<figure id=\"attachment_230\" aria-describedby=\"caption-attachment-230\" style=\"width: 870px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-230\" src=\"https:\/\/quecst.qcri.org\/blog\/wp-content\/uploads\/2021\/11\/silos.jpg\" alt=\"\u00a0SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns\" width=\"870\" height=\"500\" srcset=\"https:\/\/acua.qcri.org\/blog\/wp-content\/uploads\/2021\/11\/silos.jpg 870w, https:\/\/acua.qcri.org\/blog\/wp-content\/uploads\/2021\/11\/silos-300x172.jpg 300w, https:\/\/acua.qcri.org\/blog\/wp-content\/uploads\/2021\/11\/silos-768x441.jpg 768w\" sizes=\"(max-width: 870px) 100vw, 870px\" \/><figcaption id=\"caption-attachment-230\" class=\"wp-caption-text\"><a href=\"http:\/\/www.bernardjjansen.com\/uploads\/2\/4\/1\/8\/24188166\/01_idsta2021_rc_03.pdf\" target=\"_blank\" rel=\"noopener\">SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns<\/a><\/figcaption><\/figure>\n<p>Data silo problem refers to related datasets located in different databases, systems, or files. In the case of online advertising, performance metrics are fragmented in different campaigns and ad sets, making it difficult to compare customer segments.<\/p>\n<p>In this research, we present SiloSolver, an algorithm that:<\/p>\n<ul>\n<li>(a) retrieves performance metrics for different customer segments across all campaigns,<\/li>\n<li>(b) aggregates the values for each customer segment in mean values, and<\/li>\n<li>(c) runs a statistical comparison (Student\u2019s t-test) on the performance differences between the segments.<\/li>\n<\/ul>\n<p>The algorithm is evaluated using a real Facebook Ads dataset from an e-commerce company consisting of hundreds of campaigns from over five years.<\/p>\n<p>Using SiloSolver, advertisers using Facebook Ads are better able to understand their market segments across multiple seemingly disparate campaigns.<\/p>\n<p>Salminen, J., Salenius, T., and\u00a0Jansen. B. J.\u00a0(2021)\u00a0<a href=\"http:\/\/www.bernardjjansen.com\/uploads\/2\/4\/1\/8\/24188166\/01_idsta2021_rc_03.pdf\" target=\"_blank\" rel=\"noopener\">SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns<\/a>. The International Conference on Intelligent Data Science Technologies and Applications (IDSTA2021), 15-17 November. Tartu, Estonia. p. 1-5.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data silo problem refers to related datasets located in different databases, systems, or files. In the case of online advertising, performance metrics are fragmented in different campaigns and ad sets, making it difficult to compare customer segments. In this research, we present SiloSolver, an algorithm that: (a) retrieves performance metrics for different customer segments across&hellip; <a class=\"more-link\" href=\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/\">Continue reading <span class=\"screen-reader-text\">SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,33,41],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns - Team Acua<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns - Team Acua\" \/>\n<meta property=\"og:description\" content=\"Data silo problem refers to related datasets located in different databases, systems, or files. In the case of online advertising, performance metrics are fragmented in different campaigns and ad sets, making it difficult to compare customer segments. In this research, we present SiloSolver, an algorithm that: (a) retrieves performance metrics for different customer segments across&hellip; Continue reading SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns\" \/>\n<meta property=\"og:url\" content=\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/\" \/>\n<meta property=\"og:site_name\" content=\"Team Acua\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-16T15:07:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-21T06:41:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quecst.qcri.org\/blog\/wp-content\/uploads\/2021\/11\/silos.jpg\" \/>\n<meta name=\"author\" content=\"Jim Jansen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jim Jansen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/\"},\"author\":{\"name\":\"Jim Jansen\",\"@id\":\"https:\/\/acua.qcri.org\/blog\/#\/schema\/person\/e3bb7a0b58349e548e8940716694c215\"},\"headline\":\"SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns\",\"datePublished\":\"2021-11-16T15:07:28+00:00\",\"dateModified\":\"2021-11-21T06:41:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/\"},\"wordCount\":191,\"publisher\":{\"@id\":\"https:\/\/acua.qcri.org\/blog\/#organization\"},\"articleSection\":[\"CRM\",\"Customer Lifetime Value\",\"Value-Based Segmentation\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/\",\"url\":\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/\",\"name\":\"SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns - Team Acua\",\"isPartOf\":{\"@id\":\"https:\/\/acua.qcri.org\/blog\/#website\"},\"datePublished\":\"2021-11-16T15:07:28+00:00\",\"dateModified\":\"2021-11-21T06:41:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/acua.qcri.org\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/acua.qcri.org\/blog\/#website\",\"url\":\"https:\/\/acua.qcri.org\/blog\/\",\"name\":\"Team Acua\",\"description\":\"Audience, Customer, and User Analytics\",\"publisher\":{\"@id\":\"https:\/\/acua.qcri.org\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/acua.qcri.org\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/acua.qcri.org\/blog\/#organization\",\"name\":\"Team Acua\",\"url\":\"https:\/\/acua.qcri.org\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/acua.qcri.org\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/acua.qcri.org\/blog\/wp-content\/uploads\/2022\/10\/cropped-cropped-logo.png\",\"contentUrl\":\"https:\/\/acua.qcri.org\/blog\/wp-content\/uploads\/2022\/10\/cropped-cropped-logo.png\",\"width\":1466,\"height\":770,\"caption\":\"Team Acua\"},\"image\":{\"@id\":\"https:\/\/acua.qcri.org\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/acua.qcri.org\/blog\/#\/schema\/person\/e3bb7a0b58349e548e8940716694c215\",\"name\":\"Jim Jansen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/acua.qcri.org\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4f97370631247bb1aed9a897d658981?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4f97370631247bb1aed9a897d658981?s=96&d=mm&r=g\",\"caption\":\"Jim Jansen\"},\"sameAs\":[\"https:\/\/quecst.qcri.org\/blog\"],\"url\":\"https:\/\/acua.qcri.org\/blog\/author\/jjansenacm-org\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns - Team Acua","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:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/","og_locale":"en_US","og_type":"article","og_title":"SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns - Team Acua","og_description":"Data silo problem refers to related datasets located in different databases, systems, or files. In the case of online advertising, performance metrics are fragmented in different campaigns and ad sets, making it difficult to compare customer segments. In this research, we present SiloSolver, an algorithm that: (a) retrieves performance metrics for different customer segments across&hellip; Continue reading SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns","og_url":"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/","og_site_name":"Team Acua","article_published_time":"2021-11-16T15:07:28+00:00","article_modified_time":"2021-11-21T06:41:37+00:00","og_image":[{"url":"https:\/\/quecst.qcri.org\/blog\/wp-content\/uploads\/2021\/11\/silos.jpg"}],"author":"Jim Jansen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jim Jansen","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/#article","isPartOf":{"@id":"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/"},"author":{"name":"Jim Jansen","@id":"https:\/\/acua.qcri.org\/blog\/#\/schema\/person\/e3bb7a0b58349e548e8940716694c215"},"headline":"SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns","datePublished":"2021-11-16T15:07:28+00:00","dateModified":"2021-11-21T06:41:37+00:00","mainEntityOfPage":{"@id":"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/"},"wordCount":191,"publisher":{"@id":"https:\/\/acua.qcri.org\/blog\/#organization"},"articleSection":["CRM","Customer Lifetime Value","Value-Based Segmentation"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/","url":"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/","name":"SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns - Team Acua","isPartOf":{"@id":"https:\/\/acua.qcri.org\/blog\/#website"},"datePublished":"2021-11-16T15:07:28+00:00","dateModified":"2021-11-21T06:41:37+00:00","breadcrumb":{"@id":"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/acua.qcri.org\/blog\/silosolver-algorithm-for-aggregating-siloed-customer-segments-in-facebook-ads-campaigns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/acua.qcri.org\/blog\/"},{"@type":"ListItem","position":2,"name":"SiloSolver: Algorithm for Aggregating Siloed Customer Segments in Facebook Ads Campaigns"}]},{"@type":"WebSite","@id":"https:\/\/acua.qcri.org\/blog\/#website","url":"https:\/\/acua.qcri.org\/blog\/","name":"Team Acua","description":"Audience, Customer, and User Analytics","publisher":{"@id":"https:\/\/acua.qcri.org\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/acua.qcri.org\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/acua.qcri.org\/blog\/#organization","name":"Team Acua","url":"https:\/\/acua.qcri.org\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/acua.qcri.org\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/acua.qcri.org\/blog\/wp-content\/uploads\/2022\/10\/cropped-cropped-logo.png","contentUrl":"https:\/\/acua.qcri.org\/blog\/wp-content\/uploads\/2022\/10\/cropped-cropped-logo.png","width":1466,"height":770,"caption":"Team Acua"},"image":{"@id":"https:\/\/acua.qcri.org\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/acua.qcri.org\/blog\/#\/schema\/person\/e3bb7a0b58349e548e8940716694c215","name":"Jim Jansen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/acua.qcri.org\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4f97370631247bb1aed9a897d658981?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4f97370631247bb1aed9a897d658981?s=96&d=mm&r=g","caption":"Jim Jansen"},"sameAs":["https:\/\/quecst.qcri.org\/blog"],"url":"https:\/\/acua.qcri.org\/blog\/author\/jjansenacm-org\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/acua.qcri.org\/blog\/wp-json\/wp\/v2\/posts\/229"}],"collection":[{"href":"https:\/\/acua.qcri.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/acua.qcri.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/acua.qcri.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/acua.qcri.org\/blog\/wp-json\/wp\/v2\/comments?post=229"}],"version-history":[{"count":2,"href":"https:\/\/acua.qcri.org\/blog\/wp-json\/wp\/v2\/posts\/229\/revisions"}],"predecessor-version":[{"id":232,"href":"https:\/\/acua.qcri.org\/blog\/wp-json\/wp\/v2\/posts\/229\/revisions\/232"}],"wp:attachment":[{"href":"https:\/\/acua.qcri.org\/blog\/wp-json\/wp\/v2\/media?parent=229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/acua.qcri.org\/blog\/wp-json\/wp\/v2\/categories?post=229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/acua.qcri.org\/blog\/wp-json\/wp\/v2\/tags?post=229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}