|
|
MDR Email Solutions |
|
Campaign Analyzer User Guide Version 3.0 - Updated 3/2010
|
Summary: This goal of this guide is to share the benefits of MDR’s Campaign Analyzer email campaign reporting and demonstrate how to make the most of the reports now available to you.
What is Campaign Analyzer?
Campaign Analyzer is a free component of the MDR Email Solution suite that gives you comprehensive feedback on your active and past email campaigns. You can view your results across key individual, building level and geographical level demographics. This report will give you new insight on each of your campaigns to increase your e-marketing ROI and generate more sales.
Will I get Campaign Analyzer for every message I deploy?
Comprehensive Campaign Analyzer reporting is currently available on the following products:
E@quire, E@quire Plus, DM-Opt, DM-Opt Plus
Standard campaign summary reporting and results over time reporting is available for:
E@ppend, E@ppend Plus, E@ppend Premium EAH, InfoBuyer, Deploy Only campaigns or user supplied emails will get standard Campaign Summary reporting and results over time reporting
Table of Contents:
1.) Campaign Summary
2.) Total Opens/Clicks by Day by URL
3.) Opens and Clicks By Keycode Value
4.) Literal Keycode by Day by URL
5.) Segment Opens/Clicks by Day by URL
6.) Opens and Clicks by Job Title / Course Taught
7.) Institution Type
a. District
e. Colleges
f. Libraries
g. Daycares
10.) Appendix A: Keycode Listing
Each campaign you execute includes a quick summary of key campaign deployment metrics. This section defines the universe that will be used for the rest of the report.
Explanation of Terms in the Campaign Summary Section:
Campaign Synopsis:
E@quire Addresses = Includes the total number of MDR-supplied deliverable email addresses that were deployed.
Total Email Addresses = If customer-supplied email addresses deployed as part of this campaign, they are included on a separate line below the MDR addresses. The total email address category combines both MDR and customer emails.
Campaign Results:
Total Deliverable Messages = Includes the total number of emails that are deemed deliverable, based on a positive response from the deployed-to email server. This number is less than the total deployed amount (not shown) as it is subtracts hard bounces, invalid addresses, syntax errors or other recorded undeliverable explanations.
Full Mailboxes – Not Delivered = Includes the number of valid email addresses that were not delivered at the time of the report because the recipients’ box was full. This number will change over the first 24-48 hours of a campaign as our deployment vendor will re-attempt to deliver these messages for a period of time. These are valid addresses and are counted in the total deliverable messages number but have encountered this temporary non-delivered status.
Blocks = Blocks occur prior to the campaign leaving the deployment vendor, and are based on global suppression or other vendor-wide suppressions. Not counted in the Total Deliverable Messages.
Opt-Outs from this Campaign = Opt-Outs include the current total of anyone who has clicked on the opt-out mechanism included in the campaign message.
Response Tracking:
Total Opens = total number of opens recorded for this campaign. For a message to be recorded as “opened”, the end recipient must have a HTML enabled email client and have image downloading enabled. For more information about Open Rates see Appendix A. Total Opens can be affected by recipients opening the message multiple times.
Unique Open = includes the total of unique opens for the campaign. Only one open per email address is recorded no matter how many times they opened the message.
Tracked Links:
Each tracked hyperlink in the email message is reported here. The number of clicks are unique (net) per link.
Send a Friend:
If the Send-a-Friend option is used on the campaign, the results will be recorded under this section.
Total Send a Friend Forwards = includes the total number of additional emails deployed by recipients of the original campaign using the Send-a-Friend option.
Additional Email sent % = helps you understand how much the Send a Friend feature has contributed to your campaign results. It is the Total Deliverable Messages divided by the Total Send a Friend initiated emails.
Send a Friend Opens = Total Opens for all Send a Friend emails sent.
Send a Friend Opens percentage = Total Send a Friend forwarded emails sent divided by the number of Send a Friend Opens.
Send a Friend Clicks = Total clicks for all Send a Friend emails sent.
Send a Friend Clicks percentage = Total Send a Friend forwarded emails sent divided by the number of Send a Friend Clicks
|
Total Send a Friend Forwards |
21 |
Additional Email sent 1% |
|
Send a Friend Opens |
15 |
71% |
|
Send a Friend Clicks |
9 |
42% |
Note: all of the percentages in the right hand column are calculated by dividing the current number being reported on in the Total Deliverable Messages.
Total Opens/Clicks by day by URL:
This section displays the Total Opens and Clicks that occurred per day. It displays the Open or Click per day through Day 7. Day 14 is the total of Opens/Clicks that have occurred since Day 7. Day 21 is the total of Opens/Clicks that have occurred since Day 14. Day 30 is the total of Opens/Clicks that have occurred since Day 21.
The report has a line for Total Opens, Total Clicks and one line per tracked link in the message with total clicks per day.
Total Opens and Clicks by Day (with rolling totals)
This section reports the total number of Opens and Clicks that have occurred through the day. The report has a line for Total Opens, Total Clicks and one line per tracked link in the message with the total of clicks recorded as of that day.
Opens and Clicks By Keycode Value:
MDR’s list ordering system allows for email campaign list to be split into different segments. These segments can be used to isolate various subsections of the list so that they can be treated independently. MDR allows for these segments to be keycoded by various selection data. For example, you could keycode your list by Computer Intensity (how many computers in the classroom), then you would see open and click results by this keycoded detail.
All of the KeyCoded results are presented in a list that can be sorted by column headers. To view the campaign results by each individual Keycode, click on the [+]” icon and the report will expand with the campaign results broken out for the variables of that keycode.
See Appendix A for a complete listing of the eligible Keycodes for Campaign Analyzer reporting.
Literal Keycode by Day by URL
MDR’s list ordering system allows for email campaign list to be split into different segments. These segments can be used to isolate various subsections of the list so that they can be treated independently. MDR allows for customer labeling of these segments through the use of a “Literal” keycode. This means the customer creates and supplies MDR with a name for this segment that will be passed though as a “Literal” label.
This section will only populate if Literal keycodes were used in the list order.
All of the Literal Keycoded results are presented in a list that can be sorted by column headers. To view the campaign results by each individual Literal Keycode, click on the [+]” icon and the report will expand with the campaign results broken out for the variables of that Literal Keycode.
Expanded Literal Keycode View
Segment Opens and Clicks by Day by URL
MDR’s list ordering system allows for email campaign list to be split into different segments. These segments can be used to isolate various subsections of the list so that they can be treated independently.
This section will allow you to view the results of a particular list segment that was used in the list order.
All of the Segment results are presented in a list that can be sorted by column headers. To view the campaign results by each individual Segment, click on the [+]” icon and the report will expand with the campaign results broken out for the variables of that Segment.
Please consult with your Sales Account Rep or your Customer Service Support person for a copy of your list order segmentation criteria.
Segment - Expanded View
Campaign Results by Institution Type
Campaign Analyzer will break out the results of the campaign based on the different institutions where email was sent. Each institution-based section will display only if there were email addresses included in the campaign for that institution type.
Each Institution Type has a number of demographic elements against which campaign results can be compared.
List of Institution Type reporting categories:
a. District
b. Public Schools
c. Private
d. Catholic
e. College
f. Library
g. Daycare
These Institution result summaries will display in a collapsed format, by default. To expand or collapse them, simply click anywhere on the yellow title bar of the Institution you wish to view.
This Institution profile will be populated if there were email addresses included in the campaign for that institution type.
Districts By Enrollment Field Definitions:
Total Public District Universe = the total deliverable records (as defined in the Campaign Synopsis section) from the email addresses included in the campaign for that institution type.
Percent of Total = The Total Public District Universe divided by the Total Deliverable Messages of the campaign.
Universe Coverage = The number of the Total Public District Universe for each sub group (i.e. number of Total Public District Universe that falls into the 1-599 bucket)
Universe Coverage Percentage = The percent of this sub group to the Total Public District Universe
Total Opens = Total Opens from the campaign associated with this sub group.
Open Rate = The percent of opens in the this sub group to the total number of opens in the Total Public District universe.
Total Clicks = Total Clicks from the campaign associated with this sub group.
Click Rate = The percent of clicks in the this sub group to the total number of clicks in the Total Public District universe.
Enrollment Ranges = The following enrollment ranges are reported: 1-599, 600-1199, 1200-2499,2500-4999,5000-9999,10000-24999,25000+, Unclassified
District By Day Field Definitions:
This section displays the Total Opens and Clicks that occurred per day reported on. It displays the Opens or Clicks per day through Day 7. Day 14 is the total of Opens/Clicks that have occurred since Day 7. Day 21 is the total of Opens/Clicks that have occurred since Day 21. Day 30 is the total of Opens/Clicks that have occurred since Day 21.
The report has a line for Total Opens, total Clicks and all of the tracked links in the message with total clicks per day.
This Institution profile will be populated if there were emails in the campaign sent into this Institution type.
Public Schools by Enrollment Field Definitions:
Total Public Schools Universe = The total deliverable (as defined in Campaign Synopsis section) records from the outbound file that were from this file type
Percent Total of the campaign = The Total Public School Universe divided by the Total Deliverable Messages of the campaign.
Universe Coverage = The number of the Total Public School Universe for each sub group (i.e. number of Total Public School Universe that falls into the 1-99 bucket)
Universe Coverage Percentage = The percent of this sub group to the Total Public School Universe
Total Opens = Total Opens from the campaign associated with this sub group.
Open Rate = The percent of opens in the this sub group to the total number of opens in the Total Public School universe.
Total Clicks = Total Clicks from the campaign associated with this sub group.
Click Rate = The percent of clicks in the this sub group to the total number of clicks in the Total Public School universe.
Public Schools By Type Field Definitions:
Total Opens = Total Opens from the campaign associated with this data point
Total Clicks = Total Clicks from the campaign associated with this data point
School Types = Adult Ed, Combined, Elementary, Junior High School, Middle School, Middle, Special Ed, Senior High School, Vocational/Technical Ed
Public Schools By Metro Status Field Definitions:
Total Opens = Total Opens from the campaign associated with this data point
Total Clicks = Total Clicks from the campaign associated with this data point
Metro Status = Rural/Non-Metro, Suburban, Urban
Public School By Day Field Definitions:
This section reports the Total Opens and Clicks that occurred per day. It displays the Opens or Clicks per day through Day 7. Day 14 is the total of Opens/Clicks that have occurred since Day 7. Day 21 is the total of Opens/Clicks that have occurred since Day 21. Day 30 is the total of Opens/Clicks that have occurred since Day 21.
The report includes a line for Total Opens, Total Clicks and all of the tracked links in the message with total clicks per day.
This Institution profile will be populated if there were emails in the campaign sent into this Institution type.
Private Schools by Enrollment Field Definitions:
Total Private Schools Universe = The total deliverable (as defined in the Campaign Synopsis section) records (as defined in the Campaign Synopsis section) from the outbound file that were from this file type
Percent Total of the campaign = The Total Private School Universe divided by the Total Deliverable Messages of the campaign.
Universe Coverage = The number of the Total Private Schools Universe for each sub group (i.e. number of Total Private Schools Universe that falls into the 1-99 bucket)
Universe Coverage Percentage = The percent of this sub group to the Total Private Schools Universe
Total Opens = Total Opens from the campaign associated with this sub group.
Open Rate = The percent of opens in the this sub group to the total number of opens in the Total Private Schools universe.
Total Clicks = Total Clicks from the campaign associated with this sub group.
Click Rate = The percent of clicks in the this sub group to the total number of clicks in the Total Private Schools universe.
Private Schools By Type Field Definitions:
Total Opens = Total Opens from the campaign associated with this data point
Total Clicks = Total Clicks from the campaign associated with this data point
School Types = Adult Ed, Combined, Elementary, Junior High School, Middle School, Middle, Special Ed, Senior High School, Vocational/Technical Ed
Private Schools By Metro Status Field Definitions:
Total Opens = Total Opens from the campaign associated with this data point
Total Clicks = Total Clicks from the campaign associated with this data point
Metro Status = Rural/Non-Metro, Suburban, Urban
Private School By Day Field Definitions:
This section reports the Total Opens and Clicks that occurred per day. It displays the Opens or Clicks per day through Day 7. Day 14 is the total of Opens/Clicks that have occurred since Day 7. Day 21 is the total of Opens/Clicks that have occurred since Day 21. Day 30 is the total of Opens/Clicks that have occurred since Day 21.
The report has a line for Total Opens, Total Clicks and all of the tracked links in the message with total clicks per day.
This Institution profile will be populated if there were emails in the campaign sent into this Institution type.
Catholic Schools by Enrollment Field Definitions:
Total Catholic Schools Universe = The total deliverable records (as defined in the Campaign Synopsis section) from the outbound file for this file type
Percent Total of the campaign = The Total Catholic School Universe divided by the Total Deliverable Messages of the campaign.
Universe Coverage = The number of the Total Catholic School Universe for each sub group (i.e. number of Total Catholic School Universe that falls into the 1-99 bucket)
Universe Coverage Percentage = The percent of this sub group to the Total Catholic School Universe.
Total Opens = Total Opens from the campaign associated with this sub group.
Open Rate = The percent of opens in the this sub group to the total number of opens in the Total Catholic School Universe.
Total Clicks = Total Clicks from the campaign associated with this sub group.
Click Rate = The percent of clicks in the this sub group to the total number of clicks in the Total Catholic School Universe.
Catholic Schools By Type Field Definitions:
Total Opens = Total Opens from the campaign associated with this data point
Total Clicks = Total Clicks from the campaign associated with this data point
School Types = Adult Ed, Combined, Elementary, Junior High School, Middle School, Middle, Special Ed, Senior High School, Vocational/Technical Ed
Catholic Schools By Metro Status Field Definitions:
Total Opens = Total Opens from the campaign associated with this data point
Total Clicks = Total Clicks from the campaign associated with this data point
Metro Status = Rural/Non-Metro, Suburban, Urban
This section reports the Total Opens and Clicks that occurred per day. It displays the Opens or Clicks per day through Day 7. Day 14 is the total of Opens/Clicks that have occurred since Day 7. Day 21 is the total of Opens/Clicks that have occurred since Day 21. Day 30 is the total of Opens/Clicks that have occurred since Day 21.
The report has a line for Total Opens, Total Clicks and all of the tracked links in the message with total clicks per day.
This Institution profile will be populated if there were emails in the campaign sent into this Institution type.
Colleges by Enrollment Field Definitions:
Total Colleges Universe = The total deliverable records (as defined in Campaign Synopsis section) from the outbound file that were from this file type
Percent Total of the campaign = The Total College Universe divided by the Total Deliverable Messages of the campaign.
Universe Coverage = The number of the Total College Universe for each sub group (i.e. number of Total College Universe that falls into the 1-500 bucket)
Universe Coverage Percentage = The percent of this sub group to the Total College Universe.
Total Opens = Total Opens from the campaign associated with this sub group.
Open Rate = The percent of opens in the this sub group to the total number of opens in the Total College Universe.
Total Clicks = Total Clicks from the campaign associated with this sub group.
Click Rate = The percent of clicks in the this sub group to the total number of clicks in the Total College Universe.
Enrollment Ranges = The following enrollment ranges are reported: 1-500, 501-1,000, 1,001-2,500, 2,501-5,000, 5,001-7,500, 7,501-10,000, 10,001-16,000, 16,001-25,000, Over 25,000, Not Classified.
Colleges By Level Field Definitions:
Total Opens = Total Opens from the campaign associated with this data point
Total Clicks = Total Clicks from the campaign associated with this data point
School Types = Junior College, Senior College/Univ, Unclassified
Colleges By Metro Status Field Definitions:
Total Opens = Total Opens from the campaign associated with this data point
Total Clicks = Total Clicks from the campaign associated with this data point
Metro Status = Rural/Non-Metro, Suburban, Urban
Colleges By Day Field Definitions:
This section reports the Total Opens and Clicks that occurred per day. It displays the Opens or Clicks per day through Day 7. Day 14 is the total of Opens/Clicks that have occurred since Day 7. Day 21 is the total of Opens/Clicks that have occurred since Day 21. Day 30 is the total of Opens/Clicks that have occurred since Day 21.
The report has a line for Total Opens, Total Clicks and all of the tracked links in the message with total clicks per day.
This Institution profile will be populated if there were emails in the campaign sent into this Institution type.
Libraries by Population Served Field Definitions:
Total Libraries Universe = The total deliverable records (as defined in Campaign Synopsis section) from the outbound file that were from this file type
Percent Total of the Campaign = The Total Libraries divided by the Total Deliverable Messages of the campaign.
Universe Coverage = The number of the Total Libraries Universe for each sub group (i.e. number of Total Libraries Universe that falls into the 1-9999 bucket)
Universe Coverage Percentage = The percent of this sub group to the Total Libraries Universe.
Total Opens = Total Opens from the campaign associated with this sub group.
Open Rate = The percent of opens in the this sub group to the total number of opens in the Total Libraries Universe.
Total Clicks = Total Clicks from the campaign associated with this sub group.
Click Rate = The percent of clicks in the this sub group to the total number of clicks in the Total Libraries Universe.
Population Served Ranges = The following enrollment ranges are reported: 1-9999, 10,000-39,999, 40,000-79,999, 80,000-199,999, 200,000-399,999, 400,000-999,999, 1,000,000+, Unknown
Libraries By Metro Status Field Definitions:
Total Opens = Total Opens from the campaign associated with this data point
Total Clicks = Total Clicks from the campaign associated with this data point
Metro Status = Rural/Non-Metro, Suburban, Urban
Libraries By Day Field Definitions:
This section reports the Total Opens and Clicks that occurred per day. It displays the Opens or Clicks per day through Day 7. Day 14 is the total of Opens/Clicks that have occurred since Day 7. Day 21 is the total of Opens/Clicks that have occurred since Day 21. Day 30 is the total of Opens/Clicks that have occurred since Day 21.
The report has a line for Total Opens, Total Clicks and all of the tracked links in the message with total clicks per day.
This Institution profile will be populated if there were emails in the campaign sent into this Institution type.
Daycares by Population Served Field Definitions:
Total Daycares Universe = The total deliverable records (as defined in Campaign Synopsis section) from the outbound file that were from this file type
Percent Total of the Campaign = The Total Daycares by the Total Deliverable Messages of the campaign.
Universe Coverage = The number of the Total Daycares Universe for each sub group (i.e. number of Total Daycares Universe that falls into the 1-10 bucket)
Universe Coverage Percentage = The percent of this sub group to the Total Daycares Universe.
Total Opens = Total Opens from the campaign associated with this sub group.
Open Rate = The percent of opens in the this sub group to the total number of opens in the Total Daycares Universe.
Total Clicks = Total Clicks from the campaign associated with this sub group.
Click Rate = The percent of clicks in the this sub group to the total number of clicks in the Total Daycares Universe.
Population Served Ranges = The following enrollment ranges are reported: 1-9999, 10,000-39,999, 40,000-79,999, 80,000-199,999, 200,000-399,999, 400,000-999,999, 1,000,000+, Unknown
Daycares By Metro Status Field Definitions:
Total Opens = Total Opens from the campaign associated with this data point
Total Clicks = Total Clicks from the campaign associated with this data point
Metro Status = Rural/Non-Metro, Suburban, Urban
Daycares By Day Field Definitions:
This section reports the Total Opens and Clicks that occurred per day. It displays the Opens or Clicks per day through Day 7. Day 14 is the total of Opens/Clicks that have occurred since Day 7. Day 21 is the total of Opens/Clicks that have occurred since Day 21. Day 30 is the total of Opens/Clicks that have occurred since Day 21.
The report has a line for Total Opens, total Clicks and all of the tracked links in the message with total clicks per day.
Opens and Clicks by Job Title / Course Taught:
This section shows campaign summary total opens and clicks results by the Job Titles (K12) and/or Courses Taught (Higher Ed). The designation of Job Title or Course Taught is based on the Institution the Job Title or Course Taught that was selected via the list order. If a instructor holds multiple Job Titles, the Job Title that will be reported on will be the one specified when the list was ordered. If no Job Title was speficially requested via the list order, the results will be reported by default Job Title that the person holds.
Only campaigns that contain K12 or Higher Ed personnel will show up in the Opens and Clicks by Job Title / Course Taught report section.
Opens and Clicks by JobCodes/College Course Codes Field Definitions:
Deliverables = The total number of the Total Deliverable Messages universe that fall in this Job Title/Course Taught.
Total Opens = Total Opens from the campaign associated with this Job Title/Course Taught.
Open Rate = The percent of opens in this Job Title/Course Taught to the total number of deliverables in this Job Title/Course Taught.
Total Clicks = Total Clicks from the campaign associated with this Job Title/Course Taught.
Click Rate = The percent of clicks in the this sub group to the total number of deliverables in the Job Title/Course Taught.
This section contains a table that displays the results of the campaign by US state.
These Opens and Clicks by State results summaries will show up collapsed by default. To expand or collapse them, simply click anywhere on the yellow title bar of the Institution you wish to view.
This section will show the summary total opens and clicks by State. The designation of state is based on the Institution that the email address is associated with and the person associated to this email address.
Only states that were in the deployment that had results will show up in the Opens and Clicks by State report section.
Additionally, this report section will also show the total Clicks on the two most popular links in the message by state. This is does not show all the activity on all the links in the message, just the top two most selected across the entire campaign.
Total Opens and Clicks by State Field Definitions:
State = The state that the email address is associated with based on their institution’s mailing address.
Total Opens = Total Opens from the campaign associated with this data point.
Total Clicks = Total Clicks from the campaign associated with this data point.
Link 1 = The total clicks to the most clicked link in the campaign.
Link 2 = The total clicks to the second most clicked link in the campaign.
Campaign Analyzer has a Data Export (Export Details) feature where you can save all of the campaign results to several popular file formats including:
-
Adobe Acrobat (PDF)
-
Microsoft Excel
-
Microsoft Rich Text Format (Word)
-
TIFF image file
To initiate the Data Export function, click the [Export Detail] button located at the top of the report in the summary section.
This will open a new browser window with the Campaign Analyzer report in a report export screen.
From this screen you can choose a file format to export to from the drop down menu located at the top. The Export Link (located just to the right of the drop down box) will be greyed out and not clickable until you choose a file format. Once you select a file format from the list, the link will become active. Click it to initiate the file transfer.
Click on Open to open your file or Save to save it to your local hard drive:
Example of the Campaign Analyzer report exported and opened in Microsoft Excel format - NOTE: there are two are more tabs in the excel file, with the report summary on the first tab, and the segment detail on the second tab. There could be additional tabs if Literal Keycodes where used in the order
Example of the Campaign Analyzer report exported and opened in Microsoft Excel format - Segment Detail Tab:
Example of the Campaign Analyzer report exported and opened in Adobe PDF format:
Example of the Campaign Analyzer report exported in .RTF format and opened in Microsoft Word:
Example of the Campaign Analyzer report exported in .TIFF image format and opened with Microsoft Windows Picture and Fax Viewer :
Appendix A: Keycode Listing:
Below is a list of the eligible OMS keycodes and their associated file types that will be reported on by Campaign Analyzer. This is for informational purposes only. Consult your Sales Representative or Customer Service Specialist about your email campaign reporting requirements and they will help structure your OMS list appropriately for you.
|
Campaign Analyzer Keycode Reporting |
Allowed File Types* |
|
Address Type |
33 |
|
Affiliation Code – College |
18,19 |
|
AIM – All Instructional Materials Expenditures Code |
07,10 |
|
Book Budget Code – Library |
08,22 |
|
Closing Date Code |
07,10 |
|
College Level |
18,19 |
|
Computer Intensity |
10,11,12,15,16 |
|
Computer Quantity Range Code (Districts) |
07 |
|
Computer Quantity Range Code (Libraries) |
08 |
|
Computer Quantity Range Code (Schools) |
10,11,12,15,16 |
|
Current Expenditure Code |
07,10 |
|
Daycare Capacity Code |
17,21 |
|
Daycare Type Code |
17,21 |
|
Degree Level Code: Highest Degree Offered – College |
18,19 |
|
District Technology Budgets – Hardware |
07,10 |
|
District Technology Budgets – Software |
07,10 |
|
District Technology Budgets – Total IT |
07,10 |
|
District Technology Budgets – Training |
07,10 |
|
District Technology Budgets Per Pupil – Hardware |
07,10 |
|
District Technology Budgets Per Pupil – Software |
07,10 |
|
District Technology Budgets Per Pupil – Total IT |
07,10 |
|
District Technology Budgets Per Pupil – Training |
07,10 |
|
District Type Code |
07 |
|
EAH At School File type |
95 |
|
Enroll Range Code - College |
18,19 |
|
Enroll Range Code - District |
02,03,04,07,10 |
|
Enroll Range Code - School |
01,03,04,10,11,12,15,16,17 |
|
Faculty Size Code - College |
18,19 |
|
File Type |
33 |
|
File Type Number |
|
|
Grade Range Code |
01,02,03,04,06,07,10,11,12,15,16,17,21 |
|
Library Population Served |
8 |
|
Library Type Code |
08 |
|
Locale Code |
01,06,07,08,09,10,11,12,13,14,15,16,17,18,33,52,53,54,55,56,62,65,95 |
|
Metro Classification |
33 |
|
Metro Classification Code |
|
|
Opening Date Code |
07,10 |
|
Poverty Code |
07,10 |
|
Predominant Computer Brand Code |
10,11,12,15,16 |
|
School Type Code |
01,03,04,10,11,12,15,16 |
|
Test Scores - ACT % Student |
10,15,16 |
|
Test Scores - ACT Composite |
10,15,16 |
|
Test Scores – Math 3rd Grade |
10,15,16 |
|
Test Scores – Math 4th Grade |
10,15,16 |
|
Test Scores – Math 5th Grade |
10,15,16 |
|
Test Scores – Math 6th Grade |
10,15,16 |
|
Test Scores – Math 7th Grade |
10,15,16 |
|
Test Scores – Math 8th Grade |
10,15,16 |
|
Test Scores – Math Overall |
10,15,16 |
|
Test Scores – Reading 3rd Grade |
10,15,16 |
|
Test Scores – Reading 4th Grade |
10,15,16 |
|
Test Scores – Reading 5th Grade |
10,15,16 |
|
Test Scores – Reading 6th Grade |
10,15,16 |
|
Test Scores – Reading 7th Grade |
10,15,16 |
|
Test Scores – Reading 8th Grade |
10,15,16 |
|
Test Scores – Reading Overall |
10,15,16 |
|
Test Scores - SAT % Student |
10,15,16 |
|
Test Scores - SAT Composite |
10,15,16 |
|
Test Scores - SAT Math |
10,15,16 |
|
Test Scores - SAT Verbal |
10,15,16 |
|
VCR Presence (at District) |
07,10 |
|
VCR Presence (at School) |
10,11,12,15,16,17 |
|
VCR Quantity Code (at District) |
07,10 |
|
VCR Quantity Code (at School) |
10,11,12,15,16 |
|
Volumes (# of) Code – Library |
08,22 |
|
|
|
|
* This Keycode will be reported on if the list order contained one or more of the allowed File Types | |
|
|
|
|
File Type Translation |
|
|
001 BIA |
|
|
002 Canadian Districts |
|
|
003 Canadian Public Schools |
|
|
004 Canadian Private Schools |
|
|
006 Catholic Diocese |
|
|
007 Public Districts |
|
|
008 Public Libraries |
|
|
009 Regional Centers |
|
|
010 Public Schools |
|
|
011 Private Catholic Schools |
|
|
012 Private Non-Catholic Schools |
|
|
013 County Centers |
|
|
014 State Departments |
|
|
015 State Schools |
|
|
016 County Schools |
|
|
017 Day Care Centers |
|
|
018 Colleges |
|
|
019 Canadian Colleges |
|
|
021 Canadian Day Care Centers |
|
|
022 Canadian Libraries |
|
|
052 Head Start |
|
|
053 Special Libraries |
|
|
054 Overseas English-Speaking Schools (DOD) |
|
|
056 Prisons |
|
|
059 Seed |
|
|
062 U.S. Territory Schools |
|
|
068 College Coaches |
|