Monthly Archives: July 2015

Using Constant Contact with GoldMine – Part 4

Continuing with our series, today’s post will show you how to access and leverage the information you get back from Constant Contact.

If you missed our 3 previous posts here ya go:

Using Constant Contact with GoldMine – Part 1
Using Constant Contact with GoldMine – Part 2
Using Constant Contact with GoldMine – Part 3
Now that all the Campaign results have arrived in GoldMine, Bounces, Opt-Outs, Open, Clicks, and so on, how do we use this information?Using_Constant_Contact_with_GoldMine_02

Let’s say that you now want to make a call to all of those contacts who performed a clicked-through on one of your previous broadcasts. For this we will use the GoldMine Lookup Wizard. For a more in-depth review of the Lookup Wizard, please review that previous post.

Using the GoldMine Lookup Wizard

  1. Click Tools | Lookup Wizard.
  2. Select Contact information.Using_Constant_Contact_with_GoldMine_06a
  3. Click Next.
  4. Click Specify completed activity match options.Using_Constant_Contact_with_GoldMine_06b
  5. Click Next.
  6. Place a checkmark next to Result Codes and the Wizard will prompt you to select the Code or Codes you would like to use.  For this example, we will use CLK for Clicks.
  7. Click the Add>> button.Using_Constant_Contact_with_GoldMine_07
  8. Click OK.
  9. We can now add additional parameters to be more specific. (e.g. adding the Reference line to focus on a specific campaign).Using_Constant_Contact_with_GoldMine_08
  10. Once you are done with your entire selections, click Next, and Next again.Using_Constant_Contact_with_GoldMine_09a

From here you can Activate SQL statement to see the results immediately, save the Query for later use, or copy it to use in Reports or the Search Center.

In our next and final installment, we will show you how to use the Query results to schedule that follow-up call.


Hope you find this of value!
Enjoy and Happy GoldMining!!

Using Constant Contact with GoldMine – Part 3

Building on our 2 previous posts on the subject, today’s post will cover what information gets recorded into GoldMine by the Constant Contact integration.

If you missed our 2 previous posts here ya go:

Using Constant Contact with GoldMine – Part 1
Using Constant Contact with GoldMine – Part 2

When viewing your list of Constant Contact Campaigns in GoldMine you will see the following columns of information:Using_Constant_Contact_with_GoldMine_04

The numbers you see under Sent, Bounces, Opt-Outs, Opens, Clicks, and Forwards are the same statistics you see in Constant Contact. Though it’s a bit more convenient to see that information here instead of having to log into Constant Contact, this chart isn’t the real power of GoldMine’s Constant Contact integration. The real power, which is not easily available from Constant Contact, is access to the specific records behind the data.

For each of the activities listed above, GoldMine creates History records in the appropriate Contact records. These records are recorded as Other Actions, with a Code of CCE (Constant Contact E-Mail). For granularity, each of these activities have a specific 3-letter Result code. Here is a list of those codes:

Code     Action
SNT       Sent: A campaign email was sent.
BNC      Bounce: A campaign email bounced and was not received.
OPN     Open: A campaign email was opened.
CLK       Click: A link within the email was clicked.
OUT      Opt-Out: The recipient unsubscribed from receiving any further e-mails.
FWD      Forward: The recipient used the “Forward to a Friend” functionality.

If the contact opened the e-mail, clicked the link, and then forwarded it to a friend, 4 history records (including the sent) for that contact, will be recorded in GoldMine.Using_Constant_Contact_with_GoldMine_05


Stay tuned for Part 4!!

Hope you find this of value!
Enjoy and Happy GoldMining!!