Import Facebook Ads Manager data into Mammoth
The Facebook Ads Manager connector imports advertising data from your ad accounts into Mammoth as a dataset. You sign in to Facebook, so there are no API keys to manage. Open it from Data Library > New dataset > Connectors, search for Facebook and click Facebook Ads Manager. Project Admins create the connection; Project Editors can start datasets from a connection the project already has. Which connectors you can add depends on your plan.
What you can bring in from Facebook Ads
- Tables for the Ads Manager ad accounts the signed-in account can access, and the columns you tick.
- Data you ask for in the Chat. The agent picks tables and columns for you.
The dataset can refresh daily or only when you ask.
Before you connect Facebook Ads Manager
You need a Facebook account with access to the Ads Manager ad accounts you want to import data from.
Connect Facebook Ads Manager to Mammoth
- Go to the Data Library, click New dataset, and choose Connectors.
- Search for Facebook and click the Facebook Ads Manager tile. The connector workspace opens with the Chat connecting Facebook Ads.
- In the chat's card, click the button to sign in to Facebook. Mammoth sends you to Facebook in the same browser tab.
- Sign in with the account that has access to your ad accounts and authorize Mammoth. You're returned to Mammoth.
If you already have a Facebook Ads connection, pick it under Your connections in the launcher instead. See Connect a database or app for the shared steps.
Pick Facebook Ads tables and columns
- In Tables, click a table to see its columns and sample rows.
- Tick the columns you want. They gather in Your table.
- Click Preview 100 rows to check the result.
Save Facebook Ads data as a dataset
- Click Save as dataset.
- Enter a Dataset name, for example "Facebook Ads Campaign Performance", and pick the folder under Save in.
- Under Keep it up to date, choose Daily or Manual.
- Click Save.
Choosing Daily creates a Dataset Refresh automation that you can reschedule later.
Choose a Facebook Ads update method that keeps corrections
After the dataset is saved, its Update method offers these options:
| Update method | What it does |
|---|---|
| Replace all data | Rebuilds the dataset from the source on every refresh |
| Add new rows only | Keeps your rows and adds rows above the last value of a Key column |
| Keep only the newest rows | Empties the dataset, then brings in rows since the last refresh (needs a Key column) |
Facebook keeps correcting the numbers of recent days after it first reports them. With a date key column, each day is imported only once, so those corrections never arrive. Choose Replace all data to always have the corrected numbers. Mammoth shows the same warning when you pick a date key column for this source.
Troubleshoot Facebook Ads connections
| Symptom | Likely cause | Fix |
|---|---|---|
| Authorization fails | You closed the tab or denied access | Start the connection again; Mammoth returns you after sign-in |
| Authorization fails or ad accounts are missing | You signed in with the wrong Facebook account | Authorize with the account that has access to the ad accounts you need |
| No ad accounts visible | The account can't see the ad account | Confirm access to the ad account in Ads Manager |
| Recent days don't match Ads Manager | A date key column skips late corrections | Switch the Update method to Replace all data |
Related
- Google Ads: import Google advertising data.
- Google Analytics 4: add web analytics to your ad data.
- Connect a database or app: the shared connector workspace steps.
- Refresh a dataset: change when the dataset refreshes.
- Manage saved connections: reuse or remove this connection.
Something wrong? support@mammoth.io