Facebook Ads Manager

Facebook Ads Manager is your starting point for running ads on Facebook, Instagram, Messenger or Audience Network. It’s an all-in-one tool for creating ads, managing when and where they’ll run, and tracking how well your campaigns are performing.

Connecting to Facebook Ads

Mammoth allows you to connect your Facebook account to get your Ads data into Mammoth.

  1. Select API & Databases from the add menu and click on Facebook Ads Manager.

    Facebook Ads selection
  2. Click on a new connection and log in into your Facebook account.

    Facebook Ads login
  3. Select the account and click on “Next”.

    Facebook Ads login

    Once your Facebook account is connected with Mammoth, you will be presented with a list of tables and views in that database.

  4. Select the table you want to import and complete the test query with ID/TARGET , like this:

SELECT * FROM Ads WHERE Id = 'act_123456'
Facebook Ads table selection
  • Click on Next.


  1. Facebook mandates the use of ID / TARGET for connecting Ads data to any third-party applications for security purposes. Keep it handy for a swift connection.

  2. The Ids for Ad accounts in Facebook are always returned in the format “act_” and when they are used as a Target in requests for other tables, the Id with the prefix “act_” must always be used.

After you have selected the table you want to work on, you get options to configure it as follows:

  • Rename it in the data pull scheduling window.

  • Set the frequency of the data import.

  • Save it in a desired location in the Data Library from Adding file to option.

  • Schedule pull.

Scheduling your Data Pulls

You can start retrieving the data now or at a specific time according to your choice. You can also schedule the data pull in order to get the latest data from your Database at a certain time interval - every few minutes, daily, weekly or monthly.

On every data pull from your Database, you also have an option to either replace the older data or combine with older data.

Facebook Ads data pull

On choosing Combine with older data option, you will get an option to choose a unique sequence column. Using this column, on refresh, Mammoth will pick up all the rows that have greater value in this column than the previous data pull.