Create Full URLs from Google Analytics in Excel or Google Sheets
Google Analytics uses URIs instead of URLs by default. But that makes it difficult to marry your data with data from other marketing tools. This video will show you how to create full URLs from Google Analytics content reports, whether your site uses one subdomain or multiple subdomains. This process is called concatenation and could also be accomplished with the CONCATENATE function, but I find it clunky. Although I demonstrate how to do this in Excel, the steps are exactly the same in Google Sheets.