Ads - Chord Commerce

Chord Commerce Data Platform

...

Chord Data Attribute Definitio...

Shopify

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

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?

Activities

Conversions