Sample code for 30+ languages & platforms
VBScript 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 VBScript Downloads

VBScript
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

'  Assumes Chilkat is unlocked. See Global Unlock Sample.
set vault = CreateObject("Chilkat.Secrets")
vault.Location = "local_manager"
vault.AutoSplit = 1
set entry = CreateObject("Chilkat.JsonObject")
success = entry.UpdateString("appName","ConstantContactV3")
success = entry.UpdateString("service","OAuth2")
success = entry.UpdateString("username","my-account")
set tokens = CreateObject("Chilkat.JsonObject")
loaded = vault.GetSecretJson(entry,tokens)
If (loaded <> 1) Then
    outFile.WriteLine("Run the desktop authorization example using this account and store.")
    WScript.Quit
End If

If (tokens.JsonTypeOf("access_token") <> 1) Then
    outFile.WriteLine("The saved authorization has no access token.")
    WScript.Quit
End If

set http = CreateObject("Chilkat.Http")
http.RequireSslCertVerify = 1
http.AuthToken = tokens.StringOf("access_token")
set resp = CreateObject("Chilkat.HttpResponse")

set ids = CreateObject("Chilkat.JsonArray")
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
    outFile.WriteLine("Choose one to ten sent activity IDs.")
    WScript.Quit
End If

set url = CreateObject("Chilkat.StringBuilder")
success = url.Append("https://api.cc.email/v3/reports/stats/email_campaign_activities/")
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
    outFile.WriteLine("Read statistics: HTTP request failed.")
    WScript.Quit
End If

If ((success <> 1) Or ((resp.StatusCode < 200) Or (resp.StatusCode >= 300))) Then
    outFile.WriteLine("Read statistics: HTTP " & resp.StatusCode & " " & resp.BodyStr)
    WScript.Quit
End If

set report = CreateObject("Chilkat.JsonObject")
success = report.Load(resp.BodyStr)
If (success <> 1) Then
    outFile.WriteLine("Expected a JSON object in the response.")
    WScript.Quit
End If

i = 0
Do While (i < report.SizeOfArray("errors"))
    report.I = i
    outFile.WriteLine(report.StringOf("errors[i].error_key") & ": " & report.StringOf("errors[i].error_message"))
    i = i + 1
Loop
outFile.WriteLine("Activity ID | Sends | Unique opens | Unique clicks | Bounces | Last refresh")
set row = CreateObject("Chilkat.JsonObject")
i = 0
Do While (i < ids.Size)
    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.
        outFile.WriteLine(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
        outFile.WriteLine(id & " | No statistics returned")
    End If

    i = i + 1
Loop

outFile.Close