Mapping conversion attribution data in Zapier

You can send the UTM parameters of your WooCommerce Order to any of Zapier’s apps by using our AFL UTM Tracker plugin and the WooCommerce Zapier plugin.

In this Zapier example, we will show you how to send the First Touch UTM and Last Touch UTM of your WooCommerce Orders to Google Sheet.

The steps are similar if you’re planning to send the attribution data to your CRM app.

Requirements

• WooCommerce Zapier plugin
• Zapier Pro plan

Steps

1. Create a Trigger for a WooCommerce Order
2. Setup Code by Zapier
3. Mapping UTM parameters in Google Sheets

Create a Trigger for a WooCommerce Order

1. Search for the WooCommerce app and set the Trigger Event to Order.
2. Connect your WooCommerce account to Zapier.
3. Set the Trigger Rule to Order Created.

Setup Code by Zapier

1. Add a New Action.
2. Search for Code by Zapier.
3. Set the Action Event to Run Javascript
4. 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.

What does each meta value represents?

Please refer to our Attribution Meta List to know what each meta represents.