Creating Reports with Incident Data from City as a Platform in Google Looker Studio
Managing urban operations effectively requires visibility into real-time incident data — and that’s exactly what this integration provides. With the City as a Platform (CaaP) Incidents connector for Google Looker Studio, users can seamlessly bring incident-related data into interactive reports and dashboards. This step-by-step guide is designed to help teams working in public services, operations, and IT connect their CaaP instance and start leveraging incident data to drive faster, more informed decision-making.
1. Select the relevant City as a Platform Connector
Navigate to your Google Looker Studio main page and select your report or create a new one.
Add a new Data Source to your report.
From the list of available data sources, search for the relevant City as a Platform connector.
Looker Studio connectors search
2. Configure the data source connection to match your City as a Platform instance and data
Confirm access to your CaaP instance
In the initial CaaP connector configuration screen, type your instance name (the CaaP instance name must match the prefix of your CaaP instance URL: https://INSTANCE_NAME.city-platform.com’).
Type the CaaP API Key (CaaP API Keys are created and managed in the CaaP Manager by users with Administrator role).
CaaP Incidents Looker Studio connector config - step 1.
Click Next to proceed with the configuration.
Select Incidents or Assets
If the connector was able to establish a connection with your instance using the provided API Key, you will be able to select either the Incidents data or the (incident related) Assets data to be used as your data source from the dropdown list:
CaaP Incidents Looker Studio connector config - step 2.
Click Connect.
3. Confirm the schema
Once you are connected to the Incidents or Assets data source, you will be shown its schema with its fields, and you are able to add the data source to your report.
CaaP Incidents Looker Studio Incidents schema.
4. Use CaaP incidents and assets data in your report
You can now use the Incidents/assets data in your Looker Studio dashboards and reports.
CaaP Incidents Looker Studio incidents data.
Connecting your CaaP Incidents data to Looker Studio allows your organization to go beyond raw records — enabling you to visualize, analyze, and share key patterns in incident activity. From monitoring trends to optimizing response strategies, this setup provides a clear view into what’s happening on the ground. To maintain data integrity and control, make sure only users with administrative rights manage access and API keys during the configuration process.
