Adobe Analytics

lawrenceo754086 · 1/27/19

Hi there,

I'd like to find out which are my worst performing articles of the past 2018, by page views. Ideally the worst-performing 100 articles. How would I go about generating this kind of report?

Thanks for the help

kevinw30375507 · 1/28/19

Hello,

I would do this in analysis workspace, using article as the dimension (or perhaps page name, I don't know if you are capturing the article title in it's own variable or not), and then pull in page views as the metric. By default, the order would be from greatest to least, however, you can change that by hovering over the metric header column, an arrow will appear, click on the arrow and that will change the order to least to greatest.

Then to get 100 rows, in the dimension header, you'll see a showing 50 of X,XXX. Click on 50 and change that to 100.

Here's a video on pagination and sorting in analysis workspace that should help you get where you want to go

Pagination, Filtering, and Sorting Tables in Analysis Workspace | Adobe Analytics - YouTube

View solution in original post

kevinw30375507 · 1/28/19

Hello,

I would do this in analysis workspace, using article as the dimension (or perhaps page name, I don't know if you are capturing the article title in it's own variable or not), and then pull in page views as the metric. By default, the order would be from greatest to least, however, you can change that by hovering over the metric header column, an arrow will appear, click on the arrow and that will change the order to least to greatest.

Then to get 100 rows, in the dimension header, you'll see a showing 50 of X,XXX. Click on 50 and change that to 100.

Here's a video on pagination and sorting in analysis workspace that should help you get where you want to go

Pagination, Filtering, and Sorting Tables in Analysis Workspace | Adobe Analytics - YouTube