Skip to main content
Procore

Procore Analytics: Q2 2021 Releases

This announcement represents a single point in time. Future releases may impact the information below.
Feature Released: June 23, 2021


Procore Analytics: Q2 2021 Releases

The following sections outline the updates included in the Q2 release for Procore Analytics.

All Reports

  • Upgraded to support the Power BI May 2021 update.

Specialty Contractor Report

  • Production Report Report Page:
    • Added the ability to perform point-in-time production reporting using a new 'Date' picker. This allows closer monitoring of production rate data by narrowing it down to specific date ranges.
    • Added new financial metrics to track 'Job To Date Costs' from the project's Direct Costs and Invoicing tools.

      procore-analytics-q2-2021-ann-production-report.png

This sample report was created using fictitious data for demonstration purposes only.
 


Quality & Safety Report

  • TRIFR Analysis Report Page:
    • Report page created. This report page provides detailed analysis on data from the project's Incidents tool and reports on industry safety metrics such as Total Recordable Injury Frequency Rate (TRIFR), Lost Time Injury Frequency Rate (LTIFR), First Aid Injury Frequency Rate (FAIFR), and Medically Treated Injury Frequency Rate (MTIFR). This allows you to analyze the frequency rate of these occurrences over time and can help you to better understand the behaviors that can lead to various types of incidents.

      procore-analytics-q2-2021-ann-trifr-analysis.png

This sample report was created using fictitious data for demonstration purposes only.
 


Financials Report

  • Subcontractor Invoices Report Page:
    • Added 'Contract Title' to filter pane.
    • Added 'Invoice Line Item' visual to allow you to see the cost code breakdown of each invoice.

      procore-analytics-q2-2021-ann-subcontractor-invoices.png

This sample report was created using fictitious data for demonstration purposes only.
 

  • Commitment Payments Issued Report Page:
    • Added 'Purchase Order Contract Title' filter to filter pane.
    • Added 'Work Order Contract Title' filter to filter pane.
  • Subcontractor Payment Reconciliation Report Page:
    • Added 'Contract Title' filter to filter pane.
  • Commitment Purchase Order Contracts Report Page:
    • Added 'Purchase Order Contract Title' filter to filter pane.
  • Commitment Purchase Order Change Orders Report Page:
    • Added 'Purchase Order Contract Title' filter to filter pane.
  • Commitment Work Order Contracts Report Page:
    • Added 'Work Order Contract Title' filter to filter pane.
  • Commitment Work Order Change Orders Report Page:
    • Added 'Work Order Contract Title' filter to filter pane.
  • All report pages:
    • Added 'Prime Contract Title' filter to filter pane.

Project Management Report

  • Projects Report Page:
    • 'Custom Fields' slicer removed.
  • Metrics Correlation Report Page:
    • Report page removed.
  • All report pages:
    • Added 'Project Custom Field Name' filter to filter pane.
    • Added 'Project Custom Field Value' filter to filter pane.

Database Changes with Procore Data Extract

See all database changes to Procore Data Extract in the 'Change Log' tab here.

New Reportable Field from Procore's RFIs Tool

  • Added: New reportable field in the RFI table based on user-defined custom fields for the project's RFIs tool:
    • custom_fields

New SQL View for Procore's RFIs Tool

  • Added: New SQL view called vwRFICustomField that reports on custom field data for the project's RFIs tool in the following columns:
    • RFIID
    • ProjectID
    • company_id
    • custom_field_key
    • custom_field_key_label
    • custom_field_id
    • custom_field_data_type
    • custom_field_value
    • custom_field_option_id

Coming Soon  New Reportable Fields from Procore's Invoicing Tool

  • Added: New SQL table called DrawRequestLineItem that reports on schedule of value data for subcontractor invoices in the following columns:
    • id
    • amount
    • company_id
    • company_name
    • cost_code_id
    • cost_code_biller
    • cost_code_biller_id
    • cost_code_biller_type
    • cost_code_code
    • cost_code_created_at
    • cost_code_deleted_at
    • cost_code_full_code
    • cost_code_name
    • cost_code_origin_data
    • cost_code_origin_id
    • cost_code_parent_id
    • cost_code_position
    • cost_code_sortable_code
    • cost_code_updated_at
    • created_at
    • description
    • extended_type
    • holder_id
    • holder_type
    • line_item_type_id
    • line_item_type_name
    • line_item_type_code
    • line_item_type_base_type
    • origin_data
    • origin_id
    • position
    • quantity
    • total_amount
    • unit_cost
    • uom
    • updated_at
    • infoJson
    • DirectCostID
    • ProjectID
    • DateUpdated

Coming Soon  New Reportable Fields from Procore's Admin Tool

  • Added: New reportable field in the Project table based on user-defined custom fields for the 'Project' fieldset:
    • custom_fields_v2
 Important

Project.custom_fields will be migrated to a new field starting on July 30, 2021. After the migration is complete, any of your company's custom Procore Analytics reports using Project.custom_fields will need to be updated. Contact analyticssupport@procore.com for more information.

 

Coming Soon  New SQL View from Procore's Admin Tool

  • Added: New SQL view called vwProjectCustomField that reports on custom field data for the 'Project' fieldset:
    • ProjectID
    • company_id
    • custom_field_key
    • custom_field_key_label
    • custom_field_id
    • custom_field_data_type
    • custom_field_value
    • custom_field_option_id

 

If you would like to ask questions or share any feedback, please contact analyticssupport@procore.com.