Overview

You can export ActiveCampaign contacts with a specific custom field value to a CSV file using the Advanced Task Editor Mode in a Skyvia Export integration.

Steps

1. Create a new Export integration.
2. Open it and switch to Advanced Task Editor Mode.
3. Add an Execute Command action.
4. Use the following query, replacing your field id with the actual custom field ID value from your ActiveCampaign connection:

SELECT Email, CreatedDate, Value
FROM (SELECT ContactId, Value
      FROM ContactCustomFieldValues
      WHERE FieldId = your field id) AS cfv
JOIN
     (SELECT Id, Email, CreatedDate
      FROM Contacts) AS ct
ON cfv.ContactId = ct.Id
GROUP BY Value

Note: Value contains the custom field value. Email serves as the unique contact identifier.

Result

The exported CSV will include:

• Contact email
• Contact created date
• Value of the custom field