Category: Pinterest Ads

How to Import Targeting Analytics for Campaign Data from Pinterest Ads into Google Sheets

Accessing your Pinterest Ads Targeting Analytics for Campaign data directly in Google Sheets is essential for flexible analysis, custom reporting, and sharing insights with your marketing team.

Instead of manual exports, you can set up a live connection that keeps your spreadsheet updated automatically.

This guide shows you how to import your Pinterest Ads Targeting Analytics for Campaign data into Google Sheets using Coefficient.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Google Workspace Marketplace and connect to your Pinterest Ads account.

  • Step 2:

    Step 2. Select Import from… and choose Pinterest Ads, then select the Targeting Analytics for Campaign object.

  • Step 3:

    Step 3. Configure your import settings and pull the data into your Google Sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your Targeting Analytics for Campaign data updated automatically on your preferred schedule.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 1: Install and Connect Coefficient

First, you need to get Coefficient for Google Sheets.

  • Open Google Sheets.
  • Go to Extensions > Add-ons > Get add-ons.
  • Search for “Coefficient” and install it from the Google Workspace Marketplace.

Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.

In the Coefficient sidebar, click “Import from…” and find Pinterest Ads in the list of connectors. You’ll be guided to connect your Pinterest Ads account securely.

Marketing integrations such as Google Ads, Facebook Ads, HubSpot, and Klaviyo listed.

Step 2: Import Pinterest Ads Targeting Analytics for Campaign Data

After connecting, you’ll see options for importing data from Pinterest Ads.

  • Select the “Targeting Analytics for Campaign” object from the available options.
  • Choose the specific date range and dimensions/metrics you want to include.
  • You can apply filters, segment data, and preview the data before importing.
  • Click “Import” to pull the data into your active Google Sheet tab.
Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Step 3: Set Up Auto-Refresh (Optional)

To keep your Pinterest Ads Targeting Analytics for Campaign data current, set up an automatic refresh schedule.

In the Coefficient sidebar, find your imported data.

  • Click the “Refresh” button or the three-dot menu next to your import.
  • Select “Schedule Refresh”.
  • Choose your desired frequency (e.g., daily, hourly, weekly) and time.

Coefficient will now automatically update your sheet with the latest data from Pinterest Ads based on your schedule.

Available Pinterest Ads Objects

  • Ad Groups
  • Ad Group Analytics
  • Targeting Analytics for Ad Groups
  • Ads
  • Ad Analytics
  • Ad Account Analytics
  • Targeting Analytics for Ad Account
  • Campaigns
  • Campaign Analytics
  • Targeting Analytics for Campaign

How to Import Ad Group Analytics Objects from Pinterest Ads into Excel

Accessing Pinterest Ads Ad Group Analytics in Excel is crucial for marketers looking to analyze performance metrics and optimize ad spend. Creating a direct connection saves time and ensures you’re working with the latest data.

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 Ad Group Analytics from Pinterest Ads

  • Step 3:

    Step 3: Configure your data preferences and import the analytics data

  • Step 4:

    Step 4: Set up auto-refresh to keep your data updated automatically

Step-by-Step Guide to Importing Pinterest Ads Ad Group 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:

  1. Open Excel and navigate to the Insert tab in the ribbon
  2. Click on “Get Add-ins” to open the Office Add-ins store
  3. Search for “Coefficient” and click “Add” to install the add-in
  4. After installation, the Coefficient sidebar will appear on the right side of your Excel sheet
  5. Click on “Import from…” in the Coefficient sidebar
  6. Select “Pinterest Ads” from the list of available marketing connectors
  7. Follow the authentication prompts to connect your Pinterest Ads account
Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Ad Group Analytics Data

Now that you’re connected to Pinterest Ads, you can import your Ad Group Analytics data:

  1. In the Coefficient sidebar, under Pinterest Ads, select “Objects”
  2. From the available objects list, select “Ad Group Analytics”
  3. Configure which performance metrics you want to include (impressions, clicks, CTR, conversions, etc.)
  4. Choose any filters you’d like to apply to your data (e.g., specific ad groups, date ranges, etc.)
  5. Click “Import” to bring the data into your Excel spreadsheet
