Ads - Chord Data Attribute Definitions

1 min

x_fct_unions

Name	Description
Account Name	The name of the ad account.
Account Source Account Id	The unique identifier of the ad account from the source dataset.
Account Updated At Date	The timestamp of when an ad account was last updated in the database - Universal Time Zone.
Account Updated At Month	The timestamp of when an ad account was last updated in the database - Universal Time Zone.
Account Updated At Quarter	The timestamp of when an ad account was last updated in the database - Universal Time Zone.
Account Updated At Time	The timestamp of when an ad account was last updated in the database - Universal Time Zone.
Account Updated At Week	The timestamp of when an ad account was last updated in the database - Universal Time Zone.
Account Updated At Year	The timestamp of when an ad account was last updated in the database - Universal Time Zone.
Ad Name	The name of the ad.
Ad Source Ad Id	The unique identifier of the ad from the source dataset.
Ad Status	The status of the ad.
Ad Updated At Date	The timestamp of when an ad was last updated in the database - Universal Time Zone.
Ad Updated At Month	The timestamp of when an ad was last updated in the database - Universal Time Zone.
Ad Updated At Quarter	The timestamp of when an ad was last updated in the database - Universal Time Zone.
Ad Updated At Time	The timestamp of when an ad was last updated in the database - Universal Time Zone.
Ad Updated At Week	The timestamp of when an ad was last updated in the database - Universal Time Zone.
Ad Updated At Year	The timestamp of when an ad was last updated in the database - Universal Time Zone.
Ad Group Name	The name of the ad group or ad set of the ad.
Ad Group Source Ad Group Id	The unique identifier of the ad group or ad set for the ad.
Ad Group Status	Status of the ad group or ad set.
Ad Group Updated At Date	The timestamp of when an ad group or ad set was last updated in the database - Universal Time Zone.
Ad Group Updated At Month	The timestamp of when an ad group or ad set was last updated in the database - Universal Time Zone.
Ad Group Updated At Quarter	The timestamp of when an ad group or ad set was last updated in the database - Universal Time Zone.
Ad Group Updated At Time	The timestamp of when an ad group or ad set was last updated in the database - Universal Time Zone.
Ad Group Updated At Week	The timestamp of when an ad group or ad set was last updated in the database - Universal Time Zone.
Ad Group Updated At Year	The timestamp of when an ad group or ad set was last updated in the database - Universal Time Zone.
Campaign Advertising Channel Type	The type of advertising channel being used by the campaign.
Campaign End Date Date	The date when the ad campaign ends - Universal Time Zone.
Campaign End Date Month	The date when the ad campaign ends - Universal Time Zone.
Campaign End Date Quarter	The date when the ad campaign ends - Universal Time Zone.
Campaign End Date Time	The date when the ad campaign ends - Universal Time Zone.
Campaign End Date Week	The date when the ad campaign ends - Universal Time Zone.
Campaign End Date Year	The date when the ad campaign ends - Universal Time Zone.
Campaign Name	The name of the ad campaign.
Campaign Source Campaign Id	The unique identifier of the ad campaign from the source dataset.
Campaign Start Date Date	The date when the ad campaign starts - Universal Time Zone.
Campaign Start Date Month	The date when the ad campaign starts - Universal Time Zone.
Campaign Start Date Quarter	The date when the ad campaign starts - Universal Time Zone.
Campaign Start Date Time	The date when the ad campaign starts - Universal Time Zone.
Campaign Start Date Week	The date when the ad campaign starts - Universal Time Zone.
Campaign Start Date Year	The date when the ad campaign starts - Universal Time Zone.
Campaign Status	The status of the ad campaign.
Campaign Updated At Date	The timestamp of when an ad campaign was last updated in the database - Universal Time Zone.
Campaign Updated At Month	The timestamp of when an ad campaign was last updated in the database - Universal Time Zone.
Campaign Updated At Quarter	The timestamp of when an ad campaign was last updated in the database - Universal Time Zone.
Campaign Updated At Time	The timestamp of when an ad campaign was last updated in the database - Universal Time Zone.
Campaign Updated At Week	The timestamp of when an ad campaign was last updated in the database - Universal Time Zone.
Campaign Updated At Year	The timestamp of when an ad campaign was last updated in the database - Universal Time Zone.
Insight Ad Network Type	The network type used across the account. This field is native to Google and YouTube and fileld with the ad source for other sources.
Insight Date Date	The date of the insight - Universal Time Zone.
Insight Date Month	The date of the insight - Universal Time Zone.
Insight Date Quarter	The date of the insight - Universal Time Zone.
Insight Date Time	The date of the insight - Universal Time Zone.
Insight Date Week	The date of the insight - Universal Time Zone.
Insight Date Year	The date of the insight - Universal Time Zone.
Source	The source of the Ad dataset - Google, Facebook, Tiktok, etc.
Average Clicks	The number of paid and earned clicks that occurred on the day of the record.
Average Impressions	The number of paid and earned impressions - the number of times an ad appeared on the page - that occurred on the day of the record.
Average Link Clicks	The number of link clicks on the ad's text, media or call-to-action that link to destinations or experiences specified by the advertiser. This metric excludes clicks on content or links in the comments section of a post. Currently, only Facebook Ads sourced insights surface this data.
Average Spend	The estimated total amount of spend that occurred on the day of the record.
Total Clicks	The number of paid and earned clicks that occurred on the day of the record.
Total Impressions	The number of paid and earned impressions - the number of times an ad appeared on the page - that occurred on the day of the record.
Total Link Clicks	The number of link clicks on the ad's text, media or call-to-action that link to destinations or experiences specified by the advertiser. This metric excludes clicks on content or links in the comments section of a post. Currently, only Facebook Ads sourced insights surface this data.
Total Spend	The estimated total amount of spend that occurred on the day of the record.