Mapping conversion attribution data with Webhook

You will be able to send the captured UTM parameters for your WooCommerce Orders to any webhook URL using our AFL UTM Tracker plugin and the WooCommerce Webhook feature.

In this example, we will be sending the data to Zapier’s webhook.

For a full list of conversion attribution values which you can access, please view our Attribution Meta List.

Compatibility:

• WooCommerce Order

Steps

1. Setup Zapier Webhook Trigger
2. Setup WooCommerce Webhook
3. Setup Code by Zapier
4. Mapping UTM parameters in Google Sheet

Setup Zapier Webhook Trigger

1. Sign-in into your Zapier account.
2. Create a Zap.
3. Find for the ‘Webhooks by Zapier’ trigger.
4. Set the Trigger Event to ‘Catch’.
5. Continue.
6. Copy Custom Webhook URL.
7. Continue.

Setup WooCommerce Webhook

1. Go to your WooCommerce > Settings.
2. Click the Advanced tab.
3. Click the Webhooks sub-tab.
4. Add webhook.
5. Type in a Name (e.g. Zapier Order Created).
6. Set the Status to Active.
7. Set the Topic to Order Created.
8. Paste the Zapier’s Custom Webhook URL into the Delivery URL field.
9. Save webhook.
10. Now try placing an Order through your checkout page.

Setup Code by Zapier

1. Go back to Zapier and click on Test Trigger.
2. You might need to retry the Test Trigger until WooCommerce sends out the data.
3. Continue.

4. Add a New Action.
5. Search for Code by Zapier.
6. Set the Action Event to Run Javascript
7. Continue.

8. Set up action > type metaData into the Input Data field.
9. In the right hand field, select 1. Meta Data as the value.
10. Copy and paste the JavaScript code below into the Zapier’s Code textarea.
11. Click on Continue.

12. Test action.
13. Click Retest & Review if needed.
14. You should see the values being populated like in the screenshot below.
15. Continue.

Mapping UTM parameters in Google Sheets

For this tutorial, we will show you how to map the data obtained from the JavsScript action to your Google Sheet.

1. Create a Google Sheet in your Google Drive.
2. Add 4 columns:
   1. Order ID
   2. First UTM Source
   3. First UTM Medium
   4. Last UTM Source
   5. Last UTM Medium
3. In Zapier, add a new Action to ‘Create Spreadsheet Row in Google Sheets’.
4. Select the Google Sheet from your Google Drive.
5. Select your Worksheet.
6. Refresh your fields if you don’t see any columns.
7. To map the First UTM Source field, select the dropdown > Run Javascript > Afl Wc Utm Utm Source 1st.
8. Continue mapping for the other fields.
9. Click on Continue.
10. Turn on Zap.