Query Rule Dialing Times Real Time Report(camqry04)

Call Summary Count Of Query Rule Within Campaign Real Time(camqry05)

Call Counts of Query Rule within Campaign Real Time Report (camqry01)

Purpose: Run this report to display the status of each query rule within a campaign report.

Query: This report data is built from an Anonymous Block.

Views: This report has a grid view only.

Grouping: This report is grouped and sorted by campaign name and then by query rule name.

Default Sort Order: By campaign name and then by query rule name.

Value List: Campaigns

Drilldowns: No

Database and Tables

Database	Real-time
•Table	Campaign
•Table	Query_Rule
•Table	Campaign_Query_Rule_Real_Time

Notes :

This report displays the status of each query rule within a campaign report. The data in the

Campaign_Query_Rule_Real_Time table is reset nightly.

Current Fields in the Query Rule within Campaign Real Time Report View

Current fields are those fields that appear by default in a report generated from the Campaign template. You can change them.

Current fields are listed below in the order (left to right) in which they appear by default in the Campaign template.

Column (Field)	Description
Campaign Name	The name of the campaign selected for the report. Derived from:Campaign.CampaignName
Query Rule Name	The name of the query rule Derived from:Query_Rule.QueryRuleName
Attempted	Summary total of the number of calls attempted. Derived from: Campaign_Query_Rule_Real_Time.AttemptedCount
Requested Personal Callback	The number of call-back contacts scheduled. Derived from: Campaign_Query_Rule_Real_Time.PersonalCallbackCount
Requested Callback	The number of call-back contacts. Derived from: Campaign_Query_Rule_Real_Time.CallBackCount
Voice	The number of calls for the day that ended in successful customer contact. Derived from: Campaign_Query_Rule_Real_Time.VoiceCount
Busy	The number of calls that detected a busy signal. Derived from: Campaign_Query_Rule_Real_Time.BusyCount
No Answer	The number of calls that were not answered. Derived from: Campaign_Query_Rule_Real_Time.NoAnswerDetectCount
No Ringback	The number of calls that did not detect a ring back. The Calls with CallResults 4, 27 and 28 are mentioned in this column. Derived from: Campaign_Query_Rule_Real_Time.NoRingBackDetectCount
No Dialtone	The number of calls that did not detect a dial tone. Derived from: Campaign_Query_Rule_Real_Time.NoDialToneDetectCount
Fax	The number of calls that detected a fax. Derived from: Campaign_Query_Rule_Real_Time.FaxDetectCount
Network IVR	The number of calls that detected a network answering machine. Derived from: Campaign_Query_Rule_Real_Time.NetworkAnsMachineCount
Answering Machine	The number of calls that detected an answering machine. Derived from: Campaign_Query_Rule_Real_Time.AnsweringMachineCount
SIT Tone	The number of calls that detected a Special Information Tone (SIT). Derived from: Campaign_Query_Rule_Real_Time.SITToneDetectCount
Agent Rejected	The number of preview/callback calls that were rejected by the agent but that might be called back. Derived from: Campaign_Query_Rule_Real_Time.AgentRejectedCount
Agent Closed	The number of preview/callback calls that were rejected by the agent (these customers will not be dialed). Derived from: Campaign_Query_Rule_Real_Time.AgentClosedCount
Customer Not Home	The number of contacts where the party answering the phone was not the customer. Derived from: Campaign_Query_Rule_Real_Time.CustomerNotHomeCount
Wrong Number	The number of contacts where the party answering the phone indicated the customer didn’t live there. Derived from: Campaign_Query_Rule_Real_Time.WrongNumberCount
Canceled	The number of calls where the dialer canceled a ringing customer call. See Reasons for Canceled Calls for Outbound Option Reports. Derived from: Campaign_Query_Rule_Real_Time.CanceledDetectCount
Dialer Abandon	The number of calls abandoned by the dialer. Derived from: Campaign_Query_Rule_Real_Time.AbandonDetectCount
Abandon to IVR	The number of calls that were abandoned by the dialer. However, instead of hanging-up on the customer the customer was transferred to an IVR which plays a message. Derived from: Campaign_Query_Rule_Real_Time.AbandonToIVRCount
Customer Abandon	The number of calls where the customer hung-up immediately after picking up the phone. Derived from: Campaign_Query_Rule_Real_Time.CustomerAbandonDetectCount
Talk Time	The total time in HH:MM:SS (hours, minutes, seconds) that agents spent talking on the telephone today. Derived from: Campaign_Query_Rule_Real_Time.TalkTimeCount
Wrapup Time	The length of time the agents spent in wrap-up work. Derived from: Campaign_Query_Rule_Real_Time.WrapupTimeCount

