Back to Hub
• Smart Summary Stats • Logic v3.0

DSP Scorecard
Extractor

Automatically calculates Total Delivered and Per-File breakdown.

Drop your PDFs here

(Multiple files supported)

About DSP Scorecard Extractor

Automate your DSP scorecard analysis with our intelligent extractor. This tool processes multiple PDF scorecards, extracts key performance metrics like Delivered packages and FICO scores, and compiles them into a single, structured report.

How to Use
  1. Upload your DSP scorecard PDF files.
  2. Monitor the real-time extraction progress.
  3. Review the per-file delivered counts and total metrics.
  4. Inspect the extracted data table for accuracy.
  5. Download the complete report as a formatted Excel file.
Key Features
  • Smart header and table detection
  • Multi-page PDF support
  • Automatic data normalization and validation
  • Detailed summary and per-file statistics
  • Real-time processing feedback
  • One-click Excel export

What is the DSP Scorecard Extractor?

The DSP Scorecard Extractor by Ztoolx is a mission-critical utility for Delivery Service Partners looking to optimize their performance and streamline their back-office operations. It leverages intelligent coordinate-based extraction to pull vital KPIs from multiple PDF scorecards simultaneously. By aggregating data points such as total deliveries, FICO scores, seatbelt compliance, and distraction rates into a single master spreadsheet, it enables managers to conduct deep-dive performance audits and identify coaching opportunities with unprecedented speed.

How to Use the Scorecard Extractor

Analyzing your team's weekly performance is simple and secure:

  1. Batch Upload: Select all your weekly PDF scorecards. Our tool can process dozens of files at once, saving you from the "one-by-one" data entry trap.
  2. Real-Time Monitoring: Watch as the extractor identifies headers and parses rows in real-time. You'll see immediate stats on files processed and rows validated.
  3. Audit the Summary: Use our unique "Summary Cards" to see a high-level breakdown of total packages delivered across all files, as well as a per-file breakdown for easy cross-referencing.
  4. Download Master Report: Export everything to a clean, structured Excel file. The output is pre-formatted for further analysis or integration with your internal HR and payroll systems.

Key Benefits

  • Intelligent Data Merging: Our "Logic v3.0" engine handles multi-line names and non-standard row spacing, ensuring that your data remains structured and accurate even with complex PDF layouts.
  • Multi-Metric Extraction: Go beyond just "Delivered" counts. Extract FICO scores, POD opportunities, CDF DPMO, and safety rates (speeding, distractions, following distance) all in one go.
  • Automated Validation: Built-in numeric validation ensures that metrics like "Delivered" packages are extracted as clean numbers, ready for mathematical analysis without manual cleanup.
  • Privacy & Security: We understand the sensitivity of performance data. That's why every byte is processed locally in your browser. No data ever leaves your device.

Frequently Asked Questions (FAQ)

Can I process scorecards from different weeks?

Yes. The tool is designed to be agnostic of the specific week. As long as the PDF follows the standard scorecard layout, it can aggregate data across any timeframe.

How does it handle multi-line driver names?

We use sophisticated Y-coordinate clustering to "stitch" multi-line text back together. This ensures that names like "John Michael Smith" are captured as a single, coherent string.

What if a column is missing in my PDF?

Our extractor uses a "flexible midpoint" boundary system. If a column isn't present in a specific file, it will simply leave those cells blank in the output while continuing to extract the remaining data.