Campaign Groups

CampaignGroupID

CampaignGroupID

int

(not null)

The campaign group ID autogenerated at the time of creation.

OBD_CAMPAIGN_GROUP

CAMPAIGNGROUP

CAMPAIGNGROUP

nvarchar

(64) (null)

The campaign group name.

OBD_CAMPAIGN_GROUP

DESCRIPTION

DESCRIPTION

nvarchar

(256) (null)

The campaign group description.

OBD_CAMPAIGN_GROUP

CISCOCAMPAIGNID

CISCOCAMPAIGNID

bigint

(null)

The Cisco Campaign ID for this campaign group.

OBD_CAMPAIGN_GROUP

CISCOUPLOADFILEPATH

CISCOUPLOADFILEPATH

nvarchar

(250) (null)

The file upload path to place the contact upload files.

OBD_CAMPAIGN_GROUP

CISCOALARMTIME

CISCOALARMTIME

nvarchar

(16) (null)

Not in use.

OBD_CAMPAIGN_GROUP

CISCOINITIALNOOFCONTACTS

CISCOINITIALNOOFCONTACTS

bigint

(null)

The initial number of contacts that are to be delivered to the dialer.

OBD_CAMPAIGN_GROUP

CISCOREDUCEFACTOR

CISCOREDUCEFACTOR

bigint

(null)

The factor by which the contact delivery has to reduce when dialing is not as per the expected pace.

OBD_CAMPAIGN_GROUP

CISCOUPLOADFILEFORMAT

CISCOUPLOADFILEFORMAT

nvarchar

(512) (null)

The contact file upload format such as text, JSON, and so on.

OBD_CAMPAIGN_GROUP

CISCOINCREMENTPERCENT

CISCOINCREMENTPERCENT

bigint

(null)

The percentage for contact upload increment if dialing is faster than expected.

OBD_CAMPAIGN_GROUP

CISCODECREMENTPERCENT

CISCODECREMENTPERCENT

bigint

(null)

The percentage for contact upload decrement if dialing is faster than expected.

OBD_CAMPAIGN_GROUP

ISCISCOGROUP

ISCISCOGROUP

int

(null)

Specifies if this is a Cisco campaign (group).

OBD_CAMPAIGN_GROUP

ZONENAME

ZONENAME

nvarchar

(128) (null)

The time zone for this campaign group.

OBD_CAMPAIGN_GROUP

CISCOALTERNATEVDN

CISCOALTERNATEVDN

nvarchar

(32) (null)

Alternate Cisco campaign ID for contact delivery in case of some failure.

OBD_CAMPAIGN_GROUP

CISCOPERIPHERALID

CISCOPERIPHERALID

int

(null)

The port number in Cisco for a switch.

OBD_CAMPAIGN_GROUP

REDUCETHRESHOLD

REDUCETHRESHOLD

int

(null)

The number of contacts to be reduced from the initial delivery based on the dialing speed.

OBD_CAMPAIGN_GROUP

CISCOINCREASETHRESHOLD

CISCOINCREASETHRESHOLD

int

(null)

The number of contacts to be increased from the initial delivery based on the dialing speed.

OBD_CAMPAIGN_GROUP

CONFIGDATA

CONFIGDATA

nvarchar

(4000) (null)

This indicates if detailed configuration data for the group and its parameters are available or not.

OBD_CAMPAIGN_GROUP

ISDELETED

ISDELETED

nvarchar

(2) (null)

Specifies if the campaign group is deleted.

OBD_CAMPAIGN_GROUP

ISENABLED

ISENABLED

nvarchar

(2) (null)

Specifies if the campaign group is active.

OBD_CAMPAIGN_GROUP

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.

OBD_CAMPAIGN_GROUP

IsLCMEnabled

IsLCMEnabled

bit

(null)

Specifies if this group is for Cisco CCE.

OBD_CAMPAIGN_GROUP

IsULGroup

IsULGroup

bit

(not null)

Specifies if this is a Shared List campaign.

OBD_CAMPAIGN_GROUP

IsULGroupMapped

IsULGroupMapped

bit

(not null)

Specifies if this campaign group is mapped to a shared list.

OBD_CAMPAIGN_GROUP

IterationInterval

IterationInterval

int

(not null)

The iteration interval between two contact delivery iterations.

OBD_CAMPAIGN_GROUP

CreatedDateTime

CreatedDateTime

datetime

(null)

The date and time this campaign group was created.

OBD_CAMPAIGN_GROUP

ModifiedDateTime

ModifiedDateTime

datetime

(null)

