User Active Attribution Meta List

The WordPress User Active Attribution is the latest attribution of the user when the user was logged-in. It is stored in the wp_user meta database table.

Meta Prefix

The attribution data has the following meta prefix depending on your WordPress installation:

Standard WordPress

wp_afl_wc_utm_active_

WordPress Multisite

wp_<blog_id>_afl_wc_utm_active_

For main site, there is no blog ID required
wp_afl_wc_utm_active_

Cross-subdomain Activated
afl_wc_utm_active_

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):
wp_afl_wc_utm_active_conversion_type

Conversion Lag (x days y hours or x minutes y seconds):
wp_afl_wc_utm_active_conversion_lag_human

Conversion Lag (seconds):
wp_afl_wc_utm_active_conversion_lag

Conversion Date:
wp_afl_wc_utm_active_conversion_date_local
wp_afl_wc_utm_active_conversion_date_utc
wp_afl_wc_utm_active_conversion_ts

First Visit Date:
wp_afl_wc_utm_active_sess_visit_date_local
wp_afl_wc_utm_active_sess_visit_date_utc
wp_afl_wc_utm_active_sess_visit

First Landing Page URL:
wp_afl_wc_utm_active_sess_landing
wp_afl_wc_utm_active_sess_landing_clean

First Website Referer URL:
wp_afl_wc_utm_active_sess_referer
wp_afl_wc_utm_active_sess_referer_clean

Google Analytics Client ID:
wp_afl_wc_utm_active_sess_ga

Cookie Consent (allow or deny or n/a):
wp_afl_wc_utm_active_cookie_consent

First Touch UTM URL

UTM URL:
wp_afl_wc_utm_active_utm_1st_url
wp_afl_wc_utm_active_utm_1st_url_clean

Visit Date:
wp_afl_wc_utm_active_utm_1st_visit_date_local
wp_afl_wc_utm_active_utm_1st_visit_date_utc
wp_afl_wc_utm_active_utm_1st_visit

UTM Source: 
wp_afl_wc_utm_active_utm_source_1st

UTM Medium: 
wp_afl_wc_utm_active_utm_medium_1st

UTM Campaign: 
wp_afl_wc_utm_active_utm_campaign_1st

UTM Term: 
wp_afl_wc_utm_active_utm_term_1st

UTM Content:
wp_afl_wc_utm_active_utm_content_1st

Custom Parameter:
wp_afl_wc_utm_active_utm_<custom_parameter>_1st

Last Touch UTM URL

UTM URL:
wp_afl_wc_utm_active_utm_url
wp_afl_wc_utm_active_utm_url_clean

Visit Date:
wp_afl_wc_utm_active_utm_visit_date_local
wp_afl_wc_utm_active_utm_visit_date_utc
wp_afl_wc_utm_active_utm_visit

UTM Source:
wp_afl_wc_utm_active_utm_source

UTM Medium:
wp_afl_wc_utm_active_utm_medium

UTM Campaign:
wp_afl_wc_utm_active_utm_campaign

UTM Term:
wp_afl_wc_utm_active_utm_term

UTM Content:
wp_afl_wc_utm_active_utm_content

Custom Parameter *:
wp_afl_wc_utm_active_utm_<custom_parameter>

Click Identifiers

Google Click Identifier (gclid)

URL:
wp_afl_wc_utm_active_gclid_url
wp_afl_wc_utm_active_gclid_url_clean

Visit Date:
wp_afl_wc_utm_active_gclid_visit_date_local
wp_afl_wc_utm_active_gclid_visit_date_utc
wp_afl_wc_utm_active_gclid_visit

gclid Value:
wp_afl_wc_utm_active_gclid_value

Facebook Click Identifier (fbclid)

URL:
wp_afl_wc_utm_active_fbclid_url
wp_afl_wc_utm_active_fbclid_url_clean

Visit Date:
wp_afl_wc_utm_active_fbclid_visit_date_local
wp_afl_wc_utm_active_fbclid_visit_date_utc
wp_afl_wc_utm_active_fbclid_visit

fbclid Value:
wp_afl_wc_utm_active_fbclid_value

Microsoft / Bing Click Identifier (msclkid)

URL:
wp_afl_wc_utm_active_msclkid_url
wp_afl_wc_utm_active_msclkid_url_clean

Visit Date:
wp_afl_wc_utm_active_msclkid_visit_date_local
wp_afl_wc_utm_active_msclkid_visit_date_utc
wp_afl_wc_utm_active_msclkid_visit

msclkid Value:
wp_afl_wc_utm_active_msclkid_value

Custom Click Identifier **

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

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

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

Click Identifier Value:
wp_afl_wc_utm_active_<click_identifier>_value