Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Send reminder who have not pay mobile bill

parasb1361107
Level 2
Level 2

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

1 Reply
ramon_bisswanger
Employee
Employee

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.