Mailchimp Migration Guide

Availability:

Airbyte Cloud Airbyte OSS PyAirbyte

Support Level:

Airbyte Connector

Connector Version:

2.0.19(Last updated 3 months ago)

CDK Version:

3.9.6

Sync Success Rate:

Usage Rate:

Version 2.0.0 introduces changes in primary key for streams Segment Members and List Members.

1. Select Connections in the main nav bar.
   1. Select the connection(s) affected by the update.
2. Select the Replication tab. 1. Select Refresh source schema. 2. Select OK.
   note

   Any detected schema changes will be listed for your review.

3. Select Save changes at the bottom of the page. 1. Ensure the Reset affected streams option is checked.
   note

   Depending on destination type you may not be prompted to reset your data.

4. Select Save connection.
   note

   This will reset the data in your destination and initiate a fresh sync.

For more information on resetting your data in Airbyte, see this page.

Version 1.0.0 of the Source Mailchimp connector introduces a number of breaking changes to the schemas of all incremental streams. A full schema refresh and data reset are required when upgrading to this version.

1. Select Connections in the main navbar.
2. From the list of your existing connections, select the connection(s) affected by the update.
3. Select the Replication tab, then select Refresh source schema.

note

Any detected schema changes will be listed for your review. Select OK when you are ready to proceed.

4. At the bottom of the page, select Save changes. Ensure the Reset all streams option is checked.

note

Depending on the destination type, you may not be prompted to reset your data

5. Select Save connection. This will reset the data in your destination (if applicable) and initiate a fresh sync.

• The ._links field, which contained non-user-relevant Mailchimp metadata, has been removed from all streams.
• All instances of datetime fields have had their type changed from string to airbyte-type timestamp-with-timezone. This change should ensure greater precision and consistency in how datetime information is represented and processed by destinations.
• The Mailchimp API returns many fields without data as empty strings. To accomodate the above changes, empty strings are now converted to null values:

{"id": "record_id", "last_opened": ""} -> {"id": "record_id", "last_opened": null}

• Automations:

  • create_time
  • send_time

• Campaigns:

  • create_time
  • send_time
  • rss_opts.last_sent
  • ab_split_opts.send_time_a
  • ab_split_opts.send_time_b
  • variate_settings.send_times (Array of datetime fields)

• Email Activity:

  • timestamp

• List Members:

  • timestamp_signup
  • timestamp_opt
  • last_changed
  • created_at

• Lists:

  • date_created
  • stats.campaign_last_sent
  • stats.last_sub_date
  • stats.last_unsub_date

• Reports:

  • send_time
  • rss_last_send
  • opens.last_open
  • clicks.last_click
  • ab_split.a.last_open
  • ab_split.b.last_open
  • timewarp.last_open
  • timeseries.timestamp

• Segment Members:

  • timestamp_signup
  • timestamp_opt
  • last_changed
  • last_note.created_at

• Segments:

  • created_at
  • updated_at

• Unsubscribes:

  • timestamp