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

Recency and Frequency Report

Avatar

Avatar
Seeker
Level 5
David-123
Level 5

Likes

114 likes

Total Posts

132 posts

Correct Reply

18 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Springboard
Establish
View profile

Avatar
Seeker
Level 5
David-123
Level 5

Likes

114 likes

Total Posts

132 posts

Correct Reply

18 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Springboard
Establish
View profile
David-123
Level 5

16-03-2018

Hi there,

I think that this must be one of those things that is possible but I have given it a good couple of hours with no luck.

I am trying to create a Freeform table in workspace that essentially shows the following for number of visitors:

                                                       Has not purchased in last 30 days          Has not purchased in last 60 days

Purchased Once last year               500 visitors                                             300 visitors

Puchased Twice last year               400 visitors                                             400 visitors

I fully understand the time based segments and I am clearly getting stuck with the nested segments somewhere.

If anybody can shed any light that would be great.

Thanks

Dave

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
MVP
ursboller
MVP

Likes

521 likes

Total Posts

1,020 posts

Correct Reply

256 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

521 likes

Total Posts

1,020 posts

Correct Reply

256 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
ursboller
MVP

07-08-2018

Hi davidj85759080

Don't know if the question is already solved in the meantime, but there was a "challenge" on measure slack to answer this question

I just tried to create a table as desired - or something similar. Since it was easier for me to create, I changed the Columns/Rows compared to what you described. So first how my result looks like:

1544014_pastedImage_1.png

As you can see I created the following items

  • Header (Columns) - show last 12 full month
    Using the timetrame for last 12 full month would include all traffic for this timerange.
    To see Visitors who made 1 or 2 orders, I just created two simple segments (see small screenshot from segment preview)
  • Rows - Show behavior for last few monthsYou need a trick here to get the desired result: you need to select all Visitors who had any traffic in the last 12 month and then exclude those visitors who had orders in the last 1 or 2 month. If you do not add the "last 12 month", it will only show visitors from the last 1 or 2 month who visited the website without order, skip data from visitors before! (let me know if you need to more information about that...)

To make it more ease to recreate, I show you the full segment I created for one of the rows. The following screenshot show the segment "Visitors no Order last 1 Month":

1544195_pastedImage_7.png

I hope you can use this answer to create your own table. let me know if you need more explanation.

Regards Urs

Answers (0)