> ## Documentation Index
> Fetch the complete documentation index at: https://docs.adriel.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Data reference

> Metrics, breakdowns, refresh cadence, and limits for the Constant Contact SMS data source in Adriel.

## 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-sources/a-f/constant-contact-sms/how-to-connect).

## 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

<Note>
  **How to read the columns**

  **Data 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`).
</Note>

### SMS campaigns

| Metric | Description              | Data type | API Key |
| ------ | ------------------------ | --------- | ------- |
| Sends  | Total SMS messages sent. | Number    | `sends` |

### Delivery

| Metric     | Description                            | Data type | API Key    |
| ---------- | -------------------------------------- | --------- | ---------- |
| Deliveries | Total messages successfully delivered. | Number    | `delivers` |

### Engagement

| Metric | Description                               | Data type | API Key  |
| ------ | ----------------------------------------- | --------- | -------- |
| Opens  | Total opens recorded.                     | Number    | `opens`  |
| Clicks | Total clicks on tracked links in the SMS. | Number    | `clicks` |

### Contacts

| Metric   | Description                                      | Data type | API Key   |
| -------- | ------------------------------------------------ | --------- | --------- |
| Opt-outs | Total opt-outs / unsubscribes from the SMS list. | Number    | `optouts` |

## Breakdowns

### Campaign

| Breakdown     | Description                                        | API Key         |
| ------------- | -------------------------------------------------- | --------------- |
| Campaign ID   | Group by Constant Contact SMS campaign identifier. | `campaign_id`   |
| Campaign name | Group by campaign display name.                    | `campaign_name` |

### Time

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

| Breakdown | Description                                             |
| --------- | ------------------------------------------------------- |
| Date      | Group by fetch day. Used for daily time-series reports. |

## 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](https://developer.constantcontact.com/api_guide/rate_limits.html)). 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

* [Constant Contact v3 API — SMS campaign summaries](https://developers.constantcontact.com/api_reference/index.html#!/SMS)
* [Constant Contact API overview](https://developers.constantcontact.com/api_guide/index.html)

## See also

* [How to connect Constant Contact SMS to Adriel](/data-sources/a-f/constant-contact-sms/how-to-connect) (paired how-to)
* [Constant Contact Email data reference](/data-sources/a-f/constant-contact-email/data-reference) — for email campaign metrics on the same account