# Campaign Phone Counts

## Definition(s)

* Since we don't enforce uniqueness of [](https://docs.glencoco.com/core-concepts/phone-numbers/lead-phone-numbers "mention") for [leads](https://docs.glencoco.com/core-concepts/leads "mention") in [campaigns](https://docs.glencoco.com/core-concepts/campaigns "mention"), [campaign-phone-counts](https://docs.glencoco.com/core-concepts/phone-numbers/lead-phone-numbers/campaign-phone-counts "mention") is a table that stores call attempt information purely at the phone number level, regardless of association to one contact, or multiple contacts

<figure><img src="https://2457054009-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff5LkmcT8D3Tt8FlyON5s%2Fuploads%2FS0zfP3yrdqFvlHKeghfB%2FScreenshot%202025-10-27%20at%2006.43.58%20PM%402x.png?alt=media&#x26;token=dca56e72-5e98-4472-be30-28d3b2ae7355" alt=""><figcaption></figcaption></figure>

* [campaign-phone-counts](https://docs.glencoco.com/core-concepts/phone-numbers/lead-phone-numbers/campaign-phone-counts "mention") is used to keep track of the total call atempts to a particular phone number, regardless of the lead(s) the phone number is associated with, as well as update do not call flags.

## Simplified Schema

<table><thead><tr><th width="218.6640625">column</th><th>datatype</th><th>context</th></tr></thead><tbody><tr><td>phone</td><td>text</td><td>unique (equivalent to id)</td></tr><tr><td>campaign_id</td><td>text</td><td>relates to <a href="../../campaigns">campaigns</a></td></tr><tr><td>created_at</td><td>timestamptz</td><td></td></tr><tr><td>last_contacted_at</td><td>timestamptz</td><td></td></tr><tr><td>do_not_call</td><td>boolean</td><td>can be set to true to disqualify a phone number</td></tr><tr><td>call_counter</td><td>integer</td><td>keeps track of the total number of call attempts to that number from the cmapaign</td></tr></tbody></table>

{% hint style="success" %}
Learn about [lead-ingestions](https://docs.glencoco.com/core-concepts/lead-ingestions "mention")
{% endhint %}

{% hint style="success" %}
Learn about [phone-disqualified-leads](https://docs.glencoco.com/core-concepts/lead-statuses/disqualified-leads/phone-disqualified-leads "mention")
{% endhint %}

{% hint style="success" %}
Learn about [deduplication](https://docs.glencoco.com/core-concepts/lead-ingestions/deduplication "mention")
{% endhint %}
