Procore Analytics 2.0
Procore Analytics 2.0 has 3 guiding pillars of value today and in the future to make a user-friendly product that gives access to all of your data, with business intelligence included. Ultimately, this allows you to quickly access any Procore data you need and gain value from it to make informed, data-driven decisions. See Getting Started With Analytics 2.0 to begin your journey today.
Key benefits include:
|
 |
- Getting Started With Procore Analytics 2.0
- About Procore Analytics 2.0
- Add Custom Views for Procore Analytics 2.0
- Configure a Custom Budget Report
- Connect to Power BI Desktop
- Connect Your Procore Data by Downloading Analytics Models
- Connect Your Procore Data to Your Databricks Workspace
- Generate an Access Token
- Migrate an Existing Report to Procore Analytics 2.0
- Rename Report Tables and Columns in Procore Analytics 2.0
- Set Up Row-Level Security for Procore Analytics 2.0
- Upload Reports to the Power BI Service
Getting Started with Procore Analytics 2.0
Connect to Power BI
Copy Data to Microsoft Fabric Lakehouse Using Dataflow and Delta Sharing
Getting Started with Procore Analytics 2.0 (Open Beta)
Video content may not accurately reflect the current state of the system, and/or it may be out of date.
- Analytics 2.0 General FAQ
- Do I still need Power BI licences to access Procore Analytics 2.0?
- How do I connect to Procore Analytics 2.0?
- How do I update the custom reports that were developed in-house?
- How do permissions work for Analytics 2.0?
- How frequent is the data refresh?
- How will Procore-built customer reports get migrated to 2.0?
- How will the process for copying data to my data warehouse be affected by 2.0?
- What are the differences between the various budget reports in Procore Analytics?
- What is the plan for deprecating Procore Analytics 1.0?
- Why is my data still not showing after generating a token and making a connection?
- Will customers only on Data Extract have to migrate to 2.0?
Learn which user permissions are required to take the described actions in this tool.
Permissions
| | The action is available on Procore's Web, iOS, and/or Android application. Click to view the article.
Users can take the action with this permission level.
Users can take this action with this permission level AND one or more additional requirements, like granular permissions.
Note
- To learn more about permissions, see How do permissions work for Procore Analytics 2.0?
- Procore Analytics 2.0 follows the same permissions as Procore objects. Note that objects with private and super private function the same as noted in the Procore Users Permissions Matrix.
| Action | None | Read Only | Standard | Admin | Notes |
|---|---|---|---|---|---|
|
Add Custom Views |
  |
