What specific PipeRun data can I extract using Kondado?

Kondado replicates data from two main pipelines: standard Opportunities containing fields like deal ID, status, value, and closed_at dates, plus Opportunities: Custom Fields which includes your configured customfield_name and value data. This covers 134 total fields spanning core sales metrics and custom business attributes you have defined in your PipeRun CRM.

How do I connect PipeRun to Google Sheets or Power BI for reporting?

After adding PipeRun as a data source in Kondado, select your desired pipelines and choose Google Sheets or Power BI as your destination. The platform handles the data replication automatically, delivering fresh PipeRun data directly into your chosen tool without manual exports.

How often does Kondado update my PipeRun opportunity data?

You can configure update frequencies ranging from every 5 minutes to daily, depending on how current you need your sales analytics to be. This configurable schedule ensures your dashboards reflect recent opportunity changes, status updates, and closed deals without overwhelming your systems with unnecessary API calls.

Can I analyze PipeRun custom fields alongside standard opportunity data?

Yes, Kondado extracts both the standard Opportunities pipeline and the Opportunities: Custom Fields pipeline, allowing you to join these datasets in your BI tool. This enables analysis that correlates your custom business attributes with core metrics like deal value and close dates for deeper sales insights.

What types of sales analyses can I build with PipeRun data in BigQuery?

You can construct analyses including funnel conversion tracking, sales velocity calculations, win/loss rate by custom field segments, and revenue forecasting models. Send your data to BigQuery to combine PipeRun information with marketing spend data or product usage metrics for comprehensive business intelligence.

Do I need API coding skills to replicate PipeRun data to PostgreSQL?

No coding is required; Kondado provides a no-code interface to authenticate your PipeRun account and select data for replication to PostgreSQL or other destinations. The platform manages the technical complexity of the PipeRun API connection while you focus on defining the business logic for your analytics.

Can I send PipeRun data to multiple destinations simultaneously?

Yes, you can configure separate pipelines to send the same PipeRun data to different destinations such as Looker Studio for executive dashboards, Google Sheets for operational spreadsheets, and BigQuery for data warehouse storage, all on independent schedules.

Send PipeRun data to reports, spreadsheets and ETL

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Connect PipeRun to Your Analytics Stack

Unlock the full potential of your PipeRun CRM data by replicating detailed opportunity records, deal values, status transitions, and custom field attributes directly into your preferred analytics environment. Kondado extracts granular sales pipeline information including opportunity IDs, closing dates, monetary values, and won/lost indicators alongside custom field configurations that capture your unique business processes and deal characteristics. This seamless access to PipeRun data enables comprehensive sales analytics without requiring manual CSV exports or complex PipeRun API coding, letting your team focus on insights rather than data extraction.

Kondado’s PipeRun data source provides direct access to 2 distinct pipelines containing 134 total fields, covering both standard opportunity data and custom field configurations.

Sales managers leverage this information to track funnel conversion rates and identify bottlenecks across pipeline stages, while revenue operations teams monitor custom field trends to optimize deal scoring and qualification criteria. Marketing leaders combine opportunity values with campaign attribution data to calculate true ROI on lead generation efforts, and data analysts build automated PipeRun analytics reports that refresh on a configurable schedule to keep executives informed with current sales performance metrics and revenue forecasts. Operations teams also benefit from automated data replication that eliminates manual spreadsheet updates and ensures everyone works from the same accurate sales figures.

The Kondado platform takes care of refreshing PipeRun data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing PipeRun data in your report, spreadsheet, data warehouse, data lake, or database

Below you will find the complete listing of available pipelines you can replicate from your PipeRun CRM into any destination.

The Opportunities pipeline delivers essential sales intelligence including deal values, status transitions, and closing dates that power accurate revenue forecasting and sales velocity calculations for your team. The Opportunities: Custom Fields pipeline captures your specifically configured deal attributes such as customfield_name and associated values, enabling granular analysis of segmented performance across business categories, lead sources, or qualification criteria. By combining these standard opportunity metrics with custom field dimensions, you can create powerful cross-functional analyses that correlate specific deal characteristics with win rates, average sales cycles, and pipeline contribution to total revenue. With automated updates configurable from every 5 minutes to daily intervals, you can monitor critical sales KPIs and opportunity movements as frequently as your business requires without manual data refreshing or stale reporting.

Try out all the features for free for 14 days

Available PipeRun data

available pipelines

134

extractable fields

Available integrations

Integration	Description
Opportunities	Table provides information on opportunities, including fields such as id, status, value, and closed_at date.
Opportunities: Custom Fields	Table contains custom fields for opportunities, such as deal_id, customfield_name, and value.

Opportunities

Table provides information on opportunities, including fields such as id, status, value, and closed_at date.

Opportunities: Custom Fields

Table contains custom fields for opportunities, such as deal_id, customfield_name, and value.

See all available data →

Try out all the features for free for 14 days

How to visualize PipeRun data in 3 steps

Connect PipeRun to dashboards, spreadsheets, or databases — no code required.

Add PipeRun as a Data Source

Log into Kondado and select PipeRun from the available CRM data sources, then authenticate your account using your PipeRun credentials to establish the initial connection.

Select Pipelines and Destination

Choose which pipelines to replicate, such as Opportunities and Opportunities: Custom Fields, then select where to send your data, whether to Power BI, Google Sheets, BigQuery, PostgreSQL, or other supported destinations like MySQL or Redshift.

Analyze in Dashboards, Sheets, or Databases

Build custom reports in Looker Studio or Power BI, analyze trends in Google Sheets or Excel, or run SQL queries against your data in PostgreSQL, BigQuery, SQL Server, or Amazon S3 to derive actionable insights from your sales information.

Try out all the features for free for 14 days