MemberId on ClickedMembers

  • 26Views
  • Last Post 13 November 2017
0
votes
Raja posted this 24 October 2017

Dear Team,

I am using Skyvia for Integration purpose.
I need data about Opened Members and Clicked Members.

Under Opened Members, I have ListMemberId column which serves as external Id in my application for any UPSERT operation. However, When I look for Clicked Member I don't get the option to choose ListMemberId.

 

Please help and look for the attachment for your reference.

 

 

Thanks,

Raja

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 24 October 2017

We will investigate this behaviour and contact you as soon as possible.

 

Best regards,

Mariia

0
votes
Mariia Zaharova posted this 13 November 2017

We have investigated the issue. Unfortunately, MailChimp API doesn't return the MemberId value (leid) for ClickedMembers table and, thus, we cannot make any changes so that ClickedMembers table includes this field. However, ClickedMembers table includes ListId and Email fields, so, if you need to use this CSV file (results file of your export task) in Import task, you can use Lookup mapping with the ListId and Email fields to get the necessary Id from the ListMembers table.

Close