Contents

CampaignStats

Table Name	Column Name	CX Insights Name	CX Insights Type	Data Type	Description	Folder
CampaignStats	adjcpa	Adjust CPA	fact	float	The adjusted calls per agent being used by the campaign (for example the CPA adjusted by pace.)	IC Dialer
CampaignStats	campaignname	Campaign Name	attribute	varchar	The name of the campaign	IC Dialer
CampaignStats	campaignstate	Campaign State	attribute	varchar	The state of the campaign at the end of the sample period. Valid values: 'on', 'off', 'paused', 'scheduledonly'	IC Dialer
CampaignStats	campaignstats_id	Campaign Stats Id	attribute	bigint	The number of agents that are in an idle or finishing state in the campaign	IC Dialer
CampaignStats	cpa	CPA	fact	float	The current calls per agent being used by the campaign (for example: 1/ConnectRate)	IC Dialer
CampaignStats	dialingmode	Dialing Mode	attribute	varchar	The dialing mode of the campaign at the end of the sample period. Valid values: 'preview', 'predictive', 'power', 'agentless'	IC Dialer
CampaignStats	dndagents	DnD Agents	fact	int	The number of agents in a DND state in the campaign	IC Dialer
CampaignStats	effectiveidleagents	Effective Idle Agents	fact	float	The number of idle agents minus average non-Dialer agents	IC Dialer
CampaignStats	effectivetotalagents	Effective Total Agents	fact	float	The total number of agents that are active in the campaign minus average non-Dialer agents (agents in this campaign that are currently on non-Dialer calls ().	IC Dialer
CampaignStats	event	Event	attribute	varchar	Records significant campaign events that occurred during the sample period. Valid values: 'recycle', 'reset', 'NewActive Group'	IC Dialer
CampaignStats	filtersize	Filter Size	fact	int	The filter size at the start of the sample period	IC Dialer
CampaignStats	idleagents	idleagents	fact	int	idleagents	IC Dialer
CampaignStats	nondialeragents	Non Dialer Agents	fact	int	The number of agents that are on non-dialer calls in the campaign.	IC Dialer
CampaignStats	odsoffset	ODS Offset	fact	int	The offset of the ODS's time zone from UTC in seconds. This is used to translate the agenttimeUTC field to local time.	IC Dialer
CampaignStats	pace	Pace	fact	int	The current pace value for the campaign.	IC Dialer
CampaignStats	periodendtimeUTC	Period End Time UTC	attribute	datetime	Timestamp for the end of the sample period.	IC Dialer
CampaignStats	periodstarttimeUTC	Period Start Time UTC	attribute	datetime	Timestamp for the start of the sample period.	IC Dialer
CampaignStats	recyclesize	Recycle Size	fact	int	The recycle size at the start of the sample period.	IC Dialer
CampaignStats	rulegroupid	Rule Group Id	attribute	smallint	The ID assigned to the Rule Group that was set. You can find more details about the RuleGroupID, such as the name of the Rule Group, in the CallHistory_RuleGroup table.	IC Dialer
CampaignStats	totalagents	Total Agents	fact	int	The total number of agents that are active in the campaign.	IC Dialer
CampaignStats	totaldialercalls	Total Dialer Calls	fact	int	The total number of active calls in the campaign (pending + outstanding + connected).	IC Dialer