Hi all,
I've tried to be as descriptive as possible in the thread title. I've had a look through old posts but haven't seen this particularly query come up although I may not even be searching for the right thing.
I work in ecommerce and want to produce a report in a table. I have a list of 100 URLs for particular pages of interest on a website in a worksheet and then on another tab I have a list of all pages on said website. I need to use a formula to add up things like sessions, unique users etc for the list of 100 URLs of interest. To complicate matters slightly, the list of all pages contains these URLs but they can be slightly different in format (additional variables at the end of the URL).
As an example:
I am interested in a URL abc.com/data
In the bulk export there are many instances of abc.com/data but some of them will look like "abc.com/data/longerURL" or "abc.com/data/additionaltextstring". If I was only doing it for 1 URL it's easy enough just to set a filter and total off the values that I need. However, as I need to do this for 100 URLs and the reference list is nearly 6,000 rows I'm hoping this can be done with a formula to speed things up.
Hopefully this gives enough information but please let me know if I can provide further clarification.
Thanks.
Bookmarks