Mailchimp Migration Guide

Upgrading to 2.0.0

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

Migration Steps

Refresh affected schemas and reset data

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.

Upgrading to 1.0.0

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.

Upgrade steps

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.

Changes

• 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 accommodate the above changes, empty strings are now converted to null values:

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

Updated datetime fields

• 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