{"id":1533,"date":"2021-10-13T10:07:53","date_gmt":"2021-10-13T14:07:53","guid":{"rendered":"https:\/\/poiseddevelopers.com\/vertex-old\/?post_type=case_study&p=1533"},"modified":"2022-03-25T16:19:18","modified_gmt":"2022-03-25T20:19:18","slug":"ecommerce-promotion-analysis","status":"publish","type":"case_study","link":"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/","title":{"rendered":"Is Tracking Promotional Data a Pain Point?"},"content":{"rendered":"

CPG Manufacturer Finds Huge Promotion Efficiencies with Vertex-Designed Analytics Tool<\/h2>\n

\"company<\/p>\n

Problem and Background<\/strong><\/p>\n

Our client \u2013 a global leader in consumer-packaged goods \u2013 markets products across ten major categories, with countless subcategories and variations in packaging, size, fragrance, and so on. Like any large CPG manufacturer, they do a significant part of their business with the largest online retailers, making them an important part of their revenue mix. Promotions \u2013 such as online coupons, bundles, and other discounts \u2013 are often a necessary part of business to make their products stand out from those of their competitors.<\/p>\n

But what promotions? And when? And for how long? Furthermore, does a given product even NEED a promotion to sell well? These are the questions that our client was struggling to answer.<\/p>\n

They came to Vertex for a solution that would allow them to process and analyze the huge amounts of pricing and promotional data for their brands. Because they had been downloading data from the online retailer\u2019s promotional portal and trying to analyze it manually, they often missed out on revenue opportunities or spent promotional dollars on products that were already selling strong in the absence of a promotion.<\/p>\n

The Vertex Solution<\/strong><\/p>\n

While the project is still ongoing, Vertex was able to take the \u2018manual\u2019 processes being performed with Microsoft Excel and digitize them for greater accuracy and efficiency.<\/p>\n

Vertex created a phased set of data analytics<\/a> initiatives utilizing dotnet, an Azure SQL database & Web Server, and Microsoft Power BI to reduce inefficiencies and help the manufacturer to make the most of their promotional budget.<\/p>\n

The solution hinged on a digital transformation of the manufacturer\u2019s manually maintained Excel spreadsheets into a format that was easier to analyze and was not only compatible with the online retailer\u2019s portal but allowed the client to make in-flight management of promotions. With that phase of the project complete, product analysts are now able to do more informed decision-making about their promotions.<\/p>\n

The Results<\/strong><\/p>\n

With the first phase of the project already completed, our client has already realized efficiency gains and they look forward to the next phases of the project for even more capabilities.<\/p>\n

Where they previously relied on manual processing of data files, they now have automated processing of data, reducing errors and increasing productivity. Built-in help in Vertex\u2019s system helps to reduce data entry times and an easy & intuitive user interface has streamlined the entire business process for promotions, allowing more time to focus on analysis.<\/p>\n

Furthermore, where the client previously had to maintain multiple spreadsheets by product category, Vertex\u2019s solution has centralized all the data into a single database, making analytics and advanced reporting easier and more efficient.<\/p>\n

Who Can Use This?<\/strong><\/p>\n

While Vertex\u2019s solution to work with a major online retailer\u2019s promotional system was originally developed specifically for our Global CPG<\/a> client, the system would provide operational and analytical efficiencies to any supplier that is selling their products through the largest online marketplaces.<\/p>\n","protected":false},"excerpt":{"rendered":"

Tracking coupons, bundles, and other discounts is necessary to assess your promotion’s success. Learn about the solution we created for this CPG manufacturer that is far more accurate and efficient than the Excel spreadsheets they were using.<\/p>\n","protected":false},"featured_media":1536,"parent":0,"template":"","categories":[66,121,138],"acf":{"title_color":"black","is_a_flyer":false,"additional_information":"","title":"","case_study":[{"title":"CLIENT","description":"

A Global CPG Company<\/p>\n"},{"title":"THE PROBLEM","description":"

Our client was struggling to uncover inefficiencies in managing the effectiveness of their promotional programs with a major online retailer. With hundreds of thousands of SKUs being sold, there was simply too much data for the product teams assigned to that retailer to manage their promotional budgets. They were relying on Excel spreadsheets to track their promotions in the retailer\u2019s system and were not able to analyze if a given promotion was effective \u2013 or even necessary. This often meant that some sales team members just split up their promotion budget across all of their assigned products whether or not it made sense. <\/p>\n

While the retailer\u2019s promotions portal did offer some analytics capability, it did not provide the level of reporting or analysis that our client desired \u2013 nor did they have the time to do this type of analysis in Microsoft Excel.<\/p>\n

It is safe to say that some \u2018staple\u2019 products marketed by this manufacturer would sell at full price, yet it was all too easy to set a blanket discount because that was easier than analyzing sales performance. <\/p>\n"},{"title":"THE VERTEX SOLUTION","description":"

Vertex created a phased set of initiatives to reduce inefficiencies and help the manufacturer to make the most of their promotional budget. <\/p>\n

The solution hinged on a digital transformation of the manufacturer\u2019s manually maintained Excel spreadsheets into a format that was easier to analyze and was compatible with the online retailer\u2019s portal. With that phase of the project complete, product analysts are now able to do more informed decision making about their promotions. <\/p>\n"},{"title":"RESULTS","description":"

Because the product analysts were able to make more informed decisions about where to allocate their promotional dollars, they were able to simultaneously save on promotional costs for some products AND increase the sales on other products through the application of well-timed promotions. <\/p>\n"}]},"yoast_head":"\nEcommerce Promotion Analysis | A Closer Look at Coupon Data<\/title>\n<meta name=\"description\" content=\"Ecommerce promotion analysis is a huge pain point for many companies. Learn about the analytics solution we helped this CPG company implement!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ecommerce Promotion Analysis | A Closer Look at Coupon Data\" \/>\n<meta property=\"og:description\" content=\"Ecommerce promotion analysis is a huge pain point for many companies. Learn about the analytics solution we helped this CPG company implement!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/\" \/>\n<meta property=\"og:site_name\" content=\"Vertex Computer Systems\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-25T20:19:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ozb.8fe.myftpupload.com\/wp-content\/uploads\/2021\/10\/amazon-coupon-case-study-feature-image.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2160\" \/>\n\t<meta property=\"og:image:height\" content=\"853\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/\",\"url\":\"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/\",\"name\":\"Ecommerce Promotion Analysis | A Closer Look at Coupon Data\",\"isPartOf\":{\"@id\":\"https:\/\/poiseddevelopers.com\/vertex-old\/#website\"},\"datePublished\":\"2021-10-13T14:07:53+00:00\",\"dateModified\":\"2022-03-25T20:19:18+00:00\",\"description\":\"Ecommerce promotion analysis is a huge pain point for many companies. Learn about the analytics solution we helped this CPG company implement!\",\"breadcrumb\":{\"@id\":\"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Case Studies\",\"item\":\"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Is Tracking Promotional Data a Pain Point?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/poiseddevelopers.com\/vertex-old\/#website\",\"url\":\"https:\/\/poiseddevelopers.com\/vertex-old\/\",\"name\":\"Vertex Computer Systems\",\"description\":\"We Got IT.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/poiseddevelopers.com\/vertex-old\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Ecommerce Promotion Analysis | A Closer Look at Coupon Data","description":"Ecommerce promotion analysis is a huge pain point for many companies. Learn about the analytics solution we helped this CPG company implement!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Ecommerce Promotion Analysis | A Closer Look at Coupon Data","og_description":"Ecommerce promotion analysis is a huge pain point for many companies. Learn about the analytics solution we helped this CPG company implement!","og_url":"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/","og_site_name":"Vertex Computer Systems","article_modified_time":"2022-03-25T20:19:18+00:00","og_image":[{"width":2160,"height":853,"url":"https:\/\/ozb.8fe.myftpupload.com\/wp-content\/uploads\/2021\/10\/amazon-coupon-case-study-feature-image.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/","url":"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/","name":"Ecommerce Promotion Analysis | A Closer Look at Coupon Data","isPartOf":{"@id":"https:\/\/poiseddevelopers.com\/vertex-old\/#website"},"datePublished":"2021-10-13T14:07:53+00:00","dateModified":"2022-03-25T20:19:18+00:00","description":"Ecommerce promotion analysis is a huge pain point for many companies. Learn about the analytics solution we helped this CPG company implement!","breadcrumb":{"@id":"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/ecommerce-promotion-analysis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Case Studies","item":"https:\/\/poiseddevelopers.com\/vertex-old\/resources\/case-studies\/"},{"@type":"ListItem","position":2,"name":"Is Tracking Promotional Data a Pain Point?"}]},{"@type":"WebSite","@id":"https:\/\/poiseddevelopers.com\/vertex-old\/#website","url":"https:\/\/poiseddevelopers.com\/vertex-old\/","name":"Vertex Computer Systems","description":"We Got IT.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/poiseddevelopers.com\/vertex-old\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/vertex-old\/wp-json\/wp\/v2\/case_study\/1533"}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/vertex-old\/wp-json\/wp\/v2\/case_study"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/vertex-old\/wp-json\/wp\/v2\/types\/case_study"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/vertex-old\/wp-json\/wp\/v2\/media\/1536"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/vertex-old\/wp-json\/wp\/v2\/media?parent=1533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/vertex-old\/wp-json\/wp\/v2\/categories?post=1533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}