Highlighted

Send reminder who have not pay mobile bill

parasb1361107

10-05-2019

Hi All,

Please can anyone explain how make  data flow in adobe campaign to send a reminder who have not pay mobile bill yet

Thanks,

Paras

Replies

Highlighted

ramon_bisswange

Employee

11-05-2019

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.