Days since last purchase by category | Community
Skip to main content
Level 2
August 10, 2021
Solved

Days since last purchase by category

  • August 10, 2021
  • 1 reply
  • 3169 views

Is there a way to segment the "Days since last purchase" metric to see it by category purchased? Even at a high level?

 

I tried creating a segment looking at visitors who purchased within category X, but concerned that this is only looking at the purchases of category X after their last purchase from category A/B/C so many days ago.

 

Knowing that the days since last purchase dimension looks only at the hits after their most recent purchase, is there any way we can look at it by what category that most recent purchase was from?

 

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by MikeCo9

Hi AnthonyBBY, 

 

Does this look like what you are looking for? Below is a report that shows the days since last purchase for the Women's category. In this report I initially report on the Category dimension then break it down by Days Since Last Visit. 

 

1 reply

MikeCo9Adobe EmployeeAccepted solution
Adobe Employee
August 11, 2021

Hi AnthonyBBY, 

 

Does this look like what you are looking for? Below is a report that shows the days since last purchase for the Women's category. In this report I initially report on the Category dimension then break it down by Days Since Last Visit. 

 

Level 2
August 11, 2021

Thanks for your reply!

 

To me, that says 150 visits of the 8,490 had visited and women's category and their most recent purchase was earlier that day, but I'm not sure that it means that their most recent purchase was within the Women's category. That is what I'm trying to verify/validate.

The way I'm trying to look at it is Visitors who had made a purchase in a category and then having a table with Days since last purchase, but I'm still seeing orders for that same category even same day (like those who bought a laptop buying another laptop same day). I'm not sure if those orders are truly of those who are ordering a second laptop or are just identifying those who purchased a laptop after making a purchase of anything earlier that day.

 

Does that make sense?

Adobe Employee
August 16, 2021

If I segment by the Women's category there are not any other categories in the data set. I get 564 same day purchases of 12,461 occurrences. This is a test database so a dev might be hitting it often in a single day. 

 

I receive the same numbers when I generate the same report I sent earlier. This tells me the report I originally provided does not include purchases from another category.