Campaign activity exports to Snowflake

Blueshift uses Snowflake's Secure Data Sharing feature to give you access to campaign activity reports saved in Blueshift's Snowflake account. You can easily consume this data by querying it or by creating a database from the share. The raw campaign data is readily available in Snowflake, and you can easily access it without setting up any ETL logic. All customer engagement and campaign data is immediately accessible and can be queried to gain valuable 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 the campaign activity reports in Snowflake

• Data is exported into Snowflake from the day exports are set up. Previous campaign activity data will not be available in Snowflake.
• The data is batched and written to Snowflake daily (once a day).
• Campaign activity data is retained in Snowflake for 3 months.
• To retain the data for a more extended period, copy the data into a dedicated table in your database instance.
• For details about the saved data, please look at Campaign Activity attributes and extended attributes.

Please watch this video for a quick overview of exporting the campaign activity reports to Snowflake.

In addition to setting up this export within Blueshift, you can request a campaign activity export to Snowflake through our listing on the Snowflake marketplace.

Set up exports to Snowflake

To set up Secure Data Sharing and to get access to campaign activity reports in Blueshift's Snowflake account, complete the following steps:

• Go to Account Settings > Campaign Activity Export > Export to Snowflake tab.
• Enter the Account Identifier for your Snowflake account in the format <OrgName>.<AccountName>. For more information, please refer to Account Identifiers.
• Select the required Snowflake Cloud Provider.
• Select the necessary Snowflake Cloud Provider Region.
• Click Start Snowflake Export.

Set up data access in Snowflake

Before you can use (query) the data shared with you by Blueshift, you must first consume the data by creating a database from the share made available to you.

• Log into your Snowflake account.
• Go to Data > Private Sharing > Direct Shares.
• You can see the shared database here.
• Click Get Data to create and configure a database from the share.

• Go to Data > Databases to see the new database.
  • The schema name is the <site_name> for your site.
  • The table that contains all the campaign activity data is CAMPAIGN_ACTIVITY.

Set up exports to unsupported Snowflake region or provider

If Blueshift does not support your Snowflake Cloud Provider or Snowflake Cloud Provider region, complete the following steps to set up the export of campaign activity reports:

• Set up a Snowflake sub-account in a region that Blueshift supports. For more information, see the Snowflake documentation for creating a sub-account in a different region.
• Set up exports to this sub-account.
• Set up data access in Snowflake.
• Replicate the data to your main account. For more information, see the Snowflake documentation for Sharing Data Securely Across Regions and Cloud Platforms.