StackAdapt Fields

Dimensions (40)

Ad Type

API Name: records.nodes.ad.__typename
NinjaCat System ID: stackadapt:DIM_Ad_Type
Data Type: text

Advertiser

API Name: records.nodes.campaign.advertiser.name
NinjaCat System ID: stackadapt:DIM_Advertiser
Data Type: text
Aggregates To: DIM_ACCOUNT

Advertiser ID

API Name: records.nodes.campaign.advertiser.id
NinjaCat System ID: stackadapt:DIM_Advertiser_ID
Data Type: text
Aggregates To: DIM_ACCOUNT_ID

Audience Segment

Deprecated: 2025-01-22T16:45:41.075Z
API Name: Split into interestSegments, demographicSegments, and customSegments
NinjaCat System ID: stackadapt:DIM_Audience_Segment
Data Type: text

Campaign Group

API Name: records.nodes.campaign.campaignGroup.name
NinjaCat System ID: stackadapt:DIM_Campaign_Group
Data Type: text
Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign Group ID

API Name: records.nodes.campaign.campaignGroup.id
NinjaCat System ID: stackadapt:DIM_Campaign_Group_ID
Data Type: text

Campaign Group Name

API Name: custom(campaign_group_name)
NinjaCat System ID: stackadapt:DIM_CG_Name
Data Type: text

Campaign ID

API Name: records.nodes.campaign.id
NinjaCat System ID: stackadapt:DIM_Campaign_ID
Data Type: text

Campaign Name

API Name: records.nodes.campaign.name
NinjaCat System ID: stackadapt:DIM_Campaign_Name
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Campaign Type

API Name: records.nodes.campaign.__typename
NinjaCat System ID: stackadapt:DIM_Campaign_Type
Data Type: text

Click URL

API Name: records.nodes.ad.|||CtvAd|||DisplayAd|||NativeAd|||VideoAd.clickUrl
NinjaCat System ID: stackadapt:DIM_Click_URL
Data Type: text

Conversion Device

API Name: records.nodes.attributes.deviceType
NinjaCat System ID: stackadapt:DIM_Conversion_Device
Data Type: text
Aggregates To: DIM_DEVICE_TYPE

Conversion Domain

API Name: nodes.domain
NinjaCat System ID: stackadapt:DIM_Conversion_Domain
Data Type: text

Conversion Event Type (Shopify)

API Name: nodes.conversionPixel.shopifyEventType
NinjaCat System ID: stackadapt:DIM_Conversion_Shopify_Type
Data Type: text

Conversion ID

API Name: nodes.conversionPixel.id
NinjaCat System ID: stackadapt:DIM_Conversion_Tracker_ID
Data Type: text

Conversion Key

API Name: nodes.conversionPixel.uniqueKey
NinjaCat System ID: stackadapt:DIM_Conversion_Key
Data Type: text

ConversionName

API Name: nodes.conversionPixel.name
NinjaCat System ID: stackadapt:DIM_Conversion_Tracker_Name
Data Type: text

Conversion Type

API Name: nodes.conversionPixel.conversionType
NinjaCat System ID: stackadapt:DIM_Conversion_Tracker_Type
Data Type: text

Creative File Name (Image)

API Name: records.nodes.ad.|||DisplayAd|||DoohAd|||NativeAd.creativesConnection.nodes.||DisplayCreative||DoohCreative||.|||ImageCreative.fileName
NinjaCat System ID: stackadapt:DIM_Image_Creative_File_Name
Data Type: text

Creative File Name (Video)

API Name: records.nodes.ad.|||CtvAd|||DoohAd|||VideoAd.creativesConnection.nodes.|| ||DoohCreative||.|||UploadedVideo.fileName
NinjaCat System ID: stackadapt:DIM_Video_Creative_File_Name
Data Type: text

Creative Height (Image)

API Name: records.nodes.ad.|||DisplayAd|||DoohAd|||NativeAd.creativesConnection.nodes.||DisplayCreative||DoohCreative||.|||ImageCreative.height
NinjaCat System ID: stackadapt:DIM_Image_Creative_Height
Data Type: text

Creative Height (Video)

API Name: records.nodes.ad.|||CtvAd|||DoohAd|||VideoAd.creativesConnection.nodes.|| ||DoohCreative||.|||UploadedVideo.height
NinjaCat System ID: stackadapt:DIM_Video_Creative_Height
Data Type: text

Creative ID (Image)

API Name: records.nodes.ad.|||DisplayAd|||DoohAd|||NativeAd.creativesConnection.nodes.||DisplayCreative||DoohCreative||.|||ImageCreative.id
NinjaCat System ID: stackadapt:DIM_Image_Creative_ID
Data Type: text

Creative ID (Video)

API Name: records.nodes.ad.|||CtvAd|||DoohAd|||VideoAd.creativesConnection.nodes.|| ||DoohCreative||.|||UploadedVideo.id
NinjaCat System ID: stackadapt:DIM_Video_Creative_ID
Data Type: text

Creative Image Preview

