Attribution Meta List

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

Database Table

WordPress User (wp_usermeta)
Easy Digital Downloads (wp_edd_ordermeta, wp_edd_customermeta)
Flamingo for Contact Form 7 (wp_postmeta)
Fluent Forms (wp_fluentform_submission_meta)
Gravity Forms (wp_gf_entry_meta)
Ninja Forms (wp_postmeta)
WooCommerce (wp_postmeta / wp_wc_orders_meta)

For User Attribution

Meta Prefix

Our meta data has the following prefix with exception for the user meta table:

_afl_wc_utm_

Meta List

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.

* For Custom Parameter usage, you first need to setup the plugin settings.

General

Conversion Type (lead or order):
_afl_wc_utm_conversion_type

Conversion Lag (x days y hours or x minutes y seconds):
_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

First Visit Date:
_afl_wc_utm_sess_visit_date_local
_afl_wc_utm_sess_visit_date_utc
_afl_wc_utm_sess_visit

First Landing Page URL:
_afl_wc_utm_sess_landing
_afl_wc_utm_sess_landing_clean

First 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 (allow or deny or n/a):
_afl_wc_utm_cookie_consent

First Touch UTM URL

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

Custom Parameter:
_afl_wc_utm_utm_<custom_parameter>_1st

Last Touch UTM URL

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

Custom Parameter *:
_afl_wc_utm_utm_<custom_parameter>

Click Identifiers

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

Custom Click Identifier **

** For Custom Click Identifier usage, you first need to setup the plugin settings.

Click Identifier URL:
_afl_wc_utm_<click_identifier>_url
_afl_wc_utm_<click_identifier>_url_clean

Visit Date:
_afl_wc_utm_<click_identifier>_visit_date_local
_afl_wc_utm_<click_identifier>_visit_date_utc
_afl_wc_utm_<click_identifier>_visit

Click Identifier Value:
_afl_wc_utm_<click_identifier>_value

AFL UTM Tracker Documentation