Hi Paras,
some comments / hints:
- First question would be where the information about "open" bills is stored / available.
There are few ways to handle that:- Store the data within the Adobe Campaign database and regular import from an external system
- Integrate the database via FDA and then do queries directly on the billing database and then joining it to profile data
- Data Flow would look like:
- If DB is in campaign database, it's rather very simple as just a "Query" activity would be used in the database.
This can join billing table with recipient table to determine all affected recipients - If DB is in FDA, rather following approach might be taken:
- Fetch list of all customers with open bills in the external database.
The query result needs to contain some field to identify the recipients (e.g. customer ID) - Then in the next step join the external data with local recipients based on the identification field
For both approaches, the workflow then would have list of recipients and following tasks can do sendout or further segmentations.