Visual Basic 6.0 Requires Chilkat v11.0.0+
Visual Basic 6.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
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