Import Mailchimp data

To get a comprehensive picture of your campaigning efforts, you can import your Mailchimp email campaign data into Commerce Intelligence. To complete the import, you need to do the following for each Mailchimp campaign you have:

Export Opens data

  1. After logging into Mailchimp, go to the Campaigns tab.

    import mailchimp 1

  2. Click View Report, next to the campaign name.

    import mailchimp 2

  3. Click the Opened number.

    import mailchimp 3

  4. Click Export and save the .csv file.

    You must add primary key, date (mm/dd/yyyy), and campaign name columns to this file. Make sure the primary keys are unique to each row.

    import mailchimp 4

Export Clicks data

  1. Navigate back to the View Report screen for the campaign.

  2. Click the number that Clicked.

    import mailchimp 5

  3. Click either the number under the Total Clicks OR Unique Clicks column.

    import mailchimp 6

  4. Click Export and save the .csv file.

    You must add Primary Key, date (mm/dd/yyyy), campaign name, and URL columns to this file. You do not need to add the full URL, just something that lets you know what was clicked.

    import mailchimp 7

  5. Repeat steps 3 and 4 for each URL clicked in your email, combining all the data into the same .csv file when finished.

Export Sent data

  1. Go into the Campaigns tab of Mailchimp.

  2. Click View Report next to the campaign name.

  3. Click the number next to Recipients.

    import mailchimp 8

  4. Click Export and save the .csv file.

    You must add Primary Key, date (mm/dd/yyyy), and campaign name columns to this file.

    import mailchimp 9

Prepare files for upload into Commerce Intelligence

Each file - Opens, Clicks, and Sent - should be uploaded to Commerce Intelligence as a separate file. Adobe recommends that you name the files using this naming convention: MailChimp\_ACTION\_DATE. Replace ACTION with Open, Click, or Sent, and replace DATE with the date of export.

When you are ready to upload the files, use the File Upload feature to bring the data into your Data Warehouse.

On this page