Reporting Based on Event Date, Rather Than Close Date

Posted by: Bri Guarnieri Date Posted: August 26, 2025
Back to Case Studies

Issue

We ran into a number of issues that we had to tackle throughout the project this summer:

  1. The native integration between Nutshell and RCFX doesn’t allow us to log custom fields!
  2. The event date was populated in the tag field & reads as text, not a date!
  3. There were numerous formats of the field (YYYY-MM-DD / MM-DD, etc.)
  4. There were some dates logging as ‘yesterday’ ‘today,’ and ‘tomorrow’

Solution

Addressing these issues…

Issue 1: The native integration between Nutshell and RCFX doesn’t allow us to log custom fields!

  • We built out a custom integration to log the event date in Nutshell as a deal tag in RevenueCloudFX.

Issue 2 & 3: The event date was populated in the tag field & reads as text, not a date! There were also numerous formats of the field (YYYY-MM-DD / MM-DD, etc.)

  • Because of this, we couldn’t create a dynamic date range filter! We had to use custom filters to account for the different formats & give month-by-month views, but this wasn’t ideal!
  • We took it a step further and tried to convert the text to date (shoutout to Gina B for helping me with this piece). We used a calculated field to convert all of the date formats into 1 unified format & set the data type as date.

Issue 4: There were some dates logging as ‘yesterday’ ‘today,’ and ‘tomorrow.’

  • This caused our fix above to still throw errors and null our results.
  • We were able to have our integration dev read the backend format of the field from Nutshell, rather than the display of ‘today,’ ‘tomorrow,’ and yesterday!
  • We ran a backfill to correct this issue!

From there, we were able to configure the date range filter to our calculated field & filter based on event date. This is a huge win for revenue reporting alignment moving forward! We now have to tabs within our report – our first tab being our new view based on event date & our second tab that is based on the closed date for reference and comparison!

Achievement

Created a custom Looker Report that allows for date filtering based on a custom field in Nutshell (Event Date) that is logged as a tag in RevenueCloudFX! To date, we were reporting on revenue when the deal closes, but they base their own reporting & revenue numbers based on the events that occurred in a month (not that closed), which meant that we weren’t aligned on numbers and ROI. We’re now able to report and look at the same numbers because of this project!

Snippet/Screenshot/Link

Link to Report: https://lookerstudio.google.com/reporting/1a185c61-45dd-40f5-b40e-c4940cbe5c8c