Untitled

Oct 18, 2026 00:18 UTC1 day ago67 lines2502 charsExpires: Never

LIVING+ LEAD EXPORT - COLUMN GUIDE
==================================
WHO THEY ARE
------------
lead_id Unique ID for this sign-up
created_at When they submitted (UTC)
form_id Which form (wl-endurance = the Endurance copy page)
first_name As typed
last_name As typed
email Lowercased
phone Converted to +1 format, blank if left empty
state Two-letter state
interest Always "unsure" (preference question removed)
CONSENT
-------
consent_terms 1 = agreed to the terms and confirmed 18+ (pressing the button)
consent_email 1 = agreed to marketing emails (pressing the button)
consent_sms 1 = ticked the text-message box, 0 = did not
consent_version Which consent wording they saw (v2 = current page)
consent_hash Fingerprint of that exact wording, for proof
consent_text_terms Exact terms wording they agreed to
consent_text_email Exact email wording they agreed to
consent_text_sms Exact text-message wording they agreed to
PROOF / DEVICE
--------------
ip Their IP address (part of the consent record)
user_agent Their browser and device
page_url Exact page address they signed up on, with tracking tags
referrer Site that sent them, if the browser reported one
visitor_id Ties the sign-up to their page views in the click gateway
WHERE THEY CAME FROM
--------------------
utm_source Ad/campaign source tag
utm_medium Ad/campaign medium tag
utm_campaign Campaign name tag
utm_content Ad content tag
utm_term Keyword tag
gclid Google Ads click ID
fbclid Facebook click ID
couponCode Discount code in their link, if any
QUALITY FLAGS
-------------
fill_ms How long they took to fill the form (thousandths of a second)
spam 1 = bot (hidden field filled, or under 1.5 seconds)
Bots are left out of the export unless you add &spam=1
blocked 1 = Louisiana (GLP-1 treatment not allowed there)
duplicate 1 = same email already signed up in the last 24 hours
IGNORE (GHL sync is off)
------------------------
ghl_status Always "pending"
ghl_contact_id Blank
ghl_attempts 0
ghl_error Blank
ghl_synced_at Blank
BUILDING LISTS
--------------
Email list: spam=0 AND duplicate=0 AND consent_email=1
Text list: spam=0 AND duplicate=0 AND consent_sms=1
```

LIVING+ LEAD EXPORT - COLUMN GUIDE
==================================

WHO THEY ARE
------------
lead_id            Unique ID for this sign-up
created_at         When they submitted (UTC)
form_id            Which form (wl-endurance = the Endurance copy page)
first_name         As typed
last_name          As typed
email              Lowercased
phone              Converted to +1 format, blank if left empty
state              Two-letter state
interest           Always "unsure" (preference question removed)

CONSENT
-------
consent_terms      1 = agreed to the terms and confirmed 18+ (pressing the button)
consent_email      1 = agreed to marketing emails (pressing the button)
consent_sms        1 = ticked the text-message box, 0 = did not
consent_version    Which consent wording they saw (v2 = current page)
consent_hash       Fingerprint of that exact wording, for proof
consent_text_terms Exact terms wording they agreed to
consent_text_email Exact email wording they agreed to
consent_text_sms   Exact text-message wording they agreed to

PROOF / DEVICE
--------------
ip                 Their IP address (part of the consent record)
user_agent         Their browser and device
page_url           Exact page address they signed up on, with tracking tags
referrer           Site that sent them, if the browser reported one
visitor_id         Ties the sign-up to their page views in the click gateway

WHERE THEY CAME FROM
--------------------
utm_source         Ad/campaign source tag
utm_medium         Ad/campaign medium tag
utm_campaign       Campaign name tag
utm_content        Ad content tag
utm_term           Keyword tag
gclid              Google Ads click ID
fbclid             Facebook click ID
couponCode         Discount code in their link, if any

QUALITY FLAGS
-------------
fill_ms            How long they took to fill the form (thousandths of a second)
spam               1 = bot (hidden field filled, or under 1.5 seconds)
                   Bots are left out of the export unless you add &spam=1
blocked            1 = Louisiana (GLP-1 treatment not allowed there)
duplicate          1 = same email already signed up in the last 24 hours

IGNORE (GHL sync is off)
------------------------
ghl_status         Always "pending"
ghl_contact_id     Blank
ghl_attempts       0
ghl_error          Blank
ghl_synced_at      Blank

BUILDING LISTS
--------------
Email list:  spam=0  AND  duplicate=0  AND  consent_email=1
Text list:   spam=0  AND  duplicate=0  AND  consent_sms=1
```