KPI Data Collection Planning
Resources and tools to help you collect and calculate KPI data for your city.
Before You Begin
These resources are optional and helpful information to get you started, you are free to use these or your own tools as you see fit. The main goal is to support your data collection efforts effectively.
Take time to review the materials below and develop a data collection plan tailored to your city's needs and available resources.
Available Resources
KPI SIEF Framework & Formulas
Comprehensive documentation explaining each KPI, calculation methodologies, data requirements, and scientific framework for NSM-PT integration metrics.
KPI Calculation Spreadsheet
Pre-built Excel template with formulas and data validation to help you organize raw data and calculate KPI values. Includes examples and instructions.
Survey Template (English)
Sample survey questionnaire designed to collect citizen feedback and usage data for relevant KPIs. Can be adapted and translated for your city's specific context.
Developing your data collection plan
Follow these steps to build an effective data collection strategy
Review KPI Requirements
Start by thoroughly reading the KPI Framework document to understand what data you need to collect for each metric.
Identify available data sources
Map out existing data sources in your city (transport authority, municipality, operators) and identify gaps that need new collection methods.
Adapt resources to your context
Customize the spreadsheet and survey templates to match your city's specific needs, available resources, and local language.
Implement collection and calculate KPIs
Execute your data collection plan and use the provided tools to organize and calculate your KPI values before entering them into the platform.
Important notes
- These resources provide guidance for many, but not all KPIs. Some metrics may require city-specific data collection approaches.
- The survey template is a starting point. Adapt questions to your local context and ensure compliance with data protection regulations.
- Data quality is crucial for meaningful insights. Take time to ensure accuracy in your collection and calculation processes.
Why Your Data Matters
This platform tracks KPIs and policy measures across cities working to integrate New Shared Modes (NSM) with Public Transport (PT). Your participation contributes to:
Scientific Evidence Base
Building a robust dataset that demonstrates the impact of integration policies.
Comparative Insights
Understanding how your city performs relative to others with similar characteristics.
Policy Learning
Identifying which measures drive meaningful improvements in NSM-PT integration.
Collective Impact
More participating cities means stronger evidence for policy change and investment.
Ready to Enter Your KPI Data?
Once you've collected and calculated your data, proceed to login to your living lab administration dashboard to enter your KPI values and contribute to our collective understanding of NSM-PT integration impacts.