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.

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

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

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