Mapping conversion attribution data in Integromat (Make)

You can easily send the captured UTM parameters from your WooCommerce Orders to Integromat / Make using our AFL UTM Tracker plugin.

For this Integromat example, we will send the UTM Source, UTM Medium and UTM Campaign value from your WooCommerce Order to a Google Sheet.

Steps

Create a new Integromat Scenario

1. Login to Integromat.com or Make.com.
2. Create a new Scenario.
3. Add a new Module > Webhooks > Custom webhook.

Create a new Webhook in WooCommerce

1. Go to your WooCommerce admin.
2. Under WooCommerce > Settings > Advanced > Webhook.
3. Create a new Webhook.
4. Enter a suitable Name.
5. Set the Status to Active.
6. Set the Topic to ‘Order created‘.
7. In Integromat, copy the Webhook address to clipboard and paste into the Delivery URL below.
8. Save webhook.

Create a test WooCommerce Order

1. Generate a UTM campaign URL using Google Campaign URL Builder.
2. Open the campaign URL in a Incognito/Private Browser mode to simulate a new visitor.
3. Add an item to your cart.
4. In Integromat and under your Webhook module, click on the ‘Redetermine data structure’ button.
5. Checkout from your website and place the order.
6. In Integromat, wait for the Webhook module to show successful.

Create a Google Sheet

1. Go to your Google Drive.
2. Create a new Google Sheet.
3. Create 4 columns (Order ID, UTM Source, UTM Medium, UTM Campaign)

Add a Google Sheet Module

1. In Integromat, add a new Google Sheet Module.
2. Choose Add Row.
3. Select your Spreadsheet.
4. Select your Sheet.

The captured UTM parameters from our WordPress plugin will be stored in the WooCommerce Order meta data.

To map your Google Sheet columns to the WooCommerce Order Meta data, you would need to use a formula to extract the meta data value (see screenshot below).

To extract the Last UTM Source value, copy and paste the following formula into field.

{{get(map(3.meta_data; "value"; "key"; "_afl_wc_utm_utm_source"); 1)}}

To extract the Last UTM Medium value:

{{get(map(3.meta_data; "value"; "key"; "_afl_wc_utm_utm_medium"); 1)}}

To extract the Last UTM Campaign value:

{{get(map(3.meta_data; "value"; "key"; "_afl_wc_utm_utm_campaign"); 1)}}

Then delete the black-colored label 3.meta_data and replace with your actual meta_data[] until it turned into a red-colored label.

For the full list of meta data names, please refer to our Attribution Meta list.

Final Test

1. Remember to Save your Scenario.
2. Click on the Run Once button.
3. Go to your website to add an item to your cart and checkout again.
4. Wait for data to be sent to your Google Sheet.
5. Done!