Contents

CampaignStats Table

The ININ_DIALER_40.CampaignStats table contains summary statistics for each campaign running in Dialer. Each row will contain a set of statistics averaged over a configurable sample period. The default sample period is 60 seconds, but the user can change the sample period under the campaign configuration using the 'Statistics sample period' control. Columns that do not allow NULL values must have a value when records are added or inserted.

CampaignStats Schema

Column Name	Details	Description
periodstarttimeUTC	datetime, not null	Timestamp for the start of the sample period
periodendtimeUTC	datetime, not null	Timestamp for the end of the sample period
odsoffset	int, not null	The UTC offset of the ODS in seconds
campaignname	varchar(255), not null	The name of the campaign
siteid	varchar(80), not null	The site name of the ODS for this row
event	varchar(20), null	Records significant campaign events that occurred during the sample period. Valid values: ‘recycle', ‘reset', ‘NewActive Group''
campaignstate	varchar(20), not null	The state of the campaign at the end of the sample period. Valid values: ‘on', ‘off', ‘paused', ‘scheduledonly'
dialingmode	varchar(10), not null	The dialing mode of the campaign at the end of the sample period. Valid values: ‘preview', ‘predictive', ‘power', ‘agentless'
filtersize	int, not null	The filter size at the start of the sample period
recyclesize	int, not null	The recycle size at the start of the sample period
totalagents	int, not null	The total number of agents that are active in the campaign
effectivetotalagents	float, not null	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 ().
idleagents	int, not null	The number of agents that are in an idle or finishing state in the campaign
effectiveidleagents	float, not null	The number of idle agents minus average non-Dialer agents
nondialeragents	int, not null	The number of agents that are on non-dialer calls in the campaign
dndagents	int, not null	The number of agents in a DND state in the campaign
totaldialercalls	int, not null	The total number of active calls in the campaign (pending + outstanding + connected)
pace	int, null	The current pace value for the campaign
cpa	float, null	The current calls per agent being used by the campaign (for example: 1/ConnectRate)
adjcpa	float, null	The adjusted calls per agent being used by the campaign (for example the CPA adjusted by pace.)
abandonrate	float, null	The current abandon rate of the campaign
RuleGroupID	smallint, null	The ID assigned to the Rule Group that was set. (When an entry appears in the RuleGroupID column, an entry titled NewAcive Group will appear in Event column.)
priority	tinyint, not null	The campaign's priority among all running campaigns

The analytics table is written to via the DialerTranServer process server. It is treated like a log table to implement data retention. The table will be named Dialer.CampaignStats. Rows are written to the table only if the data in the row is different from the previous row. Rows are written to the table only if any of the following values are non-zero: calls placed, dispositions, abandons, detections, contacts, rpcs, or if a significant event occurs.