AFL UTM Tracker Documentation

  1. Home
  2. Docs
  3. AFL UTM Tracker Documentation
  4. Developer
  5. Attribution Meta List

Attribution Meta List

Conversion attribution data from our AFL UTM Tracker plugin is saved in the following database tables.

Database Table

  • WordPress (wp_usermeta)
  • WooCommerce (wp_postmeta)
  • 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