Exporting conversion attribution report in WooCommerce

Since WooCommerce does not have a built-in Order export tool, you can use any third-party WooCommerce Order Export plugin in the market that supports custom meta fields.

Take note that for this to work with third-party export plugins, the Attribution Data Format setting needs to be ‘Standard’ (refer to the AFL UTM Tracker > Settings > Site Performance section).

Here’s a list of export plugin which we have tried:

• Advanced Order Export for WooCommerce (How to export custom fields?)

List of Order Meta Fields

== General ==

Conversion Type:
_afl_wc_utm_conversion_type

Conversion Lag (readable):
_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:
_afl_wc_utm_sess_landing
_afl_wc_utm_sess_landing_clean

Website Referer:
_afl_wc_utm_sess_referer
_afl_wc_utm_sess_referer_clean

Google Analytics Client ID:
_afl_wc_utm_sess_ga

== 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

First UTM Source:
_afl_wc_utm_utm_source_1st

First UTM Medium:
_afl_wc_utm_utm_medium_1st

First UTM Campaign:
_afl_wc_utm_utm_campaign_1st

First UTM Term:
_afl_wc_utm_utm_term_1st

First 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

Last UTM Source:
_afl_wc_utm_utm_source_1st

Last UTM Medium:
_afl_wc_utm_utm_medium_1st

Last UTM Campaign:
_afl_wc_utm_utm_campaign_1st

Last UTM Term:
_afl_wc_utm_utm_term_1st

Last UTM Content:
_afl_wc_utm_utm_content_1st

== GOOGLE (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

Value:
_afl_wc_utm_gclid_value

== FACEBOOK (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

Value:
_afl_wc_utm_fbclid_value

== Microsoft / Bing (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

Value:
_afl_wc_utm_msclkid_value