Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Work in progress....

Panel
titleTable of Contents

Table of Contents


Overview: Dynamics 365

The reports below are created for the Office of Admissions to aid in their recruiting efforts. Data from Dynamics 365 is extracted using the APIs and grouped.


Tip
titleData Refresh

Reports are refreshed daily




Read below for information on working with the reports, or click on the Report Elements Glossary link in the Table of Contents above to view definitions for the report filters and display elements.

Report : Dynamics 365-Contacts and Activities

Tab 1: Activities

Filters

Insert excerpt
Dynamics Report - Campus
Dynamics Report - Campus
nopaneltrue

Insert excerpt
Dynamics Report - College
Dynamics Report - College
nopaneltrue

Insert excerpt
Dynamics Report - USF Terms
Dynamics Report - USF Terms
nopaneltrue

Insert excerpt
Dynamic Report - Activity Type Code
Dynamic Report - Activity Type Code
nopaneltrue

Insert excerpt
Dynamics Report - USF ID
Dynamics Report - USF ID
nopaneltrue

Insert excerpt
Dynamics Report - Full Name
Dynamics Report - Full Name
nopaneltrue


Visualizations: 

Table

The table displays the following values for each record:

Activity Type Code

USF ID

Name Email

Count of Activities

Earliest Activity

Created Latest

Activity modified


Tab 2: Activity Details

Filters

Insert excerpt
Dynamics Report - Campus
Dynamics Report - Campus
nopaneltrue

Insert excerpt
Dynamics Report - College
Dynamics Report - College
nopaneltrue

Insert excerpt
Dynamics Report - USF Terms
Dynamics Report - USF Terms
nopaneltrue

Insert excerpt
Dynamic Report - Activity Type Code
Dynamic Report - Activity Type Code
nopaneltrue

Insert excerpt
Dynamics Report - USF ID
Dynamics Report - USF ID
nopaneltrue

Insert excerpt
Dynamics Report - Full Name
Dynamics Report - Full Name
nopaneltrue


Visualizations: 

Table

The table displays the following values for each record:

Activity Type Code

USF ID

Full Name

Email Mailer Title

Subject

Activity Status

Status Reason

Created/Send date time

Sender

To Recipients




Report : Dynamics 365-Contacts, Opportunities and Attributes

Tab 1: Dynamics 365-Contacts, Opportunities and Attributes

Filters

Insert excerpt
Dynamics Report - Campus
Dynamics Report - Campus
nopaneltrue

Insert excerpt
Dynamics Report - College
Dynamics Report - College
nopaneltrue

Insert excerpt
Dynamics Report - USF Terms
Dynamics Report - USF Terms
nopaneltrue

Insert excerpt
Dynamics Report - Attribute Source
Dynamics Report - Attribute Source
nopaneltrue

Insert excerpt
Dynamics Report - Attribute Code
Dynamics Report - Attribute Code
nopaneltrue

Insert excerpt
Dynamics Report - Attribute Description
Dynamics Report - Attribute Description
nopaneltrue

Insert excerpt
Dynamics Report - USF ID
Dynamics Report - USF ID
nopaneltrue

Insert excerpt
Dynamics Report - Full Name
Dynamics Report - Full Name
nopaneltrue


Visualizations: 

Table

The table displays the following values for each record:

USF ID

Talisma Contact ID

Email Name

College Code

College Description

Major Code

Major Description

Opportunity id

USF Term

Attribute Code

Attribute Description

Attribute Source




Report : Dynamics 365-Opportunities and School History

Tab 1: Dynamics 365-Opportunities and School History

Filters

Insert excerpt
Dynamics Report - Campus
Dynamics Report - Campus
nopaneltrue

Insert excerpt
Dynamics Report - College
Dynamics Report - College
nopaneltrue

Insert excerpt
Dynamics Report - USF Terms
Dynamics Report - USF Terms
nopaneltrue

Insert excerpt
Dynamics Report - School Name
Dynamics Report - School Name
nopaneltrue

Insert excerpt
Dynamics Report - USF ID
Dynamics Report - USF ID
nopaneltrue

Insert excerpt
Dynamics Report - Full Name
Dynamics Report - Full Name
nopaneltrue

                                                       


Visualizations: 

Table

The table displays the following values for each record:

Name

USF ID

Opportunitiy ID

Term

School Code

School Name

Source GPA

Graduation Date




Report : Dynamics 365-Exception Report- Duplicate Records

Tab 1: Dynamics 365-Exception Report- Duplicate Records

Visualizations: 

Contacts with USF ID duplicates

This bar graph displays the count of USFID duplicates in the Dynamics 365 Admissions platform.


Contacts with USF Email duplicates

This bar graph displays the count of USF Email duplicates in the Dynamics 365 Admissions platform.


Contacts with personal email duplicates

This bar graph displays the count of duplicates in the Dynamics 365 Admissions platform based on personal email


