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.

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

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

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