The date and time this campaign group was last updated.

OBD_CAMPAIGN_GROUP

ICMId

ICMId

int

(not null)

The ICM ID for this campaign group.

OBD_CAMPAIGN_GROUP

APIGenerated

APIGenerated

char

(1) (null)

Specifies if this is a campaign group created using an API.

OBD_CAMPAIGN_GROUP

isThrottlingEnable

isThrottlingEnable

bit

(null)

Specifies if IVR Throttling is enabled for this campaign group.

OBD_CAMPAIGN_GROUP

CampaignPurposeType

CampaignPurposeType

int

(null)

The campaign purpose type. 1 indicates an API Voice Campaign; 2 indicates a Campaign Manager group.

OBD_CAMPAIGN_GROUP

IsNiceinContactGroup

IsNiceinContactGroup

bit

(null)

Specifies if this is a campaign group of Nice CXone.

OBD_CAMPAIGN_GROUP

ISTwilioGroup

ISTwilioGroup

bit

(null)

Specifies if this is campaign group of Twilio Flex.

OBD_CAMPAIGN_GROUP

TwilioProjectName

TwilioProjectName

nvarchar

(256) (null)

The Twilio Project Name for this campaign group.

OBD_CAMPAIGN_GROUP

WorkspceSID

WorkspceSID

nvarchar

(256) (null)

The Twilio workspace ID for this campaign group.

OBD_CAMPAIGN_GROUP

WorkFlowSID

WorkFlowSID

nvarchar

(128) (null)

The Twilio workflow ID for this campaign group.

OBD_CAMPAIGN_GROUP

ReservationTimeout

ReservationTimeout

int

(null)

Not in use.

OBD_CAMPAIGN_GROUP

UjetDNIS

UjetDNIS

nvarchar

(56) (null)

The UJET DNIS mapped to this campaign group.

OBD_CAMPAIGN_GROUP

UjetAgentPercentage

UjetAgentPercentage

bigint

(null)

Not in use.

OBD_CAMPAIGN_GROUP

UjetQueueId

UjetQueueId

nvarchar

(100) (null)

The autogenerated ID for the UJET queue (campaign group on Campaign Manager).

OBD_CAMPAIGN_GROUP

IsUjetGroup

IsUjetGroup

bit

(null)

Specifies if this campaign group belongs to the UJET dialer.

OBD_CAMPAIGN_GROUP

IsAECGroup

IsAECGroup

bit

(null)

Specifies if this campaign group belongs to the Amazon Connect dialer.

OBD_CAMPAIGN_GROUP

WxCCReferenceId

WxCCReferenceId

nvarchar

(64) (null)

Unique ID of the Webex Contact Center Entry Point which is synced as campaign group into Campaign Manager

OBD_CAMPAIGN_GROUP

IsWxCCGroup

IsWxCCGroup

bit

(null)

Specifies if this campaign group belongs to the Cisco Webex Contact Center dialer.

OBD_CAMPAIGN_GROUP

PlatformProviderID

PlatformProviderID

int

(null)

The ID auto-generated for a platform provider created on Campaign Manager. For example, if a CCaaS provider platform is created and a campaign is mapped to this provider, this field is used.

SubtenantID

SubtenantID

int

(not null)

The sub tenant ID auto generated at the time of creation.

DialerID

DialerID

int

(not null)

This is the dialer that the application delivers contacts to.

AutoBalanceEnabled

AutoBalanceEnabled

bit

(not null)

This indicates if auto balancing contacts among campaigns in enabled for this group.

IsAvayaPOMGroup

IsAvayaPOMGroup

bit

This indicates if the group has Avaya POM as the dialer.

DialerAttributes

DialerAttributes

JSON Array

This field shows all the attributes configured  for a dialer by a user, as a JSON Array. This may differ for each group.