API Name: records.nodes.ad.|||DisplayAd|||DoohAd|||NativeAd.creativesConnection.nodes.||DisplayCreative||DoohCreative||.|||ImageCreative.s3Url
NinjaCat System ID: stackadapt:DIM_Image_Creative_Image
Data Type: text
Display As: image

Creative Size (Image)

API Name: custom(image_creative_size)
NinjaCat System ID: stackadapt:DIM_Image_Creative_Size
Data Type: text

Creative Size (Video)

API Name: custom(video_creative_size)
NinjaCat System ID: stackadapt:DIM_Video_Creative_Size
Data Type: text

Creative URL (Image)

API Name: records.nodes.ad.|||DisplayAd|||DoohAd|||NativeAd.creativesConnection.nodes.||DisplayCreative||DoohCreative||.|||ImageCreative.s3Url
NinjaCat System ID: stackadapt:DIM_Image_Creative_URL
Data Type: text

Creative URL (Video)

API Name: records.nodes.ad.|||CtvAd|||DoohAd|||VideoAd.creativesConnection.nodes.|| ||DoohCreative||.|||UploadedVideo.s3Url
NinjaCat System ID: stackadapt:DIM_Video_Creative_URL
Data Type: text

Creative Video Thumbnail

API Name: records.nodes.ad.|||CtvAd|||DoohAd|||VideoAd.creativesConnection.nodes.|| ||DoohCreative||.|||UploadedVideo.thumbS3Url
NinjaCat System ID: stackadapt:DIM_Video_Creative_Image
Data Type: text
Display As: image

Creative Width (Image)

API Name: records.nodes.ad.|||DisplayAd|||DoohAd|||NativeAd.creativesConnection.nodes.||DisplayCreative||DoohCreative||.|||ImageCreative.width
NinjaCat System ID: stackadapt:DIM_Image_Creative_Width
Data Type: text

Creative Width (Video)

API Name: records.nodes.ad.|||CtvAd|||DoohAd|||VideoAd.creativesConnection.nodes.|| ||DoohCreative||.|||UploadedVideo.width
NinjaCat System ID: stackadapt:DIM_Video_Creative_Width
Data Type: text

Date

API Name: records.nodes.granularity.startTime
NinjaCat System ID: stackadapt:DIM_Date
Data Type: date
Aggregates To: DIM_DATE

Deal ID

API Name: records.nodes.campaign.advertiser.dealIds
NinjaCat System ID: stackadapt:DIM_Deal_ID
Data Type: text

Domain

API Name: records.nodes.attributes.app.domain
NinjaCat System ID: stackadapt:DIM_Domain
Data Type: text

Product Name

API Name: records.nodes.campaign.ads.nodes.brandname
NinjaCat System ID: stackadapt:DIM_Product_Name
Data Type: text

Row

NinjaCat System ID: stackadapt:DIM_ROW
Data Type: text
Aggregates To: DIM_ROW

Visited City

API Name: records.nodes.attributes.city
NinjaCat System ID: stackadapt:DIM_Visited_City
Data Type: text
Aggregates To: DIM_CITY

Visited Region

API Name: records.nodes.attributes.region.name
NinjaCat System ID: stackadapt:DIM_Visited_Region
Data Type: text
Aggregates To: DIM_STATE_PROVINCE

Visited Zip

API Name: records.nodes.attributes.zipCode
NinjaCat System ID: stackadapt:DIM_Visited_Zip
Data Type: text
Aggregates To: DIM_POSTAL_CODE

Metrics (34)

100% Audio Completion Rate

NinjaCat System ID: stackadapt:MET_100_Audio_Completion_Rate
Data Type: decimal
Display As: percent
Formula: (stackadapt:MET_100%_Audio_Completions / stackadapt:MET_Audio_Starts)

100% Audio Completions

API Name: records.nodes.metrics.audioCompletions
NinjaCat System ID: stackadapt:MET_100_Audio_Completions
Data Type: integer

100% Video Completion Rate

NinjaCat System ID: stackadapt:MET_100_Video_Completion_Rate
Data Type: decimal
Display As: percent
Formula: (stackadapt:MET_100%_Video_Completions / stackadapt:MET_Video_Starts)

100% Video Completions

API Name: records.nodes.metrics.videoCompletions
NinjaCat System ID: stackadapt:MET_100_Video_Completions
Data Type: integer

25% AC

API Name: records.nodes.metrics.audioQ1Playbacks
NinjaCat System ID: stackadapt:MET_25_AC
Data Type: integer

25% VC

API Name: records.nodes.metrics.videoQ1Playbacks
NinjaCat System ID: stackadapt:MET_25_VC
Data Type: integer

50% AC

API Name: records.nodes.metrics.audioQ2Playbacks
NinjaCat System ID: stackadapt:MET_50_AC
Data Type: integer

50% VC

API Name: records.nodes.metrics.videoQ2Playbacks
NinjaCat System ID: stackadapt:MET_50_VC
Data Type: integer

75% AC

API Name: records.nodes.metrics.audioQ3Playbacks
NinjaCat System ID: stackadapt:MET_75_AC
Data Type: integer

