)
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.”
Analyzing Pinterest Ads targeting analytics by ad group helps marketers understand which audience segments perform best for different campaign objectives. Using Excel for this analysis enables deeper insights than the native Pinterest dashboard.
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 Ad Groups from Pinterest Ads
-
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 for Ad Groups
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 Ad Groups 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 Ad Groups”
- Configure which targeting metrics and dimensions you want to include (audience segments, demographics, interests, etc.)
- Choose any filters you’d like to apply to your data (e.g., specific ad groups, date ranges, performance thresholds)
- 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
