✅ Source ✅ Destination (beta)
Transfer data at scale between your data warehouse (Snowflake, Redshift, BigQuery...) and MadKudu through Amazon S3.
What does this integration do?
Amazon Simple Storage Service (Amazon S3) is a service allowing to store and exchange data in a highly scalable, reliable, fast, and inexpensive way. Learn more.
- Source: Send to MadKudu your data sitting in your Data Warehouse or other integrations not connected to MadKudu, such as your web traffic, in-app data, etc. to use in models and segmentations.
- Destination: Send the results of your MadKudu models and segmentations as a file in an S3 bucket to import back into your Data Warehouse.
Use cases
- Send behavioral data to MadKudu on a daily basis to use in a behavioral scoring model or aggregation
- Score contacts on a daily basis in your data warehouse to surface qualified and engaged users
- Send a list of emails or domains as a one-time scoring to surface qualified prospects to focus on
How to set it up?
To enable Amazon S3 as a source (to send data from S3 to MadKudu)
Please follow these steps:
- Send your data to S3 following the supported format
- Give MadKudu access to your S3 bucket
- Let us know when you have added a file to your bucket so we'll validate we can pull it
- Set up a recurring dump (at least daily) of your fresh data to S3 and give us a green light to activate the recurring pull of your data.
Once setup and MadKudu has access to your data, you'll be able to:
- Map the data pulled on MadKudu platform in the event mapping
- Start building a Likelihood to Buy model or aggregations based on your behavioral data
To enable Amazon S3 as a destination (to send data from MadKudu to S3)
* Please note that this destination is available in beta
To score contacts coming from your data warehouse (or a CSV)
- Please follow the instructions above to enable Amazon S3 as a source first, sending to S3 the list of your contacts following the supported formats.
- Make sure MadKudu has write permissions (PutObject and DeleteObject) for the bucket
- Contact your Account Manager at MadKudu or support@madkudu.com with the following details:
- bucket path where MadKudu can find the file(s) containing the list of contacts to pull and score
- bucket path where MadKudu can add the files of scored contacts
- desired format of the file (supported format: CSV, JSON, PARQUET)
- the models, computations, or aggregations to score the contacts with
We'll take care of the rest and contact you for more information if necessary or to confirm when the setup is finalized. It should only take a few days but it all depends on volume, format respected, availability, etc.
Once the setup is completed, you'll start receiving in your s3 bucket at every sync process (every 4h to 12h, which means at the same time MadKudu pushes updates in your CRM or other integrations set up) a different file timestamped containing the full list of contacts with the result of the model(s). Each file is independent from each other so that you have the full history of scores, not just the updates.
For example, the file could contain the following properties
- mk_customer_fit_score
- mk_customer_fit_segment
- mk_customer_fit_signals
- mk_likelihood_to_buy_score
- mk_likelihood_to_buy_segment
- mk_likelihood_to_buy_signals
- mk_lead_grade_score
- mk_lead_grade_segment
- persona (= a computation named persona flagging people as buyer, influencer...)
- email_number_activities_last_90_days (an aggregation counting the activities of the person)
To export all the records pulled by MadKudu from your CRM, MAP.... and scored back into S3
You'll only need to set up an S3 bucket and give MadKudu access to this S3 bucket.
- Make sure MadKudu has write permissions (PutObject and DeleteObject) for the bucket
- Contact your Account Manager at MadKudu or support@madkudu.com with the following details:
- bucket path where MadKudu can add the files of scored contacts
- desired format of the file (supported format: CSV, JSON, PARQUET)
- the models, computations, or aggregations to score the contacts with
F.A.Q
What CSV parameters are sent to Amazon S3 when it is enabled as a Destination for MadKudu?
- delimiter: quote
- row delimiter: \n (line break)
- quotes: around multiline elements only (signals)