How does Kondado replicate Salesforce Marketing Cloud data to Redshift?

Kondado connects to your Marketing Cloud account through a direct integration, extracting data from selected pipelines such as Data Extensions, Events, and Subscribers. The platform loads this information into your specified Redshift cluster automatically on your chosen schedule, handling schema creation and updates without requiring manual API management or ETL scripting.

What specific marketing data can I extract from Salesforce Marketing Cloud to Redshift?

You can replicate nine distinct pipelines including Data Extensions for custom attributes, Events for interaction timestamps, Emails for campaign definitions, and Subscribers for contact management. Each pipeline contains specific fields such as send status, folder organization, and list membership details, totaling 164 available fields for comprehensive marketing analytics.

How often can I schedule updates for my Marketing Cloud data in Redshift?

Kondado offers configurable scheduling options ranging from every five minutes to daily intervals, allowing you to balance data freshness with processing efficiency. You can set different frequencies for individual pipelines, ensuring high-priority Events data updates near-real-time while running bulk Subscribers refreshes on hourly or daily schedules.

What format does Salesforce Marketing Cloud data take when stored in Redshift?

Data arrives in Redshift as structured tables following PostgreSQL conventions, with each pipeline creating distinct tables containing the original field names and data types from Marketing Cloud. The schema preserves relationships between entities like Lists and Subscribers, enabling complex SQL joins and aggregations directly within your data warehouse queries.

Can I combine Salesforce Marketing Cloud data with other sources in my Redshift warehouse?

Yes, Kondado enables you to replicate data from additional sources such as Salesforce CRM , advertising platforms, or e-commerce systems into the same Redshift instance. This allows you to create unified analytics by joining Marketing Cloud engagement metrics with sales transactions or customer service records using standard SQL joins across different datasets.

Which Redshift fields are created for Marketing Cloud Events and Subscribers?

The Events pipeline creates fields capturing timestamps, event types, and campaign associations, while the Subscribers pipeline includes email addresses, status indicators, and list membership details. These fields maintain their original Marketing Cloud naming conventions within Redshift, facilitating straightforward mapping to your existing business intelligence tools like Power BI or Looker Studio .

Do I need technical skills to set up the Salesforce Marketing Cloud to Redshift pipeline?

No coding is required to establish the connection, you simply authenticate your Marketing Cloud credentials and provide your Redshift cluster details through Kondado's interface. The platform handles the technical complexities of API authentication, data type mapping, and schema management automatically, making the setup accessible to marketing analysts and business users.

Send data from Salesforce Marketing Cloud (Exact Target) to Redshift

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Replicate Salesforce Marketing Cloud (Exact Target) to Redshift

To send your marketing data from Salesforce Marketing Cloud (Exact Target) to Redshift, start by selecting this data source in Kondado and authenticating your account. Configure your Redshift destination with the cluster details, then choose which pipelines you want to replicate from the nine available options including Data Extensions, Events, and Subscribers. Set your preferred schedule for automated updates, ranging from every five minutes to daily intervals, and Kondado handles the replication process without requiring any coding or manual exports.

Kondado provides a direct integration between Salesforce Marketing Cloud (Exact Target) and Redshift, replicating nine distinct pipelines with 164 fields on a configurable schedule. The platform automates data movement from marketing automation sources to your Amazon data warehouse, enabling analysts to query subscriber behavior, campaign performance, and engagement metrics using standard SQL without managing API connections or manual data transfers.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Once your Data Extension and Events pipelines arrive in Redshift, you can build comprehensive customer journey analyses by joining timestamped interaction data with custom field attributes from your marketing campaigns. Marketing teams leverage the Subscribers and List Sends pipelines to calculate cohort retention rates and deliverability metrics directly within their data warehouse, connecting the results to Looker Studio or Power BI for interactive stakeholder dashboards.

Try out all the features for free for 14 days

Salesforce Marketing Cloud (Exact Target) data available for Redshift

available pipelines

164

extractable fields

Available integrations

Integration	Description
Data Extension	Returns data from a specific data extension, including _kdd_rowkey, col_x, col_y, and col_z, allowing for incremental or full integration.
Emails	Provides definitions of stored emails, with fields such as id, status, name, and modifieddate, along with information on dynamic subject line usage.
Events	Captures event data, allowing analysis of interactions with campaigns, including timestamps and other relevant details.
Folders	Organizes and categorizes objects, with fields such as id and folder, facilitating the management of emails and other assets.
List Sends	Records list sends, allowing analysis of metrics such as number of sends and status, essential for marketing campaigns.
List Subscribers	Provides information about list subscribers, including data such as email and status, fundamental for segmentation and engagement.
Lists	Groups subscribers and allows efficient management, with fields such as id and customerkey, essential for targeted campaigns.
Sends	Monitors all sends made, with metrics such as status and timestamps, allowing performance analysis of campaigns.
Subscribers	Contains information about subscribers, including fields such as email and status, essential for list and campaign management.

Data Extension

Returns data from a specific data extension, including _kdd_rowkey, col_x, col_y, and col_z, allowing for incremental or full integration.

Emails

Provides definitions of stored emails, with fields such as id, status, name, and modifieddate, along with information on dynamic subject line usage.

Events

Captures event data, allowing analysis of interactions with campaigns, including timestamps and other relevant details.

Folders

Organizes and categorizes objects, with fields such as id and folder, facilitating the management of emails and other assets.

List Sends

Records list sends, allowing analysis of metrics such as number of sends and status, essential for marketing campaigns.

List Subscribers

Provides information about list subscribers, including data such as email and status, fundamental for segmentation and engagement.

Lists

Groups subscribers and allows efficient management, with fields such as id and customerkey, essential for targeted campaigns.

Sends

Monitors all sends made, with metrics such as status and timestamps, allowing performance analysis of campaigns.

Subscribers

Contains information about subscribers, including fields such as email and status, essential for list and campaign management.

See all available data →

Try out all the features for free for 14 days

How to send Salesforce Marketing Cloud (Exact Target) data to Redshift

Sync data automatically — no code, no manual exports.

Connect your Marketing Cloud account

Navigate to the data sources section and select Salesforce Marketing Cloud (Exact Target), then enter your API credentials to establish authentication. Kondado validates the connection immediately, displaying the nine available pipelines including Data Extensions, Events, and Subscribers for selection.

Configure your Redshift destination

Enter your Redshift cluster endpoint, database name, and access credentials to establish the target warehouse for your marketing data. The platform tests connectivity to ensure proper permissions and schema creation capabilities before proceeding to pipeline selection.

Select pipelines and schedule updates

Choose which of the nine pipelines you want to replicate, such as Subscribers for contact data or List Sends for campaign metrics, then set your preferred update frequency from five minutes to daily intervals. Activate the configuration to begin automated replication, with data flowing continuously according to your specified schedule.

Try out all the features for free for 14 days