SOLVED

Re: RCE - custom measures based on custom fields

Go to solution
Matt_Stone2
Level 9

RCE - custom measures based on custom fields

I'm poking around in RCE and am trying to create a custom measure to use in an opportunity analysis field. Essentially, I want to recreate the Opportunity Amount measure, but using a custom synced field (we don't use the native Amount field in SFDC opportunities). However, when I click "Create Calculated Measure" the only fields visible are standard fields or existing measures. Is it not possible to create a custom measure based on a custom field?

1 ACCEPTED SOLUTION

Accepted Solutions
Jessica_Kao3
Level 10 - Champion Alumni

Re: RCE - custom measures based on custom fields

Hey Matt Stone​,

I know exactly what you are trying to do.  You have to call support and tell them that you want to remap the default opportunity amount field in RCE to a custom field.  Not everyone in support will understand what you are talking about.  Devyn has done this for me out of Portland support center.  It is possible. You might run into 1st line support folks that say its not.  It is.  The caveat to that is you have to force RCE to recognize the update so you have to make an update to all records in SFDC, like adding a period to a field in SFDC  that syncs to marketo.  I'll be at Summit so reach out if you need more help. 

View solution in original post

12 REPLIES 12
Grégoire_Miche2
Level 10

Re: RCE - custom measures based on custom fields

Hi Matt,

Once the field has been created in Marketo, you need to go to admin-> Revenue Cycle Analytics and hit the "custom field sync" tab on the top of the screen. There, you will be able to sync your new field with RCE datamart. It will take 24 hours after this to show up in RCE.

-Greg

Matt_Stone2
Level 9

Re: RCE - custom measures based on custom fields

Hey Grégoire Michel, I got the field to sync properly, it's how I'm trying to use the field that's the problem. I want to effectively create a new "Opportunity Amount" measure, but with this custom field instead. But when I get into the "Create Calculated Measure" screen, I see this:

Screen Shot 2018-04-25 at 3.46.13 PM.png

So there's no way to incorporate this new field and I'm left only being able to use my custom field as a row or column, but not the actual dataset (measure) of the report. Does that make sense?

Grégoire_Miche2
Level 10

Re: RCE - custom measures based on custom fields

Hi Matt,

Have you synchronized the field as a metric or as a dimension ?

-Greg

Matt_Stone2
Level 9

Re: RCE - custom measures based on custom fields

A dimension because that's the only option presented to me in the Custom Field Sync screen. The field is a Currency(18,0) type in SFDC.

Grégoire_Miche2
Level 10

Re: RCE - custom measures based on custom fields

Then, since it's a dimension, it cannot be used as a metric.

Is the field an opportunity field or a contact field  in SFDC  ?

-Greg

Matt_Stone2
Level 9

Re: RCE - custom measures based on custom fields

Opportunity -- I'm struggling to identify what ​type​ of field can be synced from SFDC and then used as a Measure instead of a Dimension.

Grégoire_Miche2
Level 10

Re: RCE - custom measures based on custom fields

OK, I had missed this. then it's impossible to make it a metric, then, unfortunately. Sorry for not asking this question first

-Greg

Matt_Stone2
Level 9

Re: RCE - custom measures based on custom fields

Do you know what fields/field types can be synced from SFDC and then used to create a Measure? I tried different field types and couldn't see any that would let me create them as a Measure.

Grégoire_Miche2
Level 10

Re: RCE - custom measures based on custom fields

HI Matt,

It's not the field type that matters, it's the object to which they below. It has to be a lead, contact or account field. As long as they belong to these objects, any number or currency field can be made a measure.

-Greg