The fields are PaceMode, PaceName, Preview, PacingModeParameters (this includes ANIList, ANIName, ACWTime, RingingDuration, PreviewDuration, PreviewActionID, PreviewActionName, CloseContactOnReject, ContactFlowID, MaxContacts, AvgCallConnecttime, MaxAgentline, LinesPerAgent, AbandonedRatio, MaxLinePerCamp, isManualGroup, isCallRecord, MinAgentLine, DialerIteration, InitialSeed, InitialSeedIteration, GainFactor, LossFactor, IVRContactFlow, TaskTimeOut, ReservationTimeOut, CampaignAttribute, AbanLowerRatio, isPCB, Gain, MakeCallTimeOut, AgentNoAnswerTimeout, CfgAlgoAbanUpperBoundPer, CfgAlgoAbanLowerBoundPer, AbandonPerFormulaConfig, AbandonPerFormulaConfigDesc, FCC(US), OFCOM(UK) IsRampNCD, IsRampNCDDesc.

IsConsent

IsConsent

bit

(not null)

This indicates if the group is a Consent Group for using ADM and dialing via a Clicker Agent.

GetCampaignAPIResponse

GetCampaignAPIResponse

JSON Array

This field contains the JSON array of the response received for the GetCampaign API.

GroupStatus

GroupStatus

int

This field contains status of the group - Executing, Stopped, and so on.

GroupType

GroupType

int

This field contains group type - Voice, Manual, or Digital.

IsGenesysGroup

IsGenesysGroup

bool

This indicates if the group uses the Genesys dialer.

BusinessFieldMapping

BusinessFieldMapping

JSON Array

This field displays the business fields mapped from the dialer to this group. The data is displayed as a JSON array.

OBD_CAMPAIGN_GROUP_IMPORTRULE_CLAUSE

CampaignGroupID

CampaignGroupID

int

(not null)

The campaign group ID autogenerated at the time of creation.

OBD_CAMPAIGN_GROUP_IMPORTRULE_CLAUSE

CampaignGroup

CampaignGroup

nvachar

(32) (null)

The campaign group name.

OBD_CAMPAIGN_GROUP_IMPORTRULE_CLAUSE

Type

Type

int

(null)

Indicates if this is a Cisco Voice API campaign group.

OBD_CAMPAIGN_GROUP_IMPORTRULE_CLAUSE

Length

Length

int

(null)

The max length for business fields for Cisco campaigns.

OBD_CAMPAIGN_GROUP_IMPORTRULE_CLAUSE

FieldName

FieldName

nvarchar

(64) (null)

The supported Cisco business field name.

OBD_CAMPAIGN_GROUP_IMPORTRULE_CLAUSE

ICMId

ICMId

int

(not null)

The ICM ID (Cisco dialer) for this campaign group.

OBD_CAMPAIGN_GROUP_IMPORTRULE_CLAUSE

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.

OBD_CAMPAIGN_GROUP_IMPORTRULE_CLAUSE

SubTenantID

SubTenantID

int

(null)

The Sub Tenant ID autogenerated by the application when a new tenant is created.

OBD_CAMPAIGN_GROUP_IMPORTRULE_CLAUSE

DialerID

DialerID

int

(null)

This is the dialer that the application delivers contacts to.

OBD_Twilio_WorkFlows

ID

ID

int

(not null)

Identity column unique to each record.

OBD_Twilio_WorkFlows

ProjectID

ProjectID

int

(not null)

ID of the Twilio Project.

OBD_Twilio_WorkFlows

WorkFlowName

WorkFlowName

nvarchar

(64) (not null)

The Twilio workflow name for this campaign group.

OBD_Twilio_WorkFlows

WorkFlowSID

WorkFlowSID

int

(64) (not null)

The Twilio workflow SID for this campaign group.

OBD_Twilio_WorkFlows

WorkspaceID

WorkspaceID

int

(not null)

The workspace ID autogenerated at the time of creation on Twilio Flex.

OBD_Twilio_WorkFlows

ICMId

ICMId

int

(null)

Not in use.

OBD_Twilio_WorkFlows

TaskQueueSID

TaskQueueSID

nvarchar

(64) (null)

The SID for the task queue mapped to the workflows.

OBD_Twilio_WorkFlows

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.

OBD_Twilio_WorkFlows

SubTenantID

SubTenantID

int

(null)

The Sub Tenant ID autogenerated by the application when a new tenant is created.

OBD_Twilio_WorkerWorkFlowConditionMapping

Id

Id

int

(not null)

Identity column unique to each record.

OBD_Twilio_WorkerWorkFlowConditionMapping

WorkerSID

WorkerSID

nvarchar

(64) (not null)

The worker SID autogenerated at the time of creation.

OBD_Twilio_WorkerWorkFlowConditionMapping

WorkFlowSID

WorkFlowSID

nvarchar

(64) (not null)

The Workflow SID autogenerated at the time of creation.

OBD_Twilio_WorkerWorkFlowConditionMapping

TaskQueueSID

TaskQueueSID

nvarchar

(64) (not null)

The SID for the task queue autogenerated at the time of creation.

OBD_Twilio_WorkerWorkFlowConditionMapping

Expression

Expression

nvarchar

(max) (not null)

The expression mapping the Workflow and the Worker.

OBD_Twilio_WorkerWorkFlowConditionMapping

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.