Ads
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. |