Our Mission
About us
Quick & Simple
What you need
The more pre-requisites are already available in your organization the better. But don’t worry. We can help you with everything.
Ideally you have:
Desktop
Microsoft Surface
Joanne uses this Device at work
Smartphone
Apple iPhone 15
Joanne uses this device daily especially for Social Media
Smart TV
Sony Bravia
Joanne likes to watch TV in the evening while doing other things
Tablet
iPad Pro 3
Joanne uses her tablet especially when traveling
Laptop
HP Elitebook
Joanne has a private Laptop that she uses at home
Google Analytics 4 is an advanced web and app analytics platform that provides insights into user behavior and engagement across digital properties
SQL (Structured Query Language) is a standardized programming language used for managing and manipulating relational databases
BigQuery is a serverless, highly scalable data warehouse offered by Google Cloud that enables super-fast SQL queries and interactive analysis of large datasets
Google Dataform is a collaborative data modeling tool that helps teams manage and transform data in BigQuery efficiently
Apache Airflow is an open-source platform for orchestrating, scheduling, and monitoring complex workflows, allowing users to automate tasks
Looker Studio is a data visualization and reporting tool that allows users to create interactive dashboards and explore data from various sources in real-time
Tools & Services
How it works
The tools that we are offering are SQL based and tool agnostic. This means that you will be able to deploy the SQL statements where you need them, at your Cloud Data Provider or at your On Premise Infrastructure. The statements are currently optimized to work with Big Data in Google Cloud BigQuery. The free package includes demo data for the profile of Joanne which is based on standard CRM Identifiers aswell as commonly used Cookie Identifiers with Google Analytics 4. Reporting is built with Looker Studio that connects to tables generated in Google Cloud BigQuery.
Create lists of
Input Edges
An edge represents the connection between two different IDs of different types. They can be based on cookie signals, CRM data, payment data, etc. They can be deterministic or probabilistic
Learn more
Clean Input Data
The list of Input Edges might need to be transformed to make sure data is consistent and the naming of ID types is streamlined. Data records that do not satisfy defined requirements might need to be removed before the modelling starts.
Learn more
Create an
ID Dictionary
The ID Dictionary retrieves data of the list of input edges and defines a numeric value for each unique ID value that will be computed. The ID Dictionary helps with Integer Encoding of the String Values in the List of Edges.
Learn more
Create the
Edges Main Tables
The edges main table holds the integer encoded list of input edges and is the source table for the graph modelling algorithm. Multiple edges main tables might be relevant depending on your data structure.
Learn more
Anomaly Detection
Our solution helps to connect user specific identifiers to the profile of a person. To make sure that no IDs that represent a group of individuals are used in the Data Modelling process, our Anomaly Detection helps to find suspicious IDs and excludes them.
Learn more
Complex
Deduplication
This represents the mechanism that connects the edges with each other and forms a unique profile. The process runs in iterations and joins the edges until no more edge can be found that can be found that could be merged.
Learn more
ID Graph
Results
After the complex deduplication the Integer Encoded Edges are converted to Value based Edges. The results are saved as a flat for faster querying and also as a nested table for better readability.
Learn more
Edges Main Table & Complex Deduplication
The Data Transformation
The Edges Main Table loads the integer encoded edges that will be used in the graph modelling process. Feel free to use the buttons to see step by step how the core functionalities of our solution work.
| timestamp | int 1 | int 2 | edge id | group id | # of edges | edge source | country | z score | anomaly |
|---|---|---|---|---|---|---|---|---|---|
| 2024-06-22T11:44:21 | 41 | 43 | 3838474483911267041 | Online Registration | US | ||||
| 2024-06-22T11:44:21 | 41 | 20 | -8662941687709176414 | Online Registration | US | ||||
| 2024-09-30T08:35:00 | 19 | 41 | 8442466952663002838 | Offline Registration | US | ||||
| 2024-09-30T08:35:00 | 20 | 41 | -8662941687709176414 | Offline Registration | US | ||||
| 2024-09-30T08:35:00 | 41 | 19 | 8442466952663002838 | Offline Registration | US | ||||
| 2024-10-31T10:05:34 | 43 | 41 | 3838474483911267041 | Progressive Profiling | US | ||||
| 2024-11-01T09:35:21 | 19 | 1 | 5153311434518392276 | Progressive Profiling | US | ||||
| 2024-12-20T08:21:30 | 20 | 3 | -1587548660121875313 | Progressive Profiling | US |
| insertion_time | i | updates | start timestamp |
|---|---|---|---|
Check out our free starter pack
USER INTERFACES
The Customer Profile
The Customer Profile View helps you to look up the IDs, Devices, Consent Status and Activity Stream of an individual person. Those interactions can include all types of events that are relevant to track for a business incl. online product interactions, customer service request, online ad impressions, offline & online product purchases, etc. The report can be further filtered to just analyze the activity of a specific device owned by the customer.
Identifiers
All unique identifiers that were assigned to the profile
Consent Status
Consolidates different Consent Types tracked across different Channels
Activity Stream
Lists all events that are tracked across different customer touchpoints
Devices
Lists all devices that are connected to the profile
Connection Strength
Shows the connection strength between the profile and the device
Reporting Flow
The reporting flow analysis data trends per table and per processing step and saves the data for the Looker Report.
Graph Modelling
The Graph Modelling Flow merges data from source tables into the input tables for the modelling and executes the steps until the final User ID Graph is created.
Data Management
The Orchestration
The deployment of an orchestration pipeline for the describes SQL statements can be done in different ways. A simple and Google Cloud native approach is to use Dataform. The system helps to manage the dependencies and scheduling of processing tasks in an easy to use interface.
Our USP for the Small & Medium Companies
Simple setup that helps to get started
Companies tend to believe that licensing a customer data platform is going to fix the issues they have trying to understand customer profiles and customer journeys holistically. Unfortunately, even though some Customer Data Platform vendors might tell you this is the case, it is actually not.
We believe the smart approach is doing things step by step:
Our USP for Enterprises
Pre-compute & reduce CDP license costs
Customer Data Platforms tend to be expensive as their license fees are usually based on the amount of data that is loaded into their SaaS platforms. Identity Graph helps you business to become more efficient by filtering the data that is actually relevant before loading everything into your Customer Data Platform.
We help you by:
Business Collaboration
"Do it yourself"
Identity Graph Starter Package
€59€0/ lifetime
- Data Preparation: List of Input Edges, User ID Dictionary, Integer Encoding of User Ids
- ID Graph Modelling: Edges Main Table & Complex Deduplication
- Results: Flat Results Schema & Nested Results Schema
Popular
"Do it yourself"
Advanced Orchestration
with Dataform
€99/ lifetime
- Dataform: Automatic Graph Orchestration Environment Configuration Variables & Automatic Scheduling
- Alerting: Notification Emails & Automatic Retry
- Data Monitoring: Tech Monitoring for Data Quality Management & User Profile Search Interface
Coming
Standard Package
Data Foundation Consulting
custom
- Exploration: Understanding the current data foundation & identifying issues
- Roadmap: Developing an action plan to establish the data foundation for success
- Implementation support: Regular alignment meetings and support calls
