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.

Establishing Connection

To create a connection, log in with CleverReach account. Skyvia stores only the OAuth authentication token. Skyvia does not store your credentials.

Creating Connection

  1. In the Connection Editor click Sign In with CleverReach. Connection window

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

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

  4. Use the Test Connection button to make sure that the connection is successful and then click Create Connection.

Additional Connection Parameters

Suppressing Extended Requests

CleverReach API returns only part of the fields for some objects when querying multiple records. To query the values of additional fields, Skyvia performs additional extended requests for each record of such an object. However, this can decrease performance and significantly increase the number of API calls.

To reduce the number of API calls, select the Suppress Extended Requests checkbox. However, please note that some of the fields in such objects will not be available in Skyvia (will return empty values) even if they have values in CleverReach because its API does not return them without extended requests.

Connector Specifics

Object Peculiarities

  • The ReceiverOrders object displays the Orders related to the specific receiver regardless of the list this receiver 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 object displays the orders related to the specific receiver and specific list, which this receiver belongs to.

Stored Procedures

A part of the CleverReach functionality is supported in Skyvia as stored procedures:

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

call DeactivateReceiver(:group_id,:Id) — updates the value in the Deactivated field.

call RemoveReceiverTags(:Id,:Tags)— deletes specific tags in the Tags field.

For example, if the specific record contains the array of tags [“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 or in Query.

DML Operations Support

Skyvia supports DML operations for such CleverReach objects:

Operation Object
INSERT, UPDATE, DELETE Blacklists, GlobalAttributes, Groups, GroupAttributes, GroupReceivers, GroupReceiverOrders, ReceiverOrders
UPDATE GroupReceiverAttributes

Incremental Replication and Synchronization

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.

Skyvia does not support Synchronization for CleverReach.

Supported Actions

Skyvia supports all the common actions for CleverReach.