)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Accessing Pinterest Ads targeting analytics in Excel helps marketers understand audience performance and optimize campaign strategies. With direct data integration, you can analyze targeting effectiveness and make quick adjustments to improve ROI.
In this guide, you’ll learn how to import Targeting Analytics for Ads data from Pinterest Ads into Excel using Coefficient.
TLDR
-
Step 1:
Step 1: Install Coefficient from the Office Add-ins store and connect to your Pinterest Ads account
-
Step 2:
Step 2: Select Import from Objects and choose Targeting Analytics for Ads from the Pinterest Ads integration
-
Step 3:
Step 3: Configure your data preferences and import the targeting analytics data
-
Step 4:
Step 4: Set up auto-refresh to keep your data updated automatically
Step-by-Step Guide to Importing Pinterest Ads Targeting Analytics
Step 1: Install and Connect Coefficient
Before importing Pinterest Ads data, you need to install the Coefficient add-in and connect to your Pinterest Ads account:
- Open Excel and navigate to the Insert tab in the ribbon
- Click on “Get Add-ins” to open the Office Add-ins store
- Search for “Coefficient” and click “Add” to install the add-in
- After installation, the Coefficient sidebar will appear on the right side of your Excel sheet
- Click on “Import from…” in the Coefficient sidebar
- Select “Pinterest Ads” from the list of available marketing connectors
- Follow the authentication prompts to connect your Pinterest Ads account
Step 2: Import Targeting Analytics for Ads Data
Now that you’re connected to Pinterest Ads, you can import your targeting analytics data:
- In the Coefficient sidebar, under Pinterest Ads, select “Objects”
- From the available objects list, select “Targeting Analytics for Ads”
- Configure which targeting analytics metrics you want to include in your import
- Choose any filters you’d like to apply to your data (e.g., specific ads, date ranges, etc.)
- Click “Import” to bring the data into your Excel spreadsheet
Step 3: Set Up Auto-Refresh (Optional)
To ensure your Pinterest Ads targeting analytics data stays current:
- With your imported data selected, click on “Automations” in the Coefficient sidebar
- Select “Auto-refresh” to open the scheduling options
- Choose your preferred refresh frequency (hourly, daily, or weekly)
- Set specific times for the refresh to occur
- Click “Save” to activate the auto-refresh schedule
Available Pinterest Ads Data
Analytics Reports
- Targeting Analytics for Ads
- Ad Group Analytics
- Targeting Analytics for Ad Groups
- Ad Analytics
- Campaign Analytics
- Targeting Analytics for Campaign
Objects
- Ad Groups
- Ads
- Ad Account Analytics
- Campaigns
- Targeting Analytics for Ad Account
- Targeting Analytics for Ads
Related Pinterest Ads Use Cases
How to Import Targeting Analytics for Ads Data from Pinterest Ads into Google Sheets
Learn how to easily import live Pinterest Ads Targeting Analytics for Ads data into Google Sheets using Coefficient for streamlined analysis and reporting.
How to Import Ad Groups Data from Pinterest Ads into Google Sheets
Learn how to easily import live Pinterest Ads Ad Groups data into Google Sheets using Coefficient for streamlined analysis and reporting.
How to Import Ad Group Analytics Data from Pinterest Ads into Google Sheets
Learn how to easily import live Pinterest Ads Ad Group Analytics data into Google Sheets using Coefficient for streamlined analysis and reporting.
Trusted By Over 50,000 Companies
