Facebook Ads | Standard Dataset DMA
Below are the fields Alight Analytics considers standard for Facebook Ads | DMA dataset. By default, this dataset is scheduled to pull yesterday and the previous 28 days data to align with the Facebook's default conversion window.
All descriptive fields are also available in the Facebook Ads | Standard Conversion DMA dataset to allow easy analysis/reporting for custom conversions.
Facebook Ads data also includes Instagram Ads if you are advertising on both platforms, but due to the Facebook Ads breakdown limitations, we are unable to break out the data by platform.
Note: Facebook limits data availability to the last 37 months.
This dataset can be automatically activated without a ticket through Dataset Activation.
| Field | Type | Description |
| Report Date | DATE | The date the activity occurred |
| Campaign | STRING | The campaign name |
| Campaign ID | BIGINT | The campaign ID |
| Account ID | BIGINT | The account ID |
| Account | STRING | The account name |
| Ad Set | STRING | A group of ads |
| Ad Set ID | BIGINT | The ad set ID |
| Ad | STRING | The ad name |
| Ad ID | BIGINT | The ad ID |
| DMA | STRING | Designated Market Area in which the Ad was served. |
| Objective | STRING | The objective given to the campaign |
| Impressions | INTEGER | The number of times the ad was served |
| Clicks | INTEGER | The number of clicks on the ad |
| Cost | MONEY | The amount spent on the ad |
| Page Likes | INTEGER | The number of page likes attributed to the ad |
| Photo Views | INTEGER | The number of photo views attributed to the ad |
| Link Clicks | INTEGER | The number of link clicks attributed to the ad |
| Post Reactions | INTEGER | The number of post reactions attributed to the ad |
| Comments | INTEGER | The number of post comments the ad received |
| Shares | INTEGER | The number of times the ad was shared |
| Post Engagements | INTEGER | The number of actions the ad received |
| Landing Page Views | INTEGER | The number of landing page views the ad received |
| Video Views | INTEGER | The number of 3 second video views the ad received |
| Video AVG % Watched Actions | DECIMAL | The average percentage viewed of the video |
| Video p100 Watched Actions | INTEGER | The number of times the entire video was watched |
| Video p95 Watched Actions | INTEGER | The number of times 95% video was watched |
| Video p75 Watched Actions | INTEGER | The number of times 75% video was watched |
| Video p50 Watched Actions | INTEGER | The number of times 50% video was watched |
| Video p25 Watched Actions | INTEGER | The number of times 25% video was watched |
| Lead Forms | INTEGER | The number of lead forms attributed to the ad |
| Insert Date | TIMESTAMP | ChannelMix Field: when the row was inserted into the dataset |
| ChannelMix Profile | STRING | ChannelMix Field: the ChannelMix Profile associated to the data |