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!
Best answer by dan_ahrensView original