Mtm_cid (gclid) Converted to lower case

Saens · February 23, 2023, 11:11am

I’m tagging my google ads clicks with the mtm_cid parameter which is filled with the gclid by google.
It seems Matomo converts this (and other tags) to lower case.
Is there a way to keep proper capitalization? Gclid in all lower case is useless for proper conversion reporting.

heurteph-ei · March 8, 2023, 9:48am

Hi @Saens
It seems an issue has already been created about this:

github.com/matomo-org/matomo

Refactor handling of campaign parameters

opened 08:32AM - 04 Nov 22 UTC

sgiehl

c: Tracking

Currently all campaign parameters tracked in core (as well as in MarketingCampai…gnsReporting plugin) are stored on lower case in the database. This is actually a manipulation of the provided data we should avoid as there might be reasons why this might cause trouble. For example a click id might contain upper and lower case letters, changing them might make the click id not usable anymore, as it differs from the one stored on the advertising network. We should remove the code that lowers the data in core as well as in the plugin. To achieve some sort of backwards compatibility we could introduce config values for each report, to configure if the report should be generated case sensitive or insensitive. For new installs this could be directly set to case sensitive. Old installs would set it to case insensitive using an update script to keep bc. Alternatively we could also add a visualization option to enable case in-/sensitivity in the UI maybe. The solution we implement in core also needs to be implemented in MarketingCampaignsReporting plugin. follow-up to https://github.com/matomo-org/plugin-MarketingCampaignsReporting/pull/65 see also https://github.com/matomo-org/plugin-MarketingCampaignsReporting/issues/27