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