How to run win-back campaigns with Power Automate

My flows > New flow > Scheduled cloud flow

Create new scheduled cloud flow

Navigate to make.powerautomate.com and sign in with your Microsoft account. Click 'My flows' in the left sidebar, then 'New flow' at the top. Select 'Scheduled cloud flow' from the dropdown menu. Name your flow 'WooCommerce Win-back Tagger' and set it to run daily at 8 AM.

1. 1Click 'My flows' in the left navigation
2. 2Click the 'New flow' button at the top
3. 3Select 'Scheduled cloud flow' from the options
4. 4Enter 'WooCommerce Win-back Tagger' as the flow name
5. 5Set repeat interval to 'Daily' at 8:00 AM

Flow designer > New step > HTTP

Add WooCommerce connection

Click 'New step' below the recurrence trigger. Search for 'HTTP' in the connector search box and select 'HTTP'. Choose the 'HTTP - HTTP' action since WooCommerce uses REST API calls. You'll configure the actual API call in the next step.

1. 1Click the 'New step' button below the trigger
2. 2Type 'HTTP' in the search box
3. 3Select 'HTTP' from the connector list
4. 4Choose 'HTTP - HTTP' action

HTTP action configuration

Configure WooCommerce API call

Set Method to 'GET' and URI to your WooCommerce orders endpoint. The URL format is 'https://yourstore.com/wp-json/wc/v3/orders'. In Headers, add 'Authorization' with value 'Basic [base64-encoded-credentials]'. Add another header 'Content-Type' with value 'application/json'. In the URI parameters, add 'per_page=100' to fetch more orders per call.

1. 1Select 'GET' from the Method dropdown
2. 2Enter your WooCommerce REST API URL in URI field
3. 3Click 'Add new parameter' and select 'Headers'
4. 4Add Authorization header with your API credentials
5. 5Add Content-Type header set to 'application/json'

New step > Data Operations > Parse JSON

Parse WooCommerce response

Add a new step and search for 'Parse JSON'. Select 'Data Operations - Parse JSON' action. Click in the Content field and select 'body' from the dynamic content (HTTP response). You'll need to generate the schema by running a test call first, or manually create it based on WooCommerce order structure.

1. 1Click 'New step' below the HTTP action
2. 2Search for and select 'Parse JSON'
3. 3Click in Content field and select 'body' from dynamic content
4. 4Click 'Generate from sample' or paste WooCommerce order JSON schema

New step > Control > Apply to each

Filter customers by last purchase date

Add a new step and select 'Control - Apply to each'. Set the input to the parsed JSON array from WooCommerce orders. Inside the loop, add a 'Control - Condition' action. Configure it to check if the order date is older than 90 days using the expression 'sub(utcnow(),90)' compared to the order date field.

1. 1Add 'Apply to each' action
2. 2Select the orders array from Parse JSON output
3. 3Inside the loop, add a 'Condition' control
4. 4Set left side to order date from current item
5. 5Set condition to 'is less than'
6. 6Set right side to expression: sub(utcnow(),90)

Condition > Yes branch > New step > Mailchimp

Connect to Mailchimp

In the 'Yes' branch of your condition, add a new action and search for 'Mailchimp'. Select the Mailchimp connector and choose 'Add or update member' action. Click 'Sign in' when prompted and authenticate with your Mailchimp account. Grant Power Automate permission to access your Mailchimp lists and audience data.

1. 1Click 'Add an action' in the Yes branch
2. 2Search for 'Mailchimp' and select the connector
3. 3Choose 'Add or update member' action
4. 4Click 'Sign in' and authenticate with Mailchimp
5. 5Grant requested permissions

Mailchimp action configuration

Configure Mailchimp member update

Select your target audience from the List dropdown. Map the customer email from WooCommerce order data to the Email field. Set Status to 'subscribed' to ensure the contact remains active. In the Tags field, click 'Add new parameter' and add 'win-back' as a tag value. This tag will trigger your email campaign in Mailchimp.

1. 1Select your Mailchimp audience from List dropdown
2. 2Map customer email from WooCommerce data to Email field
3. 3Set Status to 'subscribed'
4. 4Click 'Show advanced options'
5. 5Add 'win-back' to the Tags field

HTTP action > Settings > Configure run after

Add error handling

Click the three dots on your HTTP action and select 'Settings'. Enable 'Configure run after' and check both 'is successful' and 'has failed' boxes. Add a parallel branch for failure handling with a 'Compose' action to log errors. This prevents the entire flow from stopping when individual API calls fail.

1. 1Click three dots menu on HTTP action
2. 2Select 'Settings' then 'Configure run after'
3. 3Check 'is successful' and 'has failed' boxes
4. 4Add a parallel branch after HTTP action
5. 5Add 'Compose' action in failure branch to log errors

Flow designer > Save > Test

Test and activate flow

Click 'Save' at the top right of the flow designer. Then click 'Test' and select 'I'll perform the trigger action'. Since this is a scheduled flow, click 'Run flow' to test immediately. Monitor the run history to verify customers are being tagged correctly in Mailchimp. Check your Mailchimp audience for new win-back tags.

1. 1Click 'Save' button at top right
2. 2Click 'Test' next to the Save button
3. 3Select 'I'll perform the trigger action'
4. 4Click 'Run flow' to test immediately
5. 5Monitor the run in the flow history

Use this expression in your condition to handle different WooCommerce date formats and ensure accurate 90-day calculations regardless of timezone.

// In your condition, use this expression for reliable date comparison
formatDateTime(
  addDays(utcnow(), -90),

// In your condition, use this expression for reliable date comparison
formatDateTime(
  addDays(utcnow(), -90),
  'yyyy-MM-ddTHH:mm:ss'
)

// For parsing WooCommerce dates that might include timezone info
formatDateTime(
  items('Apply_to_each')?['date_created'],
  'yyyy-MM-dd'
)

// Check if customer already has win-back tag to prevent duplicates
if(
  contains(body('Get_member_info')?['tags'], 'win-back'),
  false,
  true
)