Available fields in the Call Counts of Query Rule within Campaign Real Time Report (camqry01) View

Available fields for this report include the fields that display by default as Current. Additional Available fields in this report are:

•	Abandon (Abandon)
•	Available (Available)
•	Closed (Closed)
•	DateTime (DateTime)
•	home_duration_min (home_duration_min)
•	home_end_time (home_end_time)
•	home_start_time (home_start_time)
•	qry_duration_min (qry_duration_min)
•	qr_end_time (qr_end_time)
•	qr_start_time (qr_start_time)
•	Total Records (Total_Records)
•	VoiceCQ1 (VoiceCQ1)
•	work_duration_min (work_duration_min)
•	work_end_time (work_end_time)
•	work_start_time (work_start_time)

Goto Top

Call Counts of Query Rule within Campaign Real Time Report(camqry01)

Call Summary Count Of Query Rule Within Campaign Real Time(camqry05)

Query Rule Dialing Times Real Time Report (camqry04)

Purpose: Run this report to display the currently valid query rule dialing times

Query: This report data is built from an Anonymous Block.

Views: This report has a grid view only.

Grouping: This report is grouped and sorted by campaign name, and then by query rule name, query rule start time, query rule end time, campaign Zone1 start time, campaign Zone1 end time, campaign Zone2 start time, and campaign Zone2 end time

Default Sort Order: By campaign name, and then by query rule name, query rule start time, query rule end time, campaign Zone1 start time, campaign Zone1 end time, campaign Zone2 start time, and campaign Zone2 end time.

Value List: Campaigns

Drilldowns: No

Database and Tables

Database	Real-time
•Table	Campaign
•Table	Query_Rule
•Table	Campaign_Query_Rule_Real_Time

Notes:

This report displays the currently valid query rule dialing times.

Current Fields in the Query Rule Dialing Times Real Time Report View

Current fields are those fields that appear by default in a report generated from the Campaign template. You can change them.

Current fields are listed below in the order (left to right) in which they appear by default in the Campaign template.

Column (Field)	Description
Campaign Name	The name of the campaign selected for the report. Derived from:Campaign.CampaignName
Query Rule Name	The name of the query rule Derived from:Query_Rule.QueryRuleName
Start Zone 1 Time	Campaign Start Zone 1 time measured in HH:MM:SS format. Campaign Start Zone 1 time is the start time that a customer can be phoned at Zone 1 numbers.Zone 1 time and Zone 2 time cannot overlap. Derived from:Campaign.HomeStartHours':'Campaign.HomeStartMinutes
Query Rule Start Time	The time in HH:MM:SS format that the query rule starts.Query rule time is based on the Central Controller’s time zone. Typically, the Administration & Data Server from which a query is run is in the Unified ICM central controller’s time zone. Derived from:Campaign_Query_Rule.StartHours “:” Campaign_Query_Rule.StartMinutes
End Zone 1 Time	Campaign End Zone 1 time measured in HH:MM:SS format. Campaign End Zone 1 time is the time beyond which a customer can no longer be phoned at Zone 1 numbers. Derived from:Campaign.HomeEndHours':'Campaign.HomeEndMinutes
Query Rule End Time	The time in HH:MM:SS format that the query rule ends. Derived from:Campaign_Query_Rule.EndHours':'Campaign_Query_Rule.EndMinutes
Zone 1 Duration	The total Zone 1 time. Zone 1 Duration = End Zone 1 Time – Start Zone 1 Time. Derived from:(((Campaign.HomeEndHours * 60) +(Campaign.HomeEndMinutes)) -((Campaign.HomeStartHours * 60) + (Campaign.HomeStartMinutes)))
Query Rule Duration	The total query rule time. Work Duration = End Query Rule Time – Start Query Rule Time. Derived from:(((Campaign_Query_Rule.EndHours * 60) + (Campaign_Query_Rule.EndMinutes)) - ((Campaign_Query_Rule.StartHours * 60) + (Campaign_Query_Rule.StartMinutes)))
Start Zone 2 Time	Campaign Start Zone 2 time measured in HH:MM:SS format. Campaign Start Zone 2 time is the start time that a customer can be phoned at Zone 2 numbers.Campaign time is normalized to the customer’s time zone. For example, if the campaign runs from 3 to 6 PM Eastern Standard time and it is past 6 PM on the East coast, you can still dial someone in Chicago since it is not yet 6 PM there.. Derived from:Campaign.WorkStartHours ':'Campaign.WorkStartMinutes
End Zone 2 Time	The Zone 2 time in HH:MM:SS format that the campaign ends Derived from:Campaign.WorkEndHours ':'Campaign.WorkEndMinutes
Zone 2 Duration	The total Zone 2 time. Zone 2 Duration = End Zone 2 Time – Start Zone 2 Time Derived from:(((Campaign.WorkEndHours * 60) +(Campaign.WorkEndMinutes)) -((Campaign.WorkStartHours * 60) + (Campaign.WorkStartMinutes)))

