Campaign Phone Counts

Definintion of campaign phone counts, a table that allows us to keep track of every unique phone number in a given campaign.

Definition(s)

• Since we don't enforce uniqueness of Lead Phone Numbers for Leads in Campaigns, Campaign Phone Counts is a table that stores call attempt information purely at the phone number level, regardless of association to one contact, or multiple contacts

• Campaign Phone Counts 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

column	datatype	context
phone	text	unique (equivalent to id)
campaign_id	text	relates to campaigns
created_at	timestamptz
last_contacted_at	timestamptz
do_not_call	boolean	can be set to true to disqualify a phone number
call_counter	integer	keeps track of the total number of call attempts to that number from the cmapaign

Learn about Lead Ingestions

Learn about Phone Disqualified Leads

Learn about Deduplication