Marketing integrations such as Google Ads, Facebook Ads, HubSpot, and Klaviyo listed.

Step 3: Set Up Auto-Refresh (Optional)

To ensure your Pinterest Ads Ad Group Analytics data stays current:

  1. With your imported data selected, click on “Automations” in the Coefficient sidebar
  2. Select “Auto-refresh” to open the scheduling options
  3. Choose your preferred refresh frequency (hourly, daily, or weekly)
  4. Set specific times for the refresh to occur
  5. Click “Save” to activate the auto-refresh schedule
Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

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

How to Import Ad Groups Data from Pinterest Ads into Excel

Analyzing Pinterest Ads Ad Groups in Excel helps marketing teams track performance and make data-driven decisions. Instead of manual exports, create a live connection for up-to-date insights.

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 Ad Groups from Pinterest Ads

  • Step 3:

    Step 3: Configure your data preferences and import the Ad Groups data

  • Step 4:

    Step 4: Set up auto-refresh to keep your data updated automatically

Step-by-Step Guide to Importing Pinterest Ads 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:

  1. Open Excel and navigate to the Insert tab in the ribbon
  2. Click on “Get Add-ins” to open the Office Add-ins store
  3. Search for “Coefficient” and click “Add” to install the add-in
  4. After installation, the Coefficient sidebar will appear on the right side of your Excel sheet
  5. Click on “Import from…” in the Coefficient sidebar
  6. Select “Pinterest Ads” from the list of available marketing connectors
  7. Follow the authentication prompts to connect your Pinterest Ads account
Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Ad Groups Data

Now that you’re connected to Pinterest Ads, you can import your Ad Groups data:

  1. In the Coefficient sidebar, under Pinterest Ads, select “Objects”
  2. From the available objects list, select “Ad Groups”
  3. Configure which Ad Groups metrics and dimensions you want to include in your import
  4. Choose any filters you’d like to apply to your data (e.g., specific campaigns, date ranges, status)
  5. Click “Import” to bring the data into your Excel spreadsheet
Marketing integrations such as Google Ads, Facebook Ads, HubSpot, and Klaviyo listed.

Step 3: Set Up Auto-Refresh (Optional)

To ensure your Pinterest Ads Ad Groups data stays current:

  1. With your imported data selected, click on “Automations” in the Coefficient sidebar
  2. Select “Auto-refresh” to open the scheduling options
  3. Choose your preferred refresh frequency (hourly, daily, or weekly)
  4. Set specific times for the refresh to occur
  5. Click “Save” to activate the auto-refresh schedule
Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

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

How to Import Ads Data from Pinterest Ads into Excel

Analyzing individual Pinterest Ads in Excel helps marketers identify top performers and optimize creative assets. With direct data integration, you can track metrics across ads and make smarter decisions about budget allocation.

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 Ads from Pinterest Ads

  • Step 3:

    Step 3: Configure your data preferences and import the ads data

  • Step 4:

    Step 4: Set up auto-refresh to keep your data updated automatically

Step-by-Step Guide to Importing Pinterest Ads Data

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:

  1. Open Excel and navigate to the Insert tab in the ribbon
  2. Click on “Get Add-ins” to open the Office Add-ins store
  3. Search for “Coefficient” and click “Add” to install the add-in
  4. After installation, the Coefficient sidebar will appear on the right side of your Excel sheet
  5. Click on “Import from…” in the Coefficient sidebar
  6. Select “Pinterest Ads” from the list of available marketing connectors
  7. Follow the authentication prompts to connect your Pinterest Ads account
Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Ads Data

Now that you’re connected to Pinterest Ads, you can import your ads data:

  1. In the Coefficient sidebar, under Pinterest Ads, select “Objects”
  2. From the available objects list, select “Ads”
  3. Configure which ad metrics and attributes you want to include (title, status, creative details, performance metrics, etc.)
  4. Choose any filters you’d like to apply to your data (e.g., specific campaigns, ad groups, date ranges, status)
  5. Click “Import” to bring the data into your Excel spreadsheet