||||
|
Configure A Custom Budget Report |
|
||||
|
Generate A Data Token |
|
|
|
Below are the notable changes to Procore Analytics 2.0.
Recent Changes
Speciality contractor report now available in procore analytics 2.0 (22/04/2025)
Procore has introduced an enhanced version of the Speciality Contractor Report using our new Power BI design system.
Incremental refresh now available in procore analytics 2.0 (22/04/2025)
Procore Analytics 2.0 has launched an incremental refresh feature, which significantly enhances data processing efficiency by only updating changed data. This optimization leads to substantial improvements in performance and significant reductions in resource consumption.
delta lake time travel now available in procore analytics 2.0 (22/04/2025)
Procore's new Delta Lake time travel feature allows users to query the previous 7 days of table history for all Procore Analytics 2.0 tables, enabling them to recreate past analyses, construct temporal queries, and rectify data errors.
new and enhanced report options now available in procore analytics 2.0 (18/03/2025)
Procore has introduced enhanced versions of existing report templates, as well as new templates, in an open beta for Analytics 2.0. Reports offerings include:
- Risk Report using our new design system (Power BI)
- Adoption Report using our new design system (Power BI)
- Financials and Budget Reports using our new design system (Power BI)
User activity now available in procore analytics 2.0 (18/03/2025)
Procore has expanded the capabilities of Procore Analytics by adding user activity data access, enabling Project and Company Admins to gain a comprehensive view of user actions across various tools. The User Activity Data feature allows customers to pull raw user activity from a rolling seven day dataset, facilitating the creation of searchable datasets and aggregations.
'Last updated' timestamps now available in procore analytics 2.0 (18/03/2025)
Procore has introduced the 'Last Updated' timestamp feature in Procore Analytics 2.0, enhancing data transparency and ensuring stakeholders have access to the most current information. This feature benefits Procore Analytics users by providing clear visibility into data changes, improving collaboration and decision-making.
Procore Analytics 2.0 Data Connectors (21/01/2025)
Procore has introduced a new in-app Procore Analytics Data Connector experience in the Getting Started area of Procore Analytics. This new in-app experience allows customers to select from a menu of connection options to connect to Procore Analytics 2.0. The Procore Analytics Data Connector user experience enables customers to choose their preferred data connection method and access resources like documentation, videos, and executable files to facilitate their connection to Procore Analytics data. See Getting Started With Procore Analytics to learn more.
Procore Analytics 2.0 custom budget report is now available (09/11/2024)
The Procore Analytics 2.0 Financials Budget Report is now available for customers. This report integrates various financial aspects of project management, helping users track and analyse budget performance in detail. See About Procore Analytics 2.0 to learn more.
Procore analytics 2.0 now available for new and existing customers (23/09/2024)
Analytics 2.0 is designed to provide deeper insights into project performance and outcomes. Analytics 2.0 introduces several enhancements and new features aimed at improving data accessibility, accuracy, and usability. See About Procore Analytics 2.0 to learn more.
Procore Analytics 2.0 is now available in open beta (17/07/2024)
Existing Procore Analytics customers can now join the open beta for Analytics 2.0. Analytics 2.0 is our new and improved Analytics solution offering many enhancements customers have requested. See About Procore Analytics 2.0 to learn more.
Below are the notable changes to the Procore data and intelligence layer accessible via the Procore Analytics 2.0 Cloud Connector.
Recent Changes
procore analytics 2.0 data updates (coming soon!)
Procore added the following models (tables):
- Company_folder_documents
- Folder_documents
- Folder_watchers
- Equipment_telematic
- wp_project_custom_fields
- estimating_project_custom_field_configs
Procore updated the following models (tables):
- Changes in project_users:
- Added project_users.abbreviated_name
- Added project_users.add_to_new_projects
- Added project_users.address
- Added project_users.business_phone_extension
- Added project_users.cached_full_name
- Added project_users.can_add_new_projects
- Added project_users.can_push_to_accounting
- Added project_users.city
- Added project_users.classification
- Added project_users.company_name
- Added project_users.company_permission_template
- Added project_users.contact_id
- Added project_users.country_name
- Added project_users.deliverable
- Added project_users.email_signature
- Added project_users.external_origin_data
- Added project_users.external_origin_id
- Added project_users.is_company_primary_contact
- Added project_users.is_insurance_manager
- Added project_users.last_activated_at
- Added project_users.login
- Added project_users.login_information_id
- Added project_users.name
- Added project_users.new_project_permission_template_id
- Added project_users.origin_id
- Added project_users.origin_name
- Added project_users.permission_template
- Added project_users.permission_template_project_specific
- Added project_users.pk_user_id
- Added project_users.project_roles
- Added project_users.project_user_id
- Added project_users.send_this_user_messages
- Added project_users.state_name
- Added project_users.user_resource_url
- Added project_users.users_slony
- Added project_users.welcome_email_sent_at
- Changes in subcontractor_invoice_line_items:
- Added subcontractor_invoice_line_items.adjusted_materials_previously_stored
- Added subcontractor_invoice_line_items.adjusted_materials_previously_stored_company_currency
- Added subcontractor_invoice_line_items.adjusted_materials_previously_stored_project_currency
- Added subcontractor_invoice_line_items.adjusted_materials_retained_previously
- Added subcontractor_invoice_line_items.adjusted_materials_retained_previously_company_currency
- Added subcontractor_invoice_line_items.adjusted_materials_retained_previously_project_currency
- Added subcontractor_invoice_line_items.gross_amount
- Added subcontractor_invoice_line_items.gross_amount_company_currency
- Added subcontractor_invoice_line_items.gross_amount_project_currency
- Added subcontractor_invoice_line_items.net_amount
- Added subcontractor_invoice_line_items.net_amount_company_currency
- Added subcontractor_invoice_line_items.net_amount_project_currency
- Added subcontractor_invoice_line_items.retention_new_materials_from_percent
- Added subcontractor_invoice_line_items.retention_new_materials_from_percent_company_currency
- Added subcontractor_invoice_line_items.retention_new_materials_from_percent_project_currency
- Added subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous
- Added subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous_company_currency
- Added subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous_project_currency
- Added subcontractor_invoice_line_items.commitment_line_item_id
- Added subcontractor_invoice_line_items.prime_contract_line_item_id
- Changes in submittals:
- Added submittals.anticipated_delivery_date_at_close
- Added submittals.remaining_buffer_time_at_close
- Added submittals.workflow_progress_at_close
- Changes in wp_people:
- Added wp_people.custom_fields
- Changes in wp_projects:
- Added wp_projects.custom_fields
- Changes in budget_view_details:
- Added budget_view_details.infojson_currency_conversion
procore analytics 2.0 data updates (20/05/2025)
Procore added the following models (tables):
- project_company_comments
- tags
Procore updated the following models (tables):
- Changes in company_comments:
- Added company_comments.audit_transaction_timestamp
- Added company_comments.rating
- Changes in company_distribution_groups:
- Added company_distribution_groups.audit_transaction_timestamp
- Added ,company_distribution_groups.project_id
- Changes in project_distribution_groups:
- Added project_distribution_groups.audit_transaction_timestamp
- Added ,project_distribution_groups.company_id
- Changes in project_tools:
- Added project_tools.audit_transaction_timestamp
- Added ,project_tools.is_active
- Changes in budget_codes:
- Added ,budget_codes.production_quantity_code_description
- Changes in drawing_attachment:
- Added ,drawing_attachment.folder_document_id
- Changes in inspections:
- Added ,inspections.closed_at
- Changes in equipment:
- Added ,equipment.status_type
- Changes in field_productivity:
- Added ,field_productivity.hours_utilization_enrp
- Added ,field_productivity.projected_hours_at_completion_enrp
procore analytics 2.0 data updates (22/04/2025)
Procore added the following models (tables):
- budget_forecasts
- early_pay_program
- early_pay_program_enrollment
- task_distribution_member
- wp_roles
- estimate_budget_item
- estimate_budget_item_WBS_value
- estimate_budget_included_item
- procore_analytics_metadata
Procore updated the following models (tables):
- Changes in project_role_memberships:
- Added: project_role_memberships.employee_id
- Changes in project_vendors:
- Added: project_vendors.cost_codes
- Added: project_vendors.trades
- Changes in projects:
- Added: projects.schedule_last_updated
- Added: projects.schedule_percent_completion
- Changes in vendors:
- Added: vendors.cost_codes
- Added: vendors.trades
- Changes in budget_change_adjustment_line_items:
- Added: budget_change_adjustment_line_items.budget_changes_approved_amount
- Added: budget_change_adjustment_line_items.budget_changes_approved_amount_company_currency
- Added: budget_change_adjustment_line_items.budget_changes_approved_amount_project_currency
- Added: budget_change_adjustment_line_items.budget_changes_draft_amount
- Added: budget_change_adjustment_line_items.budget_changes_draft_amount_company_currency
- Added: budget_change_adjustment_line_items.budget_changes_draft_amount_project_currency
- Added: budget_change_adjustment_line_items.budget_changes_under_review_amount
- Added: budget_change_adjustment_line_items.budget_changes_under_review_amount_company_currency
- Added: budget_change_adjustment_line_items.budget_changes_under_review_amount_project_currency
- Changes in budget_columns:
- Added: budget_columns.budget_column_id
- Changes in budget_snapshot_line_item_forecasts:
- Added: budget_snapshot_line_item_forecasts.approval_status
- Added: budget_snapshot_line_item_forecasts.snapshot_type
- Changes in budget_snapshot_line_item_headers:
- Added budget_snapshot_line_item_headers.approval_status
- Added: budget_snapshot_line_item_headers.audit_transaction_timestamp
- Added: budget_snapshot_line_item_headers.snapshot_type
- Changes in budget_snapshot_line_items:
- Added budget_snapshot_line_items.approval_status
- Added: budget_snapshot_line_items.audit_transaction_timestamp
- Added: budget_snapshot_line_items.snapshot_type
- Changes in change_event_line_item_with_markups:
- Added: change_event_line_item_with_markups.links_commitment_contract_cost
- Added: change_event_line_item_with_markups.links_commitment_pco_cost
- Added: change_event_line_item_with_markups.links_contract
- Added: change_event_line_item_with_markups.links_edit
- Added: change_event_line_item_with_markups.links_prime_pco_cost
- Added: change_event_line_item_with_markups.links_rfq_amount
- Added: change_event_line_item_with_markups.links_rom
- Added: change_event_line_item_with_markups.links_view
- Changes in commitment_line_items:
- Added: commitment_line_items.contracts_approved_amount
- Added: commitment_line_items.contracts_approved_amount_company_currency
- Added: commitment_line_items.contracts_approved_amount_project_currency
- Added: commitment_line_items.contracts_complete_amount
- Added: commitment_line_items.contracts_complete_amount_company_currency
- Added: commitment_line_items.contracts_complete_amount_project_currency
- Added: commitment_line_items.contracts_draft_amount
- Added: commitment_line_items.contracts_draft_amount_company_currency
- Added: commitment_line_items.contracts_draft_amount_project_currency
- Added: commitment_line_items.contracts_out_for_signature_amount
- Added: commitment_line_items.contracts_out_for_signature_amount_company_currency
- Added: commitment_line_items.contracts_out_for_signature_amount_project_currency
- Changes in commitments:
- Added: commitments.global_insurance_compliance
- Added: commitments.project_insurance_compliance
- Added: commitments.remaining_balance
- Added: commitments.revised_contract_amount
- Changes in payments_issued:
- Added: payments_issued.early_pay_fee_amount
- Changes in payments_project_controls:
- Added payments_project_controls.assigned_early_pay_program
- Added: payments_project_controls.audit_transaction_timestamp
- Added: payments_project_controls.early_pay_program_id
- Changes in payments_subtier_waivers:
- Added: payments_subtier_waivers.joint_check_commitment progress claim
- Changes in payments_subtiers:
- Added payments_subtiers.additional_address_information
- Added: payments_subtiers.address
- Added: payments_subtiers.amount_billed_to_date
- Added: payments_subtiers.city
- Added: payments_subtiers.country
- Added: payments_subtiers.joint_check_future_commitment progress claims
- Added: payments_subtiers.kind_of_work
- Added: payments_subtiers.phone
- Added: payments_subtiers.state
- Added: payments_subtiers.subtier_type
- Added: payments_subtiers.waiver_contact_email
- Added: payments_subtiers.zip
- Changes in head_contract_change_order_requests:
- Added: head_contract_change_order_requests.schedule_impact_days
- Changes in head_contract_change_orders:
- Added: head_contract_change_orders.schedule_impact_days
- Changes in head_contract_potential_change_orders:
- Added: head_contract_potential_change_orders.schedule_impact_days
- Changes in subcontractor_invoices:
- Added: subcontractor_invoices.early_pay_fee_amount
- Added: subcontractor_invoices.early_pay_fee_rate
- Added: subcontractor_invoices.early_pay_status
- Added: subcontractor_invoices.missed_payment_due_date
- Added: subcontractor_invoices.original_payment_due
- Added: subcontractor_invoices.original_payment_due_company_currency
- Added: subcontractor_invoices.original_payment_due_project_currency
- Added: subcontractor_invoices.payment_due_date
- Changes in correspondence_types:
- Added: correspondence_types.created_at
- Changes in correspondence_workflow_steps:
- Added: correspondence_workflow_steps.current_step_due_date
- Changes in daily_log_accident_custom_fields:
- Added: daily_log_accident_custom_fields.type_id
- Changes in daily_log_completion:
- Added: daily_log_completion.created_at
- Changes in daily_log_construction_report_custom_fields:
- Added: daily_log_construction_report_custom_fields.type_id
- Changes in daily_log_delay_custom_fields:
- Added: daily_log_delay_custom_fields.type_id
- Changes in daily_log_delivery_custom_fields:
- Added: daily_log_delivery_custom_fields.type_id
- Changes in daily_log_skip_custom_fields:
- Added: daily_log_skip_custom_fields.type_id
- Changes in daily_log_equipment:
- Added: daily_log_equipment.equipment_id
- Added: daily_log_equipment.equipment_identification_number
- Added: daily_log_equipment.equipment_name_beta
- Changes in daily_log_equipment_custom_fields:
- Added: daily_log_equipment_custom_fields.type_id
- Changes in daily_log_inspection_custom_fields:
- Added: daily_log_inspection_custom_fields.type_id
- Changes in daily_log_working hours_custom_fields:
- Added: daily_log_working hours_custom_fields.type_id
- Changes in daily_log_plan_revision_custom_fields:
- Added: daily_log_plan_revision_custom_fields.type_id
- Changes in daily_log_productivity_custom_fields:
- Added: daily_log_productivity_custom_fields.type_id
- Changes in daily_log_scheduled_work_task:
- Added: daily_log_scheduled_work_task.created_at
- Changes in drawing_revision:
- Added: drawing_revision.created_at
- Changes in incident_alert:
- Added: incident_alert.created_at
- Added: incident_alert.updated_at
- Changes in inspection_distribution_list:
- Added: inspection_distribution_list.created_at
- Added: inspection_distribution_list.updated_at
- Changes in inspection_item_signature_requests:
- Added: inspection_item_signature_requests.created_at
- Added: inspection_item_signature_requests.updated_at
- Changes in inspection_schedule_assignees:
- Added: inspection_schedule_assignees.created_at
- Added: inspection_schedule_assignees.updated_at
- Changes in inspection_schedule_distribution_list:
- Added: inspection_schedule_distribution_list.created_at
- Added: inspection_schedule_distribution_list.updated_at
- Changes in inspection_schedules:
- Added: inspection_schedules.created_at
- Added: inspection_schedules.equipment_id
- Added: inspection_schedules.equipment_identification_number
- Added: inspection_schedules.equipment_name
- Added: inspection_schedules.updated_at
- Changes in meeting_attendee:
- Added: meeting_attendee.created_at
- Added: meeting_attendee.updated_at
- Changes in meeting_item_assignee:
- Added: meeting_item_assignee.updated_at
- Changes in observation_distribution_member:
- Added: observation_distribution_member.created_at
- Changes in defect_item:
- Added: defect_item.audit_transaction_timestamp
- Changes in defect_item_bic:
- Added defect_item_bic.audit_transaction_timestamp
- Added: defect_item_bic.ball_in_court_role
- Changes in defect_item_custom_fields:
- Added: defect_item_custom_fields.type_id
- Changes in defect_item_distribution_member:
- Added defect_item_distribution_member.audit_transaction_timestamp
- Changes in rfi_assignees:
- Added: rfi_assignees.audit_transaction_timestamp
- Changes in rfi_distributions:
- Added rfi_distributions.audit_transaction_timestamp
- Changes in rfi_responses:
- Added rfi_responses.audit_transaction_timestamp
- Changes in rfis:
- Added: rfis.audit_transaction_timestamp
- Added: rfis.current_revision
- Added: rfis.revision
- Changes in rfis_bic:
- Added rfis_bic.audit_transaction_timestamp
- Added: rfis_bic.ball_in_court_role
- Changes in program_calendar_item:
- Added: program_calendar_item.audit_transaction_timestamp
- Changes in program_lookahead:
- Added program_lookahead.audit_transaction_timestamp
- Changes in program_lookahead_task:
- Added: program_lookahead_task.audit_transaction_timestamp
- Changes in program_task:
- Added: program_task.audit_transaction_timestamp
- Changes in program_task_changes:
- Added: program_task_changes.audit_transaction_timestamp
- Changes in program_task_requests:
- Added program_task_requests.audit_transaction_timestamp
- Changes in site_instructions:
- Added: site_instructions.audit_transaction_timestamp
- Changes in specification_sections:
- Added specification_sections.audit_transaction_timestamp
- Changes in submittal_approvers:
- Added submittal_approvers.audit_transaction_timestamp
- Added: submittal_approvers.comments
- Changes in submittal_ball_in_courts:
- Added submittal_ball_in_courts.audit_transaction_timestamp
- Added: submittal_ball_in_courts.response_required
- Changes in submittal_distributions:
- Added submittal_distributions.audit_transaction_timestamp
- Changes in submittals:
- Added: submittals.audit_transaction_timestamp
- Added: submittals.closed_at
- Changes in task:
- Added: task.audit_transaction_timestamp
- Changes in task_activity:
- Added: task_activity.audit_transaction_timestamp
- Changes in task_assignee:
- Added: task_assignee.audit_transaction_timestamp
- Changes in equipment:
- Added: equipment.rental_end_date
- Added: equipment.rental_start_date
- Added: equipment.vendor_name
- Changes in field_productivity:
- Added: field_productivity.cost_code_id
- Added: field_productivity.production_quantity_code
procore analytics 2.0 data updates (18/03/2025)
Procore added the following models (tables):
- Budget Code Segments
- Layer WBS Values
- Layer Group WBS Values
- Estimate Adjustment
Procore updated the following models (tables):
- Changes in correspondence_workflow_steps
- Added current_step_due_date
- Added current_step_name
- Changes in payments_disbursements
- Added owner_invoices.tax_applicable_to_this_payment_company_currency
- Added owner_invoices.tax_applicable_to_this_payment_project_currency
- Changes in subcontractor_invoice_line_items
- Added payments_disbursements.number
- Added subcontractor_invoice_line_items.total_retention_company_currency
- Added subcontractor_invoice_line_items.total_retention_project_currency
- Changes in action_plan
- Added action_plan.audit_transaction_timestamp
- Changes in action_plan_approver
- Added action_plan_approver.audit_transaction_timestamp
- Changes in action_plan_completed_receiver
- Added action_plan_completed_receiver.audit_transaction_timestamp
- Changes in action_plan_line_item
- Added action_plan_line_item.audit_transaction_timestamp
- Changes in action_plan_line_item_assignee
- Added action_plan_line_item_assignee.audit_transaction_timestamp
- Changes in action_plan_line_item_record
- Added action_plan_line_item_record.audit_transaction_timestamp
- Changes in action_plan_line_item_record_request
- Added action_plan_line_item_record_request.audit_transaction_timestamp
- Changes in action_plan_line_item_reference
- Added action_plan_line_item_reference.audit_transaction_timestamp
- Changes in drawing_revision
- Added drawing_revision.is_connected_drawing
- Changes in incident_record
- Added incident_record.affected_person_id
- Changes in observation
- Added observation.created_by_company
- Changes in rfi_responses
- Added rfi_responses.is_most_recent
- Changes in rfis_bic
- Added rfis_bic.response_required
- Changes in program_task
- Added program_task.predecessor_wbs_list
- Added program_task.successor_wbs_list
- Changes in specification_sections
- `Added specification_sections.specification_area_description
- Added specification_sections.specification_area_name
- Changes in submittal_approvers
- Added submittal_approvers.previous_due_date
- Added submittal_approvers.previous_returned_date
- Added submittal_approvers.previous_sent_date
- Changes in wp_projects
- Added wp_projects.categories
- Added users.audit_transaction_timestamp
- Added estimate_layer_groups.profit
procore analytics 2.0 data updates (18/02/2025)
Procore added the following models (tables):
- Financial
- payments_permissions
- payments_disbursements
- pay_requirement_settings
- payments_project_controls
- payments_invites
- payments_agreements
- payments_received
- Project Management
- connected_rfi_responses
- connected_rfis
- daily_log_accident_custom_field_configs
- daily_log_accident_custom_fields
- daily_log_delay_custom_field_configs
- daily_log_delay_custom_fields
- daily_log_delivery_custom_field_configs
- daily_log_delivery_custom_fields
- daily_log_skip_custom_field_configs
- daily_log_skip_custom_fields
- daily_log_inspection_custom_field_configs
- daily_log_inspection_custom_fields
- daily_log_phone_call_custom_field_configs
- daily_log_phone_call_custom_fields
- daily_log_plan_revision_custom_field_configs
- daily_log_plan_revision_custom_fields
- daily_log_productivity_custom_field_configs
- daily_log_productivity_custom_fields
- daily_log_quantity_custom_field_configs
- daily_log_quantity_custom_fields
- daily_log_safety_violation_custom_field_configs
- daily_log_safety_violation_custom_fields
- daily_log_scheduled_work_custom_field_configs
- daily_log_scheduled_work_custom_fields
- daily_log_waste_custom_field_configs
- daily_log_waste_custom_fields
- inspection_item_references
- program_task_changes
- Resource Planning
- assignments
- job titles
- requests
- time off
- wp people
- wp projects
- groups
- Equipment
- equipment
- equipment project register
- equipment timecard entry
- Estimating
- estimating projects
- estimate layers
- estimate layer groups
- estimating project custom fields
Procore updated the following models (tables):
- Changes in project_vendor_insurances.sql:
- Added project_vendor_insurances.external_origin_data
- Added project_vendor_insurances.external_origin_id
- Changes in projects.sql:
- Added projects.code
- Added projects.delivery_method
- Added projects.external_origin_data
- Added projects.external_origin_id
- Added projects.sector
- Added projects.work_scope
- Changes in users.sql:
- Added users.abbreviated_name
- Added users.can_push_to_accounting
- Added users.company_name
- Added users.company_permission_template
- Added users.external_origin_data
- Added users.external_origin_id
- Added users.login_information_id
- Added users.origin_id
- Added users.origin_name
- Changes in budget_changes.sql:
- Added budget_changes.external_origin_data
- Added budget_changes.external_origin_id
- Changes in budget_line_items.sql:
- Added budget_line_items.budget_notes
- Changes in change_events.sql:
- Added change_events.external_origin_data
- Added change_events.external_origin_id
- Changes in commitment_change_orders.sql:
- Added commitment_change_orders.external_origin_data
- Added commitment_change_orders.external_origin_id
- Changes in commitment_line_items.sql:
- Added commitment_line_items.external_origin_data
- Added commitment_line_items.external_origin_id
- Changes in direct_cost_line_items.sql:
- Added direct_cost_line_items.external_origin_data
- Added direct_cost_line_items.external_origin_id
- Changes in direct_costs.sql:
- Added direct_costs.external_origin_data
- Added direct_costs.external_origin_id
- Changes in owner_invoice_line_item_with_markups.sql:
- Added owner_invoice_line_item_with_markups.external_origin_data
- Added owner_invoice_line_item_with_markups.external_origin_id
- Added owner_invoice_line_item_with_markups.materials_presently_stored_qty
- Added owner_invoice_line_item_with_markups.name
- Added owner_invoice_line_item_with_markups.new_materials_stored_qty
- Added owner_invoice_line_item_with_markups.previous_materials_stored_qty
- Added owner_invoice_line_item_with_markups.prime_contract_id
- Changes in owner_invoice_line_items.sql:
- Added owner_invoice_line_items.external_origin_data
- Added owner_invoice_line_items.external_origin_id
- Added owner_invoice_line_items.line_type
- Added owner_invoice_line_items.markup_id
- Added owner_invoice_line_items.materials_presently_stored_qty
- Added owner_invoice_line_items.name
- Added owner_invoice_line_items.new_materials_stored_qty
- Added owner_invoice_line_items.owner_invoice_line_item_with_markup_id
- Added owner_invoice_line_items.owner_invoice_markup_line_item_id
- Added owner_invoice_line_items.previous_materials_stored_qty
- Changes in owner_invoice_markup_line_items.sql:
- Added owner_invoice_markup_line_items.approved_changes
- Added owner_invoice_markup_line_items.approved_changes_company_currency
- Added owner_invoice_markup_line_items.approved_changes_project_currency
- Added owner_invoice_markup_line_items.balance_to_finish
- Added owner_invoice_markup_line_items.company_id_2
- Added owner_invoice_markup_line_items.external_origin_data
- Added owner_invoice_markup_line_items.external_origin_id
- Added owner_invoice_markup_line_items.line_type
- Added owner_invoice_markup_line_items.materials_presently_stored_qty
- Added owner_invoice_markup_line_items.name
- Added owner_invoice_markup_line_items.new_materials_stored_qty
- Added owner_invoice_markup_line_items.owner_invoice_line_item_id
- Added owner_invoice_markup_line_items.owner_invoice_line_item_with_markup_id
- Added owner_invoice_markup_line_items.previous_materials_stored_qty
- Added owner_invoice_markup_line_items.prime_contract_id
- Changes in owner_invoices.sql:
- Added owner_invoices.external_origin_data
- Added owner_invoices.external_origin_id
- Added owner_invoices.tax_applicable_to_this_payment
- Changes in payments_issued.sql:
- Added payments_issued.external_origin_data
- Added payments_issued.external_origin_id
- Changes in head_contract_change_order_line_items.sql:
- Added head_contract_change_order_line_items.external_origin_data
- Added head_contract_change_order_line_items.external_origin_id
- Changes in head_contract_change_order_requests.sql:
- Added head_contract_change_order_requests.external_origin_data
- Added head_contract_change_order_requests.external_origin_id
- Changes in head_contract_change_orders.sql:
- Added head_contract_change_orders.external_origin_data
- Added head_contract_change_orders.external_origin_id
- Changes in head_contract_line_items.sql:
- Added head_contract_line_items.external_origin_data
- Added head_contract_line_items.external_origin_id
- Added head_contract_line_items.vendor_id
- Changes in head_contract_potential_change_orders.sql:
- Added head_contract_potential_change_orders.external_origin_data
- Added head_contract_potential_change_orders.external_origin_id
- Changes in head_contracts.sql:
- Added head_contracts.external_origin_data
- Added head_contracts.external_origin_id
- Changes in subcontractor_invoice_line_items.sql:
- Added subcontractor_invoice_line_items.materials_presently_stored_qty
- Added subcontractor_invoice_line_items.materials_previously_stored_qty
- Added subcontractor_invoice_line_items.new_materials_qty
- Changes in subcontractor_invoices.sql:
- Added subcontractor_invoices.external_origin_data
- Added subcontractor_invoices.external_origin_id
- Changes in inspections.sql:
- Added inspections.equipment_identification_number
- Changes in rfi_assignees.sql:
- Added rfi_assignees.forwarded_by
- Changes in submittal_approvers.sql:
- Added submittal_approvers.is_last_step
- Changes in equipment_timecard_entry.sql:
- Added equipment_timecard_entry.equipment_identification_number
- Added equipment_timecard_entry.equipment_name
procore analytics 2.0 data updates (21/01/2025)
Procore has added the following models (tables):
- inspection_item_references
- program_task_changes
- equipment
- equipment_project_log
- equipment_timecard_entry
- payments_project_controls
- payments_invites
- payments_agreements
- pay_requirement_settings
Procore has updated the following models (tables):
- company_vendor_insurances:
- Added company_vendor_insurances.template_name
- project_role_memberships:
- Added project_role_memberships.user_id
- budget_change_workflow_steps:
- Added budget_change_workflow_steps.current_step_due_date
- budget_codes:
- Deleted SELECT budget_codes.budget_code
- Added SELECT budget_codes.attribute_1_line_item
- Added budget_codes.attribute_1_name
- Added budget_codes.attribute_2_line_item
- Added budget_codes.attribute_2_name
- Added budget_codes.attribute_3_line_item
- Added budget_codes.attribute_3_name
- Added budget_codes.budget_code
- budget_columns:
- Added budget_columns.created_at
- Added budget_columns.updated_at
- change_event_line_item_with_markups:
- Deleted SELECT change_event_line_item_with_markups.budget_days_in_stage
- Added SELECT change_event_line_item_with_markups.biller_id
- Added change_event_line_item_with_markups.biller_model_name
- Added change_event_line_item_with_markups.biller_name
- Added change_event_line_item_with_markups.budget_days_in_stage
- Added change_event_line_item_with_markups.change_event_events_id
- Added change_event_line_item_with_markups.change_event_status
- Added change_event_line_item_with_markups.change_event_title
- Added change_event_line_item_with_markups.contract_id
- Added change_event_line_item_with_markups.contract_number
- Added change_event_line_item_with_markups.contract_title
- Added change_event_line_item_with_markups.estimated_budget_amount
- Added change_event_line_item_with_markups.estimated_budget_transfer_amount
- Added change_event_line_item_with_markups.estimated_cost_amount
- Added change_event_line_item_with_markups.estimated_cost_amount_company_currency
- Added change_event_line_item_with_markups.estimated_cost_amount_project_currency
- Added change_event_line_item_with_markups.event_scope
- Added change_event_line_item_with_markups.proposed_contract_id
- Added change_event_line_item_with_markups.proposed_vendor_id
- Added change_event_line_item_with_markups.source
- Added change_event_line_item_with_markups.vendor_name
- Added change_event_line_item_with_markups.wbs_code_id
- commitment_change_order_line_items:
- Added commitment_change_order_line_items.commitment_change_order_request_id
- Added commitment_change_order_line_items.commitment_potential_change_order_id
- commitment_change_order_workflow_steps:
- Added commitment_change_order_workflow_steps.current_step_due_date
- commitment_custom_field_configs:
- Added commitment_custom_field_configs.name
- commitment_pco_workflow_steps:
- Added commitment_pco_workflow_steps.current_step_due_date
- commitment_workflow_step_occurrences:
- Added commitment_workflow_step_occurrences.current_step_due_date
- contract_compliance_documents:
- Added contract_compliance_documents.template_name
- owner_invoice_workflow_steps:
- Added owner_invoice_workflow_steps.current_step_due_date
- owner_invoices:
- Added owner_invoices.erp_latest_status
- Added owner_invoices.erp_updated_at
- Added owner_invoices.erp_user_name
- Added owner_invoices.synced_with_accounting
- payments_beneficiaries:
- Added payments_beneficiaries.early_pay_classification
- head_contract_change_order_line_items:
- Added head_contract_change_order_line_items.name
- Added head_contract_change_order_line_items.prime_contract_change_order_request_id
- Added head_contract_change_order_line_items.prime_contract_potential_change_order_id
- head_contract_change_order_workflow_steps:
- Added head_contract_change_order_workflow_steps.current_step_due_date
- head_contract_pco_workflow_steps:
- Added head_contract_pco_workflow_steps.current_step_due_date
- head_contract_workflow_steps:
- Added head_contract_workflow_steps.current_step_due_date
- subcontractor_invoice_line_items:
- Added subcontractor_invoice_line_items.total_retention
- subcontractor_invoice_workflow_steps:
- Added subcontractor_invoice_workflow_steps.current_step_due_date
- action_plan_custom_fields:
- Added action_plan_custom_fields.type_id
- action_plan_line_item_record:
- Added action_plan_line_item_record.action_plan_line_item_record_resource_url
- correspondence_custom_fields:
- Added correspondence_custom_fields.type_id
- correspondence_response_attachments:
- Added correspondence_response_attachments.type_id
- correspondence_schedule_tasks:
- Added correspondence_schedule_tasks.type_id
- correspondence_workflow_responses:
- Added correspondence_workflow_responses.type_id
- correspondence_workflow_steps:
- Added correspondence_workflow_steps.type_id
- daily_log_accident:
- Added daily_log_accident.daily_log_completion_id
- daily_log_construction_reports:
- Added daily_log_construction_reports.daily_log_completion_id
- daily_log_delay:
- Added daily_log_delay.daily_log_completion_id
- daily_log_delivery:
- Added daily_log_delivery.daily_log_completion_id
- daily_log_skip:
- Added daily_log_skip.daily_log_completion_id
- daily_log_equipment:
- Added daily_log_equipment.daily_log_completion_id
- daily_log_inspection:
- Added daily_log_inspection.daily_log_completion_id
- daily_log_working hours:
- Added daily_log_working hours.daily_log_completion_id
- daily_log_note:
- Added daily_log_note.daily_log_completion_id
- daily_log_observed_weather_condition:
- Added daily_log_observed_weather_condition.daily_log_completion_id
- daily_log_phone_call:
- Added daily_log_phone_call.daily_log_completion_id
- daily_log_plan_revision:
- Added daily_log_plan_revision.daily_log_completion_id
- daily_log_productivity:
- Added daily_log_productivity.daily_log_completion_id
- daily_log_quantity:
- Added daily_log_quantity.daily_log_completion_id
- daily_log_safety_violation:
- Added daily_log_safety_violation.daily_log_completion_id
- daily_log_scheduled_work:
- Added daily_log_scheduled_work.daily_log_completion_id
- daily_log_scheduled_work_task:
- Added daily_log_scheduled_work_task.daily_log_completion_id
- Added daily_log_scheduled_work_task.schedule_task_id
- daily_log_visitor:
- Added daily_log_visitor.daily_log_completion_id
- daily_log_waste:
- Added daily_log_waste.daily_log_completion_id
- inspection_custom_fields:
- Added inspection_custom_fields.type_id
- inspection_item_signature_requests:
- Added inspection_item_signature_requests.inspection_schedule_id
- inspection_items:
- Added inspection_items.position_number
- inspection_schedules:
- Added inspection_schedules.ends_at
- Added inspection_schedules.starts_at
- inspections:
- Added inspections.equipment_id
- Added inspections.equipment_name
- observation_custom_field_configs:
- Added observation_custom_field_configs.observation_type_id
- Added observation_custom_field_configs.type_id
- observation_custom_fields:
- Added observation_custom_fields.type_id
- defect_item_bic:
- Added defect_item_bic.punch_item_bic_id
- rfis_bic:
- Added rfis_bic.rfi_bic_id
- program_lookahead_task:
- Added program_lookahead_task.task_id_comp
- program_task:
- Added program_task.task_id
- submittal_ball_in_courts:
- Added submittal_ball_in_courts.company_name
- Added submittal_ball_in_courts.role
- submittals:
- Added submittals.ball_in_court_role
- Added submittals.paused
- actual_production_quantities:
- Added actual_production_quantities.wbs_code_id
- budget_change_production_quantities:
- Deleted SELECT budget_change_production_quantities.budget_change_production_quantity_id
- Added SELECT budget_change_production_quantities.budget_change_id
- Added budget_change_production_quantities.budget_change_production_quantity_id
- Added budget_change_production_quantities.wbs_code_id
- head_potential_change_order_production_quantities:
- Added head_potential_change_order_production_quantities.prime_contract_change_order_id
- Added head_potential_change_order_production_quantities.wbs_code_id
- project:
- Added project.code
- owner_invoices:
- Added owner_invoices.Tax_Applicable_To_This_Payment
- timecard_entries:
- Added timecard_entries.user_id
procore analytics 2.0 data updates (17/12/2024)
Procore has added (current_step_due_date) to the following models (tables):
- budget_change_workflow_steps
- commitment_change_order_workflow_steps
- commitment_pco_workflow_responses
- commitment_workflow_step_occurrences
- owner_invoice_workflow_steps
- head_contract_change_order_workflow_steps
- head_contract_pco_workflow_steps
- head_contract_workflow_steps
- subcontractor_invoice_workflow_steps
Procore has added the following fields:
- actual_production_quantities.wbs_code_id
- timecard_entries.user_id
Below are the notable changes to Analytics 2.0 Power BI Reports.
Recent Changes
Report Updates (20/05/2025)
- Power BI Report Updates
- Procore Financials Budget (Custom)
- Report updated to work with multi-select synced custom budget view
- Report updated to include snapshot_type filter
- Procore Financials Budget
- Report updated to include snapshot_type filter
- Procore Project Management Report
- Fixed incorrect calculation for Gantt visuals
- Report updated the start and end date column names in visuals to match Procore user interface
- Procore Financials Budget (Custom)
Report Updates (22/04/2025)
- Procore Specialty Contractor
- Uploaded report to Analytics
- Procore Action Plans 2.0
- Adjusted logic on “Progress” page to include items that have no progress (0%)
- Procore Financials Budget 2.0
- Fixed bug that would occur with multiple budget snapshots taken in the same day
- Procore Financials
- Added ProjectTool table to data model
- Added “Tool Configuration” report page
- Procore Project Management 2.0
- Added ProjectTool table to data model
- Added “Tool Configuration” report page
- All Reports
- Minor performance enhancements
- Data Connectors
- Added support for incremental refresh.
- Other Updates
- Added procore_analytics_metadata table which contains:
- Model Name
- Primary Keys
- Refresh Type - FULL/INCREMENTAL
- last_refresh_time - Data last refreshed on PA tables
- latest_transaction_timestamp - Cut off time from Procore APP
- Added procore_analytics_metadata table which contains:
Report Updates (18/3/2025)
- Power BI Report Updates
- Core
- Tool Configuration
- Project Tasks
- Financials
- Financials Tool Utilization (Deprecated )
- Financials Budget and Financials Budget (Custom)
- Budget Snapshot Forecast (Deprecated)
- Advanced Forecasting Over Time
- Owner-developer
- Advanced Forecasting Over Time
- Project Management
- Project Tool Utilization (Deprecated)
- Project Trending (Deprecated)
- Core
Bug fixes and Report updates (18/02/2025)
- All Reports:
- Fixed a bug causing an issue with relationships when a token has access to multiple companies.
- Updated default row limit to prevent refresh from not pulling all data.
- Added in line comments to some report measure and calculated columns.
- Project Management
- Fixed an issue with a relationship causing Ball In Court for submittals to not filter correctly.
- Quality and Safety
- Removed filter that was set as default.
- Fixed an issue where Correspondence custom fields were returning empty.
- Owner
- Updated documentation URL.
- Fixed an issue when duplicated budget names were used.
Bug fixes and Report updates (21/01/2025)
- Performance Fixed to Custom Budget Report
- Updated queries to remove redundant parameters and source queries, updated dynamic data type change to properly account for percentage data types.
- Performance fixes for all reports
- Removed some report parameters and standard source queries for performance, errors, and clarity.
- Added Budget Comparison to Budget Report (Analytics 1.0 parity)
- Added Advanced Forecasting Pages back to Owner and Budget Report
- Bug Fix - Financials Report - Subcontractor Reconciliation Page
- Fixes a bug where values of difference paid of 0 or 1 were counting as unpaid when marked paid in Procore.
- Bug Fix - Drill through fixes
- Reintroduced select missing drills through filters from Analytics 1.0.
bug fixes and Report updates (17/12/2024)
- All Reports
- Removed some report parameters and standard source queries for performance, errors, and clarity
- All Reports
- Reintroduced some missing drills through filters from Procore Analytics 1.0
- Procore Financials Budget (Custom)
- Updated queries to remove redundant parameters and source queries
- Updated dynamic data type change to properly account for percentage data types
- Procore Financials Budget
- Added Budget Comparison
- Procore Owner and Procore Financials Budget
- Added Advanced Forecasting
- Procore Financials - Subcontractor Reconciliation
- Fixed a bug where values of difference paid of 0 or 1 were counting as unpaid when marked paid in Procore
bug fixes and Report updates (04/11/2024)
- All Reports
- Fixed bugs with various URLs
- Removed HTML tags in some description columns to display better in Power BI
- Procore Site Diaries
- Added 'Attachment Details' visual to the following pages: Construction, Delays, Deliveries, Working hours, Notes
- Procore Adoption
- Various bug fixes
bug fixes and Report updates (14/10/2024)
- Procore Project Management
- Added Program ToDos and Schedule ToDo Gantt pages
- Procore Quality & Safety
- Fixed tooltips for TRIFR Analysis
bug fixes and Report updates (07/10/2024)
- Procore Financials Budget
- Various bug fixes and formatting changes
- Procore Quality & Safety
- Various bug fixes and formatting changes
- Procore Project Management
- Various bug fixes and formatting changes
- Procore Actions Plans
- Various bug fixes and formatting changes
- Procore Site Diaries
- Various bug fixes and formatting changes
- Procore Adoption
- Uploaded report to Analytics
- Procore Design Co-ordination
- Uploaded report to Analytics
Support
Analytics 2.0 is generally available for new and existing Procore customers. Reach out to your Procore point of contact to learn more.
For support with Analytics 2.0:
| Issue | Solution |
|---|---|
|
Make sure you're working with the most up-to-date reports and data. The latest report files are found in your company level Procore Analytics tool from the Power BI tile. Procore Analytics 2.0 updates on a monthly cadence. View the latest changes and updates below: |
|
If you’re up-to-date and still experiencing issues, please collect the following information:
|
Please email this information to support@procore.com with 'Procore Analytics 2.0' as part of the subject. |