Microsoft: Tropics V2 Campaign Management System

Client

Microsoft

Industry

Software products

Technologies

ASP.NET, SQL Server, Access

Overview

Project highlights

Two systems into oneTropics V2 replaced both older campaign systems.
Hundreds of usersOne ASP.NET application and SQL Server database for everyone.
Smart validationRules change with campaign type, owning group, and life-cycle stage.
At-a-glance tabsTab labels show how many detail records each tab holds.

Before

The challenge

Microsoft's Business Management Operations (BMO) team was running two older marketing-campaign systems and needed to consolidate them into one.

The new system would serve hundreds of users, and its validation rules had to vary based on each campaign's type, the group that owns it, and the campaign's stage in its life cycle.

After

What we built

J Street designed and developed Tropics V2, a web-based system to manage marketing campaigns that replaced both older systems and consolidated their functionality in one ASP.NET web application and SQL Server database.

The home page gives users a quick look at news and alerts and lets them quickly sort and select the campaigns they work with. Each campaign has several tabs of information, with dynamic tab labels that show how many detail records are underneath. The data validation logic behind these pages was very challenging, with rules that change by campaign type, owning group, and life-cycle stage.

The complex project spanned thousands of hours of requirements, design, construction, data conversion, testing, and deployment, with stakeholders across many teams.

Inside the system

A closer look

News, alerts, and campaigns

The home page gives the user a quick look at news and alerts, and allows them to quickly sort and select campaigns to work with.

Campaign detail tabs

Each marketing campaign has several tabs of information, with dynamic tab descriptions indicating the number of underlying detail records. The data validation logic for these pages was very challenging, with validation rules varying based on the type of campaign, the group owning the campaign, and stage of the campaign in its life cycle.

“

The outcome

How it turned out

One system for managing marketing campaigns instead of two.
Supports hundreds of users.
Delivered through thousands of hours of requirements, design, construction, data conversion, testing, and deployment.
Built in collaboration with stakeholders across many teams.

See more of our work for software product companies.