Attention: The Marketo Community will undergo scheduled maintenance on Tuesday, August 20th between 10-11 PM PDT. During this time, the Community and its content will not be accessible. We apologize for any inconvenience this may cause.
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?
Solved! Go to 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."
you should be able to do so if you edit the field to group it in RCE.
Hi Josh,
Could you please share a screenshot of where to do that?
Thanks,
Eva
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."
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