View: Vendor

The Vendor-Reported Marketing Performance View displays high-level KPIs from All integrated Marketing Vendors.

NOTE: This View Does NOT tie into Shopify or Goggle Analytics – This Data is Pulled straight from each Vendor.

Explorer containing this View: Vendor Reported Marketing Performance

Dimensions

Field Name

Description Source
Account    
Account ID The unique identifier of the advertiser account on the ad platform.A vendor_performance.ad_account_id
Ad Account Name The name of the advertiser account on the ad platform. vendor_performance.ad_account_name
Ad    
Ad ID The unique identifier for the ad. Note: that Google Performance Max campaigns will always have NULL ad IDs. vendor_performance.ad_id
Ad Name The name of the ad. Note: Google Ads does not have ad names available. vendor_performance.ad_name
Ad Status The status of the ad at time of the latest extraction.
vendor_performance.ad_status
 
Ad Set  
 
Ad Set ID The unique identifier for the ad set. Note: this may be labeled slightly different in some ad platforms, e.g.: ad group, ad squad. Google Performance Max campaigns will always have NULL ad set IDs.
vendor_performance.adset_id
Ad Set Name The name of the Ad Set. Note: this may be labeled slightly different in some ad platforms, e.g.: ad group, ad squad. Google Performance Max campaigns will always have NULL ad set names.
vendor_performance.adset_name
Ad Set Status The status of the Ad Set at time of the latest extraction. Note: this may be labeled slightly different in some ad platforms, e.g.: ad group, ad squad.
vendor_performance.adset_status
Campaign  
 
Campaign ID The unique identifier for the campaign.
vendor_performance.campaign_id
Campaign Name The name of the campaign.
vendor_performance.campaign_name
 
Campaign Status The status of the campaign at time of the latest extraction
vendor_performance.campaign_status
Store The name of the store integration (or linked store integration) in the Daasity app.
integration_mapping.name
Vendor The Ad Platform name.
vendor_performance.vendor

 

Measures

Field Name Description Source
Clicks & Impressions    
Clickthrough Rate (CTR) The percent of ad impressions that result in a click. Calculated as Total Clicks / Total Impressions. vendor_performance.ctr
Total Clicks Total number of times users clicked on an ad. vendor_performance.total_clicks
Total Impressions Total number of times users viewed an ad. vendor_performance.total_impressions
Conversions    
Total Vendor-Reported Orders Total number of orders, as reported by the Ad Platform. Note: There may be a discrepancy between Daasity and the marketing platform if you are NOT using the same attribution window. Total Vendor-Reported Orders will sometimes exceed the number of orders reported by your e-commerce platform. This is because multiple vendors may claim credit for the same order, so they may be double-counted.
vendor_performance.total_vendor_reported_orders
 
Total Vendor-Reported Revenue Total revenue, as reported by the Ad Platform. This amount is converted from your ad account currency into your Daasity account currency. Note: There may be a discrepancy between Daasity and the marketing platform if you are not using the same attribution window. Total Vendor-Reported Revenue will sometimes exceed the revenue amounts reported by your e-commerce platform. This is because multiple vendors may claim credit for the same order, so the revenue may be double-counted. Additionally, there may be a discrepancy in whether you are tracking 'Net Sales' or 'Gross Sales' via your vendor conversion pixel.
vendor_performance.total_vendor_reported_revenue
Cost Metrics  
 
Cost per 1,000 Impressions (CPM)
 
 
 
 
Average cost per 1,000 ad impressions. Calculated as Total Spend / (Total Impressions / 1,000).
vendor_performance.cpm
Cost per Click (CPC)
Average cost per ad click. Calculated as Total Spend / Total Clicks.
vendor_performance.cpc
Cost Per Order (CPO)
Average cost per order. Calculated as Total Spend / Total Vendor Reported Orders.
vendor_performance.cpo
Total Spend
Total amount spent on the ad platform. This amount is converted from your ad account currency into your Daasity account currency.
vendor_performance.total_spend
Return on Ad Spend (ROAS)
Return on Ad Spend, as reported by the ad platform. This is the ratio of revenue to spend. Calculated as Total Vendor Reported Revenue / Total Spend.
vendor_performance.roas
Video Views
 
 
Total Video Views
Total times users viewed a video ad.
vendor_performance.total_video_views
Total Video Views - 100%
Total times users viewed a video ad and reached the 100% duration mark.
vendor_performance.total_video_views_100
Total Video Views - 25%
Total times users viewed a video ad and reached the 25% duration mark.
vendor_performance.total_video_views_25
Total Video Views - 50%
Total times users viewed a video ad and reached the 50% duration mark.
vendor_performance.total_video_views_50
Total Video Views - 75%
Total times users viewed a video ad and reached the 75% duration mark.
vendor_performance.total_video_views_75