Contacts with opportunity duplicates

This bar graph displays the count of opportunity duplicates in the Dynamics 365 Admissions platform.


Contacts with mobile phone duplicates

This bar graph displays the count of mobile phone duplicates in the Dynamics 365 Admissions platform.


Contacts with home phone duplicates

This bar graph displays the count of home phone duplicates in the Dynamics 365 Admissions platform.


Contacts with permanent zipcode duplicates

This bar graph displays the count of permanent postal code duplicates in the Dynamics 365 Admissions platform.


Contacts with mailing zipcode duplicates

This bar graph displays the count of mailing address postal code duplicates in the Dynamics 365 Admissions platform.






Report : Dynamics 365-Contact details and Opportunities

Tab 1: Admissions Funnel

Filters


Insert excerpt
Dynamics Report - Campus
Dynamics Report - Campus
nopaneltrue

Insert excerpt
Dynamics Report - College
Dynamics Report - College
nopaneltrue

Insert excerpt
Dynamics Report - USF Terms
Dynamics Report - USF Terms
nopaneltrue

Insert excerpt
Dynamics Report - Territories
Dynamics Report - Territories
nopaneltrue

Insert excerpt
Dynamics Report - Owner Name
Dynamics Report - Owner Name
nopaneltrue

Insert excerpt
Dynamics Report - Student Type
Dynamics Report - Student Type
nopaneltrue


Visualizations: 

Admissions Funnel


A visual representation of the student admission pathway, depicting the admission process from suspect to deposit. 

Suspect Grouping includes anyone in (Suspect, Prospect, Applicant, Admit, Deposit)
Prospect Grouping includes anyone in (Prospect, Applicant, Admit, Deposit)
Applicant Grouping includes anyone in (Applicant, Admit, Deposit)
Admit Grouping includes anyone in (Admit, Deposit)
Deposit Grouping includes anyone in deposit

                                                                               


Admissions Trend Analysis

This visual displays the various stage counts across  5 years and the corresponding terms

                                                       


Tab 2: Dynamics 365-Contact details and Opportunities

Filters

Insert excerpt
Dynamics Report - Campus
Dynamics Report - Campus
nopaneltrue

Insert excerpt
Dynamics Report - College
Dynamics Report - College
nopaneltrue

Insert excerpt
Dynamics Report - USF Terms
Dynamics Report - USF Terms
nopaneltrue

Insert excerpt
Dynamics Report - Territories
Dynamics Report - Territories
nopaneltrue

Insert excerpt
Dynamics Report - Owner Name
Dynamics Report - Owner Name
nopaneltrue

Insert excerpt
Dynamics Report - USF ID
Dynamics Report - USF ID
nopaneltrue

Insert excerpt
Dynamics Report - Full Name
Dynamics Report - Full Name
nopaneltrue

Insert excerpt
Dynamics Report - Stage
Dynamics Report - Stage
nopaneltrue

Insert excerpt
Dynamics Report - Student Type
Dynamics Report - Student Type
nopaneltrue

               


Visualizations: 

Table

The table displays the following values for each record:

USF ID

Talisma Contact ID

Opportunity id

USF Term

Email

Name

Birthdate

Gender Code

White non hispanic

Hispanic or Latino

American Indian Alaskan Native

Asian

Black African American

Native Hawiian Pacific Islander

Citizenship Type

Owner Name

Mailing Address-Street1

Mailing Address- Street2

Mailing Address-Street3

Mailing Address- City

Mailing Address - County

Mailing Address - State

Mailing Address-Postal Code

Mailing Address - Country

ACT Score

SAT Score

Major Code

Major Description

College Code

College Name

Stage

Type Code


Type Description

Student Type

Created on




Admissions Status Cards

These cards represents the count of student records for each admission stage/status




Report : Dynamics 365-Email Template Analytics



Filters



Insert excerpt
Dynamics Report - Campus
Dynamics Report - Campus
nopaneltrue

Insert excerpt
Dynamics Report - College
Dynamics Report - College
nopaneltrue

Insert excerpt
Dynamics Report - USF Terms
Dynamics Report - USF Terms
nopaneltrue

Insert excerpt
Dynamics Report - Territories
Dynamics Report - Territories
nopaneltrue

Insert excerpt
Dynamics Report - Owner Name
Dynamics Report - Owner Name
nopaneltrue


Visualizations

Template Usage Count

This horizontal bar graph displays the number of times a given template has been used as a draft or sent email.


Template Usage Rate

This card visual displays the percent of emails that are templates..


Email Count

This card visual displays the total count of emails.


Template Count

This card visual displays the total count of emails that have templates used in them


                                                       



Table

The table displays the following values for each record:

Owner

Subject

Sender

toRecipients

Priority

Status

Modified on

Attachment Count

State Code

Created on

Template Title

Template Creator

Template Created on