75% VC

API Name: records.nodes.metrics.videoQ2Playbacks
NinjaCat System ID: stackadapt:MET_75_VC
Data Type: integer

Audio Starts

API Name: records.nodes.metrics.audioStarts
NinjaCat System ID: stackadapt:MET_Audio_Starts
Data Type: integer

Average Impression Time

API Name: records.nodes.metrics.averageImpressionTime
NinjaCat System ID: stackadapt:MET_Average_Impression_Time
Data Type: decimal
Display As: float

Average Time on Site

API Name: records.nodes.metrics.atos
NinjaCat System ID: stackadapt:MET_Average_Time_on_Site
Data Type: decimal
Display As: float

Click Conversions

API Name: records.nodes.metrics.clickConversions
NinjaCat System ID: stackadapt:MET_Click_Conversions
Data Type: decimal
Display As: integer

Clicks

API Name: records.nodes.metrics.clicks
NinjaCat System ID: stackadapt:MET_Clicks
Data Type: decimal
Display As: integer
Aggregates To: MET_CLICKS

Click Secondary Conversions

API Name: records.nodes.metrics.clickSecondaryConversions
NinjaCat System ID: stackadapt:MET_Click_Secondary_Conversions
Data Type: decimal
Display As: integer

Click-to-Conversion Time

API Name: nodes.clickToConversionTime
NinjaCat System ID: stackadapt:MET_Conversion_Click_to_Conversion_Time
Data Type: integer

Conversion Clicks

API Name: nodes.clickCount
NinjaCat System ID: stackadapt:MET_Conversion_Clicks
Data Type: integer

Conversion Impressions

API Name: nodes.impressionCount
NinjaCat System ID: stackadapt:MET_Conversion_Impressions
Data Type: integer

Conversion Impression Time

NinjaCat System ID: stackadapt:MET_Conversion_Impression_Time
Data Type: decimal
Display As: integer
Formula: (stackadapt:MET_Average_Impression_Time * stackadapt:Impressions / stackadapt:Conversions)

Conversion Revenue

API Name: records.nodes.metrics.conversionRevenue
NinjaCat System ID: stackadapt:MET_Conversion_Revenue
Data Type: decimal
Display As: currency

Conversions

API Name: records.nodes.metrics.conversions
NinjaCat System ID: stackadapt:MET_Conversions
Data Type: decimal
Display As: integer
Aggregates To: MET_CONVERSIONS

Cost

API Name: records.nodes.metrics.cost
NinjaCat System ID: stackadapt:MET_Cost
Data Type: decimal
Display As: currency
Aggregates To: MET_COST

Cost Per Conversion

NinjaCat System ID: stackadapt:MET_Cost_Per_Conversion
Data Type: decimal
Display As: currency
Aggregates To: MET_COST_PER_CONVERSION
Formula: (stackadapt:MET_Cost / stackadapt:MET_Conversions)

CPC

NinjaCat System ID: stackadapt:MET_CPC
Data Type: decimal
Display As: currency
Aggregates To: MET_CPC
Formula: (stackadapt:MET_Cost / stackadapt:MET_Clicks)

CTR

NinjaCat System ID: stackadapt:MET_CTR
Data Type: decimal
Display As: percent
Aggregates To: MET_CTR
Formula: (stackadapt:MET_Clicks / stackadapt:MET_Impressions)

Frequency

API Name: records.nodes.metrics.frequency
NinjaCat System ID: stackadapt:MET_Frequency
Data Type: decimal
Display As: float

Impression Conversions

API Name: records.nodes.metrics.impressionConversions
NinjaCat System ID: stackadapt:MET_Impression_Conversions
Data Type: decimal
Display As: integer
Aggregates To: MET_CONVERSIONS

Impressions

API Name: records.nodes.metrics.impressions
NinjaCat System ID: stackadapt:MET_Impressions
Data Type: decimal
Display As: integer
Aggregates To: MET_IMPRESSIONS

Impression Secondary Conversions

API Name: records.nodes.metrics.impressionSecondaryConversions
NinjaCat System ID: stackadapt:MET_Impression_Secondary_Conversions
Data Type: decimal
Display As: integer
Aggregates To: MET_CONVERSIONS

Impression-to-Conversion Time

API Name: nodes.impressionToConversionTime
NinjaCat System ID: stackadapt:MET_Conversion_Impression_to_Conversion_Time
Data Type: decimal
Display As: float

Secondary Conversions

API Name: records.nodes.metrics.secondaryConversions
NinjaCat System ID: stackadapt:MET_Secondary_Conversions
Data Type: decimal
Display As: integer
Aggregates To: MET_CONVERSIONS

Unique Impressions

API Name: records.nodes.metrics.uniqueImpressions
NinjaCat System ID: stackadapt:MET_Unique_Impressions
Data Type: decimal
Display As: integer

Video Starts

API Name: records.nodes.metrics.videoStarts
NinjaCat System ID: stackadapt:MET_Video_Starts
Data Type: decimal
Display As: integer