Skip to main content

Fields

This is a comprehensive list of columns/fields that can be used in V4.

ANALYTICS INFO​

analytics_property_id​

PropertyDetail
DescriptionUnique identifier for the linked Google Analytics property.
Data TypeSTRING

analytics_property_name​

PropertyDetail
DescriptionName of the linked Google Analytics property.
Data TypeSTRING

CLICK METRICS​

spend​

PropertyDetail
DescriptionTotal amount of money spent on ads during the selected period.
Data TypeNUMBER
Example154.539

impressions​

PropertyDetail
DescriptionNumber of times ads were shown to users.
Data TypeNUMBER
Example5664

clicks​

PropertyDetail
DescriptionNumber of times users clicked on ads.
Data TypeNUMBER
Example32

search_imp_share_significant_imps​

PropertyDetail
DescriptionRefers to the search impression share for a specific set of data (e.g., keyword, ad group, or campaign) that has a "significant" enough number of eligible impressions for the platform to provide an accurate estimate.
Data TypeNUMBER
Example60

search_imp_share_eligible_imps​

PropertyDetail
DescriptionSearch impression share eligible impressions refers to the total estimated number of impressions that your ads were eligible to receive based on your current campaign settings.


If you have a Search impression share of 80%, it means that out of all the times your ad was eligible to appear based on your settings, it showed 80% of the time. The other 20% were lost due to either insufficient budget or poor Ad Rank.
Data TypeNUMBER
Example113

search_imp_share_lost_rank​

PropertyDetail
DescriptionSearch Impression Share Lost to Rank is a metric in Google Ads and Microsoft Ads that estimates the percentage of times your ads didn't show on the search network due to poor Ad Rank in the auction.
Essentially, this metric tells you how often your competitors outranked you, causing your ads to miss potential impressions.
Data TypeNUMBER
Example53

search_imp_share_lost_budget​

PropertyDetail
DescriptionA metric that estimates the percentage of times your ads didn't show on the search network due to insufficient daily budget.


This metric indicates that your campaign used up its daily budget and stopped serving ads for the remainder of the day, causing you to miss out on potential impressions.
Data TypeNUMBER
Example13

impressions_abs_top​

PropertyDetail
DescriptionPercentage of your total impressions that were shown as the very first ad above the organic search results.
This metric indicates how often your ad secured the most prominent position on the Search Engine Results Page (SERP).
Data TypeNUMBER
Example39

search_imp_share_abs_eligible_imps​

PropertyDetail
DescriptionRepresents the estimated number of impressions your ad was eligible for in the absolute top position of search results.
Data TypeNUMBER
Example40

search_imp_share_abs_lost_rank​

PropertyDetail
DescriptionThe estimated percentage of missed absolute top impressions due to poor Ad Rank.
Data TypeNUMBER
Example1

search_imp_share_abs_lost_budget​

PropertyDetail
DescriptionThe estimated percentage of missed absolute top impressions due to insufficient budget.
Data TypeNUMBER
Example4

impressions_top​

PropertyDetail
DescriptionNumber of times ads appeared in the top section (not necessarily the very first position).
Data TypeNUMBER
Example83

search_imp_share_top_eligible_imps​

PropertyDetail
DescriptionRepresents the estimated number of impressions your ad was eligible for in the top location (above organic results)
Data TypeNUMBER
Example83

search_imp_share_top_lost_rank​

PropertyDetail
DescriptionThe estimated percentage of missed top impressions due to poor Ad Rank.
Data TypeNUMBER
Example504

search_imp_share_top_lost_budget​

PropertyDetail
DescriptionThe estimated percentage of missed top impressions due to insufficient budget.
Data TypeNUMBER
Example40

content_share_significant_imps​

PropertyDetail
DescriptionNumber of significant impressions for content (display) network.
Data TypeNUMBER
Example258

content_impression_share_eligible_imps​

PropertyDetail
DescriptionTotal eligible impressions for display/content campaigns.
Data TypeNUMBER
Example2580

content_imp_share_lost_rank​

PropertyDetail
DescriptionLost display impressions due to low ad rank.
Data TypeNUMBER
Example1950

content_imp_share_lost_budget​

PropertyDetail
DescriptionLost display impressions due to budget limits.
Data TypeNUMBER
Example372

views​

PropertyDetail
DescriptionNumber of views.
Data TypeNUMBER
Example2057

views_to_p25_by_imps​

