LupyAi

Google Search Console — data fields

Organic search clicks, impressions, CTR and position by query, page, country and device. 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 idNameSectionKindTypeDescription
account_id Account ID dimension string
account_name Account name dimension string
clicks Clicks Performance metric integer
country Country (ISO-3) Audience dimension string
ctr CTR (%) Performance metric percent
datasource Data source dimension string Connector the row came from
date Date Time dimension date
device Device Audience dimension string
impressions Impressions Performance metric integer
page Page URL Search dimension string
position Average position Performance metric float
query Search query Search dimension string
search_appearance Search appearance Search dimension string

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.