| Report | Select the Facebook Ads Advanced Multi Accounts Ads report you want to run. The following reports are available:
| Report | Description |
|---|
| FBAds PreBuilt Report | Domo’s complimentary pre-built report for Facebook Ads - a comprehensive analysis of advertising performance including accounts, campaigns, ad groups, and ad-level reporting. | | Ad Accounts | Returns information about one or more selected Facebook Ads Accounts. | | Ad Campaigns | Returns information about one or more Ad Campaigns controlled by the selected Account(s). | | Ad Keyword Statistics (Deprecated) | Returns information about the Keywords used for targeting the selected Ad(s). | | Ad Sets | Returns information about one or more Ad Sets within the selected Ad Campaign(s). | | Ads | Returns information about one or more Ads defined in the selected Ad Set(s). | | Custom Insights | Returns user-selected insight information at a reporting level defined by the Level field. | | General Metrics | Returns commonly-used insight metrics at the Campaign level. | | Object Information - NEW | This new report enables you to retrieve the Info edge of the all the Account, Campaign, Ad set, or Ad objects associated with the Ad Accounts you select. Select the Ad Accounts and the object type you need information about. | | Object Insights - NEW | This new report enables you to retrieve the Insights edge of the all the Account, Campaign, Ad set, or Ad objects associated with the Ad Accounts you select. Select the Ad Accounts and the object type you need insights about, and complete the other insight metrics. | | Page Actions (Ad sets) | Returns insights related to Page and Post interactions at the Adset level. | | Page Actions (Ads) | Returns insights related to Page and Post interactions at the Ad level. | | Placement Metrics | Returns common metrics, broken down by screen placement, at the Campaign level. | | Responder Demographics | Returns common metrics, broken down by age and gender, at the Adset level. | | User | Returns information about the authenticated user. |
|
| Select Object Type | Pick an object level to gather data. Domo reports all objects of the type contained in the accounts you have selected. |
| Effective Statuses | This field appears for the Object Information - NEW report when you select Campaign, Ad Set, or Ad as the Object Type. Select the effective statuses to filter your data. |
| Time Increment | Select the granularity used to aggregate the data. |
| Duration | Choose whether the report should cover a Single Date or a Date Range. |
| Date From | Choose how you want to set the start date for the report.
- Relative Date: Enter the number of days back from today.
- Specific Date: Use the date picker to select a precise date.
For example, if you enter 10 for Date From Offset and five for Date To Offset, and you set the data source to update daily, each new day the report updates to show the information for five to 10 days in the past. |
| Date From Offset | Enter the number of days you want to go back from the current date. For example, enter 0 for today or 1 for yesterday. |
| Select Specific Date From | Select the precise start date for the report using the date picker. This option is only available when the Report Date is set to Specific. |
| Date To | Choose how you want to set the end date for the report.
- Relative Date: Enter the number of days back from today.
- Specific Date: Use the date picker to select a precise date.
Choose Relative if you always want the report to retrieve data for a given number of days back (which you specify in Date To Offset) from the current date. If you choose Relative here, you should also choose Relative for Date From and specify a value for Date From Offset. For example, if you enter 10 for Date From Offset and 5 for Date To Offset and you set the data source to update daily, each new day the report will update to show information for 5 to 10 days in the past. |
| Date To Offset | Enter the number of days you want to go back from the selected end date. For example, enter 0 for today or 1 for yesterday. |
| Select Specific Date To | Select the precise end date for the report using the date picker. This option is only available when the Report Date is set to Specific. |
| Report Date | Specify whether the report data is based on a fixed date or a relative number of days. A relative number of days indicates the retrospective period from which data will be retrieved. To retrieve data from a specific date, use the date selector.
Choose Relative if you always want the report to retrieve data for a given number of days back (which you specify in Date Offset) from the current date. For example, if you enter 5 for Date Offset and set the data source to update daily, each new day the updated report will show information for the date 5 days in the past. |
| Date Offset | Enter the number of days you want to go back from the current date. For example, enter 0 for today or 1 for yesterday. |
| Select Specific Date | To select a specific report date, use the date picker. This option is only available when the Report Date is set to Specific. |
| Columns | Select the columns. |
| Time Increment | Enter the number of days used to aggregate the data. This should be an integer between 1 and 90. You can also enter monthly to show data by month or all_days to show data for all days with data. |
| Level | Select the ad level for the report. |
| Conversion Type Selection | Select if you want to bring custom or standard conversions only. |
| Breakdowns | Select how you want the report data to be broken down. |
| Action Breakdowns | Select the desired action breakdown(s) for the report. |
| Include Archived Objects | If set to True then the Archived objects will be in the results. Otherwise, Archived objects will not be reported. |
| Action Attribution Windows | Select the desired action attribution windows for the report. |
| Reset Schema | Select this checkbox if you need to reset the schema.
Warning: This can result in loss of data or change in data type if some fields are temporarily not returned by Facebook’s API. While this checkbox is selected the dataset will reset the schema for each run. Do not use in the APPEND mode. |
| Ad Account Edge | | Edge | Description |
|---|
| Ad Account Info | Returns information about the selected account. | | Activities | Returns a log of the actions taken on the selected account. | | Ad Campaigns | Returns a list of ad campaigns for the selected account. | | Ad Sets | Returns a list of ad sets for the selected account. | | Ads | Returns a list of ads for the selected account. | | Custom Audiences | Returns the custom audiences owned by or shared with the selected account. | | Insights | Returns insight information for the specified criteria. | | Partners | Returns a list of ad partners for the selected account. | | Rate Card | Returns a list of currency rates. | | Reach Estimate | Returns the reach estimate for the selected account and given targeting spec. | | Users | Returns user IDs, permissions, and roles for the selected account. |
|
| Action Report Time | Determines the report time of action stats. For example, if a person saw the ad on Jan 1st but converted on Jan 2nd, when you query the API with action_report_time=impression, you see a conversion on Jan 1st. When you query the API with action_report_time=conversion, you see a conversion on Jan 2nd. |
| Expand List Columns | | Option | Description |
|---|
| Expand as Columns | List data will expand as multiple columns in the results. | | Expand as Rows | List data will expand into multiple rows in the results. This will result in many rows with duplicated data. | | Do not expand | List data will not be expanded in the results. It will be returned as “List” in the results. | | Expand Lists In Place | List data will be converted into a comma-separated list of values for the cell. This does not result in new rows or columns. |
|
| Targeting Spec | Enter the Targeting Spec. |
| Skip Failing Ad Set IDs | When checking if any Ad Set IDs fail, it skips, and the connector continues to run using the remaining Ad Set IDs. |
| User Edge | | Edge | Description |
|---|
| Ad Accounts | Returns information for the authenticated user’s ad accounts, such as balance, capabilities, funding sources, etc. | | User Info | Returns the authenticated user’s name and ID. |
|
