• Exporting CSV of Unsubscribed Contacts from Mail Chimp and sending to FTP

Exporting CSV of Unsubscribed Contacts from Mail Chimp and sending to FTP

  • 510Views
  • Last Post 20 July 2017
  • Topic Is Solved
0
votes
Paul Johnson posted this 13 July 2017

Hi,

I am sure Skyvia can do this, but going round in circles if you can help!?

We have successfully connected to our MailChimp account, but we are trying to export a CSV of all contacts from a particular MailChimp list who have unsubscribed...

Can you help / advise how we can do this? We would hope to include some of our fields and of course the date the user unsubscribed.

Thanks in advance!

csv mailchimp ftp unsubscribes export
Order By: Standard | Newest | Votes
1
votes
Mariia Zaharova posted this 14 July 2017

Yes, you can implement this scenario via Skyvia. For this perform the following steps:

 

1) Create your MailChimp and FTP connections:

https://skyvia.com/resources/docs/index.html?connecting_to_mailchimp.htm

https://skyvia.com/resources/docs/index.html?ftp_connections.htm

2) Create new Export package with the MailChimp connection as Source and FTP connection as Target:

https://skyvia.com/resources/docs/index.html?export_package.htm

3) Click + Add task and select the ListMembers object

4) Select all the necessary fields and specify the filter conditions like it is shown below:

5) Save the task.

6) Set the schedule, if necessary, save the package and run it.

 

Please tell us if this information helps.

  • Supported by
  • Paul Johnson
0
votes
Paul Johnson posted this 14 July 2017

Hi,

This has helped a lot - Thankyou! The only data we cannot see available from Mail Chimp is the actual date a user unsubscribed...

Date Formats
==========

Do you know if there is anyway we can change a Mail Chimp date field format? For example we see the following:

29/06/2017 09:48

But it would help us if the format can be changed to:

29-Jun-2017

with no time...

Any help appreciated! Many thanks - Paul

0
votes
Mariia Zaharova posted this 17 July 2017

The only data we cannot see available from Mail Chimp is the actual date a user unsubscribed...

You can see this date in the LastUpdate column.

Do you know if there is anyway we can change a Mail Chimp date field format? For example we see the following...

This is a common universal date format and, unfortunately, at the moment, there is no way to change it.

0
votes
Paul Johnson posted this 20 July 2017

Thanks again for your support! Great work :-)

New Ticket
Categories
Popular Tags
Close