Marketing integrations such as Google Ads, Facebook Ads, HubSpot, and Klaviyo listed.

Step 3: Set Up Auto-Refresh (Optional)

To ensure your Pinterest Ads data stays current:

  1. With your imported data selected, click on “Automations” in the Coefficient sidebar
  2. Select “Auto-refresh” to open the scheduling options
  3. Choose your preferred refresh frequency (hourly, daily, or weekly)
  4. Set specific times for the refresh to occur
  5. Click “Save” to activate the auto-refresh schedule
Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

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

How to Import Targeting Analytics for Ad Groups Objects from Pinterest Ads into Excel

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:

  1. Open Excel and navigate to the Insert tab in the ribbon
  2. Click on “Get Add-ins” to open the Office Add-ins store
  3. Search for “Coefficient” and click “Add” to install the add-in
  4. After installation, the Coefficient sidebar will appear on the right side of your Excel sheet
  5. Click on “Import from…” in the Coefficient sidebar
  6. Select “Pinterest Ads” from the list of available marketing connectors
  7. Follow the authentication prompts to connect your Pinterest Ads account
Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Targeting Analytics for Ad Groups Data

Now that you’re connected to Pinterest Ads, you can import your targeting analytics data:

  1. In the Coefficient sidebar, under Pinterest Ads, select “Objects”
  2. From the available objects list, select “Targeting Analytics for Ad Groups”
  3. Configure which targeting metrics and dimensions you want to include (audience segments, demographics, interests, etc.)
  4. Choose any filters you’d like to apply to your data (e.g., specific ad groups, date ranges, performance thresholds)
  5. Click “Import” to bring the data into your Excel spreadsheet
Marketing integrations such as Google Ads, Facebook Ads, HubSpot, and Klaviyo listed.

Step 3: Set Up Auto-Refresh (Optional)

To ensure your Pinterest Ads targeting analytics data stays current:

  1. With your imported data selected, click on “Automations” in the Coefficient sidebar
  2. Select “Auto-refresh” to open the scheduling options
  3. Choose your preferred refresh frequency (hourly, daily, or weekly)
  4. Set specific times for the refresh to occur
  5. Click “Save” to activate the auto-refresh schedule
Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

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

How to Import Targeting Analytics for Ads Objects from Pinterest Ads into Excel

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:

  1. Open Excel and navigate to the Insert tab in the ribbon
  2. Click on “Get Add-ins” to open the Office Add-ins store
  3. Search for “Coefficient” and click “Add” to install the add-in
  4. After installation, the Coefficient sidebar will appear on the right side of your Excel sheet
  5. Click on “Import from…” in the Coefficient sidebar
  6. Select “Pinterest Ads” from the list of available marketing connectors
  7. Follow the authentication prompts to connect your Pinterest Ads account
Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Targeting Analytics for Ads Data

Now that you’re connected to Pinterest Ads, you can import your targeting analytics data:

  1. In the Coefficient sidebar, under Pinterest Ads, select “Objects”
  2. From the available objects list, select “Targeting Analytics for Ads”
  3. Configure which targeting analytics metrics you want to include in your import
  4. Choose any filters you’d like to apply to your data (e.g., specific ads, date ranges, etc.)
  5. Click “Import” to bring the data into your Excel spreadsheet
Marketing integrations such as Google Ads, Facebook Ads, HubSpot, and Klaviyo listed.

Step 3: Set Up Auto-Refresh (Optional)

To ensure your Pinterest Ads targeting analytics data stays current:

  1. With your imported data selected, click on “Automations” in the Coefficient sidebar
  2. Select “Auto-refresh” to open the scheduling options
  3. Choose your preferred refresh frequency (hourly, daily, or weekly)
  4. Set specific times for the refresh to occur
  5. Click “Save” to activate the auto-refresh schedule
Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

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