Salesforce Certified CRM Analytics and Einstein Discovery Consultant (Analytics-Con-201) Exam - Topic 5 Question 32 Discussion

Actual exam question for Salesforce's Salesforce Certified CRM Analytics and Einstein Discovery Consultant (Analytics-Con-201) exam

Question #: 32
Topic #: 5

[All Salesforce Certified CRM Analytics and Einstein Discovery Consultant (Analytics-Con-201) Questions]

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?

AFlatten

BCustom Multiple row formula

CCustom Formula

Show Suggested Answer

Suggested Answer: C

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.

by Nakisha at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified CRM Analytics and Einstein Discovery Consultant (Analytics-Con-201) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Cherri

4 months ago

Custom Formula gives flexibility to define new vs renewal clearly.

upvoted 0 times

...

Goldie

4 months ago

Flatten seems too simple for this. We need more detail.

upvoted 0 times

...

Danica

4 months ago

I agree, but a Custom Multiple row formula might handle renewals better.

upvoted 0 times

...

Shantay

5 months ago

I think a Custom Formula would be best. It allows for specific conditions.

upvoted 0 times

...

Melvin

5 months ago

Flattening won't help with this, it's too simplistic.

upvoted 0 times

...

Cheryl

5 months ago

Wait, how can you tell if it's a renewal without a flag?

upvoted 0 times

...

Rex

5 months ago

Not so sure about that, a Custom Multiple row formula might be better.

upvoted 0 times

...

Amos

5 months ago

Agree, it can differentiate between new and renewal easily.

upvoted 0 times

...

Sean

5 months ago

I think a Custom Formula would work best here.

upvoted 0 times

...

Britt

6 months ago

Option C all the way. Gotta love those custom formulas - they're like the duct tape of data transformations.

upvoted 0 times

...

Ruthann

6 months ago

Haha, I bet the consultant is wishing they had a "Renewal" checkbox on the Opportunity record. Custom formula it is!

upvoted 0 times

...

Daniel

6 months ago

Flattening the data? Really? That's not going to help identify new vs. renewal subscriptions. C is the way to go here.

upvoted 0 times

...

Fabiola

7 months ago

Custom Multiple row formula sounds like overkill for this use case. A simple custom formula should do the trick.

upvoted 0 times

...

Tijuana

7 months ago

The consultant should use a custom formula to determine if the subscription is new or a renewal. That's the most straightforward approach.

upvoted 0 times

...

Carline

7 months ago

This question reminds me of a similar one we did about identifying customer types. I think a custom formula could work, but I’m not completely confident.

upvoted 0 times

...

Cathrine

7 months ago

I feel like flattening the data wouldn't really help us determine if it's a renewal or not. It seems too simplistic for this scenario.

upvoted 0 times

...

Emmanuel

7 months ago

I'm not entirely sure, but I think a custom multiple row formula might be necessary since we need to compare records to identify renewals.

upvoted 0 times

...

Alecia

7 months ago

I remember we discussed using a custom formula to differentiate between new and renewal subscriptions in our last practice session.

upvoted 0 times

...

Valentin

8 months ago

This seems tricky, but I think a custom formula is the way to go. I'd try to build some logic to check the Account history and determine if this is a new or renewed subscription.

upvoted 0 times

...

Pamella

8 months ago

I'm leaning towards the Flatten option. That might let me bring in additional data sources to cross-reference and figure out the renewal status.

upvoted 0 times

...

Desirae

8 months ago

Custom Multiple row formula could work here. I'd try to find the most recent Closed Won Opportunity for the Account and compare the dates to see if this is a new subscription or a renewal.

upvoted 0 times

...

Barney

8 months ago

Hmm, I think I might try a custom formula to check if the Account has any other Closed Won Opportunities. If there's an existing one, then this must be a renewal.

upvoted 0 times

...