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

Add Next Page & Previous Page reports to Report Builder

Avatar

Avatar
Boost 5
Level 2
bshelton_swa
Level 2

Likes

6 likes

Total Posts

3 posts

Correct Reply

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

Avatar
Boost 5
Level 2
bshelton_swa
Level 2

Likes

6 likes

Total Posts

3 posts

Correct Reply

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

03-10-2014

I suggest adding the Previous Page and Next Page reports to Report Builder.

 

I need to add dependancies to the output of a previous/ next page report. For example, I'd like Report Builder to first find the top 5 previous/ next pages to a given page, then run a Pages report to find important metric values for thoses pages.

 

Currently,the only way to get this data is to use the "Page Paths" report; however, I cannot add "Pages" report as a dependent.

 

Thanks!
Brian

3 Comments

Avatar

Avatar
Level 1
gescargu
Level 1

Likes

0 likes

Total Posts

54 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
gescargu
Level 1

Likes

0 likes

Total Posts

54 posts

Correct Reply

0 solutions
View profile
gescargu
Level 1

06-10-2014

Avatar

Avatar
Level 1
gescargu
Level 1

Likes

0 likes

Total Posts

54 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
gescargu
Level 1

Likes

0 likes

Total Posts

54 posts

Correct Reply

0 solutions
View profile
gescargu
Level 1

06-10-2014

Hello,

 

This is not offered as a dependent request because users may be lead to believe that the metrics selected for the next pages were collected from the context of the current path. 

We see the same behavior in Report&Analytics. If you go to the next Page report, you can only show the "instances" metric, and cannot add other Page metrics.

 

However, there is a workaround from within Ms Excel.

 

From the Next Page report, you first need to extract the page name from the path. This is done by extracting the string from the path, after the last ">" using Ms Excel formula.

If a path is in A6, the formula to find the last ">" positiion is: 

=FIND("@",SUBSTITUTE(A6,">","@",(LEN(A6)-LEN(SUBSTITUTE(A6,">","")))/LEN(">")))

Let's put this formula in E6.

 

Now you need to extract the string after the last ">" character. Use this formula to do so:

=MID(A6,E6+1, LEN(A6)-E6)

 Let's put this formula in F6.

 

You have now extracted the Next Page from the path.

 

Finally, you can create a Page request, with a specific filter from cell, pointing to the cell F6.

 

The last trick to perform is that we need to make sure that the "Page" request always gets run after the Path request. So we need to create a dependency between the two. One handy way to do this is to use a date range from cell for the Page request, and use the cells that contain the date that was returned by the Path request.

 

Thank you.

 

Guillaume

Avatar

Avatar
Boost 5
Level 2
bshelton_swa
Level 2

Likes

6 likes

Total Posts

3 posts

Correct Reply

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

Avatar
Boost 5
Level 2
bshelton_swa
Level 2

Likes

6 likes

Total Posts

3 posts

Correct Reply

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

06-10-2014

This worked perfectly! I had already parsed the path output to get the page name, but didn't know how to create a dependency from there. Now, I know...

 

Thanks for your help!