Efficient production of marketing emails
Jotex is one of Swedens largest e-commerce websites for household linen and interior design. The company was founded 1963 and is now a part of the larger Ellos Group organization.
When I was working at Jotex, one of my tasks were to help the team create marketing e-mails on a weekly basis. A lot of that work was manual, which pushed me to create an application that would automate a lot of that work for us.
Jotex had its product catalog translated to several different markets. This meant that when an employee created a campaign for all those markets, they had to go to each website and copy the product names, prices and labels and paste that data into Photoshop to create a mockup.
The mockup was then printed out and presented to the marketing director for approval. Upon approval, the employee would move on to create the actual e-mail (following the mockup design) in the marketing application.
Depending on how large the campaign was (which often correlated with the number of products), it was fairly common that it took the employee atleast 8 hours to to have a mockup for presentation.
By utilizing the product SKUs we were able to crawl the website in all different languages, automatically fetch the necessary data and present them in an interface where the employee could copy and paste to the marketing application with the click of a button.
Product images were stitched together with the appropriate labels in all languages and thumbnails with correct size were generated and named following the internal naming conventions for download so that they quickly could be uploaded to the marketing application.
The employee was automatically notified when a product ran out of stock and needed to be switched out. When that happened, one could enter a new product SKU and the application would crawl the data again and generate the appropriate data.
A lot of the redundant work the employees did was no longer needed, which allowed for creation of marketing mails to be more effective.
Updated 2020-04-11, edited 126 times.