Understanding the Problem

When a client’s data person leaves, and the supplied keys are incorrect, it can cause significant issues with the accuracy of the data. In this case, the client is only 5 weeks into sends and has approximately 137K subscribers, so they are willing to start over from scratch.

However, it is crucial to consider the potential consequences of deleting existing data, particularly for compliance purposes. The General Data Protection Regulation (GDPR), CAN-SPAM, and other regulations require that companies maintain accurate records of subscriber interactions.

Platform-Level Considerations

Before resetting the dataset, it is essential to understand the platform-level implications. In Marketing Cloud, subscriber keys are used to uniquely identify each subscriber. If the keys are incorrect, it can cause issues with data synchronization and reporting.

Furthermore, if the client has any automations or workflows built against the existing data, resetting the dataset could cause disruptions to these processes. However, in this case, the client has confirmed that there are no automations or workflows to consider.

The root cause of the issue is the incorrect subscriber keys, which are causing data synchronization and reporting problems. To resolve this issue, it is necessary to reset the dataset and re-import the corrected data.

Step-by-Step Solution

To reset the dataset, follow these steps:

1. Export the existing data via SFTP to a secure data warehouse or other options provided by Salesforce.
2. Run full backup data reports and export them to a safe place.
3. Delete the existing data from the Marketing Cloud dataset.
4. Re-import the corrected data into the Marketing Cloud dataset.

Best Practices and Considerations

When resetting a Marketing Cloud dataset, it is essential to consider the following best practices and considerations:

data_management.js

// Example code for exporting data via SFTP
var ftp = new SFTP();
ftp.connect('ftp.example.com', 'username', 'password');
ftp.get('/path/to/data.csv', 'data.csv');
ftp.disconnect();

Heads up: Make sure to test the data import process before re-importing the corrected data to ensure that it is accurate and complete.

Checklist

• Confirm that there are no automations or workflows built against the existing data.
• Export the existing data via SFTP to a secure data warehouse or other options provided by Salesforce.
• Run full backup data reports and export them to a safe place.
• Delete the existing data from the Marketing Cloud dataset.
• Re-import the corrected data into the Marketing Cloud dataset.
• Test the data import process to ensure that it is accurate and complete.
• Verify that the subscriber keys are correct and unique.
• Monitor the dataset for any issues or discrepancies after the reset.

Frequently Asked Questions

What is the best way to export data from Marketing Cloud?

The best way to export data from Marketing Cloud is via SFTP to a secure data warehouse or other options provided by Salesforce.

How do I ensure that my subscriber keys are correct and unique?

You can ensure that your subscriber keys are correct and unique by verifying them against your data source and using a unique identifier for each subscriber.

What are the potential consequences of deleting existing data in Marketing Cloud?

The potential consequences of deleting existing data in Marketing Cloud include loss of historical data, disruption to automations and workflows, and potential compliance issues.

How do I re-import corrected data into Marketing Cloud?

You can re-import corrected data into Marketing Cloud by using the import wizard or API, and verifying that the data is accurate and complete before importing it.

What are the best practices for resetting a Marketing Cloud dataset?

The best practices for resetting a Marketing Cloud dataset include exporting existing data, running backup reports, deleting existing data, re-importing corrected data, and testing the data import process.