Goto Top

Call Counts of Query Rule within Campaign Real Time Report(camqry01)

Query Rule Dialing Times Real Time Report(camqry04)

Call Summary Count Of Query Rule Within Campaign Real Time (camqry05)

Purpose: Run this report to display the status of each query rule within a campaign

Query: This report data is built from an Anonymous Block.

Views: This report has a grid view only.

Grouping: This report is grouped and sorted by campaign name and then by query rule name.

Default Sort Order: By campaign name and then by query rule name.

Value List: Campaigns

Drilldowns: No

Database and Tables

Database	Real-time
•Table	Campaign
•Table	Query_Rule
•Table	Campaign_Query_Rule_Real_Time

Notes :

This report displays the status of each query rule within a campaign report. The data in the

Campaign_Query_Rule_Real_Time table is reset nightly.

Current Fields in the Query Rule Within Campaign Real Time Report View

Current fields are those fields that appear by default in a report generated from the Campaign template. You can change them.

Current fields are listed below in the order (left to right) in which they appear by default in the Campaign template.

Column (Field)	Description
Campaign Name	The name of the campaign selected for the report. Derived from:Campaign.CampaignName
Query Rule Name	The name of the query rule Derived from:Query_Rule.QueryRuleName
Total Records	The total number of records. Derived from: Campaign_Query_Rule_Real_Time.TotalCount
Available	The number of available records. Derived from:Campaign_Query_Rule_Real_Time.TotalCount –Campaign_Query_Rule_Real_Time.FutureUseInt1 – Campaign_Query_Rule_Real_Time.ClosedCount
Closed	The number of contacts attempted. Derived from:Campaign_Query_Rule_Real_Time.ClosedCount
Voice	The number of calls for the day that ended in successful customer contact. Derived from:Campaign_Query_Rule_Real_Time.FutureUseInt1

Available fields in the Call Summary Count Of Query Rule Within Campaign Real Time (camqry05) View

Available fields for this report include the fields that display by default as Current. Additional Available fields in this report are:

•	Abandon (Abandon)
•	Abandon_To_IVR (Abandon_To_IVR)
•	Agent_Closed (Agent_Closed)
•	Agent_Rejected (Agent_Rejected)
•	Answering_Machine (Answering_Machine)
•	Attempted (Attempted)
•	Busy (Busy)
•	Canceled (Canceled)
•	Customer_Abandon (Customer_Abandon)
•	customer_not_home (customer_not_home)
•	DateTime (DateTime)
•	Fax (Fax)
•	home_duration_min (home_duration_min)
•	home_end_time (home_end_time)
•	home_start_time (home_start_time)
•	Network_IVR (Network_IVR)
•	No_Answer (No_Answer)
•	No_Dialtone (No_Dialtone)
•	No_Ringback (No_Ringback)
•	qry_duration_min (qry_duration_min)
•	qr_end_time (qr_end_time)
•	qr_start_time (qr_start_time)
•	Requested_Callback (Requested_Callback)
•	requested_personal_callback (requested_personal_callback)
•	SIT_Tone (SIT_Tone)
•	Talk_Time (Talk_Time)
•	work_duration_min (work_duration_min)
•	work_end_time (work_end_time)
•	work_start_time (work_start_time)
•	Wrapup_Time (Wrapup_Time)
•	wrongnumber (wrongnumber)