analytics

Using parameters to create dynamic file paths in Excel queries

Parameters are an incredibly powerful tool when constructing queries in Microsoft Excel. And if your source data changes frequently, parameters can come in extremely handy to change multiple file names/paths hurry. For example, I had queries set up to pull data from about 30 spreadsheets from our finance department. Every month, they ran new reports […]

Read More
analytics

Internal campaign tracking with URL parameters

With Google Analytics, UTM tagging is essential for tracking inbound traffic from your marketing campaigns, but what if you want to track clicks originating within your site. In those instances, UTM tagging should never be used. Internal campaign tracking requires a different approach, but there is a simple workaround in Google Analytics using custom URL parameters.

Read More