Calculate touchpoints

[LAR1985]

Hi all,

In a workflow, we want to get the touchpoints of each profile to insert in a custom resource that we have created. We have tried creating a additional field in a query acivity, counting the delivery logs, with the following function "Count(logs)", but we get the following error "PGS-220000 PostgreSQL error: ERROR: INSERT has more target columns than expressions"

Do you know how can we do it?

Thanks

[SatheeskannaK · Accepted solution]

Hi @LAR1985,

Try with type aggregate on additional data in query activity to count the deliveries received.

Result:

Thanks!

[LAR1985]

Thanks!! That has worked perfectly