Skip to main content

Introduction

Constant Contact SMS is Constant Contact’s SMS marketing platform, covering text-message campaign creation and performance reporting. Marketers send SMS campaigns through the Constant Contact web app, and the connector imports each campaign’s daily performance metrics through the Constant Contact v3 REST API. This connector is distinct from Constant Contact Email. The two share the same Constant Contact OAuth account but return different metrics and behave differently — Email data represents lifetime campaign totals, while SMS data is captured daily. To connect this data source, see How to connect Constant Contact SMS to Adriel.

Data refresh strategy

SMS campaign data refreshes once daily at 3:00 AM UTC. Each cycle fetches campaign summaries for the previous two days and upserts them into the cached daily time series. On first connection, Adriel backfills the last 90 days of SMS campaign data.

Date range limits

Daily reports have no hard date-range limit inside the connector. Historical data extends back as far as the initial 90-day backfill from the connection date, plus any days accumulated since.

Metrics

How to read the columnsData type uses this vocabulary: Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean.API Key in code style like sends is the literal Constant Contact v3 API field name from the SMS campaign summary response (under unique_counts).

SMS campaigns

Delivery

Engagement

Contacts

Breakdowns

Campaign

Time

The date breakdown is an Adriel-injected daily date field applied to the cached time series, not a native Constant Contact field.

Limitations

  • SMS dates are UTC-based — SMS reporting dates are handled in UTC, so workspaces in non-UTC time zones may see daily totals that don’t align exactly with their local day boundaries.
  • Only SMS campaigns are exposed — link-level clicks or per-recipient breakdowns are not available from this connector.
  • Reconnect required when the refresh token expires — Constant Contact-issued refresh tokens can be invalidated by the platform. When this happens, the data source is disconnected and must be reauthorized in Adriel.
  • Deleted campaigns are not backfilled from Constant Contact — SMS campaigns removed on the platform stop appearing in future refreshes.
  • Shared rate limit with Constant Contact Email — both connectors share the Constant Contact rate limit of 4 API calls per second and 10,000 calls per day per account (Constant Contact rate limits). High-volume workspaces that connect both Email and SMS may see occasional rate-limit backoff.
  • 90-day initial backfill — on first connection, only the previous 90 days of SMS data are ingested; there is no way to backfill further history.

API references

See also