Facebook Ads

Section header image mobile

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

Connecting to Facebook Ads

Import from Scratch with Facebook Ads

Schedule your Import, Snapshots, and Add Automations

FAQs for Facebook Ads

Connecting to Facebook Ads

When you begin a Facebook 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 Facebook Ads to Google Sheets/Excel using Coefficient.

1. Open the Coefficient Sidebar and click the Menu.


2. Select “Connected Sources”. 

Screenshot 2023-10-10 at 5.18.29 AM.png

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


4. “Authorize” the connection.


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


Import from Scratch with Facebook Ads

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

ImportFrom (1).png

2. Select “Facebook Ads” from the list.


3. Select “Start from scratch”.


4. 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 select.Preview_fields.png

5. 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”.Filter.png

6. Congratulations on your first Facebook Ads import with Coefficient! 🙌🏼Screenshot_2023-07-05_at_12.20.16_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 Importa.png

2. Turn on Snapshotsb.png

3. Set Up Automations


FAQs for Facebook 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 Facebook Ad accounts mapped to my Facebook account. How can I pull in the data using Coefficient?

When you begin a Coefficient import from Facebook Ads - “Start from scratch”, Coefficient will check the Ads accounts that you have associated with your Facebook 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)

This error keeps coming up in my Facebook Ads imports. Why does this keep happening?


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

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

This error, originating from the Facebook API, typically occurs due to the size of the requested data. To resolve this issue, try reducing the date range for the import. 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.

FireShot-Capture-042---2024-Ghost-Sheet-for-_NES-Marketing-Data-(M+A)-_-Spreadsheet---Google_---docs.google.com (1).png



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