GA Parameters Extractor
About the GA Parameters Extractor add-on for Google Sheets
The GA Parameters Extractor add-on for Google Sheets connects to your Google Analytics accounts to help you spot unwanted query string parameters in your Google Analytics views that may distort your page metrics, expose personal information, or simply dirty the URLs of a website.
It lists all the query string parameters that appear in a Google Analytics view of your choice and lets you know in how many unique URLs they were seen (occurrences), how many times they were seen in total (views) and gives you an example URL in which the parameter was spotted.
Instructions for use
Click here to access the add-on's download page in Google's store or, in Google Sheets, click on "Add-ons" in the top menu, select "Get Add-ons..." and type "GA Parameters Extractor" in the search bar. Click on the "+ Free" button to install the add-on.
To launch the add-on, open a Google Sheet spreadsheet, click "Add-ons" in the top menu, select "GA Parameters Extractor" and then click "Start" to open the sidebar.
Select one of the Google Analytics account you have access to, then select one of this account's properties and one view. Choose the time frame of your report by filling the "start date" and "end date" fields. Click the "generate report" button to generate your report in a new sheet.
Known errors and exceptions
"No Google Analytics account found"
The Google account that you are currently using is not linked to any Google Analytics account, or none that the Google account your are currently using has access to.
"No property found for this Google Analytics account"
The selected Google Analytics account does not have any property yet, or none that the Google account you are currently using has access to.
"No view found for this Google Analytics property"
The selected Google Analytics property does not have any view yet, or none that the Google account you are currently using has access to.
"You do not have sufficient permissions to retrieve data from this Google Analytics view"
The Google account you are currently using is only allowed to read data from the selected Google Analytics view, therefore you are not allowed to import data from this view to Google Sheets.
"This Google Analytics view did not record any pageviews for the requested period"
The selected Google Analytics view did not record any visit for the requested period, either because no visitor actually saw any page within the studied domain or because the Analytics tools installed on the studied website(s) do not send any data to Google Analytics.
"No parameter was found for this Google Analytics view"
From all the URLs processed by the GA Parameters Extractor within the selected period of time, none contained query string parameters.
"Your report is based on a sample"
The GA Parameters Extractor add-on is using the Google Analytics Core Reporting API v3, which allows up to 10 000 requests per user per day (see details here). Hence the number of pagepaths one user can process per day with the add-on is limited to 10 000. If your request exceed this limit, your report will be base on a sample. This behaviour is similar to that of Google Analytics' graphical interface to the extent of one detail. In Google Analytics' graphical interface, when sampling is applied to a report, the user gets to choose between two options: "greater precision" and "faster response". In the GA Parameters Extrator, the method in use is a combination of both of these options. Thus, there might be slight differences in the data displayed by the graphical interface and the add-on.
"An error occurred"
Messages beginning as such will appear only when your request times out because the servers took too long to answer or your computer failed to process it (rare). Any other source is yet unknown.
Terms of service
The GA Parameters Extractor add-on for Google Sheets is a product of Woptimo.
The GA Parameters Extractor add-on for Google Sheets uses the Analytics Management API v3 and the Analytics Core Reporting API v3 (see terms here).
As stated in Google Apps Script's terms of service regarding end users of add-ons, users download and use add-on without any guarantee or warranty of any sort. Therefore Woptimo declines any responsibility mentionned in these terms and decline cannot be held accountable for any damage related to the use of the GA Parameters Extractor add-on.
The GA Parameters Extractor add-on for Google Sheets is hosted on Google Apps servers and all the data the user imports through the GA Parameters Extractor add-on stays within your Google Account. Therefore, both the add-on and the user's data fall within the Terms of Services the user has already agreed on with Google. Woptimo will not see or keep any of the user's data.
Please note that these terms may be subject to change.