CJA Applying Filter Conditions to Global Date Range, instead of Freeform Table Date Range

Question

Objective: I am trying to find the number of people - per week - who visit BOTH our "Offers" and "Rewards" pages. And I need to trend this audience over time.  What did I try?: I created two filters - one for Persons visiting the "Offers" path, and another for the "Rewards" path. I then created a Freeform table, with Week as the table index, and People as the metric. Lastly, I stacked both filters on the People metric, with the intention of filtering people who visited BOTH "Offers" and "Rewards" pages by week.  Result: When the global project date range filter is restricted to a specific week, the result is as expected - I get around 560K people. However, when this date range is expanded, the result balloons to over 2.3M, which is obviously incorrect, since the max cannot exceed the minimum size of these two audiences, which is around 820K.  Ask: How do I get the freeform table to only apply the Filter criteria for the individual weeks of the freeform table, and not the entire project date range.  I've attached an outline of how the audience is getting built up.

Josh__Stephens · Answer

I'm not sure if there's a way to do this without creating specific segments for each week. One sort of similar way you could easily do this in CJA is to create another data view with a longer session timeout period (say 1 week). You could then filter for sessions where both pages were engaged in the same session.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded