CleverReach

CleverReach is an email marketing tool that makes sending newsletters fast and easy.

Data integration: Skyvia supports importing data to and from CleverReach, exporting CleverReach data to CSV files, replicating CleverReach data to relational databases.

Backup: Skyvia Backup does not support CleverReach.

Query: Skyvia Query supports CleverReach.

CleverReach-Specific Features and Limitations

Skyvia has the following limitations for CleverReach:

  • In the Data Integration product, CleverReach connections are supported only for packages, which use a new data integration runtime.

    Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use CleverReach in your package.

  • Skyvia supports DML operations for such CleverReach objects:
    • INSERT, UPDATE, DELETE: Blacklists, GlobalAttributes, Groups, GroupAttributes, GroupReceivers, GroupReceiverOrders, ReceiverOrders.
    • UPDATE: GroupReceiverAttributes.
  • Skyvia supports Replication with Incremental Updates only for the Blacklists table. This table has the CreatedDate field only, there is no UpdatedDate field, it means that only newly created records could be replicated incrementally. Updated and deleted records do not take part in Incremental Replication.

  • Synchronization for CleverReach is not supported.

  • To update data in the GroupReceivers table you can use the stored procedures:

    Use call ActivateReceiver(:group_id,:Id) to update the value in the Activated field. The value in the Deactivated field will be nulled if it was not null.

    Use call DeactivateReceiver(:group_id,:Id) to update the value in the Deactivated field.

    Use call RemoveReceiverTags(:Id,:Tags) to delete specific tags in the Tags field.

    If the specific record contains the array of tags, for example: [“Tag1”,”Tag2”,”Tag3”] and you need to delete Tag2 and Tag3, then the Tags value should look like ‘Tag2, Tag3’ when you call the procedure.

    You can use a call to the stored procedure, for example as a text of the command in the ExecuteCommand action in a Target component of a Data Flow.

  • The ReceiverOrders table displays the Orders related to the specific receiver regardless of the list the recipient belongs to.

    If one receiver belongs to two lists, there will be two records with the different GroupId values and equal values of all other fields in the ReceiverOrders table.

  • The GroupReceiverOrders displays the orders related to the specific receiver and specific list, which this receiver belongs to.

CleverReach Connections

To connect to CleverReach, you need to perform the following steps:

  1. Click +NEW in the top menu.
  2. Open the Select Connector page by clicking Connection in the menu on the left.
  3. In the opened page, click CleverReach.
  4. Click Sign In with CleverReach. Connection window

  5. Click Log in with my existing CleverReach account and connect if you already have an account. Sign up or sign in

  6. Enter your CleverReach credentials and click Log in now and connect Skyvia! entering credentials

  7. Optionally, select the Suppress Extended Requests checkbox to reduce the number of API calls.
  8. Use the Test Connection button to make sure that the connection is successful and then click Create Connection.

Supported Actions and Actions Specifics

Clever Reach connector supports the following actions: