PureConnect Reporting Data Dictionary

Expand All Collapse All

CampaignStats Table

Table Type - Historical
Last Changed Version - 15.3.0.384
Last Changed Reason - Added column RuleGroupID for reporting on a campaign with context information from the rule group.

SQL Column Definitions

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
periodstarttimeUTC	datetime	False	Unknown	Timestamp for the start of the sample period	4.0.106.453	4.0 Release
periodendtimeUTC	datetime	False	Unknown	Timestamp for the end of the sample period	4.0.106.453	4.0 Release
odsoffset	int	False	Unknown	The UTC offset of the ODS in seconds	4.0.106.453	4.0 Release
campaignname	varchar (255)	False	Unknown	The name of the campaign	4.0.106.453	4.0 Release
siteid	varchar (80)	False	Unknown	The site name of the ODS for this row	4.0.106.453	4.0 Release
event	varchar (20)	True	Unknown	Records significant campaign events that occurred during the sample period. Valid values: 'recycle', 'reset', 'NewActive Group''	4.0.106.453	4.0 Release
campaignstate	varchar (20)	False	Unknown	The state of the campaign at the end of the sample period. Valid values: 'on', 'off', 'paused', 'scheduledonly'	4.0.106.453	4.0 Release
dialingmode	varchar (10)	False	Unknown	The dialing mode of the campaign at the end of the sample period. Valid values: 'preview', 'predictive', 'power', 'agentless'	4.0.106.453	4.0 Release
filtersize	int	False	Unknown	The filter size at the start of the sample period	4.0.106.453	4.0 Release
recyclesize	int	False	Unknown	The recycle size at the start of the sample period	4.0.106.453	4.0 Release
totalagents	int	False	Unknown	The total number of agents that are active in the campaign	4.0.106.453	4.0 Release
effectivetotalagents	float	False	Unknown	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 ().	4.0.106.453	4.0 Release
idleagents	int	False	Unknown	The number of agents that are in an idle or finishing state in the campaign	4.0.106.453	4.0 Release
effectiveidleagents	float	False	Unknown	The number of idle agents minus average non-Dialer agents	4.0.106.453	4.0 Release
nondialeragents	int	False	Unknown	The number of agents that are on non-dialer calls in the campaign	4.0.106.453	4.0 Release
dndagents	int	False	Unknown	The number of agents in a DND state in the campaign	4.0.106.453	4.0 Release
totaldialercalls	int	False	Unknown	The total number of active calls in the campaign (pending + outstanding + connected)	4.0.106.453	4.0 Release
pace	int	True	Unknown	The current pace value for the campaign	4.0.106.453	4.0 Release
cpa	float	True	Unknown	The current calls per agent being used by the campaign (for example: 1/ConnectRate)	4.0.106.453	4.0 Release
adjcpa	float	True	Unknown	The adjusted calls per agent being used by the campaign (for example the CPA adjusted by pace.)	4.0.106.453	4.0 Release
abandonrate	float	True	Unknown	The current abandon rate of the campaign	4.0.106.453	4.0 Release
priority	tinyint	False	Unknown	The campaign's priority among all running campaigns	4.0.106.453	4.0 Release
rulegroupid	smallint	True	Unknown	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.)	15.3.0.384	Added for reporting on a campaign with context information from the rule group.
campaignstats_id	bigint	False	Unknown	The identification number assigned to the campaign statistic.	18.4.0.000	Added id columns to agentstats and campaignstats.

Column	Data Type (Size)	Is Nullable	Contains PII	Description	Last Change Version	Last Change Reason
periodstarttimeUTC	timestamp	False	Unknown	Timestamp for the start of the sample period	4.0.106.453	4.0 Release
periodendtimeUTC	timestamp	False	Unknown	Timestamp for the end of the sample period	4.0.106.453	4.0 Release
odsoffset	number	False	Unknown	The UTC offset of the ODS in seconds	4.0.106.453	4.0 Release
campaignname	varchar2 (255)	False	Unknown	The name of the campaign	4.0.106.453	4.0 Release
siteid	varchar2 (80)	False	Unknown	The site name of the ODS for this row	4.0.106.453	4.0 Release
event	varchar2 (20)	True	Unknown	Records significant campaign events that occurred during the sample period. Valid values: 'recycle', 'reset', 'NewActive Group''	4.0.106.453	4.0 Release
campaignstate	varchar2 (20)	False	Unknown	The state of the campaign at the end of the sample period. Valid values: 'on', 'off', 'paused', 'scheduledonly'	4.0.106.453	4.0 Release
dialingmode	varchar2 (10)	False	Unknown	The dialing mode of the campaign at the end of the sample period. Valid values: 'preview', 'predictive', 'power', 'agentless'	4.0.106.453	4.0 Release
filtersize	number	False	Unknown	The filter size at the start of the sample period	4.0.106.453	4.0 Release
recyclesize	number	False	Unknown	The recycle size at the start of the sample period	4.0.106.453	4.0 Release
totalagents	number	False	Unknown	The total number of agents that are active in the campaign	4.0.106.453	4.0 Release
effectivetotalagents	float (8)	False	Unknown	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 ().	4.0.106.453	4.0 Release
idleagents	number	False	Unknown	The number of agents that are in an idle or finishing state in the campaign	4.0.106.453	4.0 Release
effectiveidleagents	float (8)	False	Unknown	The number of idle agents minus average non-Dialer agents	4.0.106.453	4.0 Release
nondialeragents	number	False	Unknown	The number of agents that are on non-dialer calls in the campaign	4.0.106.453	4.0 Release
dndagents	number	False	Unknown	The number of agents in a DND state in the campaign	4.0.106.453	4.0 Release
totaldialercalls	number	False	Unknown	The total number of active calls in the campaign (pending + outstanding + connected)	4.0.106.453	4.0 Release
pace	number	True	Unknown	The current pace value for the campaign	4.0.106.453	4.0 Release
cpa	float (8)	True	Unknown	The current calls per agent being used by the campaign (for example: 1/ConnectRate)	4.0.106.453	4.0 Release
adjcpa	float (8)	True	Unknown	The adjusted calls per agent being used by the campaign (for example the CPA adjusted by pace.)	4.0.106.453	4.0 Release
abandonrate	float (8)	True	Unknown	The current abandon rate of the campaign	4.0.106.453	4.0 Release
priority	number	False	Unknown	The campaign's priority among all running campaigns	4.0.106.453	4.0 Release
rulegroupid	number	True	Unknown	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.)	15.3.0.384	Added for reporting on a campaign with context information from the rule group.
campaignstats_id	number	False	Unknown	The identification number assigned to the campaign statistic.	18.4.0.000	Added id columns to agentstats and campaignstats.

SQL Constraints

Primary Key Name	Type	Column Name (sort order)
PK_CAMPAIGNSTATS_ID	Non-clustered	campaignstats_id (Ascending)

Primary Key Name	Column Name (sort order)
PK_CAMPAIGNSTATS_ID	campaignstats_id (Ascending)

Index Name	Type	Column Name (sort order)
IX_CampaignStats_Date	Clustered	periodstarttimeUTC (Ascending)
UX_CampaignStats	Unique non-clustered	campaignname (Ascending) periodstarttimeUTC (Ascending) periodendtimeUTC (Ascending) siteid (Ascending) event (Ascending)