Facebook Ads Advanced Settings

For users who have some experience working with their data in Panoply, there are a number of items that can be customized for this data source.

To configure the advanced settings for this data source:

1. Incremental Load: Panoply will collect all the data on the initial load. Panoply will use the last successful collection date minus 30 days as the start date on subsequent collections.
2. Delivery Breakdown: The delivery breakdown allows you to choose a method of categorization for your data. For example, if you select Age, your results will be returned based on age ranges. Learn more.
   • Facebook limits which values can be selected when choosing both an Action and a Delivery breakdown. Learn more.
3. Action Breakdown: The action breakdown allows you to categorize data by actions taken as a result of your ad. For example, if you are running a campaign with a Carousel ad, you can select Carousel Card to show how many clicks each card received. Learn more.
   • Facebook limits which values can be selected when choosing both an Action and a Delivery breakdown. Learn more.*
4. Click Window: This is the length of time after a person clicked your ad that will give that ad credit for subsequent actions. By default, Facebook uses an attribution window of 7-day click. This means your reporting table will show these actions if they happened within  7 days of someone clicking on your ad. Learn More.
5. View Window: This is the length of time after a person viewed your ad that will give that ad credit for subsequent actions. By default, Facebook uses an attribution window of 7-day click. This means your reporting table will show these actions if they happened within  7 days of someone clicking on your ad. Learn More.
6. Destination Schema: This is the name of the target schema to save the data. The default schema for data warehouses built on Google BigQuery is panoply. The default schema for data warehouses built on Amazon Redshift is public. This cannot be changed once a source has been collected.
7. Destination Prefix: The Destination Prefix determines the name of the tables created. Panoply automatically uses facebook_ads as the destination prefix, then adds the name of the resource, such as facebook_ads_<resource>. To change the prefix for these tables, enter your preferred prefix. If you enter my_fb_ads for example, the resulting table would be my_fb_ads_<resource> such as my_fb_ads_insights or my_fb_ads_campaigns.
   • For nested data, child tables will be created with the prefix facebook_ads_<resource>>_<child>.
8. Exclude: The Exclude option allows you to exclude certain data, such as names, addresses, or other personally identifiable information. Enter the column names of the data to exclude.
9. Truncate: Truncate deletes all the current data stored in the destination tables, but not the tables themselves. Afterwards Panoply will recollect all the available data for this data source.
10. Click Save Changes and then click Collect.

• The data source appears grayed out while the collection runs.
• You may add additional data sources while this collection runs.
• You can monitor this collection from the Jobs page or the Data Sources page.
• After a successful collection, navigate to the Tables page to review the data results.