In the latest release of the Analytics Edge Add-in for Excel (11.45.0) and Desktop App (1.45.0), the Split function now lets you split a column of URLs into its component parts. This simplifies URL path analysis, separates the domain from the page path, and isolates the query string and anchor tag (fragment).
In the Split wizard, simply select the column with the URL/web page address and select the new option to Split On URL.
This will work on full URLs like the ‘Page’ column from Google Search Analytics queries as well as partial URLs like the Google Analytics ‘Full page URL’, ‘Landing Page’ and ‘Page path + query string’ columns.
The split function is one of over 30 analytics functions you can string together into an Analytics Edge macro to automate your analysis.
Stop struggling with formulas — download Analytics Edge today and get started for 30 days free.