Mapping conversion attribution data in Pabbly Connect

You can easily send the captured UTM parameters from your WooCommerce Orders to Pabbly Connect using our AFL UTM Tracker plugin.

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

Steps

Create a WooCommerce Trigger

1. Login to Pabbly.com
2. Click into Pabbly Connect.
3. Create a new Trigger.
4. In the Choose App field, search for WooCommerce.
5. In the Trigger Event field, select ‘New Order Created‘.
6. Follow the on-screen instructions to add a Webhook in your WooCommerce > Settings.
7. Disable the Simple Response slider.
8. Click the ‘Capture Webhook Response’ button.

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. Copy the Webhook URL from Pabbly 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. Checkout and place the order.

Receive the Pabbly Webhook Response

1. Wait for Pabbly to receive the WooCommerce webhook response.
2. Proceed to the next step.

Add a WooCommerce Meta Data Extractor Action Step

1. Click the + sign to add a new action step.
2. In the Choose App field, search for the Data Transformer by Pabbly.
3. In the Action Event field, select the WooCommerce Meta Data Extractor.
4. Click the Save button.

Add a Google Sheet Action Step

1. In your Google Drive, create a new Google Sheet or use an existing Sheet.
2. Add 3 new columns (UTM Source, UTM Medium and UTM Campaign) into the Sheet.
3. In Pabbly, click on the + sign to add a new action step.
4. In the Choose App field, search for Google Sheets.
5. In the Action Event field, select ‘Add New Row’.
6. Click the Connect button and login to your Google Account to authorize access.
7. Select your Spreadsheet.
8. Select Sheet 1.
9. Map the columns to the appropriate data.
10. Save & Send Test Request.
11. Done!