Send reminder who have not pay mobile bill

Avatar

Avatar
Validate 1
Level 2
parasb1361107
Level 2

Likes

7 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
parasb1361107
Level 2

Likes

7 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
parasb1361107
Level 2

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

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

271 likes

Total Posts

400 posts

Correct reply

200 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

271 likes

Total Posts

400 posts

Correct reply

200 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
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.