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

Accessing your Pinterest Ads Targeting Analytics for Ads 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 Ads 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 Ads 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 Ads 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 Ads Data

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

  • Select the “Targeting Analytics for Ads” 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 Ads 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 Groups Data from Pinterest Ads into Google Sheets

Accessing your Pinterest Ads Ad Groups 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 Ad Groups 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 Ad Groups 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 Ad Groups 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 Ad Groups Data

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

  • Select the “Ad Groups” object from the available options.
  • Choose the specific ad groups you want to import.
  • You can apply filters, select specific columns, 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 Ad Groups 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 Data from Pinterest Ads into Google Sheets

Accessing your Pinterest Ads Ad Group Analytics 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 Ad Group Analytics 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 Ad Group Analytics 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 Ad Group Analytics 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 Ad Group Analytics Data

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

  • Select the “Ad Group Analytics” 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 Ad Group Analytics 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 Targeting Analytics for Ad Groups Data from Pinterest Ads into Google Sheets

Accessing your Pinterest Ads Targeting Analytics for Ad Groups 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 Ad Groups 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 Ad Groups 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 Ad Groups 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 Ad Groups Data

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

  • Select the “Targeting Analytics for Ad Groups” 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 Ad Groups 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 Ads Data from Pinterest Ads into Google Sheets

Accessing your Pinterest Ads Ads 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 Ads 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 Ads 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 Ads 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 Ads Data

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

  • Select the “Ads” object from the available options.
  • Choose the specific ads you want to import.
  • You can apply filters, select specific columns, 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 Ads 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 Analytics Data from Pinterest Ads into Google Sheets

Accessing your Pinterest Ads Ad Analytics 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 Ad Analytics 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 Ad Analytics 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 Ad Analytics 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 Ad Analytics Data

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

  • Select the “Ad Analytics” 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 Ad Analytics 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 Targeting Analytics for Ad Account Data from Pinterest Ads into Google Sheets

Accessing your Pinterest Ads Targeting Analytics for Ad Account 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 Ad Account 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 Ad Account 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 Ad Account 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 Ad Account Data

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

  • Select the “Targeting Analytics for Ad Account” 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 Ad Account 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 Account Analytics Data from Pinterest Ads into Google Sheets

Accessing your Pinterest Ads Ad Account Analytics 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 Ad Account Analytics 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 Ad Account Analytics 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 Ad Account Analytics 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 Ad Account Analytics Data

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

  • Select the “Ad Account Analytics” 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 Ad Account Analytics 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 Campaigns Data from Pinterest Ads into Google Sheets

Accessing your Pinterest Ads Campaigns 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 Campaigns 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 Campaigns 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 Campaigns 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 Campaigns Data

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

  • Select the “Campaigns” object from the available options.
  • Choose the specific campaigns you want to import.
  • You can apply filters, select specific columns, 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 Campaigns 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 Campaign Analytics Data from Pinterest Ads into Google Sheets

Accessing your Pinterest Ads Campaign Analytics 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 Campaign Analytics 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 Campaign Analytics 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 Campaign Analytics 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 Campaign Analytics Data

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

  • Select the “Campaign Analytics” 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 Campaign Analytics 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