Connect Pinterest Ads to Looker: Dashboards in Minutes

Get started for free

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

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

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

Pinterest Ads
Looker

Visualize Pinterest Ads Data in Looker

Connect your Pinterest Ads account to Kondado and replicate advertising metrics directly into Looker without technical setup. Choose which campaigns, ad groups, and performance data you want to visualize, then schedule automated updates to keep your marketing reports current. Business teams can analyze impressions, clicks, and ROAS alongside other business data to make faster advertising decisions.

Kondado provides a direct connection between Pinterest Ads and Looker that eliminates the need for intermediate databases or complex technical setup, enabling marketing teams to visualize campaign performance metrics on a configurable schedule ranging from every 5 minutes to daily updates.

With Kondado, you select exactly which Pinterest Ads pipelines you need, from Ad Performance to detailed targeting metrics, and decide how often the data refreshes. This flexibility ensures your Looker dashboards always reflect the latest advertising results while you focus on optimizing spend and creative strategy rather than managing data.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

The combination of Pinterest Ads and Looker unlocks powerful visual analysis for marketing teams tracking discovery campaigns. By accessing the Ad Performance pipeline, you can visualize detailed metrics including impressions, clicks, and costs broken down by campaign, ad group, and ad status to identify your highest-performing Pins and creative assets.

This connection helps you monitor ROAS trends, compare engagement across different targeting strategies, and share automated reports with stakeholders who need immediate visibility into advertising spend. Whether you analyze campaign-level budgets or drill into individual ad creative performance, having fresh Pinterest advertising data in Looker enables faster budget allocation decisions and strategic creative optimization without technical complexity or manual data exports.

Try out all the features for free for 14 days

Custom reports

This connector lets you create custom reports with dimensions and metrics of your choice. In addition to the pre-configured reports below, you can build tailored reports for your needs.

1
configurable report
619
extractable fields

Pre-configured reports

Report Description
Ad Performance Analyze performance with metrics such as impressions, clicks, and cost. Detail by campaign, ad group, and ad status.
Ad Performance
Analyze performance with metrics such as impressions, clicks, and cost. Detail by campaign, ad group, and ad status.

Try out all the features for free for 14 days

How to create Pinterest Ads dashboards in Looker

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Pinterest Ads as data source

Log into Kondado and add Pinterest Ads as a new data source by entering your account credentials. Select the Ad Performance pipeline to begin replicating your campaign metrics, impressions, and click data.

2
Selecting Looker as destination

Choose Looker from the available destinations to receive your Pinterest Ads data without intermediate databases or complex routing. This establishes a direct flow between your advertising platform and visualization tool.

3
Building dashboards and configuring refresh

Once data arrives in Looker, create custom dashboards tracking ROAS, campaign performance, and audience metrics that matter to your business. Set your preferred update frequency, from every 5 minutes to daily, to keep reports current automatically.

Access Pinterest Ads data in Looker and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Pinterest Ads data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Pinterest Ads data in Looker automatically

How do I connect Pinterest Ads to Looker without using a database?
Kondado provides a direct connection that sends your Pinterest Ads data straight to Looker without requiring intermediate storage or complex infrastructure. You simply authenticate your Pinterest Ads account in Kondado, select the Ad Performance pipeline, and choose Looker as your destination. The platform manages the data flow automatically on your chosen schedule, delivering fresh metrics directly to your visualization environment.
What Pinterest Ads metrics are available to visualize in Looker?
The Ad Performance pipeline includes 619 fields covering impressions, clicks, costs, ROAS, and campaign status details. You can analyze data by campaign, ad group, and individual ad level to understand which creative elements drive the most engagement. This granularity allows you to build custom reports tracking everything from spend efficiency to audience targeting performance.
How frequently can I update Pinterest Ads data in my Looker reports?
You can configure automated updates to run every 5 minutes, 15 minutes, hourly, or daily depending on how quickly you need fresh insights. This configurable schedule ensures your dashboards reflect recent campaign performance without manual refreshes or exports. Simply set your preferred frequency when configuring the connection, and Kondado maintains the data flow automatically.
Can I create Pinterest Ads ROAS dashboards in Looker?
Yes, the Ad Performance pipeline includes return on ad spend metrics that you can visualize alongside cost and conversion data. Build custom dashboards that track ROAS trends across different campaigns, ad groups, or time periods to identify your most profitable Pinterest strategies. These visualizations help marketing teams quickly reallocate budget toward high-performing Pins and audiences.
Is there a pre-built Pinterest Ads template for Looker?
Kondado does not provide pre-built report templates for this connection, allowing you to build completely custom dashboards tailored to your specific KPIs and business questions. You have full flexibility to design visualizations that match your brand reporting standards and focus on the metrics that matter most to your team. Create charts showing campaign comparisons, audience breakdowns, or spend analysis exactly how you need them.
How do I share Pinterest Ads dashboards with my team in Looker?
Once your data flows into Looker, you use Looker's native sharing features to distribute dashboards to stakeholders across your organization. Your team members can view current Pinterest Ads performance without needing access to the advertising platform itself. This simplifies reporting for agencies managing multiple client accounts or marketing teams coordinating with executives.
What do I need to set up the Pinterest Ads to Looker connection?
You need active credentials for both your Pinterest Ads account and your Looker instance to establish the connection. In Kondado, you will authenticate your Pinterest Ads data source, select the specific pipelines you want to replicate, and designate Looker as the destination. The entire setup requires no coding or technical configuration, typically taking just a few minutes to complete.
Can I combine Pinterest Ads data with other marketing sources in Looker?
Yes, you can send data from multiple sources into Looker to create unified marketing dashboards. For example, combine Pinterest metrics with data from Google Sheets, BigQuery, or PostgreSQL to compare performance across channels. This consolidated view helps you analyze cross-platform spend and allocate budgets between Pinterest and other advertising channels.

Try out all the features for free for 14 days