Open the Coefficient Sidebar and click the Menu icon.
Select “Connected Sources”.
Import from Scratch with Facebook Ads
Schedule your Imports, Snapshots, and Automations
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 using Coefficient.
Open the Coefficient Sidebar and click the Menu icon.
Select “Connected Sources”.
Select “Add Connection” at the bottom and then “Connect” to Facebook Ads.
“Authorize” the connection.
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.
Open the Coefficient Sidebar and click on the “Import from…” button. ****
Select “Facebook Ads” from the list.
Select “Start from scratch”.
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.
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”.
Congratulations on your first Facebook Ads import with Coefficient! 🙌🏼
