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?
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."
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.