US based media solutions provider improves time to market using intelligent business system.
Client
Client is one of the most successful advertising agency
Industry
Media & Advertising
The Client
Client is a full-service brand response advertising agency, specializing in strategic planning, creative development, media planning, buying and analytics, for integrated cross channel marketing campaigns.
The Challenge
- Combine data from WAM (Web Attribution Modelling- Tech Microsoft) and TT (Time Track Tech – Progress) into EDW.
- Complex Analysis Methodology used in TT and WAM.
- Huge Amount of Data ( in TBs).
- Handling different type of Log PRE, POST, AFF, BVS for Direct/Indirect Attribution/Unattributed Web Response/ Unattributed Phone Response.
The Solution
JKT has provided a SSIS based solution to meet Business Objectives
- Created Package which call .Net Code to pull data from Time Track (Progress) system in Batch and Pull data from WAM System. This System hold data about Attribution run for an Airing and Flight.
- Created ETL Solution to populate EDW.
- This EDW work as a Business Intelligence System which includes the data of Buying, Postlogs, Impressions, TRPs, Direct Attributed Responses, Indirect Attributed Responses, Unattributed Web Responses and Unattributed Phone Responses.