Docs
Blended Data Fields List
225 fields · 160 metrics · 65 dimensions
BigQuery
Looker Studio
Google Sheets
Power BI| Field Name | Label | Type | Description | Group |
|---|---|---|---|---|
| Blended Account6 fields | ||||
account_id |
Blended Account ID | Dimension | Unified account identifier across all connected advertising platforms. Use to segment performance by account. | Blended Account |
account_name |
Blended Account Name | Dimension | Display name of the advertising account. Combines account names from Meta Google LinkedIn and other platforms. | Blended Account |
data_source |
Blended Data source name | Metric | Name of the original data platform (Meta Ads Google Ads Shopify etc.). Use to filter by source. | Blended Account |
data_source_image |
Blended Data source image | Metric | Logo or icon of the data source platform for visual identification. | Blended Account |
data_source_image_url |
Blended Data source image url | Dimension | URL to the data source logo image. Use for custom branding in reports. | Blended Account |
data_source_type |
Blended Data source type | Dimension | Category of data source (Advertising Social Media E-commerce Analytics CRM). | Blended Account |
| Blended Account Performance1 fields | ||||
account_impressions |
Blended Account impressions | Dimension | Total impressions aggregated at the account level across all ad platforms. | Blended Account Performance |
| Blended Ad9 fields | ||||
ad_id |
Blended Ad ID | Dimension | Unified ad identifier across platforms. Maps to ad_id in Meta ad_id in Google Ads creative_id in LinkedIn. | Blended Ad |
ad_image |
Blended Ad Image | Dimension | Visual preview of the ad creative. Displays the primary image used in the advertisement. | Blended Ad |
ad_image_url |
Blended Ad Image URL | Dimension | Direct URL to the ad creative image. Use for custom visualizations or ad galleries. | Blended Ad |
ad_name |
Blended Ad Name | Dimension | Display name of the advertisement. Combined from ad names across all connected platforms. | Blended Ad |
ad_text |
Blended Ad Text | Dimension | Primary copy text of the advertisement. The main message shown to users. | Blended Ad |
adset_end_date |
Blended Ad Set End Date | Dimension | Scheduled end date for the ad set. Null if running continuously. | Blended Ad |
adset_id |
Blended Ad Set ID | Dimension | Unified ad set identifier. Maps to adset_id in Meta ad_group_id in Google Ads campaign_group_id in LinkedIn. | Blended Ad |
adset_name |
Blended Ad Set Name | Dimension | Display name of the ad set or ad group. Combines naming across platforms. | Blended Ad |
adset_start_date |
Blended Ad Set Start Date | Dimension | Date when the ad set started running. Use for lifecycle analysis. | Blended Ad |
| Blended Campaign3 fields | ||||
campaign_id |
Blended Campaign ID | Dimension | Unified campaign identifier across all advertising platforms. Primary key for campaign-level analysis. | Blended Campaign |
campaign_name |
Blended Campaign Name | Dimension | Display name of the marketing campaign. Combined from all connected ad platforms. | Blended Campaign |
campaign_objective |
Blended Campaign Objective | Dimension | Marketing objective of the campaign (Awareness Traffic Conversions etc.). Standardized across platforms. | Blended Campaign |
| Blended Conversions58 fields | ||||
acos |
Blended ACOS | Metric | Advertising Cost of Sale – ad spend divided by attributed revenue. Lower is better. Key metric for e-commerce profitability. | Blended Conversions |
average_orders_per_customer |
Blended Average Orders per Customer | Metric | Mean number of orders placed per unique customer. Indicates customer loyalty and repeat purchase behavior. | Blended Conversions |
blended_conversion_value_platform |
Blended conversion value (platform) | Metric | Total monetary value of conversions as reported by ad platforms (Meta Google LinkedIn). May differ from actual revenue. | Blended Conversions |
cac_payback_period |
Blended CAC: Payback Period | Metric | Number of months to recover customer acquisition cost based on average order value and purchase frequency. | Blended Conversions |
cogs_minus_refunds |
Blended COGS (Minus Refunds) | Metric | Cost of goods sold adjusted for refunded items. More accurate for profit calculations. | Blended Conversions |
conversions |
Blended Conversions | Metric | Total conversion events across all platforms. Definition varies by platform (purchases leads signups). | Blended Conversions |
cost_per_customer |
Blended Cost Per Customer | Metric | Average marketing cost to acquire or retain each customer. Total spend divided by total customers. | Blended Conversions |
cost_per_deal |
Blended Cost Per Deal | Metric | Average cost to generate a closed deal. Total ad spend divided by number of won deals (HubSpot). | Blended Conversions |
cost_per_lead |
Blended Cost Per Lead | Metric | Average cost to acquire a lead. Total ad spend divided by total leads generated. | Blended Conversions |
cost_per_mql |
Blended Cost MQL | Metric | Average cost to generate a Marketing Qualified Lead. Ad spend divided by MQL count. | Blended Conversions |
cost_per_order |
Blended Cost Per Order | Metric | Average advertising cost per order. Total ad spend divided by number of orders. | Blended Conversions |
cost_per_sql |
Blended Cost SQL | Metric | Average cost to generate a Sales Qualified Lead. Ad spend divided by SQL count. | Blended Conversions |
days_since_last_purchase |
Blended Days Since Last Purchase | Metric | Number of days since customer’s most recent order. Key metric for churn prediction. | Blended Conversions |
deal_id |
Blended Deal ID | Dimension | HubSpot deal identifier. Use to join with CRM data for B2B analysis. | Blended Conversions |
deal_is_closed |
Blended Deal Is Closed | Metric | Boolean indicating if the HubSpot deal has reached a closed state (won or lost). | Blended Conversions |
deal_is_closed_won |
Blended Deal Is Closed Won | Metric | Boolean indicating if the HubSpot deal was closed as won. Revenue-generating deals. | Blended Conversions |
deals_won |
Blended Deals Won | Metric | Count of HubSpot deals closed as won. Primary B2B conversion metric. | Blended Conversions |
discount_rate |
Blended Discount Rate | Metric | Average discount percentage applied to orders. Discounts divided by gross sales. | Blended Conversions |
event_count |
Blended Event Count | Metric | Total count of tracked events from Google Analytics 4. Includes all event types. | Blended Conversions |
ga4_user_conversion_rate_leads |
GA4 User Conversion Rate (Leads) | Metric | Percentage of GA4 users who converted to leads. Lead conversions divided by total users. | Blended Conversions |
gross_profit |
Blended Gross Profit | Metric | Gross sales minus cost of goods sold. Primary profitability metric before operating expenses. | Blended Conversions |
months_since_last_purchase |
Blended Months Since Last Purchase | Metric | Number of months since customer’s last order. Use for defining customer lifecycle stages. | Blended Conversions |
mql |
Blended MQL | Metric | Marketing Qualified Leads – leads that meet marketing qualification criteria. | Blended Conversions |
new_conversion_rate |
Blended New Conversion Rate | Metric | Percentage of new visitors who convert to customers. New customers divided by new sessions. | Blended Conversions |
new_customers |
Blended New Customers | Metric | Count of first-time purchasers in the selected period. | Blended Conversions |
new_customers_gross_profit |
Blended New Customers Gross Profit | Metric | Gross profit generated by new customers only. Revenue minus COGS for first orders. | Blended Conversions |
new_customers_orders |
Blended New Customers Orders | Metric | Number of orders from first-time customers. Each new customer’s first order. | Blended Conversions |
new_customers_ratio |
Blended New Customers % | Metric | Percentage of customers who are first-time buyers. New customers divided by total customers. | Blended Conversions |
nroas_shopify |
Blended nROAS (Shopify) | Metric | Net ROAS using Shopify net sales (after discounts and returns) divided by ad spend. | Blended Conversions |
order_rate |
Blended Order Rate | Metric | Percentage of sessions or users that result in an order. Orders divided by sessions. | Blended Conversions |
poas_ga4 |
Blended POAS (GA4) | Metric | Profit on Ad Spend using GA4 data. (Revenue – COGS) divided by ad spend. | Blended Conversions |
poas_shopify |
Blended POAS (Shopify) | Metric | Profit on Ad Spend using Shopify data. Gross profit divided by ad spend. | Blended Conversions |
purchase_frequency |
Blended Purchase Frequency | Metric | Average number of purchases per customer over their lifetime. Orders divided by unique customers. | Blended Conversions |
repeat_conversion_rate |
Blended Repeat Conversion Rate | Metric | Percentage of returning visitors who make another purchase. | Blended Conversions |
return_rate |
Blended Return Rate | Metric | Percentage of orders that were returned. Returns divided by total orders. | Blended Conversions |
returning_customers |
Blended Returning Customers | Metric | Customers who have made 2+ purchases historically. | Blended Conversions |
returning_customers_gross_profit |
Blended Repeat Customers Gross Profit | Metric | Gross profit from repeat customer orders only. | Blended Conversions |
returning_customers_orders |
Blended Repeat Customers Orders | Metric | Number of orders from customers with prior purchase history. | Blended Conversions |
returning_customers_ratio |
Blended Repeat Customers % | Metric | Percentage of customers who are repeat buyers. Returning divided by total. | Blended Conversions |
session_conversion_rate_customers |
Session Conversion Rate (Customers) | Metric | Percentage of sessions resulting in a customer conversion. | Blended Conversions |
session_conversion_rate_ga4 |
GA4 Session Conversion Rate | Metric | Overall session conversion rate from Google Analytics 4. | Blended Conversions |
session_conversion_rate_leads_ga4 |
GA4 Session Conversion Rate (Leads) | Metric | Percentage of GA4 sessions that generated a lead. | Blended Conversions |
session_conversion_rate_mqls |
Session Conversion Rate (MQLs) | Metric | Percentage of sessions resulting in a Marketing Qualified Lead. | Blended Conversions |
session_conversion_rate_orders |
Session Conversion Rate (Orders) | Metric | Percentage of sessions resulting in a completed order. | Blended Conversions |
session_conversion_rate_sqls |
Session Conversion Rate (SQLs) | Metric | Percentage of sessions resulting in a Sales Qualified Lead. | Blended Conversions |
session_conversion_rate_won |
Session Conversion Rate (Won) | Metric | Percentage of sessions associated with closed-won deals. | Blended Conversions |
sku |
Blended SKU | Metric | Stock Keeping Unit – unique product variant identifier. | Blended Conversions |
sku_sold |
Blended SKU Sold | Metric | Quantity of specific SKU units sold. | Blended Conversions |
sql |
Blended SQL | Metric | Sales Qualified Leads – leads approved by sales team for outreach. | Blended Conversions |
total_deals |
Blended Total Deals | Metric | Total number of HubSpot deals (all stages). | Blended Conversions |
user_conversion_rate_customers_shopify |
User conversion rate (Shopify customers) GA4 | Metric | GA4 users who became Shopify customers as percentage. | Blended Conversions |
user_conversion_rate_mqls |
User Conversion Rate (MQLs) | Metric | Percentage of users who became Marketing Qualified Leads. | Blended Conversions |
user_conversion_rate_new_customers_shopify |
User converion rate (New Shopify customers) GA4 | Metric | GA4 users who became new Shopify customers as percentage. | Blended Conversions |
user_conversion_rate_orders |
User Conversion Rate (Orders) GA4 | Metric | Percentage of GA4 users who completed an order. | Blended Conversions |
user_conversion_rate_sqls |
User Conversion Rate (SQLs) | Metric | Percentage of users who became Sales Qualified Leads. | Blended Conversions |
user_conversion_rate_won |
User Conversion Rate (Won) | Metric | Percentage of users associated with closed-won deals. | Blended Conversions |
weeks_since_last_purchase |
Blended Weeks Since Last Purchase | Metric | Weeks elapsed since customer’s most recent order. | Blended Conversions |
win_rate |
Blended Win Rate | Metric | Percentage of deals closed as won. Won deals divided by total closed deals. | Blended Conversions |
| Blended Customer10 fields | ||||
add_to_carts |
Blended Add to Carts | Metric | Total add-to-cart events across all platforms. Combines Shopify Meta Pixel and GA4 add_to_cart events. | Blended Customer |
checkouts |
Blended Checkouts | Metric | Total checkout initiations across all platforms. Users who started but may not have completed purchase. | Blended Customer |
customer_email |
Blended Customer Email | Metric | Email address of the customer. Primary identifier for customer-level analysis and matching. | Blended Customer |
customer_first_name |
Blended Customer First Name | Dimension | First name of the customer. Use for personalization analysis. | Blended Customer |
customer_id |
Blended Customer ID | Dimension | Unified customer identifier across e-commerce platforms (Shopify WooCommerce). | Blended Customer |
customer_last_name |
Blended Customer Last Name | Dimension | Last name of the customer. Combined with first name for full identification. | Blended Customer |
customer_orders_count |
Blended Customer Orders Count | Metric | Total number of orders placed by the customer historically. Indicates customer value tier. | Blended Customer |
customer_retention_rate |
Blended Customer Retention Rate | Metric | Percentage of customers who made repeat purchases within a defined period. | Blended Customer |
customer_type |
Blended Customer Type | Dimension | Classification of customer (New Returning VIP etc.) based on purchase history. | Blended Customer |
total_customers |
Blended Total Customers | Metric | Total unique customers across all e-commerce data sources. | Blended Customer |
| Blended Customers2 fields | ||||
blended_new_customers |
Blended New Customers | Metric | Count of first-time purchasers attributed to marketing. Customers with no prior order history. | Blended Customers |
blended_returning_customers |
Blended Returning Customers | Metric | Count of repeat purchasers. Customers who have made 2 or more orders historically. | Blended Customers |
| Blended Demographics7 fields | ||||
age |
Blended Age | Dimension | Age demographic of the audience. Standardized age ranges across platforms (18-24 25-34 etc.). | Blended Demographics |
device |
Blended Device | Dimension | Device type used (Desktop Mobile Tablet). Standardized across all platforms. | Blended Demographics |
device_icon |
Blended Device Icon | Dimension | Device type emoji icon for visual display ( ). | Blended Demographics |
device_icon_url |
Blended Device Icon Url | Dimension | URL to device icon image for custom visualizations. | Blended Demographics |
gender |
Blended Gender | Dimension | Gender demographic dimension. Standardized as Male Female or Unknown across platforms. | Blended Demographics |
gender_icon |
Blended Gender Icon | Dimension | Gender emoji icon for visual display (️ ️). | Blended Demographics |
gender_icon_url |
Blended Gender Icon Url | Dimension | URL to gender icon image for custom visualizations. | Blended Demographics |
| Blended Geo5 fields | ||||
city |
Blended City | Dimension | City-level geographic dimension. Location of the user or customer. | Blended Geo |
country |
Blended Country | Dimension | Country-level geographic dimension. ISO country of the user or customer. | Blended Geo |
country_icon |
Blended Country Icon | Dimension | Country flag emoji for visual display in dashboards and reports. | Blended Geo |
country_icon_url |
Blended Country Icon Url | Dimension | URL to country flag image for custom visualizations. | Blended Geo |
region |
Blended Region | Dimension | State province or region geographic dimension. | Blended Geo |
| Blended Lead4 fields | ||||
lead_company_name |
Blended Lead Company Name | Dimension | Company name associated with the lead. Important for B2B lead qualification. | Blended Lead |
lead_email |
Blended Lead Email | Metric | Email address of the lead. Primary identifier for lead tracking and nurturing. | Blended Lead |
lead_id |
Blended Lead ID | Dimension | Unified lead identifier from CRM or marketing automation platforms. | Blended Lead |
lead_name |
Blended Lead Name | Dimension | Full name of the lead contact. Combined first and last name. | Blended Lead |
| Blended Page10 fields | ||||
organic_reach |
Blended Organic reach | Metric | Number of unique users who saw organic (non-paid) social content. | Blended Page |
page_likes |
Blended Page likes | Metric | Total likes on social media business pages (Facebook LinkedIn). | Blended Page |
page_new_followers |
Blended Page new followers | Metric | New followers gained on social media pages in the period. | Blended Page |
page_new_likes |
Blended Page new likes | Metric | New page likes gained in the period. Net of unlikes. | Blended Page |
page_new_unfollows |
Blended Page new unfollows | Metric | Number of users who unfollowed the page in the period. | Blended Page |
page_total_followers |
Blended Page total followers | Metric | Total current follower count across social media pages. | Blended Page |
page_total_impressions |
Blended Page total impressions | Metric | Total impressions on page content including organic and paid. | Blended Page |
page_unlikes |
Blended Page unlikes | Metric | Number of page unlikes in the period. Users who removed their like. | Blended Page |
page_views |
Blended Page views | Metric | Website page view events from Google Analytics 4. | Blended Page |
total_reach |
Blended Total reach | Metric | Total unique users reached across all content (organic and paid). | Blended Page |
| Blended Post Details12 fields | ||||
post_caption |
Blended Post Caption | Metric | Caption text of organic social media posts. The written content accompanying media. | Blended Post Details |
post_creation_date |
Blended Post Creation Date | Dimension | Date and time when the social post was published. | Blended Post Details |
post_description |
Blended Post Description | Dimension | Extended description or body text of the social media post. | Blended Post Details |
post_id |
Blended Post ID | Dimension | Unique identifier for the social media post across platforms. | Blended Post Details |
post_image |
Blended Post image | Metric | Visual preview of the post media. Primary image or video thumbnail. | Blended Post Details |
post_image_url |
Blended Post image URL | Dimension | Direct URL to post media for embedding or custom displays. | Blended Post Details |
post_name |
Blended Post name | Dimension | Title or name assigned to the social media post. | Blended Post Details |
post_source |
Blended Post source | Metric | Platform where the post originated (Instagram Facebook LinkedIn TikTok). | Blended Post Details |
post_text |
Blended Post text | Dimension | Full text content of the social media post. | Blended Post Details |
post_type |
Blended Post type | Dimension | Content format of the post (Image Video Carousel Story Reel). | Blended Post Details |
post_url |
Blended Post URL | Dimension | Permanent link to the social media post. | Blended Post Details |
video_asset |
Blended Video Asset | Metric | Video creative asset used in the post or ad. | Blended Post Details |
| Blended Post Performance26 fields | ||||
ads_impressions |
Blended Ads impressions | Metric | Total paid ad impressions across all advertising platforms (Meta Google LinkedIn TikTok etc.). | Blended Post Performance |
amount_spent |
Blended Ad Spend | Metric | Total advertising spend across all connected ad platforms in your account currency. The primary cost metric. | Blended Post Performance |
app_installs |
Blended App Installs | Metric | Total mobile app installations attributed to advertising across all platforms. | Blended Post Performance |
blended_cpe |
Blended CPE | Metric | Cost Per Engagement – total ad spend divided by total engagements. Measures efficiency of engagement-focused campaigns. | Blended Post Performance |
clicks |
Blended Clicks | Metric | Total clicks across all advertising platforms. Includes link clicks and CTA clicks. | Blended Post Performance |
cpc |
Blended CPC | Metric | Cost Per Click – total ad spend divided by total clicks. Key efficiency metric for traffic campaigns. | Blended Post Performance |
cpm |
Blended CPM | Metric | Cost Per Mille – cost per 1000 impressions. Standard metric for awareness and reach campaigns. | Blended Post Performance |
ctr |
Blended CTR | Metric | Click-Through Rate – clicks divided by impressions as a percentage. Measures ad relevance and appeal. | Blended Post Performance |
landing_page_views |
Blended Landing Page Views | Metric | Count of landing page view events from advertising platforms. Users who reached the destination. | Blended Post Performance |
leads |
Blended Leads | Metric | Total lead form submissions and lead events across all platforms. | Blended Post Performance |
link_clicks |
Blended Link Clicks | Dimension | Clicks specifically on links within ads. More precise than total clicks for traffic analysis. | Blended Post Performance |
mobile_app_install |
Blended Mobile App Install | Metric | App installation events tracked across advertising platforms. | Blended Post Performance |
offline_custom_conversions |
Blended Offline Custom Conversions | Metric | Custom conversion events uploaded via offline conversion tracking (Meta). | Blended Post Performance |
offline_registration_complete |
Blended Offline Registration Complete | Metric | Offline registration events uploaded to ad platforms. | Blended Post Performance |
post_comments |
Blended Post comments | Metric | Total comments on social media posts across platforms. | Blended Post Performance |
post_engagement |
Blended Post engagement | Metric | Total engagements on posts (likes comments shares saves). Primary organic metric. | Blended Post Performance |
post_engagement_rate |
Blended Post engagement rate | Metric | Engagements divided by impressions as percentage. Measures content resonance. | Blended Post Performance |
post_impressions |
Blended Post impressions | Metric | Number of times social posts were displayed to users. | Blended Post Performance |
post_likes |
Blended Post likes | Metric | Total likes or reactions on social media posts. | Blended Post Performance |
post_reach |
Blended Post reach | Metric | Unique users who saw the social media post. Deduplicated count. | Blended Post Performance |
post_reactions |
Blended Post reactions | Metric | Total reactions on posts (Facebook reactions beyond likes). | Blended Post Performance |
post_saves |
Blended Post saves | Metric | Number of times users saved the post (Instagram bookmarks). | Blended Post Performance |
post_shares |
Blended Post shares | Metric | Number of times the post was shared or reposted. | Blended Post Performance |
social_media_impressions |
Blended Social Media Impressions | Metric | Total impressions across all social media platforms combined. | Blended Post Performance |
tk_engagement |
Blended Tiktok Post engagement | Metric | Total engagements specifically from TikTok content. | Blended Post Performance |
video_plays |
Blended Video Views | Metric | Total video view events across all platforms. Includes 3-second views. | Blended Post Performance |
| Blended Product9 fields | ||||
cac |
Blended CAC | Metric | Customer Acquisition Cost – total ad spend divided by number of new customers acquired. Key profitability metric. | Blended Product |
cost_of_goods_sold |
Blended COGS | Metric | Total cost of goods sold for products. Required for accurate profit and margin calculations. | Blended Product |
product_description |
Blended Product Description | Dimension | Description text of the product from e-commerce platform. | Blended Product |
product_id |
Blended Product ID | Dimension | Unique product identifier from e-commerce platform. | Blended Product |
product_image |
Blended Product Image | Metric | Primary product image for display in reports. | Blended Product |
product_image_url |
Blended Product Image URL | Dimension | Direct URL to product image. Use for custom visualizations. | Blended Product |
product_name |
Blended Product Name | Dimension | Display name of the product. Title shown to customers. | Blended Product |
product_price |
Blended Product Price | Metric | Listed price of the product before discounts. | Blended Product |
product_type |
Blended Product Type | Dimension | Product category or type classification. | Blended Product |
| Blended Revenue19 fields | ||||
average_order_value |
Blended Average Order Value | Metric | Average revenue per order (total revenue / number of orders). Key metric for e-commerce optimization. | Blended Revenue |
blended_roas_ga4 |
ROAS (GA4) | Metric | Return on Ad Spend using Google Analytics 4 revenue data. GA4 revenue divided by total ad spend. | Blended Revenue |
blended_roas_hubspot |
ROAS (HubSpot) | Metric | Return on Ad Spend using HubSpot closed-won deal values. Deal revenue divided by total ad spend. | Blended Revenue |
blended_roas_platform |
ROAS (Platform) | Metric | Return on Ad Spend using platform-reported conversion values. Platform revenue divided by ad spend. | Blended Revenue |
blended_roas_shopify |
ROAS (Shopify) | Metric | Return on Ad Spend using Shopify sales data. Shopify revenue divided by total ad spend. Most accurate for e-commerce. | Blended Revenue |
conversion_value_ga4 |
Blended Conversions Value (GA4) | Metric | Total conversion value tracked by Google Analytics 4. Includes all configured conversion events. | Blended Revenue |
discounts |
Blended Discounts | Metric | Total discount amount applied across all orders. Reduces gross sales to net sales. | Blended Revenue |
gross_sales |
Blended Gross Sales | Metric | Total sales revenue before discounts refunds and returns. Top-line revenue metric. | Blended Revenue |
landing_page_url |
Blended Landing Page URL | Dimension | URL of the page where users land after clicking an ad. Key for conversion optimization. | Blended Revenue |
mer |
Blended MER | Metric | Marketing Efficiency Ratio – total revenue divided by total marketing spend. Higher is better. | Blended Revenue |
net_sales |
Blended Net Sales | Metric | Gross sales minus discounts and returns. Actual revenue received from customers. | Blended Revenue |
number_of_sold_items |
Blended Number of Sold Items | Metric | Total quantity of items sold across all orders. Sum of line item quantities. | Blended Revenue |
order_id |
Blended Order ID | Dimension | Unique order identifier from e-commerce platform (Shopify WooCommerce). | Blended Revenue |
order_shipping_city |
Blended Order Shipping City | Metric | City for order delivery. Shipping destination of the customer. | Blended Revenue |
order_shipping_country |
Blended Order Shipping Country | Metric | Country for order delivery. Used for geographic revenue analysis. | Blended Revenue |
orders |
Blended Orders | Metric | Total number of completed orders across e-commerce platforms. Primary conversion metric. | Blended Revenue |
returns |
Blended Returns | Metric | Total value of returned orders. Reduces net sales. | Blended Revenue |
sales |
Blended Total Sales | Metric | Total revenue from all sales. Primary top-line metric combining all revenue sources. | Blended Revenue |
tax |
Blended Tax | Metric | Tax amount collected on orders. Separate from product revenue. | Blended Revenue |
| Blended Time9 fields | ||||
date |
Blended Date | Dimension | Standard date dimension for time-series analysis. Use as primary date field for all blended metrics. | Blended Time |
day_of_week |
Blended Day Of Week | Metric | Day of the week (Monday-Sunday). Analyze performance patterns by weekday. | Blended Time |
hour |
Blended Hour | Metric | Hour of the day (0-23). Analyze performance by time of day for optimization. | Blended Time |
month |
Blended Month | Metric | Month of the year (January-December or 1-12). Use for monthly trending analysis. | Blended Time |
quarter |
Blended Quarter | Metric | Calendar quarter (Q1 Q2 Q3 Q4). Use for quarterly business reporting. | Blended Time |
week |
Blended Week | Metric | Week number of the year (1-52). Use for weekly trending. | Blended Time |
year |
Blended Year Week | Metric | Year combined with week number (2024-W01). | Blended Time |
year_month |
Blended Year Month | Metric | Year and month combination (2024-01). Standard monthly grouping. | Blended Time |
year_week_dates |
Blended Week (Dates) | Metric | Week displayed as date range (2024-01-01 to 2024-01-07). | Blended Time |
| Blended Traffic Source11 fields | ||||
first_user_campaign |
Blended First User Campaign | Metric | The campaign that first acquired this user (GA4 first-touch attribution). | Blended Traffic Source |
first_user_default_channel_group |
Blended First User Default Channel Group | Metric | GA4 default channel grouping for first user acquisition (Paid Search Organic Social etc.). | Blended Traffic Source |
first_user_google_ads_account_name |
Blended First User Google Ads Account Name | Dimension | Google Ads account that first acquired this user. | Blended Traffic Source |
first_user_google_ads_campaign |
Blended First User Google Ads Campaign | Metric | Google Ads campaign that first acquired this user. | Blended Traffic Source |
first_user_manual_term |
Blended First User Manual Term | Metric | Manual UTM term parameter from first user acquisition. | Blended Traffic Source |
first_user_source |
Blended First User Source | Metric | Traffic source that first acquired this user (google facebook instagram etc.). | Blended Traffic Source |
session_campaign |
Blended Session Campaign | Metric | Marketing campaign associated with the session (GA4 session attribution). | Blended Traffic Source |
session_google_ads_campaign |
Blended Session Google Ads Campaign | Metric | Google Ads campaign attributed to the GA4 session. | Blended Traffic Source |
session_medium |
Blended Session Medium | Metric | Traffic medium for the session (cpc organic email referral). | Blended Traffic Source |
session_source |
Blended Session Source | Metric | Traffic source for the session (google facebook instagram). | Blended Traffic Source |
sessions |
Blended Sessions | Metric | Total website sessions from Google Analytics 4. Primary traffic metric. | Blended Traffic Source |
| Blended UTM5 fields | ||||
utm_campaign |
Blended UTM Campaign | Dimension | UTM campaign parameter from tracked URLs. Use for campaign attribution. | Blended UTM |
utm_content |
Blended UTM Content | Dimension | UTM content parameter. Typically identifies specific ad or link variant. | Blended UTM |
utm_medium |
Blended UTM Medium | Dimension | UTM medium parameter (cpc email social banner). | Blended UTM |
utm_source |
Blended UTM Source | Dimension | UTM source parameter (google facebook newsletter). | Blended UTM |
utm_term |
Blended UTM Term | Dimension | UTM term parameter. Often contains keyword or targeting info. | Blended UTM |
| Blended Video9 fields | ||||
reels_comments |
Blended Reels comments | Metric | Comments on Instagram or Facebook Reels short-form videos. | Blended Video |
reels_likes |
Blended Reels likes | Metric | Likes on Instagram or Facebook Reels content. | Blended Video |
reels_plays |
Blended Reels plays | Metric | Number of times Reels were played. Primary reach metric for short video. | Blended Video |
reels_shares |
Blended Reels shares | Metric | Number of times Reels were shared to stories or DMs. | Blended Video |
video_id |
Blended Video ID | Dimension | Unique identifier for video content across platforms. | Blended Video |
video_picture |
Blended Video picture | Metric | Thumbnail image of the video content. | Blended Video |
video_picture_url |
Blended Video picture URL | Dimension | Direct URL to video thumbnail image. | Blended Video |
video_reactions_like |
Blended Video reactions: like | Metric | Likes specifically on video content. | Blended Video |
video_title |
Blended Video title | Dimension | Title or caption of the video content. | Blended Video |
| Porter10 fields | ||||
blended_post_count |
Blended Post Count | Metric | Total number of organic social media posts across connected platforms (Instagram Facebook LinkedIn TikTok). | Porter |
data_source_account_names |
Porter Data source account name | Dimension | List of all account names connected to Porter for this data source. | Porter |
data_source_account_owner |
Porter account owner | Metric | Email of the user who connected this data source to Porter. | Porter |
data_source_fields_documentation |
Porter field documentation | Metric | Link to documentation for fields available in this data source. | Porter |
data_source_fields_source_account_owner |
Porter Data Source Account Owner | Metric | Owner email for the specific account providing this field data. | Porter |
data_source_license_next_renewal_date |
Porter license next renewal date | Dimension | Date when the Porter subscription renews for this data source. | Porter |
data_source_license_owner |
Porter license owner | Metric | Email of the Porter license holder for this connection. | Porter |
data_sources_and_accounts |
Porter Field metadata: data sources and accounts | Metric | JSON metadata listing all sources and accounts contributing to this blended field. | Porter |
data_sources_included |
Porter Field metadata: data sources included | Metric | List of data source types included in this blended metric calculation. | Porter |
today_date_field |
Porter Today | Metric | Current date field for real-time filtering and comparisons. | Porter |
