Can we group date fields by month in RCE?

[Eva_Yu]

I would like to generate a report on monthly/weekly MQLs by business unit or lead source in RCE, but it does not look like I can group the date fields by month or week. I created a field organizer in lead database, but still cannot find a way to syn it to RCE.

How can I accomplish this report?

[Josh_Hill13]

you should be able to do so if you edit the field to group it in RCE.

[Eva_Yu]

Hi Josh,

Could you please share a screenshot of where to do that?

Thanks,

Eva

[Eva_Yu · Accepted solution]

Just want to updated my own question in case others are looking for the same thing. Here is the reply I got from Marketo support:

"Unfortunately, there is not a way to show the values as a month or different measurement other than exact date. This is due to the fact that the values for these fields are measured in a month/day/year format. You can confirm this by looking at a few leads with values for the MQL fields.

In order to achieve the desired results (MQL Month, etc.), you would need to create separate fields and apply values in that format. This is similar to the sent (date), sent (month), sent (quarter), etc. fields in Email Analysis reports."

[Rachel_Noble]

Hey Eva,

One way you may be able to capture this is by updating the field grouping sync settings in Admin > Revenue Cycle Analytics:

Happy reporting!

Rachel