Conversion attribution data from our AFL UTM Tracker plugin is saved in the following database tables.
Database Table
- WordPress (wp_usermeta)
- WooCommerce (wp_postmeta / wp_wc_orders_meta)
- Gravity Forms (wp_gf_entry_meta)
- Fluent Forms (wp_fluentform_submission_meta)
Meta List
Our meta data is prefix with (_afl_wc_utm_) with exception for user meta data:
- For standard conversion attribution (_afl_wc_utm_)
- For user registration attribution (wp_afl_wc_utm_)
- For active user attribution (wp_afl_wc_utm_active_)
Take note that you can access two types of URL values:
- a full URL with all query parameters.
- a clean URL without any query parameters.
== SESSION ==
Conversion Type:
_afl_wc_utm_conversion_type
Conversion Lag:
_afl_wc_utm_conversion_lag_human
Conversion Lag (seconds):
_afl_wc_utm_conversion_lag
Conversion Date:
_afl_wc_utm_conversion_date_local
_afl_wc_utm_conversion_date_utc
_afl_wc_utm_conversion_ts
Visit Date:
_afl_wc_utm_sess_visit_date_local
_afl_wc_utm_sess_visit_date_utc
_afl_wc_utm_sess_visit
Landing Page URL:
_afl_wc_utm_sess_landing
_afl_wc_utm_sess_landing_clean
Website Referer URL:
_afl_wc_utm_sess_referer
_afl_wc_utm_sess_referer_clean
Google Analytics Client ID:
_afl_wc_utm_sess_ga
Cookie Consent:
_afl_wc_utm_cookie_consent
== UTM CAMPAIGN (FIRST TOUCH) ==
UTM URL:
_afl_wc_utm_utm_1st_url
_afl_wc_utm_utm_1st_url_clean
Visit Date:
_afl_wc_utm_utm_1st_visit_date_local
_afl_wc_utm_utm_1st_visit_date_utc
_afl_wc_utm_utm_1st_visit
UTM Source:
_afl_wc_utm_utm_source_1st
UTM Medium:
_afl_wc_utm_utm_medium_1st
UTM Campaign:
_afl_wc_utm_utm_campaign_1st
UTM Term:
_afl_wc_utm_utm_term_1st
UTM Content:
_afl_wc_utm_utm_content_1st
== UTM CAMPAIGN (LAST TOUCH) ==
UTM URL:
_afl_wc_utm_utm_url
_afl_wc_utm_utm_url_clean
Visit Date:
_afl_wc_utm_utm_visit_date_local
_afl_wc_utm_utm_visit_date_utc
_afl_wc_utm_utm_visit
UTM Source:
_afl_wc_utm_utm_source
UTM Medium:
_afl_wc_utm_utm_medium
UTM Campaign:
_afl_wc_utm_utm_campaign
UTM Term:
_afl_wc_utm_utm_term
UTM Content:
_afl_wc_utm_utm_content
== Google Click Identifier (gclid) ==
URL:
_afl_wc_utm_gclid_url
_afl_wc_utm_gclid_url_clean
Visit Date:
_afl_wc_utm_gclid_visit_date_local
_afl_wc_utm_gclid_visit_date_utc
_afl_wc_utm_gclid_visit
gclid Value:
_afl_wc_utm_gclid_value
== Facebook Click Identifier (fbclid) ==
URL:
_afl_wc_utm_fbclid_url
_afl_wc_utm_fbclid_url_clean
Visit Date:
_afl_wc_utm_fbclid_visit_date_local
_afl_wc_utm_fbclid_visit_date_utc
_afl_wc_utm_fbclid_visit
fbclid Value:
_afl_wc_utm_fbclid_value
== Microsoft / Bing Click Identifier (msclkid) ==
URL:
_afl_wc_utm_msclkid_url
_afl_wc_utm_msclkid_url_clean
Visit Date:
_afl_wc_utm_msclkid_visit_date_local
_afl_wc_utm_msclkid_visit_date_utc
_afl_wc_utm_msclkid_visit
msclkid Value:
_afl_wc_utm_msclkid_value