Sample code for 30+ languages & platforms
Visual Basic 6.0 Requires Chilkat v11.0.0+

Constant Contact V3: Compare results for sent email activities

See more Constant Contact Examples

Compare one to ten sent primary_email or resend activities with status DONE. Supply activity IDs from your sent newsletters. Campaign IDs identify a different resource. This report requires campaign_data and permission to view campaign metrics.

Each row shows sends, unique opens, unique clicks, bounces and the last metrics refresh. The code matches results by activity ID, keeps the input order, and prints any partial-success errors alongside the available results. A missing result is reported separately from a measured zero.

Authorize the application using the same account and credential store.

Constant Contact developer guide

Chilkat Visual Basic 6.0 Downloads

Visual Basic 6.0
Dim success As Long
success = 0

'  Assumes Chilkat is unlocked. See Global Unlock Sample.
Dim vault As New ChilkatSecrets
vault.Location = "local_manager"
vault.AutoSplit = 1
Dim entry As New ChilkatJsonObject
success = entry.UpdateString("appName","ConstantContactV3")
success = entry.UpdateString("service","OAuth2")
success = entry.UpdateString("username","my-account")
Dim tokens As New ChilkatJsonObject
Dim loaded As Long
loaded = vault.GetSecretJson(entry,tokens)
If (loaded <> 1) Then
    Debug.Print "Run the desktop authorization example using this account and store."
    Exit Sub
End If

If (tokens.JsonTypeOf("access_token") <> 1) Then
    Debug.Print "The saved authorization has no access token."
    Exit Sub
End If

Dim http As New ChilkatHttp
http.RequireSslCertVerify = 1
http.AuthToken = tokens.StringOf("access_token")
Dim resp As New ChilkatHttpResponse

Dim ids As New ChilkatJsonArray
success = ids.AddStringAt(-1,"FIRST_SENT_ACTIVITY_ID")
success = ids.AddStringAt(-1,"SECOND_SENT_ACTIVITY_ID")
If ((ids.Size < 1) Or (ids.Size > 10)) Then
    Debug.Print "Choose one to ten sent activity IDs."
    Exit Sub
End If

Dim url As New ChilkatStringBuilder
success = url.Append("https://api.cc.email/v3/reports/stats/email_campaign_activities/")
Dim i As Long
i = 0
Do While (i < ids.Size)
    If (i > 0) Then
        success = url.Append(",")
    End If

    success = url.Append(ids.StringAt(i))
    i = i + 1
Loop
success = http.HttpNoBody("GET",url.GetAsString(),resp)
If ((success <> 1) And (resp.StatusCode <= 0)) Then
    Debug.Print "Read statistics: HTTP request failed."
    Exit Sub
End If

If ((success <> 1) Or ((resp.StatusCode < 200) Or (resp.StatusCode >= 300))) Then
    Debug.Print "Read statistics: HTTP " & resp.StatusCode & " " & resp.BodyStr
    Exit Sub
End If

Dim report As New ChilkatJsonObject
success = report.Load(resp.BodyStr)
If (success <> 1) Then
    Debug.Print "Expected a JSON object in the response."
    Exit Sub
End If

i = 0
Do While (i < report.SizeOfArray("errors"))
    report.I = i
    Debug.Print report.StringOf("errors[i].error_key") & ": " & report.StringOf("errors[i].error_message")
    i = i + 1
Loop
Debug.Print "Activity ID | Sends | Unique opens | Unique clicks | Bounces | Last refresh"
Dim row As New ChilkatJsonObject
i = 0
Do While (i < ids.Size)
    Dim id As String
    id = ids.StringAt(i)
    success = report.FindRecord2("results","campaign_activity_id",id,1,row)
    If (success = 1) Then
        '  StringOf preserves a reported zero and leaves an unavailable individual metric blank.
        Debug.Print id & " | " & row.StringOf("stats.em_sends") & " | " & row.StringOf("stats.em_opens") & " | " & row.StringOf("stats.em_clicks") & " | " & row.StringOf("stats.em_bounces") _
             & " | " & row.StringOf("last_refresh_time")
    Else
        Debug.Print id & " | No statistics returned"
    End If

    i = i + 1
Loop