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
|