How does the 'Billing' Technical Workflow Calculate Active Profiles? | Community
Skip to main content
Level 3
July 31, 2025
Solved

How does the 'Billing' Technical Workflow Calculate Active Profiles?

  • July 31, 2025
  • 1 reply
  • 694 views

Hi,

 

The Active profiles monitoring | Adobe Campaign wiki and logs of the 'Billing' workflow give us the following information about active profiles:

  • Targeted or communicated to in the past 12 months
  • Exist in the broadLogRcp, broadlogEventHisto, broadLogOperatorLogs, broadLogBatchEvent, broadLogAppSubRcp tables

Our instance to date does not utilize the BatchEvent or AppSub features.

 

We have queried the broadLogRcp, broadLogEventHisto, and broadLogOperatorLogs tables and deduplicated on identifiers (recipient primary key for broadLogRcp, 'recipient identifier' for broadLogEventHisto, 'Primary Key (Operator)' for broadLogOperatorLogs, but the active profile count we get is slightly off. It is .8% less than the count given by the 'billing' technical workflow. 

 

Can someone please provide the specific logic used by the 'billing' technical workflow to obtain the active profiles count?

 

Thanks,

Skyler

Best answer by Manoj_Kumar

Hello @skylerqu2  You will have to consider the entries from "Recipient Exclusion Logs" schema for this calculation.

1 reply

Manoj_Kumar
Community Advisor
Community Advisor
August 1, 2025

Hello @skylerqu2 

 

You will have to consider the exclusion logs as well. Any exclusion that happens by typology is considered in this calculation.

Manoj     Find me on LinkedIn
SkylerQu2Author
Level 3
August 1, 2025

Hi @_manoj_kumar_  can you be more specific? This wiki page says "the profiles that were excluded during delivery preparation (by typology rules or quarantine mechanism for example) are not taken into account." Campaign Active profiles | Adobe Campaign

 

From what I have seen, excluded recipients are not added to broadLogRcp, so we are not including them in the calculation already.

 

Thanks,

Skyler

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
August 4, 2025

Hello @skylerqu2  You will have to consider the entries from "Recipient Exclusion Logs" schema for this calculation.

Manoj     Find me on LinkedIn