The Data Audit SWAT Team

A Squid data audit is often the first step in large scale projects.  In light of the wide variety and quality of data sets, customers are faced with the daunting task of building an inventory of what they have and testing what they know.

This is a job for the Squid Data Audit SWAT team!

The Squid team implements business rules specific to each customer’s activity to build a synthetic view of what can be done with the (data) resources at hand. This includes:
  • Data quality audit: are data fit for analysis?
  • Business rule audit: do business rules in place adequately describe your activity?
  • Performance audit: how to explain variations in usage of your service?

Start small and think BIG

With all the buzz around Big Data, Squid believes that a data audit is often the best way to get your hands on a data project. And nobody does it better than Squid!

Back to Top

Data Plumbing

Data Reconciliation

Large-businesses tend to have complex data sets stored in multiple formats across many divisions. In the case of Groups which manage brand portfolios, data sets extend across markets, product lines, consumer segments and geographic regions. Reconciling data sources from online sources and back-office databases is therefore a very big part of Big Data.  This is Data Plumbing.

Multidimensional Data Modeling

Squid integrates & reconciles massive volumes of data into its DMP. Squid’s technology and operational expertise enable it to quickly consolidate, cross analyze & aggregate these data in a multi-dimensional data model.  As a result, the DMP provides:

  • a 360 view of business activity through dashboards
  • as well as ready-to-use raw data for advanced analytics.

Dataprocessing Run

Squid automates the data processing tasks that take place within the DMP. This includes the Data Plumbing and Analytics tasks. For instance:

  • Squid automatically runs an entire predictive modeling process to create forecasts on a daily basis
  • Squid automatically joins back-office databases with online tracker feeds to update dashboards in near real-time

Data plumbers rarely speak to standing-room-only audiences at industry events but, when you need one, you want the best….Squid!

Back to Top

Session-Level Analytics

Squid collects data at session level and stores them for 2 years. Keeping granular data for advanced usage analysis such as:

  • Identifying top usage drivers on a website
  • Evaluating the impact of a product release or an external event (like a change in Google search algorithm) on usage
  • Usage forecasting
  • Understanding correlations in the data

The Squid Services team will help you by:

  • performing the analysis
  • setting up dashboards that you can use to monitor KPIs and download data.

 

Back to Top

Cookie-Level Analytics

Using session-level data, Squid also provides a machine cookie-centric datamodel for analytics and targeted marketing purposes.

User behavior analysis

Squid’s Services team automates analytical processes in the Squid DMP to provide insight such as:

  • Cohort analysis: follow a group of cookies to monitor their usage over time
  • Segmentation: create groups of cookies based on usage categories
  • Scoring: attribute a score to each cookie by applying a predictive model.

Cookie sync

If you want to manage your own cookie database via Squid’s DMP and leverage it through Real-Time Bidding on online Ad Exchanges, Squid can set up cookie synchronization with various DSP’s. Please contact us to know which ones we currently support.

 

Back to Top