Importing MailChimp data

To get a comprehensive picture of your campaigning efforts, you can import your MailChimp email campaign data into Magento BI. 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.

    Pic1.png

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

    Pic2.png

  3. Click the Opened number.

    Pic3.png

  4. Click Export and save the CSV file.

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

    Pic4.png

Export Clicks data

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

  2. Click the number that Clicked.

    Pic5.png

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

    Pic6.png

  4. Click Export and save the CSV file.

    You will need to 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 will let you know what was clicked.

    Pic7.png

  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.

    Pic8.png

  4. Click Export and save the CSV file.

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

    Pic9.png

Prepare files for upload into Magento BI

Each file - Opens, Clicks, and Sent - should be uploaded to Magento BI as a separate file. We also recommend 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.