Data in the datalake (Redshift)

All the raw datas generated by the campaign Module, by the sending communication in Salesforce are integrated on a daily frequency in the datalake.

You have access to the global documentation here : Datalake documentation for Marketing Data

You can have access to the documentation of the datamodel here for ODS (raw data) , CDS (clean data) : DataModel documentation for Marketing Data

It is better to use the data in the CDS schema

You can find some example queries to help you to start using these data

The aggregate data use by the Marketing Dashboard are in the CDS AGG tab