PropertyDetail
DescriptionPercentage of impressions where the viewer watched at least 25% of the video.
Data TypeNUMBER
Example3617

views_to_p50_by_imps​

PropertyDetail
DescriptionPercentage of impressions where the viewer watched at least 50% of the video.
Data TypeNUMBER
Example2205

views_to_p75_by_imps​

PropertyDetail
DescriptionPercentage of impressions where the viewer watched at least 75% of the video.
Data TypeNUMBER
Example1651

views_to_p100_by_imps​

PropertyDetail
DescriptionPercentage of impressions where the viewer watched 100% of the video.
Data TypeNUMBER
Example1261

CONVERSION INFO​

conversion_id​

PropertyDetail
DescriptionUnique identifier for a conversion
Data TypeSTRING
Example[Click Metrics]

conversion_name​

PropertyDetail
DescriptionName of the conversion
Data TypeSTRING
ExampleAU Passes LP Visit

conversion_info​

PropertyDetail
DescriptionAdditional descriptive details about the conversion.
Data TypeSTRING
Example{"attributiontype":"LAST_TOUCH_BY_CAMPAIGN","conversion_type":"VIEW_CONTENT","status":true}

conversion_latency_days​

PropertyDetail
DescriptionAverage time in days between ad interaction and conversion.
Data TypeNUMBER
Example1

CONVERSION METRICS​

conversions​

PropertyDetail
DescriptionTotal number of conversions recorded.
Data TypeNUMBER
Example7

conversions_clickthrough​

PropertyDetail
DescriptionConversions attributed to clicks.
Data TypeNUMBER
Example5

conversions_viewthrough​

PropertyDetail
DescriptionConversions attributed to ad views (without clicks).
Data TypeNUMBER
Example2

conversions_all​

PropertyDetail
DescriptionTotal conversions including both clickthrough and viewthrough.
Data TypeNUMBER
Example7

conversions_value​

PropertyDetail
DescriptionTotal value generated by conversions.
Data TypeNUMBER
Example64.95

conversions_value_clickthrough​

PropertyDetail
DescriptionValue of conversions attributed to clicks.
Data TypeNUMBER

conversions_value_viewthrough​

PropertyDetail
DescriptionValue of conversions attributed to ad views.
Data TypeNUMBER

conversions_value_all​

PropertyDetail
DescriptionTotal value including clickthrough and viewthrough conversions.
Data TypeNUMBER
Example64.95

DATA MANAGEMENT​

data_source_type​

PropertyDetail
DescriptionThe type of source the row data originated from.
• Ad Platform
• Analytics
• CRM
• ECOM
Data TypeSTRING
ExampleAd Platform

data_source_name​

PropertyDetail
DescriptionThe name of the source the row data originated from.
Data TypeSTRING
ExampleLinkedIn Ads

data_segment​

PropertyDetail
DescriptionThe data segment helps describe the arrangement and nature of the row data.
Data TypeSTRING
ExampleConversion Data

data_layer​

PropertyDetail
DescriptionEach data segment may have multiple layers corresponding to different levels of granularity.
Data TypeSTRING
ExampleAds Custom Level

currency_code​

PropertyDetail
Descriptioncurrency code extracted from each of the platforms on the account level
Data TypeSTRING
ExampleUSD, CAD, GBP

currency_to_cad​

PropertyDetail
Descriptiondaily rate to convert any metric by sum(value_column*currency_to_cad) to get same spend/event value in cad
Data TypeNUMBER
Example1.3333

currency_to_usd​

PropertyDetail
Descriptiondaily rate to convert any metric by sum(value_column*currency_to_usd) to get same spend/event value in usd
Data TypeNUMBER
Example0.7777

PERIOD​

date​

PropertyDetail
DescriptionThe specific date breakout of the record.
Data TypeDATE
Example2022-08-12

week_date​

PropertyDetail
DescriptionFirst date of the week as determined by the Config Sheet
Data TypeDATE
Example2022-08-08

month_date​

PropertyDetail
DescriptionFirst date of the month.
Data TypeDATE
Example2022-08-01

PLATFORM INFO​

platform​

PropertyDetail
DescriptionThe name describing the advertising platform.
Data TypeSTRING
ExampleLinkedIn, Twitter, Bing

account_id​

PropertyDetail
DescriptionThe id of the account.
Data TypeSTRING
Example5643548445

account_name​

