Software Maintenance License Renewal Activation

Thank you for renewing your software maintenance for DBX MailChimp Connect. License activation is required before you can update your software to the latest build.

Please follow the steps below to properly update your DBX license and installation.

1. Go to http://register.dbxintegrations.com/maintenance/renew

2. Identify the registration code of the DBX installation that needs to be updated. To do this, run the installation of DBX that needs to be updated, click “Help | About”. Take note of the value for “Registration Code”.

3. Enter the registration code into the “Product Registration Code” field in the Product Maintenance Renewal page.

4. Enter <%KEY%> into the “Maintenance Renewal Code” field in the renewal page.

5. Click “Renew Maintenance”. If successful, you should get a confirmation page showing the latest maintenance date.

Download the latest release of the application from the following link : http://www.dbxintegrations.com/goldmine/mailchimpconnect.html#download

Once the installer is downloaded, run the setup file and install DBX over the existing installation of the software. This should update your current installation to the latest build.

DBX MailChimp Connect Release Notes

June 17, 2018

  • Fixed issue where some e-mail addresses are not read properly from GoldMine.
  • Logs are now categorized into  Normal, General Error, Exception, Email Address Not Found.  These new categories will greatly improve troubleshooting. 

June 7, 2018

  • New option under “Options” menu – Enable Verbose Logging.  By default, only error logs are captured.  When enabled, additional logs are captured in the log text file which can be used for troubleshooting purposes.  

March 16, 2018

  • Log files are now generated when application encounters an error when executing MailChimp API calls.
  • Improved UI navigation performance by caching campaign activity data

February 24, 2018

January 19, 2018

  • Users are now able to create GoldMine history records for MailChimp campaign recipients.

E-mail Tracking Data In GoldMine

Campaign Tracking Actions

Campaign results can be tracked in 2 ways :

  1. Create history records for e-mails sent out for a compaign.
  2. Create detail records to track open and click activities for a campaign.

The actions can be found in the “Campaign Info” tab within the Actions menu.

 

Create GoldMine E-mail Sent History

This action will create a new history record in GoldMine for each of the e-mail addresses which were sent out with the MailChimp campaign.  History records are only created once in GoldMine , regardless how many times this action is executed for a campaign.

The following image shows the preview of a history record created for a campaign.  The link in the ”
Campaign Email” allows GoldMine users to view a copy of the e-mail that was sent out to the recipient.

Create GoldMine Detail History

This action will create a detail record for each e-mail recipient.  The detail record contains tracking data such as last open date, last click date, last link clicked, and who received the e-mail message.

A new tab named ‘MailChimp Track’ is created and all details tracking history records are available within this tab.

Run this action to update the open and  click tracking data for each recipient.

 

Modify default field delimiter setting

Updating Default Field Delimiters

There are errors that can be caused by some data that is unexpected by the application.  One of those cases is when data contains a comma and MailChimp Connect is using the default field delimiter which is also a comma character.

This scenario can result to an error similiar to the following:

“System.ArgumentException: Input array is longer than the number of columns in this table.”

To resolve this issue, simply go to the Additonal Options.

Select one of the available options which will replace the default field delimiter.  For example, click on the button labeled “tab” then click “Save”.

Run the same process which triggered the error to verify if it corrected the issue.

 

 

 

Unsubscribe and Bounceback Actions

DBX MailChimp Connect provides a set of processing options for both unsubscribe and bounceback email addresses.  Access to these options are available in the Unsubscribe and Bounceback tabs.

Create Contact Group

This action allows users to create or update existing contact groups.  Contact records matching any of the bounceback or unsubscribe email addresses will be added to the contact group.

Delete E-mail Addresses

This action allows users to delete unsubscribe or bounceback email address which are found in GoldMine.

Export E-mail Addresses

This action allows users to save the list of bounceback or unsubscribe email addresses to a text file.

Update E-mail Merge Code

This action allows users to update the merge code for matching e-mail addresses.

Update MailChimp List

Updating a campaign list with DBX MailChimp Connect is easy.  From the mail toolbar menu, click on “Update List”.

Specify List Name To Be Updated – click on the “Lookup” button to select an existing MailChimp campaign list.

Send an Option Opt-In e-mail message to e-mail address – Check this box if you want the e-mail address that will be added to the list to first opt-in to the list before they get added to the list.

Select GoldMine Contact Group – Pick which contact group which includes the contact records with the email addresses which will be added to the MailChimp Campaign list.

Select E-mail Address Types From Contacts – Check the appropriate box depending on what type of email address to add to the campaign list.  Optionally, provide merge codes (separted by a comma) to limit the set of e-mail addresses.

Excluding E-mail Addresses From the List – Some contacts in the group can have multiple e-mail addresses and some of them could be flagged for unsubscribe.  To avoid updating your MailChimp list with unsubscribed e-mail addresses, make sure to select the option “Exclude E-mail Addresses…” and specify the e-mail merge codes to flag an e-mail address in GoldMine as “unsubscribed”.  The merge code should be separated by a comma if there are multiple e-mail merge codes.

Select Merge Fields for list – Only the e-mail address and contact name is uploaded to your MailChimp list.  If you need some GoldMine field data to be added to your MailChimp list, simply pick the fields from the “Merge Field Selection” tab.  MailChimp limits the maximum number of merge fields (merge vars) to 30.

 

Enable Integration Between MailChimp and GoldMine

Enabling integration betwen MailChimp and GoldMine is relatively easy.  The first time that DBX MailChimp Connect is run, users will be prompted to enter their MailChimp API Integration Key.

Click on the link provided in the dialog to learn how to get the MailChimp api key.  Once entered, users can run DBX MailChimp Connect and start viewing various MailChimp stats including Bounce and Unsubscribe e-mail addresses.

The next step is to enable GoldMine integration.  From the main toolbar menu, select Option | GoldMine Integration Settings.  Simple browse to your GoldMine installation folder and provide your GoldMine username/password.  Click OK when done.

Once all the steps above are completed, users should be able to use DBX MailChimp Connect to take advantage of all the features within the application.

 

 

 

 

 

 

Quick Setup Guide

Setup Guide

Install and Setup MailChimp Integration

Download and install the latest build of DBX MailChimp Connect.   Follow instructions on initial dialog box on how to setup the MailChimp API integration.

Click here to download

Setup GoldMine Integration

Once the MailChimp API integration is enabled, the application is now able to display campaigns and related items.  To integrate with GoldMine, click on “Options” toolbar menu option and select “GoldMine Integration Setting”.  Browse to your GoldMine installation folder and provide a valid GoldMine username/password.

Verify Integration

Now that setup is completed, it is time to verify that both MailChimp and GoldMine integration is complete.  Select a campaign that has some bounce-backs (or unsubscribes) and and go to the bounceback tab then click on “Tools | Build Contact Group”.  Set it to build a new contact group and verify that the new group is created with the correct set of contact records as members of the new contact group.