CLIQ required an efficient process to monitor and optimize their digital activities in the competitive world of online advertising. Creating a real-time dashboard that consolidated data from various sources with inconsistent granularity, metrics, and time zones, was necessary. 

CLIQ’s BI department utilized Matillion to collect data from their tracking systems and multiple DSP’s. Processing is completed every 15 minutes and aggregation of data is done hourly. Using Matillion has refreshed a Tableau dashboard displaying key metrics and identifying anomalies, empowering the digital marketing team to proactively manage their campaigns. 

• CLIQ achieved a holistic view of their advertising funnel, tracking banner clicks, DSP advertising costs, leads, opt-ins, and more. Allowing to monitor the entire customer journey from banner click to a successful user registration. 
• Displaying essential metrics such as banner clicks, leads,opt-in, and advertising costs on the dashboard provided insights into relationships between metrics, aiding in campaign optimization.
• Hourly graphs with reference bands highlighted normal behaviors, enabled quick identification of unusual trends or issues