Skip to main content

How can I build a dashboard using my Pinpoint data?

A quick run through on how to quickly pull data from our API using an ETL tool into your preferred visualization tool.

F
Written by Freddie Hammond
Updated today

Pinpoint's API can connect to a wide range of extraction tools, data warehouses, and visualization platforms, so you can use the stack that works best for your team.

Overview

This guide walks you through connecting your Pinpoint account to an ELT/ETL tool, syncing your recruitment data into the data warehouse of your choice, and building visualizations in your preferred BI tool. By the end, you'll have a live dashboard pulling directly from your Pinpoint data.

Pinpoint's API can connect to a wide range of extraction tools, data warehouses, and visualization platforms, so you can use the stack that works best for your team.

Fivetran has a pre-built pinpoint connector while other ETL tools like Airbyte, Stitch and Hevo Data can be configured.

Supported data warehouses include (but are not limited to):

  • Google BigQuery

  • Mircosoft Azure

  • Snowflake

  • Amazon Redshift (AWS)

  • Databricks

  • PostgreSQL

Supported visualization tools include (but are not limited to):

  • Looker Studio

  • Tableau

  • Power BI

  • Metabase

What you'll need:

  • A Pinpoint account with API access enabled

  • An ELT/ETL tool (e.g., Fivetran, Airbyte, Stitch, Hevo Data)

  • A data warehouse (e.g., BigQuery, Mircosoft Azure, Snowflake, Amazon Redshift)

  • A visualization tool (e.g., Looker Studio, Tableau, Power BI)

Step 1: Generate Your Pinpoint API Key

  1. Log in to your Pinpoint account and navigate to Settings > API & webhooks.

  2. Click Generate API Key.

  3. Copy and securely store your API key — you'll need it in the next step.

NOTE: TREAT YOUR API KEY LIKE A PASSWORD. DO NOT SHARE IT PUBLICLY OR COMMIT IT TO VERSION CONTROL.

Step 2: Set Up Your ELT/ETL Connector

Connect your Pinpoint API key to your chosen extraction tool. Below are setup instructions for the most common platforms.

Fivetran

  1. Log in to your Fivetran dashboard.

  2. Click Add Connector and search for Pinpoint.

  3. Configure the connector:

    • Destination: Select your data warehouse destination (e.g., BigQuery, Snowflake, Amazon Redshift). If you haven't set one up yet, see Fivetran's destination setup guides.

    • Schema name: Choose a schema prefix (e.g., pinpoint).

  4. Enter your Pinpoint API Key when prompted.

  5. Click Save & Test to validate the connection.

  6. Once the test passes, click Start Initial Sync.

Using a different tool? Any ELT/ETL platform that supports REST API connectors can connect to Pinpoint using your API key. Refer to Pinpoint's API documentation for instructions on how to connect your tool to pinpoint's API.

Your chosen tool will now sync your Pinpoint data into your warehouse on a regular schedule. The initial sync may take several minutes depending on the volume of data.

Synced Tables

Your extraction tool will create tables in your warehouse dataset. Common tables include:

Table

Description

jobs

All job listings and their statuses

candidates

Candidate profiles and application data

applications

Application records linking candidates to jobs

stages

Pipeline stages and candidate progression

users

Hiring team members and their roles

Tip: Check your extraction tool's Pinpoint connector documentation for the full schema and sync frequency options.

For example, Fivetran's documentation clearly outlines the schema that can be gotten via Fivetran's pinpoint API connector.

Step 3: Verify Data in Your Warehouse

Once the initial sync completes, open your data warehouse and confirm the data has landed correctly. For example, in BigQuery:

  1. Open the BigQuery Console.

  2. Navigate to your project and find the pinpoint dataset.

  3. Preview a few tables:

SQL

SELECT * FROM `your-project.pinpoint.applications` LIMIT 10;

Similar verification steps apply in Snowflake, Redshift, or any other warehouse — query the pinpoint schema and check that your tables are populated.

Step 4: Connect Your Warehouse to a Visualization Tool

Connect your data warehouse to your preferred BI tool to start building reports and dashboards.

Looker Studio

  1. Open Looker Studio and click Create > Data Source.

  2. Select BigQuery (or your warehouse connector) and choose the pinpoint dataset.

  3. Select the table you want to start with (e.g., applications) and click Connect.

Tableau

  1. Open Tableau Desktop and click Connect > To a Server.

  2. Select your warehouse type (e.g., Google BigQuery, Snowflake, Amazon Redshift).

  3. Authenticate and navigate to the pinpoint schema.

Step 5: Use the Template Dashboard

We've built a pre-configured dashboard to get you started quickly. It includes key recruitment metrics and possible visuals you can create out of the box.


​

Make a Copy for Customisation

To customize the template with your own BigQuery data source:

  1. Open the template dashboard.

    Note: This template dashboard was built in Looker and may look different from the video above.

  2. Click the three-dot menu (⋮) in the top right, then select Make a copy.

  3. In the copy dialog, swap the data sources to point to your own BigQuery pinpoint dataset.

  4. Click Copy Report.

You now have a fully editable version connected to your live Pinpoint data.

Next Steps

  • Customize your dashboard: Add filters for departments, date ranges, or hiring managers.

  • Set up alerts: Most extraction tools (Fivetran, Airbyte, Hevo, etc.) support alerting for sync failures.

  • Schedule reports: Most BI tools (Looker Studio, Tableau, Power BI) support scheduled email delivery of your dashboards.

Related Articles
How can I use tags to organize and analyze candidate data?
How do I use the Job Board Marketplace to advertise or sponsor my job posting?
How do I migrate my existing data into Pinpoint?
Managing & monitoring your Pinpoint API
Did this answer your question?