Campaign activity exports to Databricks

Blueshift allows you to export campaign activity reports directly to your Databricks account, providing seamless access to raw campaign actions such as sent, delivered, opened, and more. This lets you analyze customer engagement and measure campaign performance within your Databricks environment.

Campaign activity data is shared using Databricks Delta Sharing, allowing you to query the data or integrate it with other datasets for deeper insights.

Secure data sharing for campaign activity

With secure data sharing, no actual data is copied or transferred between accounts. Shared data does not consume storage in your account and does not contribute to monthly storage costs. The only charges incurred are for computing resources used to process and analyze the shared data.

Benefits of campaign activity exports

Access detailed records of all campaign actions, including sent, delivered, opened, clicked, and more.
Gain valuable insights to track and measure campaign performance using raw event data.
Review individual campaign activity reports to monitor engagement trends over time.
Data is securely stored and can be accessed without additional ETL processing.

Consider the following points about campaign activity reports in Databricks

Data exports begin from the day the integration is set up; historical campaign activity data will not be available.
Exports to Databricks are batched and processed daily (once a day).
Campaign activity data is retained for 3 months.
For details about exported data, please look at campaign activity attributes and extended attributes.

Exporting campaign activity data to Databricks

Step 1: Copy the sharing identifier from Databricks

Log in to your Databricks account.
Click Catalog in the left-side panel.
Click the dropdown in the top-right corner under your Organization Name.
Select Copy Sharing Identifier to copy the value to your clipboard.

Step 2: Configure Databricks export in Blueshift

Go to Account Settings > Campaign Activity Export.
Navigate to the Export to Databricks tab.
Paste the sharing identifier into the corresponding text box.
Click Start Databricks exports to initiate the export.

Step 3: Create a catalog from a share (in Databricks)

Create a shared catalog to access the exported data in your Databricks account.
Follow the steps outlined in the official guide: Create a catalog from a share.

Step 4: Access the exported data

Open your Databricks account and navigate to the shared catalog.
Follow the steps outlined in the official guide: Access shared data in Databricks.