Facebook Ads | DLH.io Documentation

Facebook (Meta) advertising campaigns reach millions of people on a daily basis. The Facebook Ads data for the spend and metadata about the views, potential customers, conversions, etc. is available to you to bring into your data pipeline and your warehouse to build more insights, KPIs, etc. with DLH.io so that you can be as efficient and effective as possible with your marketing objectives.

DLH.io gives you the no-code tools to connect to your Facebook Ads and extract this data on your terms so you can get at the core of the data so you can see all aspects of your campaigns.

Setup Instructions

Follow the setup steps guide for configuring your Facebook Ads connection to enable data to flow into your destination via DLH.

Supported Features

Here are key features supported for this connector.

Sync Feature	Supported	Details
Custom Data and Development	✓	Ability to enhance connector upon request
Historical Re-Load/Load	✓
Incremental/Delta Load	✓	Gets most recent records and changes
Column Selection	✓
Column Hashing	✓
Re-Sync Table/Entity	✓	Select at the table level to reload data history (on next Sync Bridge run)
Custom Queries		Utilizing SQL Data Query Connector
Custom Data
Captures Deleted Rows	✓	On all supported tables
API Sync Bridge Initiation	✓
Priority Scheduling	✓
Private VPC/Link	☂
DLH Data Model Available	-

If you have any questions about these supported features please reach out to our Customer Support team.

Details on Sync Processing

For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.

Helpful Tip

Most API requests sent by Facebook Ads connectors are sent between 3 a.m. and 7 a.m. (UTC {Time Converter}). We recommend that you set the start time of your connector outside this high-load period. This action mitigates possible rate limit issues and optimizes sync time.

Replicated Entities

The following Facebook Ads entities are replicated to your target destination. These are the table names you will see:

AD
ADS_PIXEL
AD_ACCOUNT
AD_ACCOUNT_ATTRIBUTION_SPEC
AD_ACCOUNT_DELIVERY_CHECK
AD_ACCOUNT_USER
AD_ACTIVITIES
AD_CAMPAIGN
AD_CAMPAIGN_ISSUE_INFO
AD_CONVERSION_SPECS
AD_DELIVERY_CHECK
AD_GROUP_ISSUE_INFO
AD_IMAGE
AD_INSIGHT
AD_LABEL
AD_PLACE_PAGE_SET
AD_RECOMMENDATION
AD_RULE
AD_RULES_HISTORY
AD_RULE_HISTORY_RESULT
AD_RULE_HISTORY_RESULT_ACTION
AD_SET
AD_SET_AD_RECOMMENDATION
AD_SET_ATTRIBUTION_SPEC
AD_SET_FREQUENCY_CONTROL_SPECS
AD_SET_ISSUE_INFO
AD_SET_SCHEDULE
AD_STUDY
AD_TRACKING_SPECS
AD_VIDEO
AD_VOLUME
BUSINESS
SYSTEM_USER

Issue Handling

If any issues occur with the authorization simply return to the sources page in DLH.io, edit the source details and click the Save & Test or Authorize Your Account or Re-Authorize Account button to confirm connectivity. If any issues persist please contact our support team via the DLH.io Support Portal.

Schema Details (ER Diagram)

This entity relationship diagram (ERD) provides you with information about what entities/tables DLH provides for you out-of-the-box and how they are related to one another.

Page Contents