PropertyDetail
DescriptionThe name of the account.
Data TypeSTRING
ExampleThrivedigial - DMC (PO)

account_info​

PropertyDetail
DescriptionJSON object containing all other account-level dependant fields.
Data TypeSTRING
Example{"currency":"USD","edit_stamps":"`{\"created\":`{\"actor\":\"urn:li:unknown:0\",\"time\":18646}`,\"lastModified\":`{\"actor\":\"urn:li:unknown:0\",\"time\":18646}`}`","status":"ACTIVE"}

campaign_id​

PropertyDetail
DescriptionThe id of the campaign.
Data TypeSTRING
Example34186234

campaign_name​

PropertyDetail
DescriptionThe name of the campaign.
Data TypeSTRING
ExampleLICAD-LT_AMER_US_eComm_87_Famargeting-NAMERY23_ALO

campaign_info​

PropertyDetail
DescriptionJSON object containing all other campaign-level dependant fields.
Data TypeSTRING
Example{"currency":"USD","edit_stamps":"`{\"created\":`{\"actor\":\"urn:li:unknown:0\",\"time\":18646}`,\"lastModified\":`{\"actor\":\"urn:li:unknown:0\",\"time\":18646}`}`","status":"ACTIVE"}

adgroup_id​

PropertyDetail
DescriptionThe id of the adgroup (or similar).
Data TypeSTRING
Example61684766

adgroup_name​

PropertyDetail
DescriptionThe name of the adgroup.
Data TypeSTRING
ExampleCMD

adgroup_info​

PropertyDetail
DescriptionJSON object containing all other adgroup-level dependant fields.
Data TypeSTRING
Example{"currency":"USD","edit_stamps":"`{\"created\":`{\"actor\":\"urn:li:unknown:0\",\"time\":18646}`,\"lastModified\":`{\"actor\":\"urn:li:unknown:0\",\"time\":18646}`}`","status":"ACTIVE"}

ad_id​

PropertyDetail
DescriptionThe id of the ad.
Data TypeSTRING
Example617761465

ad_name​

PropertyDetail
DescriptionThe name of the ad.
Data TypeSTRING
ExampleThrive - DMC

ad_info​

PropertyDetail
DescriptionJSON object containing all other ad-level dependant fields.
Data TypeSTRING

dimensions​

PropertyDetail
DescriptionJSON object containing the dimensional fields that breakout/segment the data.
Data TypeVARIANT
Example{"ad_distribution":"Search","device":"Computer","language":"Turkish","network":"Microsoft sites and select traffic"}

dimensions_extended_type​

PropertyDetail
DescriptionType of dimension, such as campaign, ad group, or keyword level data.
Data TypeSTRING
ExampleGOOGLE_LOCATION_ID

dimensions_extended_id​

PropertyDetail
DescriptionUnique identifier for the dimension (e.g., campaign ID, ad group ID).
Data TypeSTRING
Example9027910

dimensions_extended_info​

PropertyDetail
DescriptionAdditional descriptive information about the dimension.
Data TypeSTRING
Example{"geo_target":`{"business_region":"NAM","canonical_name":"77859,Texas,United States","continent":"Americas","continent_region":"Northern America","country":"United States","country_code":"US","name":"77859","postal_code":"77859","state":"Texas","status":"ENABLED","thrive_city":"Hearne","thrive_dma":"Waco-Temple-Bryan TX","type":"Postal Code"}

TRAFFIC METRICS​

special_metrics​

PropertyDetail
DescriptionMiscellaneous custom or specialized metrics.
Data TypeSTRING
Example{"clicks_any":32,"video_starts":5255,"video_views":2057}

users​

PropertyDetail
DescriptionTotal number of unique users tracked.
Data TypeNUMBER
Example2

users_new​

PropertyDetail
DescriptionNumber of first-time users.
Data TypeNUMBER
Example2

sessions​

PropertyDetail
DescriptionTotal number of sessions recorded.
Data TypeNUMBER
Example2

sessions_duration​

PropertyDetail
DescriptionTotal duration of all sessions.
Data TypeNUMBER
Example8

bounces​

PropertyDetail
DescriptionNumber of single-page sessions where users left without further interaction.
Data TypeNUMBER
Example1

pageviews​

PropertyDetail
DescriptionTotal number of pages viewed.
Data TypeNUMBER
Example2

page_loadtime​

PropertyDetail
DescriptionAverage time taken to load a page.
Data TypeNUMBER
Example7760