The WordPress User Registration Attribution is the conversion attribution of when the user sign-up for a WordPress Account. The attribution 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_
WordPress Multisite
wp_<blog_id>_afl_wc_utm_
For main site, there is no blog ID required
wp_afl_wc_utm_
Cross-subdomain Activated
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):
wp_afl_wc_utm_conversion_type
Conversion Lag (x days y hours or x minutes y seconds):
wp_afl_wc_utm_conversion_lag_human
Conversion Lag (seconds):
wp_afl_wc_utm_conversion_lag
Conversion Date:
wp_afl_wc_utm_conversion_date_local
wp_afl_wc_utm_conversion_date_utc
wp_afl_wc_utm_conversion_ts
First Visit Date:
wp_afl_wc_utm_sess_visit_date_local
wp_afl_wc_utm_sess_visit_date_utc
wp_afl_wc_utm_sess_visit
First Landing Page URL:
wp_afl_wc_utm_sess_landing
wp_afl_wc_utm_sess_landing_clean
First Website Referer URL:
wp_afl_wc_utm_sess_referer
wp_afl_wc_utm_sess_referer_clean
Google Analytics Client ID:
wp_afl_wc_utm_sess_ga
Cookie Consent (allow or deny or n/a):
wp_afl_wc_utm_cookie_consent
First Touch UTM URL
UTM URL:
wp_afl_wc_utm_utm_1st_url
wp_afl_wc_utm_utm_1st_url_clean
Visit Date:
wp_afl_wc_utm_utm_1st_visit_date_local
wp_afl_wc_utm_utm_1st_visit_date_utc
wp_afl_wc_utm_utm_1st_visit
UTM Source:
wp_afl_wc_utm_utm_source_1st
UTM Medium:
wp_afl_wc_utm_utm_medium_1st
UTM Campaign:
wp_afl_wc_utm_utm_campaign_1st
UTM Term:
wp_afl_wc_utm_utm_term_1st
UTM Content:
wp_afl_wc_utm_utm_content_1st
Custom Parameter:
wp_afl_wc_utm_utm_<custom_parameter>_1st
Last Touch UTM URL
UTM URL:
wp_afl_wc_utm_utm_url
wp_afl_wc_utm_utm_url_clean
Visit Date:
wp_afl_wc_utm_utm_visit_date_local
wp_afl_wc_utm_utm_visit_date_utc
wp_afl_wc_utm_utm_visit
UTM Source:
wp_afl_wc_utm_utm_source
UTM Medium:
wp_afl_wc_utm_utm_medium
UTM Campaign:
wp_afl_wc_utm_utm_campaign
UTM Term:
wp_afl_wc_utm_utm_term
UTM Content:
wp_afl_wc_utm_utm_content
Custom Parameter *:
wp_afl_wc_utm_utm_<custom_parameter>
Click Identifiers
Google Click Identifier (gclid)
URL:
wp_afl_wc_utm_gclid_url
wp_afl_wc_utm_gclid_url_clean
Visit Date:
wp_afl_wc_utm_gclid_visit_date_local
wp_afl_wc_utm_gclid_visit_date_utc
wp_afl_wc_utm_gclid_visit
gclid Value:
wp_afl_wc_utm_gclid_value
Facebook Click Identifier (fbclid)
URL:
wp_afl_wc_utm_fbclid_url
wp_afl_wc_utm_fbclid_url_clean
Visit Date:
wp_afl_wc_utm_fbclid_visit_date_local
wp_afl_wc_utm_fbclid_visit_date_utc
wp_afl_wc_utm_fbclid_visit
fbclid Value:
wp_afl_wc_utm_fbclid_value
Microsoft / Bing Click Identifier (msclkid)
URL:
wp_afl_wc_utm_msclkid_url
wp_afl_wc_utm_msclkid_url_clean
Visit Date:
wp_afl_wc_utm_msclkid_visit_date_local
wp_afl_wc_utm_msclkid_visit_date_utc
wp_afl_wc_utm_msclkid_visit
msclkid Value:
wp_afl_wc_utm_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_<click_identifier>_url
wp_afl_wc_utm_<click_identifier>_url_clean
Visit Date:
wp_afl_wc_utm_<click_identifier>_visit_date_local
wp_afl_wc_utm_<click_identifier>_visit_date_utc
wp_afl_wc_utm_<click_identifier>_visit
Click Identifier Value:
wp_afl_wc_utm_<click_identifier>_value