SP UTM tags in the order and customer 2.x–3.x

SP UTM Tracking is a modern, lightweight, and fault-tolerant module for OpenCart 3, designed for accurate tracking of traffic sources, ad campaigns, and customer behavior. The module automatically intercepts UTM tags and referrer data when a user visits the site, securely stores them, and links them to placed orders and registered customer profiles.

What data (tags) does the module store? The system collects and processes 10 key parameters:

• Classic UTM tags: utm_source, utm_campaign, utm_medium, utm_content, utm_term, utm_referrer.
• Ad network IDs: gclid (Google Ads), fbclid (Facebook/Meta).
• First Referrer (first_referrer): The very first external source from which the user ever arrived at the site (stored for 365 days, helps track the real acquisition source).
• Last Referrer (last_referrer): The last recorded external source before the target action.

Note: If you are using SeoPro, you must ensure that all these tags are added to the exceptions list.

Main Features and Workflow Logic

• Smart Interception and Storage: Priority is given to URL parameters (GET requests). Data is saved in the session and long-term Cookies (for 90 days for regular tags and 1 year for first/last_referrer).
• Fail-Safe Mechanism: A built-in fallback mechanism saves data directly to the server session if HTTP headers were already mistakenly sent by another poorly coded module, preventing the loss of marketing data.
• Database Automation: Necessary columns are automatically created in the oc_order and oc_customer tables the moment the module is activated via the control panel.
• UI Integration: Tags are displayed in the general order list for quick viewing (Source and Campaign), as well as in a complete, neat list inside the order details and the customer edit page.
• 
  

Statistics Features (Dashboard) The module's control panel features a separate analytics tab powered by AJAX:

• Data Visualization: A modern doughnut chart (based on Chart.js) is generated for each individual metric. The tag name and the exact number of orders are displayed directly on the chart, eliminating the need to search for data in the legend.
• Flexible Filtering: Ability to set any calendar period (from and to) to analyze a specific advertising campaign.
• Abandoned Cart Analysis (Incomplete orders): Built-in order status toggle. You can view statistics for completed orders (status > 0) or switch to incomplete ones (status = 0). This allows marketers to quickly identify ad campaigns and keywords that yield "empty" traffic and lead to abandoned carts.