Creating a Merchant Campaign Item Selector For A Client In The Retail Space

Creating a Merchant Campaign Item Selector For A Client In The Retail Space

the background

We were tasked with creating an MCIS (Merchant Campaign Item Selector) that would let users create a price and items list for advertising vehicles on our client’s website. The MCIS was designed to be integrated into the existing databases to facilitate the import and export of data. The primary purpose of this data was to create lists that different teams could use to run ads.

services provided

  • Digital Strategy
  • Responsive Design
  • Visual Design

the challenge

Our team put together the following tech stack to create a solution that worked best against the mandate that we got:

  1. PHP, Laravel for Backend development
  2. HTML, CSS, Angular for Frontend development
  3. MySQL, InnoDB, Elastic Search(Solr, Query) for Database Management
  4. Microsoft Azure for DevOps
  5. Kong API Gateway, Kibana, Load Balancer for ancillary functionality
  6. Secondary Integrations: Share API, OneOps SSO, Walmart Teradata, Looper, AG Grid, Quality Score, Aprimo

The initial challenge that our client faced was to create events for campaigns they wanted to run, owing to the number of SKUs that they wanted to offer as part of those campaigns. It was difficult for them to provide all the details of all the items in one campaign. They needed an app to help them navigate this challenge.

the approach

Our team started building the aforementioned MCIS so that our clients could manage their campaigns and the items that they wanted to offer in those campaigns.

We integrated our client’s campaign list with the MCIS by sourcing Aprimo, which is a project management tool. To secure the MCIS, we hosted it in a OneOps environment.

All of our client’s employees were given access to the MCIS so that they may be able to update details such as price and upcoming events. The employees could create an excel-sheet like items list, which can also be used to add campaigns, to facilitate easy collaboration with the client’s existing marketing team.

our observations

Once our client had access to all items that they wanted to offer as part of their campaigns, alongwith the history of all previous items they’ve offered as part of past campaigns, it became easier for them to decide what items to offer and how many of those items would sell, based on past campaigns. With the integration of a Quality Score API, we also helped them rank each item based on its popularity during past campaigns.

Our other works