Template result: data schema of the final destination table

You will get the data in the table 'BlendedAdSpend' (with partitioning by date field by days) with the schema below:

Field name Type  
source STRING The source of the ad costs.
medium STRING The medium of the ad costs.
campaign STRING The campaign of the ad costs.
keyword STRING The keyword of the ad costs.
adContent STRING The adContent of the ad costs.
adGroup STRING The ad group name of the ad costs. Please note that the field is only applicable for google / cpc
date DATE The date is formatted as YYYY-MM-DD.
adCost FLOAT The sum of ad costs.
impressions INTEGER The total number of impressions.
adClicks INTEGER Total number of times users have clicked on an ad to reach the property.
currency STRING The code of a currency.
adAccount STRING Contains info about the source ad account.
dataSource STRING The source of data.
campaignType STRING The type of ad campaign the costs were spent on.
campaignId STRING The ID of ad campaign the costs were spent on.
campaignName STRING The name of ad campaign the costs were spent on.
adGroupId STRING The ad group ID.
adGroupName STRING The ad group name.
adSource STRING Data source.
pipelineId STRING Internal technical information.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.