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
BedrockMission!

Learn More

View all

Sign in to view all badges

How to calculate RFM value

Avatar

Avatar
Validate 10
Level 3
maheswarik23685
Level 3

Likes

21 likes

Total Posts

32 posts

Correct Reply

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

Avatar
Validate 10
Level 3
maheswarik23685
Level 3

Likes

21 likes

Total Posts

32 posts

Correct Reply

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

12-09-2018

Hi All,

Anyone aware of calculating RFM value in Adobe campaign for loyalty customers.

Thanks,

Maheswari

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 1
pranavku
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
pranavku
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
pranavku
Level 1

19-09-2018

This is fairly straightforward to setup adding data (computed aggregates) to the temp table in the query, followed by a Fork and then multiple Cell activities (one for each of r, f and m), then appending the segment codes together to get the RFM group. They can then report out on it, target specific RFM groups, or have dynamic content based on the RFM group.

The best practice is to pre-aggregate the scores on a daily basis or whatever frequency new transactions are available (in the DB or through FDA). Then a “simple” data management workflow is used to compile the 3 scores for each recipient.

PS: Schema and form XML below

  <!-- RFM Data Schema Fields -->

      <attribute enum="rfmSegments" label="RFM Segment" name="rfmSegment" type="string"/>

      <attribute enum="rfmValueSegments" label="RFM Value Segment" name="rfmValueSegment"

                 type="string"/>

      <attribute label="RFM Recency" name="rfmRecency" type="long"/>

      <attribute label="RFM Frequency" name="rfmFrequency" type="long"/>

      <attribute label="RFM Monetary" name="rfmMonetary" type="long"/>

      <attribute label="RFM Date" name="rfmDate" type="date"/>

      <!-- RFM Input Form Fields -->

    <container colcount="2" colspan="2" label="Recency Frequency Monetary" type="frame">

      <input colspan="1" xpath="scores/@rfmRecency"/>

      <input colspan="1" xpath="scores/@rfmFrequency"/>

      <input colspan="1" xpath="scores/@rfmMonetary"/>

      <input colspan="1" xpath="scores/@rfmDate"/>

      <static/>

      <static/>

      <container colcount="2" colspan="1" label="RFM Segment" type="frame">

        <input colspan="1" xpath="scores/@rfmSegment"/>

        <input colspan="1" xpath="scores/@rfmValueSegment"/>

      </container>

    </container>

Answers (0)