I have some data from analytics that I need to combine somehow and trying to find the best way of doing this. I have data similar to the following:
URL | Sessions |
---|---|
/ | 59 |
/?variable=1 | 2 |
/?variable=2 | 37 |
/?variable=3 | 1 |
/another-page/ | 21 |
/another-page/?variable=x | 1 |
I want to be able to find a way to first remove any UTM data (ie anything after the question mark) then add up the total sessions from each page. Here, the result I want is this:
URL | Sessions |
---|---|
/ | 99 |
/another-page/ | 22 |
I want this formula to be automatic in the way that it read all URLs in Column A until it reaches the end.