In CRM Analytics, when dealing with two datasets, such as Dataset A (activities) and Dataset B (users), and you want to delete records from Dataset A based on the users listed in Dataset B, you would typically use a combination of a join and filter transformation in a recipe. The join transformation allows you to combine data from both datasets based on the shared userID dimension, and the filter transformation would then be used to delete or exclude any activities from Dataset A that are associated with the users from Dataset B. This approach ensures that only relevant activities remain in Dataset A after filtering out the unwanted ones. Reference: CRM Analytics Recipes: Join and Filter Transformations

To address issues with unauthorized access to sensitive data and dashboards, the best practice is to create separate apps, datasets, and dashboards for different user groups and then manage their sharing settings appropriately. This allows you to maintain data security while ensuring that users only access the data and insights that are relevant to their roles. In this scenario, applying separate apps for managers with defined sharing rules will prevent users who shouldn't have access from seeing sensitive data. Reference: Managing Data Access and Sharing in CRM Analytics

To determine whether a subscription is new or a renewal from the Opportunity records in Salesforce, the consultant should utilize a Custom Formula in the data transformation process. Here's the rationale:

Custom Formula Usage: By employing a custom formula, the consultant can create a logical expression that checks the historical data associated with each account. If an account has previous closed-won opportunities, any new opportunities can be labeled as renewals; otherwise, they are considered new subscriptions.

Data Insight: This method provides a straightforward way to derive new insights (new vs. renewal) directly from existing data without altering the data structure itself, making it a non-invasive and efficient solution.

Implementation: The custom formula can be applied in a recipe or directly within a dataflow in CRM Analytics, offering flexibility in how and where the transformation is executed.

To ensure continuity in managing a CRM Analytics app at Cloud Kicks after the current manager leaves, it is critical to proactively assign a new manager. Here's why this is the best approach:

Role Transition: Assigning a new manager before the current manager's account is deactivated ensures there is no gap in app management, maintaining access and administrative continuity.

Avoid Disruption: Waiting for an automatic reassignment (which does not typically occur in CRM Analytics) or post-deactivation reassignment could disrupt the management and operation of the app, potentially leading to access issues or administrative challenges.

Proactive Management: This approach is in line with best practices for CRM system management, where critical roles and responsibilities are transitioned smoothly to avoid any operational disruptions.