{"id":956,"date":"2026-01-20T17:08:36","date_gmt":"2026-01-20T16:08:36","guid":{"rendered":"https:\/\/project.revolware.com\/case-studies\/?p=956"},"modified":"2026-01-30T17:06:31","modified_gmt":"2026-01-30T16:06:31","slug":"c-sunshine-mailing-system","status":"publish","type":"post","link":"https:\/\/project.revolware.com\/case-studies\/c-sunshine-mailing-system\/","title":{"rendered":"C-Sunshine&#8217;s outreach system supporting expansion"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Context<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.c-sunshine.com\/\"><strong>C-Sunshine<\/strong><\/a> is a <strong>software company<\/strong> specializing in custom e-commerce solutions, development capacity outsourcing, data analytics, and full-stack engineering. As part of their own growth and ongoing business development activities, they needed a<strong> fully self-hosted mailing system<\/strong> running on a <strong>dedicated internal mail server<\/strong>, without relying on external SaaS tools. The primary goal was to retain full ownership and control over contact data and interaction data, while still being able to measure and analyze email-driven behavior using standard analytics tools.<\/p>\n\n\n\n<p>The system was designed primarily for <strong>internal and B2B communication, supporting sales and partnership outreach<\/strong> where transparency, data control, and simplicity were more important than complex marketing automation features. Given C-Sunshine\u2019s technical focus and emphasis on data-driven decision-making, the solution had to be reliable, auditable, and easily extensible within their existing technical ecosystem.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Challenge<\/h2>\n\n\n\n<p>The main challenge was to design a solution that would:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Provide <strong>email delivery from a dedicated internal mail server<\/strong><\/li>\n\n\n\n<li>Create a <strong>structured data layer<\/strong> for contacts (email, address, city, country, ZIP code)<\/li>\n\n\n\n<li>Track <strong>individual recipient interactions<\/strong> via unique links<\/li>\n\n\n\n<li>Store detailed metadata for each interaction (timestamp, IP address, device type, browser)<\/li>\n\n\n\n<li>Enable integration with <strong>Google Tag Manager<\/strong> and <strong>Google Analytics<\/strong><\/li>\n\n\n\n<li>Remain <strong>minimalistic<\/strong>, easy to maintain, and free of unnecessary complexity<\/li>\n<\/ul>\n\n\n\n<p>A key constraint was that <strong>no customer or interaction data should be deleted<\/strong>, and the system should avoid over-engineering.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"307\" src=\"https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/ChatGPT-Image-20.-1.-2026-17_00_07-2-1024x307.png\" alt=\"\" class=\"wp-image-963\" srcset=\"https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/ChatGPT-Image-20.-1.-2026-17_00_07-2-1024x307.png 1024w, https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/ChatGPT-Image-20.-1.-2026-17_00_07-2-300x90.png 300w, https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/ChatGPT-Image-20.-1.-2026-17_00_07-2-768x230.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><em>Mail system architecture scheme<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Solution<\/h2>\n\n\n\n<p>We designed and implemented a <strong>custom mailing system<\/strong> composed of three tightly connected layers: infrastructure, backend &amp; data, and analytics.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Mailing Infrastructure<\/strong><\/h3>\n\n\n\n<p>Emails are sent from a <strong>dedicated internal mail server<\/strong>. Each email contains <strong>tracking links with unique tokens<\/strong>, allowing precise identification of recipients and their interactions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Backend &amp; Data Layer<\/strong><\/h3>\n\n\n\n<p>A lightweight PHP backend (Laravel\/Nette-compatible) was built on top of a <strong>PostgreSQL database<\/strong>.<\/p>\n\n\n\n<p>The database structure includes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Customer table<\/strong>\n<ul class=\"wp-block-list\">\n<li>Email address and basic identification data<\/li>\n\n\n\n<li>Two unique tokens generated per customer and appended to email links<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Entry table<\/strong>\n<ul class=\"wp-block-list\">\n<li>Records every link click<\/li>\n\n\n\n<li>Stores timestamp, customer ID, token used<\/li>\n\n\n\n<li>Captures IP address, device type, and browser information from HTTP headers<\/li>\n\n\n\n<li>Supports repeated clicks without artificial limits<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>The admin interface allows:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Viewing and managing customers<\/li>\n\n\n\n<li>Adding individual customers manually<\/li>\n\n\n\n<li>Bulk importing customers from CSV files<\/li>\n\n\n\n<li>Inspecting interaction data per customer<\/li>\n<\/ul>\n\n\n\n<p>No deletion logic or complex workflows were introduced, keeping the system intentionally simple and robust. Mail server hosting was established using WebSupport, while adopting open source interface Roundcube on top.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"1080\" src=\"https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/C-Sunshine_Screenshot-1-1.png\" alt=\"\" class=\"wp-image-967\" srcset=\"https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/C-Sunshine_Screenshot-1-1.png 1920w, https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/C-Sunshine_Screenshot-1-1-300x169.png 300w, https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/C-Sunshine_Screenshot-1-1-1024x576.png 1024w, https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/C-Sunshine_Screenshot-1-1-768x432.png 768w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><em>Preview of mail system deployed into production<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Analytics integration<\/h2>\n\n\n\n<p>Each tracked interaction is forwarded from the backend to <strong>Google Tag Manager<\/strong>, which then propagates events into <strong>Google Analytics<\/strong>. This enables correlation between:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Email interactions<\/li>\n\n\n\n<li>Website behavior<\/li>\n\n\n\n<li>Device and location data<\/li>\n<\/ul>\n\n\n\n<p>As a result, email performance can be analyzed directly within the existing analytics stack used by C-Sunshine.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Client reference<\/h2>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-text-align-right\"><a href=\"https:\/\/www.facebook.com\/plugins\/post.php?href=https%3A%2F%2Fwww.facebook.com%2Fjozef.szadvari%2Fposts%2Fpfbid034nEMEZ7qnhKGXJLPpkAv5Th6vZFdNibJjeziuMVYiNVGmoWvArzgtqBNfkJw9TmWl&amp;show_text=true&amp;width=500\" data-type=\"link\" data-id=\"https:\/\/www.facebook.com\/plugins\/post.php?href=https%3A%2F%2Fwww.facebook.com%2Fjozef.szadvari%2Fposts%2Fpfbid034nEMEZ7qnhKGXJLPpkAv5Th6vZFdNibJjeziuMVYiNVGmoWvArzgtqBNfkJw9TmWl&amp;show_text=true&amp;width=500\">Great team to work with. Highly professional. They genuinely love what they do, and it shows in the quality of their work.<\/a><br>&#8211; <strong>Jozef Szadvari<\/strong>, CEO at C-Sunshine<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"341\" src=\"https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/image-20-1024x341.png\" alt=\"\" class=\"wp-image-1218\" srcset=\"https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/image-20-1024x341.png 1024w, https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/image-20-300x100.png 300w, https:\/\/project.revolware.com\/case-studies\/wp-content\/uploads\/sites\/3\/2026\/01\/image-20-768x256.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><sup>Reference from Jozef Szadvari, CEO at C-Sunshine about skills of Martin Hrabovec, Revolware&#8217;s CEO<\/sup><\/figcaption><\/figure><\/div><\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">Automation of client business development<\/h2>\n\n\n\n<p>Following the successful delivery of the mailing system, our cooperation with C-Sunshine <strong>naturally expanded into their sales and business development operations<\/strong>. The solution became an integral part of their internal workflow and has been actively used by our own team as well, allowing us to directly experience, refine, and optimize the system in real-world sales scenarios. Over the years, we have continued to support C-Sunshine<strong> by automating business development outreach,<\/strong> <strong>streamlining sales processes, and helping identify new revenue opportunities.<\/strong> What began as a technical implementation evolved into a long-term partnership focused on scalable sales growth, data-driven decision-making, and continuous improvement of their commercial operations.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Looking for a similar solution?<\/h3>\n\n\n\n<p>We\u2019re happy to help you design and build a tailored system that fits your technical and business needs. Fill out the <strong><a href=\"https:\/\/revolware.com\/#contact\">form <\/a><\/strong><a href=\"https:\/\/revolware.com\/#contact\" data-type=\"link\" data-id=\"https:\/\/revolware.com\/#contact\"><strong>here<\/strong><\/a>, and we&#8217;ll get back to you soon!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Context C-Sunshine is a software company specializing in custom e-commerce solutions, development capacity outsourcing, data analytics, and full-stack engineering. As part of their own growth and ongoing business development activities, they needed a fully self-hosted mailing system running on a dedicated internal mail server, without relying on external SaaS tools. The primary goal was to [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":974,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[5,16],"class_list":["post-956","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-software-development","tag-web-development"],"_links":{"self":[{"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/posts\/956","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/comments?post=956"}],"version-history":[{"count":20,"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/posts\/956\/revisions"}],"predecessor-version":[{"id":1221,"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/posts\/956\/revisions\/1221"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/media\/974"}],"wp:attachment":[{"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/media?parent=956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/categories?post=956"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/project.revolware.com\/case-studies\/wp-json\/wp\/v2\/tags?post=956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}