I am trying to trigger a CTA for what we deem as an "Inactive" client which is based on usage date of our platform. I am not sure what would work best, creating new MDA where I can add some calculated fields or trying to calculate the data in a Bionic Rule using the Transformation task.
We have a field in the MDA labled "UsageEvent". This field contains each unique usage event performed by a user of our platform. The usage comes with the UserName and a SessionID (and some other data). The tracking description is populated in that field via an S3 connector with our dev team.
I am trying to trigger a CTA based on at least 1/2 of the licensed users on the account having a count of usage events < x amount. So if the account meets the criteria, to trigger a CTA for the CSM to alert them of a potentially risky client.
I am not that well versed using the Transformation task and have been struggling trying to create this calculation. Is this possible? Or, how would you attack this problem?
Thanks in advance!