Free Preparation Discussions
MENU
Salesforce Certified CRM Analytics and Einstein Discovery Consultant (Analytics-Con-201) Exam - Topic 5 Question 32 Discussion
Topic #: 5
An CRM Analytics consultant is working with Ursa Major Solar to build a dashboard to understand customer renewals. Each subscription is captured as a Closed Won Opportunity within Salesforce and a single Account should only have one active subscription. The consultant notices the Opportunity record does NOT specify whether it is a renewal or a net new subscription.
Which data transformation should the consultant use to determine if a subscription is new or a renewal?
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.
Daniel
5 days agoFabiola
11 days agoTijuana
16 days agoCarline
21 days agoCathrine
26 days agoEmmanuel
1 month agoAlecia
1 month agoValentin
1 month agoPamella
2 months agoDesirae
2 months agoBarney
2 months agoLayla
2 months ago