Meta Ads

Section header image mobile

With Coefficient's Meta Ads integration, you can seamlessly connect and access ad data from your Meta Ads platform. This allows you to analyze their campaign metrics and goals, helping them drive engagement and conversions.

Connecting to Meta Ads

Import from Scratch with Meta Ads

Schedule your Import, Snapshots, and Add Automations

FAQs for Meta Ads

Connecting to Meta Ads

When you begin a Meta Ads import for the first time, you will need to go through a few steps to connect your account to Coefficient before you’re able to import data from Meta Ads to Google Sheets/Excel using Coefficient.

1. Open the Coefficient Sidebar and click the Menu.

Screenshot 2025-08-15 at 6.19.09 AM.png

2. Select “Connected Sources”. 

ConnectedSources.png

3. Select “Add Connection” at the bottom and then “Connect” to Meta Ads.

Screenshot 2026-02-05 at 2.12.38 AM.png

4. “Authorize” the connection.

Screenshot 2026-02-05 at 2.12.48 AM.png

5. Log in to your Meta account and click “Continue as…” to allow access to Coefficient. When successful, you will be taken back to Google Sheets/Excel.

Screenshot 2025-10-22 at 7.49.27 PM.png

Import from Scratch with Meta Ads

1. Open the Coefficient Sidebar and click on the “Import from…” button.

Import from.png

2. Select “Meta Ads” from the list.

Screenshot 2026-02-05 at 2.15.00 AM.png

3. Select “Start from scratch”.

Screenshot 2026-02-05 at 2.15.12 AM.png

4. Select the Meta Ads account from the list. Then click Next. Screenshot 2026-02-05 at 2.17.20 AM.png

5. Select the fields needed for your import under Metrics, Breakdowns, Action Breakdown, and Action Attribution (Action Breakdown and Action Attribution fields will only be available if you choose an action metric from the Metrics list). Click inside the white box area for each section to search for the fields you need. The data previewer shows a sneak peek of the data from the fields you selectScreenshot 2026-02-05 at 2.18.13 AM.png

6. Customize your import by adding filters and/or row limits as needed. Click the “Refresh Preview” option to update the sample data based on the customizations that are added. Then “Import”.Screenshot 2026-02-05 at 2.19.11 AM.png

7. Congratulations on your first Meta Ads import with Coefficient! 🙌🏼Screenshot 2026-02-05 at 2.21.59 AM.png

Schedule your Import, Snapshots, and Add Automations

Once you have pulled your data into your spreadsheet using Coefficient, you can set up the following:

1. Schedule your ImportScreenshot 2025-09-16 at 8.02.41 AM.png

2. Turn on SnapshotsScreenshot 2025-09-16 at 7.20.51 AM.png

Screenshot 2025-09-16 at 7.20.58 AM.png

3. Set Up Automations

Screenshot 2025-09-16 at 7.22.00 AM.png

FAQs for Meta Ads

Why are the Action Breakdown and Action Attribution fields greyed out?

These fields will only be available if you choose an action metric from the Metrics list.

I have multiple Meta Ad accounts mapped to my Meta account. How can I pull in the data using Coefficient?

When you begin a Coefficient import from Meta Ads - “Start from scratch”, Coefficient will check the Ads accounts that you have associated with your Meta account. If we detect more than one Ad account, we will present you with an option to pick the Ad account you want to use for your Coefficient import. (If you only have one Ad account, we will skip this step)

I am being prompted to reconnect my Meta Ads account every 60 days. How can I fix this? 

Due to some API limitations within the Meta Ads API, you will need to “Reauthorize” your data source connection every 60 days. To “Reauthorize” your connection, click the “Re-connect Meta Ads” link in the message to log in and authorize your account again.

I am getting a "Meta Ads API experienced an issue processing your request" error when I create an import. How do I fix this?

This error, originating from the Meta API, typically occurs due to the size of the requested data. To resolve this issue, try reducing the import date range. You can create one import for a specific date range and another for the remaining dates as a workaround. This approach helps you stay within the API limitations.

Some metrics I previously added to my Meta Ads import are missing. What should I do?

Meta recently announced the deprecation of specific metrics from their Meta Ads APIs, effective October 30, 2024 (more information from Meta here).

If your existing imports include any of these deprecated metrics, they will display blank values when refreshed. You can edit your import, and Coefficient will automatically remove the deprecated fields — there’s no need to deselect them manually.

Below is a list of the metrics deprecated by Meta:

Screenshot 2025-11-07 at 4.41.17 PM.png

Was this article helpful? 0 out of 1 found this helpful