Chord Commerce Data Platform
...
Chord Data Attribute Definitio...
Salesforce

Ads

1min

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.



Updated 20 Sep 2024
Did this page help you?