Hey @edgarmsi, thank. you for your post. Forwarding this to the Product manager look into and get back to you. 

Hi @edgarmsi 

Yes, we can do that using our Rules Engine. Below are the steps to get the solution.

Step 1: using the Call to Action object get the Company GSID, Company Name, Call to Action Name, CTA Status with the required filters.

Step 2: using the previous step 1, create a transform task and calculate the Count of CTA Name with group by Company GSID with CTA Status = Open filter condition.

Step 3: using the previous step 1, create a transform task and calculate the Count of CTA Name with group by Company GSID with CTA Status = Closed filter condition.

Step 4: using the Company Object get the Company GSID and you can provide any filters like Company Status  = Active and ..etc.

Step 5: merge the Step 4 and Step 2 as Left Outer Join using the Company GSID as a Join Condition.

With this we will get the Company GSID, Count of CTA GSID name as open cta’s count.

Step 6: merge the step 5 and step 3 as Left Outer Join using the Company GSID as a Join Condition.

With this we will get the Company GSID, Open cta’s Count, and Count of CTA GSID nothing but Close cta’s count name as Closed cta’s Count.

So finally we have data with the fields like, Company GSID, Open CTA’s Count, and Closed CTA’s Count.

And the data looks like below.

Sample Data:

Here we are seeing Null data in few Id’s because we used the Left Join Condition in the Rule Setup.

So finally, based on that we can proceed with Rule Actions. You have to create multiple Actions based on the Open and Closed Counts.

If Open Count = Null And Closed Count != Null means that Company has 0Zero Open and All Closed CTA’s. So you can update Engagement Type to Established.

Hope this solves your use case.

Thanks.

Thanks @phani_kumar!  I understand your steps and will work to implement them. Thank you!