We ran into a number of issues that we had to tackle throughout the project this summer:
Addressing these issues…
Issue 1: The native integration between Nutshell and RCFX doesn’t allow us to log custom fields!
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.)
Issue 4: There were some dates logging as ‘yesterday’ ‘today,’ and ‘tomorrow.’
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!
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!
Link to Report: https://lookerstudio.google.com/reporting/1a185c61-45dd-40f5-b40e-c4940cbe5c8c