Monthly Record Load Statistics

Scope: Process for tracking vendor record load statistics at the beginning of each month
Contact: Heather Baker
Unit: Metadata & Discovery Strategy
Date last reviewed: 07/31/23
Date of next review: 07/31/24

At the beginning of each month, the vendor load statistics from the previous month are added to two spreadsheets. The stats are pulled from the most recent MARC Loads file in Box-MADS-MonthlyReports_QuarterlyReports-Vendor Marc Monthly Worksheet.

Open

Stats are added to the most recent file in Box-CS Marc Load Statistics

Open

And stats are added here:

Open

To begin,

Pull the following totals from the MARC loads spreadsheet:

1. For access print = shelf ready = YBP-SR-complete (found in row #3)

2. For payment print = for processing = YBP-SR-incomplete, YBP-UK, and all print loads (found in row #26)

3. For access electronic = electronic records = E-YBP and streaming media (found in row #50)

4. Marcive authority loads = bib updates and authority record updates

5. EOCRs for Electronic Processing (found in row #8)

Next, go to Box, CS MARC Load Statistics:

• Adding to purple MADS tab and blue TS Totals tab

• For MADS tab:

  • MARC Print for Processing, row 3 = #2 above

  • MARC Print for Access, row 4 = #1 above

  • MARC Electronic for Access, row 5 = #3 above

  • EOCRs for Electronic Processing, row 6 = #5 above

• For TS Totals tab:

  • Authority Control Updates, row 10 = #4a above

Also need to add stats to Box, MADS, Monthly ReportsQuarterlyReports, QuarterlyVendorRecordLoads:

• MARC for Print Access, row 3 = #1 above

• MARC for Electronic Access, row 4 = #3 above

• MARC for Print Processing, row 5 = #2 above

• MARCIVE Updates (Bib), row 14 = #4a above

• MARCIVE Aut AC, row 15 = #4b above

• EOCRs for Electronic Processing, row 6 = #5 above