LupyAi
Log in Start free

Data fields reference

Every field id you can pass to fields= in the API, Looker Studio, exports and AI chats. Shared ids line up across sources so they blend.

All sources Meta Ads (Facebook & Instagram)Google AdsTikTok AdsLinkedIn AdsGoogle Analytics 4Google Search ConsoleFacebook Pages (organic)Instagram (organic)YouTube AnalyticsShopifyWooCommerceKlaviyo
Field idNameKindTypeSourcesDescription
account_id Account ID dimension string 12 sources
account_name Account name dimension string 12 sources
datasource Data source dimension string 12 sources Connector the row came from
date Date dimension date 12 sources Day the row applies to
conversions Conversions metric float 8 sources Each source's main conversion: purchases, key events, orders, website conversions
revenue Revenue / conversion value metric currency 8 sources Purchase value, conversion value or order totals, depending on source
campaign Campaign name dimension string 6 sources
campaign_id Campaign ID dimension string 5 sources
clicks Clicks metric integer 5 sources Clicks for the selected dimensions
comments Comments metric integer 5 sources
country Country dimension string 5 sources
impressions Impressions metric integer 5 sources
ctr CTR (%) metric percent Meta Ads (Facebook & Instagram), Google Ads, TikTok Ads, Google Search Console Clicks ÷ impressions × 100
likes Likes metric integer TikTok Ads, LinkedIn Ads, Instagram (organic), YouTube Analytics
reach Reach metric integer Meta Ads (Facebook & Instagram), TikTok Ads, Facebook Pages (organic), Instagram (organic) Unique people reached (not summable across days)
shares Shares metric integer TikTok Ads, LinkedIn Ads, Facebook Pages (organic), YouTube Analytics
spend Spend / cost metric currency Meta Ads (Facebook & Instagram), Google Ads, TikTok Ads, LinkedIn Ads Money spent on ads, in the account currency
ad_id Ad ID dimension string Meta Ads (Facebook & Instagram), Google Ads, TikTok Ads
cpm CPM metric currency Meta Ads (Facebook & Instagram), Google Ads, TikTok Ads
orders Orders metric integer Shopify, WooCommerce, Klaviyo
ad_name Ad name dimension string Meta Ads (Facebook & Instagram), TikTok Ads
ad_status Ad status dimension string Meta Ads (Facebook & Instagram), Google Ads Effective status now
campaign_status Campaign status dimension string Meta Ads (Facebook & Instagram), Google Ads Effective status now (ACTIVE, PAUSED, ...)
cpc CPC metric currency Meta Ads (Facebook & Instagram), TikTok Ads
currency Currency dimension string Shopify, WooCommerce
customer_id Customer ID dimension string Shopify, WooCommerce
device Device dimension string Google Ads, Google Search Console
discounts Discounts metric currency Shopify, WooCommerce
follows Follows metric integer TikTok Ads, LinkedIn Ads
items_sold Items sold metric integer Shopify, WooCommerce
leads Leads metric float Meta Ads (Facebook & Instagram), LinkedIn Ads
net_revenue Net sales (total - refunded) metric currency Shopify, WooCommerce
objective Campaign objective dimension string Meta Ads (Facebook & Instagram), TikTok Ads
order_id Order ID dimension string Shopify, WooCommerce
page_views Views metric integer Google Analytics 4, Facebook Pages (organic)
post_id Post ID dimension string Facebook Pages (organic), Instagram (organic)
post_url Post URL dimension string Facebook Pages (organic), Instagram (organic)
posts Posts metric integer Facebook Pages (organic), Instagram (organic)
refunds Refunded metric currency Shopify, WooCommerce
region Region dimension string Meta Ads (Facebook & Instagram), Google Analytics 4
shipping Shipping metric currency Shopify, WooCommerce
tax Tax metric currency Shopify, WooCommerce
video_views Video views metric integer TikTok Ads, LinkedIn Ads
absolute_top_impression_pct Absolute top of page rate (%) metric percent Google Ads
active_users Active users metric integer Google Analytics 4
ad_final_url Final URL dimension string Google Ads
ad_group Ad group name dimension string Google Ads
ad_group_id Ad group ID dimension string Google Ads
ad_group_status Ad group status dimension string Google Ads
ad_type Ad type dimension string Google Ads
add_payment_info Payment info added metric float Meta Ads (Facebook & Instagram)
add_to_cart Adds to cart metric float Meta Ads (Facebook & Instagram)
add_to_cart_value Adds to cart value metric currency Meta Ads (Facebook & Instagram)
add_to_carts Add to carts metric integer Google Analytics 4
adgroup_id Ad group ID dimension string TikTok Ads
adgroup_name Ad group name dimension string TikTok Ads
adset_billing_event Ad set billing event dimension string Meta Ads (Facebook & Instagram)
adset_daily_budget Ad set daily budget metric currency Meta Ads (Facebook & Instagram)
adset_id Ad set ID dimension string Meta Ads (Facebook & Instagram)
adset_lifetime_budget Ad set lifetime budget metric currency Meta Ads (Facebook & Instagram)
adset_name Ad set name dimension string Meta Ads (Facebook & Instagram)
adset_optimization_goal Ad set optimisation goal dimension string Meta Ads (Facebook & Instagram)
adset_status Ad set status dimension string Meta Ads (Facebook & Instagram) Effective status now
age Age bracket dimension string Meta Ads (Facebook & Instagram)
all_conversions All conversions metric float Google Ads
all_conversions_value All conversions value metric currency Google Ads
average_cpc Avg. CPC metric currency Google Ads
average_session_duration Avg. session duration (s) metric float Google Analytics 4
average_view_duration Avg. view duration (s) metric float YouTube Analytics
bounce_rate Bounce rate metric percent Google Analytics 4
bounced Bounced metric integer Klaviyo
browser Browser dimension string Google Analytics 4
campaign_bid_strategy Campaign bid strategy dimension string Meta Ads (Facebook & Instagram)
campaign_bidding_strategy Bid strategy dimension string Google Ads
campaign_budget Campaign budget (daily) metric currency Google Ads
campaign_daily_budget Campaign daily budget metric currency Meta Ads (Facebook & Instagram) Current daily budget
campaign_group Campaign group name dimension string LinkedIn Ads
campaign_group_id Campaign group ID dimension string LinkedIn Ads
campaign_lifetime_budget Campaign lifetime budget metric currency Meta Ads (Facebook & Instagram)
campaign_type Campaign type dimension string Google Ads
caption Caption dimension string Instagram (organic)
checkouts Checkouts metric integer Google Analytics 4
city City dimension string Google Analytics 4
click_rate Click rate (%) metric percent Klaviyo
clicks_unique Unique clicks metric integer Klaviyo
complete_registration Registrations completed metric float Meta Ads (Facebook & Instagram)
conversion_action Conversion action dimension string Google Ads Use with conversion metrics only
conversion_rate_ranking Conversion rate ranking dimension string Meta Ads (Facebook & Instagram)
conversion_value Attributed revenue metric currency Klaviyo
cost_per_add_to_cart Cost per add to cart metric currency Meta Ads (Facebook & Instagram)
cost_per_landing_page_view Cost per landing page view metric currency Meta Ads (Facebook & Instagram)
cost_per_lead Cost per lead metric currency Meta Ads (Facebook & Instagram)
cost_per_outbound_click Cost per outbound click metric currency Meta Ads (Facebook & Instagram)
cost_per_thruplay Cost per ThruPlay metric currency Meta Ads (Facebook & Instagram)
creative_body Ad primary text dimension string Meta Ads (Facebook & Instagram)
creative_cta Call to action dimension string Meta Ads (Facebook & Instagram)
creative_id Creative ID dimension string LinkedIn Ads
creative_thumbnail_url Ad thumbnail URL dimension string Meta Ads (Facebook & Instagram)
creative_title Ad headline dimension string Meta Ads (Facebook & Instagram)
default_channel_group Default channel group dimension string Google Analytics 4
delivered Delivered metric integer Klaviyo
device_category Device category dimension string Google Analytics 4
device_platform Device platform dimension string Meta Ads (Facebook & Instagram)
device_type Device type dimension string YouTube Analytics
ecommerce_purchases E-commerce purchases metric integer Google Analytics 4
emails_clicked Emails clicked metric integer Klaviyo
emails_opened Emails opened metric integer Klaviyo
emails_received Emails received metric integer Klaviyo
engaged_sessions Engaged sessions metric integer Google Analytics 4
engagement_rate Engagement rate metric percent Google Analytics 4
engagement_rate_ranking Engagement rate ranking dimension string Meta Ads (Facebook & Instagram)
engagements Post engagements metric integer Facebook Pages (organic)
event_count Event count metric integer Google Analytics 4
event_name Event name dimension string Google Analytics 4
financial_status Financial status dimension string Shopify
first_user_campaign First user campaign dimension string Google Analytics 4
first_user_channel_group First user channel group dimension string Google Analytics 4 How users first found you
first_user_medium First user medium dimension string Google Analytics 4
first_user_source First user source dimension string Google Analytics 4
followers Followers (current) metric integer Instagram (organic)
frequency Frequency metric float Meta Ads (Facebook & Instagram)
fulfillment_status Fulfillment status dimension string Shopify
gender Gender dimension string Meta Ads (Facebook & Instagram)
hostname Hostname dimension string Google Analytics 4
impression_device Impression device dimension string Meta Ads (Facebook & Instagram)
initiate_checkout Checkouts initiated metric float Meta Ads (Facebook & Instagram)
initiate_checkout_value Checkouts initiated value metric currency Meta Ads (Facebook & Instagram)
interactions Interactions metric integer Google Ads
item_brand Item brand dimension string Google Analytics 4
item_category Item category dimension string Google Analytics 4
item_name Item name dimension string Google Analytics 4 E-commerce: use with item metrics
item_revenue Item revenue metric currency Google Analytics 4
items_purchased Items purchased metric integer Google Analytics 4
items_viewed Items viewed metric integer Google Analytics 4
keyword Keyword dimension string Google Ads
keyword_id Keyword ID dimension string Google Ads Needed to update or remove a keyword with a write action.
keyword_match_type Match type dimension string Google Ads
keyword_status Keyword status dimension string Google Ads
landing_page Landing page dimension string Google Analytics 4
landing_page_clicks Landing page clicks metric integer LinkedIn Ads
landing_page_views Landing page views metric float Meta Ads (Facebook & Instagram)
language Language dimension string Google Analytics 4
link_clicks Link clicks metric integer Meta Ads (Facebook & Instagram)
media_type Media type dimension string Instagram (organic)
medium Session medium dimension string Google Analytics 4
messaging_conversations Messaging conversations started metric float Meta Ads (Facebook & Instagram)
network Ad network type dimension string Google Ads
new_followers New followers metric integer Instagram (organic) Daily follower gains; Instagram only returns the last 30 days
new_follows New follows metric integer Facebook Pages (organic)
new_users New users metric integer Google Analytics 4
new_vs_returning New vs returning dimension string Google Analytics 4
open_rate Open rate (%) metric percent Klaviyo
opens_unique Unique opens metric integer Klaviyo
operating_system Operating system dimension string Google Analytics 4
order_name Order number dimension string Shopify
order_status Order status dimension string WooCommerce
outbound_clicks Outbound clicks metric integer Meta Ads (Facebook & Instagram) Clicks that leave Meta
page Page URL dimension string Google Search Console
page_engagement Page engagement metric float Meta Ads (Facebook & Instagram)
page_path Page path dimension string Google Analytics 4
page_title Page title dimension string Google Analytics 4
payment_method Payment method dimension string WooCommerce
platform_position Placement (feed, stories, reels...) dimension string Meta Ads (Facebook & Instagram)
position Average position metric float Google Search Console
post_engagement Post engagement metric float Meta Ads (Facebook & Instagram)
post_message Post text dimension string Facebook Pages (organic)
publisher_platform Platform (facebook/instagram/...) dimension string Meta Ads (Facebook & Instagram)
purchase_revenue Purchase revenue metric currency Google Analytics 4
purchases Complete payments metric float TikTok Ads
quality_ranking Quality ranking dimension string Meta Ads (Facebook & Instagram)
quality_score Quality score metric integer Google Ads 1–10, from Google Ads
query Search query dimension string Google Search Console
reactions Reactions (posts) metric integer Facebook Pages (organic)
recipients Recipients metric integer Klaviyo
sales_channel Sales channel dimension string Shopify
search_appearance Search appearance dimension string Google Search Console
search_budget_lost_is Search IS lost to budget (%) metric percent Google Ads
search_impression_share Search impression share (%) metric percent Google Ads
search_rank_lost_is Search IS lost to rank (%) metric percent Google Ads
search_term Search term dimension string Google Ads What people actually searched
search_term_status Search term status dimension string Google Ads ADDED, EXCLUDED, NONE…
send_channel Channel (email/sms) dimension string Klaviyo
sessions Sessions metric integer Google Analytics 4
sessions_per_user Sessions per user metric float Google Analytics 4
source Session source dimension string Google Analytics 4
source_medium Session source / medium dimension string Google Analytics 4
subscribers_gained Subscribers gained metric integer YouTube Analytics
subscribers_lost Subscribers lost metric integer YouTube Analytics
subtotal Subtotal metric currency Shopify
thruplays ThruPlays metric float Meta Ads (Facebook & Instagram) Played to completion or for 15s+
top_impression_pct Top of page rate (%) metric percent Google Ads
total_purchasers Purchasers metric integer Google Analytics 4
total_users Total users metric integer Google Analytics 4
traffic_source Traffic source type dimension string YouTube Analytics
transactions Transactions metric integer Google Analytics 4
unfollows Unfollows metric integer Facebook Pages (organic)
unique_clicks Unique clicks metric integer Meta Ads (Facebook & Instagram)
unsubscribes Unsubscribes metric integer Klaviyo
user_engagement_duration Engagement time (s) metric float Google Analytics 4 Total seconds users were engaged
video_3s_views 3-second video views metric float Meta Ads (Facebook & Instagram)
video_completions Video completions metric integer TikTok Ads
video_id Video ID dimension string YouTube Analytics
video_p100 Video watched 100% metric float Meta Ads (Facebook & Instagram)
video_p25 Video watched 25% metric float Meta Ads (Facebook & Instagram)
video_p50 Video watched 50% metric float Meta Ads (Facebook & Instagram)
video_p75 Video watched 75% metric float Meta Ads (Facebook & Instagram)
video_p95 Video watched 95% metric float Meta Ads (Facebook & Instagram)
video_plays Video plays metric float Meta Ads (Facebook & Instagram)
video_title Video title dimension string YouTube Analytics
video_views_2s 2-second views metric integer TikTok Ads
view_content Content views metric float Meta Ads (Facebook & Instagram)
view_through_conversions View-through conversions metric float Google Ads
views Views metric integer YouTube Analytics
views_per_session Views per session metric float Google Analytics 4
watch_time_minutes Watch time (minutes) metric float YouTube Analytics

Date parts

Available on any source with date. Metrics are re-aggregated to the period.

weekWeek (starting Monday)year_weekYear-week (2026-W42)monthMonth (2026-10)quarterQuarter (2026-Q4)yearYearday_of_weekDay of week (Mon..Sun)

Calculated metrics

Computed after aggregation wherever the inputs exist.

roasrevenue / nullif(spend, 0)cpaspend / nullif(conversions, 0)conversion_rateconversions / nullif(clicks, 0) * 100aovrevenue / nullif(orders, 0)

Filters

Pass JSON in filters=:

[["spend","gt",100],"and",
 ["campaign","contains","brand"]]

Operators: eq, neq, gt, gte, lt, lte, contains, ncontains, null, notnull, in.