Learn how to upsert records from Mailchimp to MySQL using Data Flow In Skyvia.

Skyvia website: [ Ссылка ]

Learn how to create connections here: [ Ссылка ]

Lookup description: [ Ссылка ]

Table example we used:

CREATE TABLE demobase2.listmembers (
Email varchar(100) NOT NULL,
ListID varchar(50) NOT NULL,
Status varchar(20) DEFAULT NULL,
EmailClient varchar(100) DEFAULT NULL,
UnsubscribeReason varchar(255) DEFAULT NULL,
AverageOpenRate double DEFAULT NULL,
AverageClickRate double DEFAULT NULL,
FNAME varchar(255) DEFAULT NULL,
LNAME varchar(255) DEFAULT NULL,
ADDRESS text DEFAULT NULL,
PHONE varchar(255) DEFAULT NULL,
LastUpdate datetime DEFAULT NULL,
CreatedDate datetime DEFAULT NULL,
VIP tinyint(1) DEFAULT NULL,
SubscriberID bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (SubscriberID)
)
ENGINE = INNODB;

свернуть