Data Integration & Management

How Cassandra handles users’ data to deliver personalized Marketing Mix Models

In this page you will find:

What type of data do we get

First of all it is important to know that Cassandra does not gather any user-level data.All of the data we fetch, store and compute is aggregated

Check the following examples

Shopify
Fields we fetch from Shopify (or other CMSs in general):
Order Id
Order Created At (Order Date)
Processed At
Customer Id (Shopify’s numeric Id)
Order
Total Price
Order Fulfillment Status
Payment
Gateway
Shipping
Country
Laptop with Cassandra Platform
2
Seamless Integrations
Cassandra connects directly to your Marketing Data Sources or Data Warehouse.

Otherwise just upload a CSV
Start for Free
Laptop with Cassandra Platform
Google Analytics
Fields we fetch from Google Analytics (or other analytics’ platforms in general):
Date
Country,
Region & City
Source & MediumNumber of Sessions
Conversions
Revenue
Meta
Fields we fetch from Meta Ads (or other Ads Platforms in general):
Date
Campaign Id & NameCampaign Objective/Type
Country
Spend
Impressions
Clicks
Attributed Conversions
Attributed Revenue
Laptop with Cassandra Platform
2
Seamless Integrations
Cassandra connects directly to your Marketing Data Sources or Data Warehouse.

Otherwise just upload a CSV
Start for Free

Cassandra Data Infrastructure

Step #1 – Fetching Data
Our current ETL Provider (that handles connections to the users’ platforms and download of the data) is Dataddo. Dataddo is compliant with the Highest Security Standards including SOC2 Type II and GDPR, full documentation can be found here: link to Dataddo’s Security Documentation.

Step #2 – Centralizing & Aggregating the Data
All of the data we download from Dataddo get centralized in Google BigQuery.
The data is queried and modified by Cassandra through Google’s Official Python APIs.

Step #3 – Modeling your Data
Once a Model Training is started the data get uploaded to a dedicated Virtual Machine instance in Scaleway. Being one of the main European’s Cloud Provider, like Dataddo, their are certified upon the main standards: full Documentation here.

The data is uploaded to the Virtual Machines through encrypted SSH Tunnels between Cassandra’s Server & the Virtual Machine itself.
As soon as the training completes, all the data and outputs are downloaded to Cassandra’s servers and removed from the Virtual Machine which is then turned off.

Step #4 – Cassandra’s Platform
The platform itself is deployed on AWS, following the AWS Well Architected Framework, including VPCs, Load Balancers, Encryption of the Data and such.

Tech infrastructure of Cassandra