Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Get metrics for list of pages via Report Builder

Avatar

Level 1

I have a static list of ~3000 URLs that I need to pull multiple metrics for into Excel (and/or Power BI). I don't want to pull all possible URLs into a tab and then VLOOKUP because there are millions.

I am wondering if there's any way to pull in metrics referencing a list of URLs already in Excel, like is possible for referencing dates from cells. Given that there are 3K items I cannot feasibly create a segment and a classification file is not an option. I suspect this is not possible, but would like the experts to please confirm. I would appreciate any suggestions as well.

Thank you!

1 Accepted Solution

Avatar

Correct answer by
Level 1

Solution: Report Builder does have this feature. Under dimension filter you can choose Select > Make selection of cells you want to reference.

View solution in original post

2 Replies

Avatar

Level 10

why a classification file is not an option?

Avatar

Correct answer by
Level 1

Solution: Report Builder does have this feature. Under dimension filter you can choose Select > Make selection of cells you want to reference.