Reach Local V2 Fields

Suggest Edits

Dimensions (35)

Account

NinjaCat System ID: reach_local_v2:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Campaign Group

NinjaCat System ID: reach_local_v2:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign ID

API Name: global_master_campaign_id

NinjaCat System ID: reach_local_v2:DIM_campaignId

Data Type: text

Aggregates To: DIM_CAMPAIGN_ID

Campaign Name

API Name: name

NinjaCat System ID: reach_local_v2:DIM_campaignName

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Conversion Fence Id

API Name: conversion_fence_id

NinjaCat System ID: reach_local_v2:DIM_conversion_fence_id

Data Type: text

Conversion Fence Name

API Name: conversion_fence_name

NinjaCat System ID: reach_local_v2:DIM_conversion_fence_name

Data Type: text

Currency

NinjaCat System ID: reach_local_v2:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: reach_local_v2:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: date

NinjaCat System ID: reach_local_v2:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: reach_local_v2:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: reach_local_v2:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

Discovery: Event Sub Type

API Name: sub_type

NinjaCat System ID: reach_local_v2:DIM_event_sub_type

Data Type: text

Discovery: Event Type

API Name: event_type

NinjaCat System ID: reach_local_v2:DIM_event_type

Data Type: text

Discovery: Group

API Name: group

NinjaCat System ID: reach_local_v2:DIM_discovery_group

Data Type: text

Discovery: Type

API Name: type

NinjaCat System ID: reach_local_v2:DIM_discovery_type

Data Type: text

External Id

NinjaCat System ID: reach_local_v2:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

FB: Age Range

API Name: age

NinjaCat System ID: reach_local_v2:DIM_fb_age

Data Type: text

FB: Device Type

API Name: device

NinjaCat System ID: reach_local_v2:DIM_fb_device

Data Type: text

FB: Gender

API Name: gender

NinjaCat System ID: reach_local_v2:DIM_fb_gender

Data Type: text

Display As: title_case

FB: Report Status

API Name: status

NinjaCat System ID: reach_local_v2:DIM_fb_status

Data Type: text

Geofence Id

API Name: geofence_id

NinjaCat System ID: reach_local_v2:DIM_geofence_id

Data Type: text

Geofence Name

API Name: geofence_name

NinjaCat System ID: reach_local_v2:DIM_geofence_name

Data Type: text

Keyword

API Name: keyword

NinjaCat System ID: reach_local_v2:DIM_keyword

Data Type: text

Aggregates To: DIM_KEYWORDS

Month Of Year

NinjaCat System ID: reach_local_v2:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: reach_local_v2:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Quarter

NinjaCat System ID: reach_local_v2:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: reach_local_v2:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

Search Activity: Device Type

API Name: device

NinjaCat System ID: reach_local_v2:DIM_sa_device

Data Type: text

Source

API Name: source

NinjaCat System ID: reach_local_v2:DIM_source

Data Type: text

Display As: title_case

Aggregates To: DIM_SOURCE

System Account ID

NinjaCat System ID: reach_local_v2:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Week Of Year

NinjaCat System ID: reach_local_v2:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: reach_local_v2:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

YouTube: Age Range

API Name: age

NinjaCat System ID: reach_local_v2:DIM_yt_age

Data Type: text

YouTube: Device Type

API Name: device

NinjaCat System ID: reach_local_v2:DIM_yt_device

Data Type: text

YouTube: Gender

API Name: gender

NinjaCat System ID: reach_local_v2:DIM_yt_gender

Data Type: text

Display As: title_case

Metrics (83)

budget

API Name: budget

NinjaCat System ID: reach_local_v2:MET_budget

Data Type: decimal

Display As: currency

Aggregates To: DIM_BUDGET

Clicks

API Name: clicks

NinjaCat System ID: reach_local_v2:MET_clicks

Data Type: integer

Aggregates To: MET_CLICKS

Conversion Fences: Spend

API Name: spend

NinjaCat System ID: reach_local_v2:MET_cf_spend

Data Type: decimal

Display As: currency

Conversion Fences: Walk-ins

API Name: walk_ins

NinjaCat System ID: reach_local_v2:MET_cf_walk_ins

Data Type: integer

Count (Unique Dimensions)

NinjaCat System ID: reach_local_v2:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

CPC

NinjaCat System ID: reach_local_v2:MET_cpc

Data Type: decimal

Display As: currency

Aggregates To: MET_CPC

Formula: reach_local_v2:MET_spend / reach_local_v2:MET_clicks

CPM

NinjaCat System ID: reach_local_v2:MET_cpm

Data Type: decimal

Display As: currency

Aggregates To: MET_CPM

Formula: 1000 * reach_local_v2:MET_spend / reach_local_v2:MET_impressions

CTR

NinjaCat System ID: reach_local_v2:MET_ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: reach_local_v2:MET_clicks / reach_local_v2:MET_impressions

Display: Calls

API Name: calls

NinjaCat System ID: reach_local_v2:MET_da_calls

Data Type: integer

Display: Clicks

API Name: clicks

NinjaCat System ID: reach_local_v2:MET_da_clicks

Data Type: integer

Display: Click-Through Form Submissions

API Name: form_submissions_ct

NinjaCat System ID: reach_local_v2:MET_da_form_submissions_ct

Data Type: integer

Display: Click-Through Priority Page Views

API Name: priority_page_views_ct

NinjaCat System ID: reach_local_v2:MET_da_priority_page_views_ct

Data Type: integer

Display: Completed Views

API Name: completed_views

NinjaCat System ID: reach_local_v2:MET_da_completed_views

Data Type: integer

Display: Cost Per Call

NinjaCat System ID: reach_local_v2:MET_da_cost_per_call

Data Type: decimal

Display As: currency

Formula: reach_local_v2:MET_da_calls / reach_local_v2:MET_da_spend

Display: Cost Per Submission

NinjaCat System ID: reach_local_v2:MET_da_cost_per_submission

Data Type: decimal

Display As: currency

Formula: (reach_local_v2:MET_da_form_submissions_vt + reach_local_v2:MET_da_form_submissions_ct) / reach_local_v2:MET_da_spend

Display: Custom Targeting Impressions

API Name: custom_targeting_impressions

NinjaCat System ID: reach_local_v2:MET_da_custom_targeting_impressions

Data Type: integer

Display: Impressions

API Name: impressions

NinjaCat System ID: reach_local_v2:MET_da_impressions

Data Type: integer

Display: % of Videos Completed

NinjaCat System ID: reach_local_v2:MET_da_view_complete_rate

Data Type: decimal

Display As: percent

Formula: reach_local_v2:MET_da_completed_views / reach_local_v2:MET_da_video_views

Display: Performance Impressions

API Name: performance_impressions

NinjaCat System ID: reach_local_v2:MET_da_performance_impressions

Data Type: integer

Display: Remarketing Impressions

API Name: remarketing_impressions

NinjaCat System ID: reach_local_v2:MET_da_remarketing_impressions

Data Type: integer

Display: Spend

API Name: spend

NinjaCat System ID: reach_local_v2:MET_da_spend

Data Type: decimal

Display As: currency

Display: Video Views

API Name: video_views

NinjaCat System ID: reach_local_v2:MET_da_video_views

Data Type: integer

Display: View-Through Form Submissions

API Name: form_submissions_vt

NinjaCat System ID: reach_local_v2:MET_da_form_submissions_vt

Data Type: integer

Display: View-Through Priority Page Views

API Name: priority_page_views_vt

NinjaCat System ID: reach_local_v2:MET_da_priority_page_views_vt

Data Type: integer

Display: Walk-ins

API Name: walk_ins

NinjaCat System ID: reach_local_v2:MET_da_walk_ins

Data Type: integer

Event Count

API Name: count

NinjaCat System ID: reach_local_v2:MET_event_count

Data Type: integer

FB: 100% Watched Actions

API Name: video_p100_watched_actions

NinjaCat System ID: reach_local_v2:MET_fb_video_p100_watched_actions

Data Type: integer

FB: Action Reaction

API Name: action_reaction

NinjaCat System ID: reach_local_v2:MET_fb_action_reaction

Data Type: integer

FB: Call to Action Clicks

API Name: call_to_action_clicks

NinjaCat System ID: reach_local_v2:MET_fb_call_to_action_clicks

Data Type: integer

FB: Checkin

API Name: checkin

NinjaCat System ID: reach_local_v2:MET_fb_checkin

Data Type: integer

FB: Clicks

API Name: clicks

NinjaCat System ID: reach_local_v2:MET_fb_clicks

Data Type: integer

FB: Comment

API Name: comment

NinjaCat System ID: reach_local_v2:MET_fb_comment

Data Type: integer

FB: CPC

NinjaCat System ID: reach_local_v2:MET_fb_cpc

Data Type: integer

Formula: reach_local_v2:MET_fb_spend / reach_local_v2:MET_fb_clicks

FB: CPM

NinjaCat System ID: reach_local_v2:MET_fb_cpm

Data Type: integer

Formula: 1000 * reach_local_v2:MET_fb_spend / reach_local_v2:MET_fb_impressions

FB: CTR

NinjaCat System ID: reach_local_v2:MET_fb_ctr

Data Type: integer

Formula: reach_local_v2:MET_fb_clicks / reach_local_v2:MET_fb_impressions

FB: Frequency

API Name: frequency

NinjaCat System ID: reach_local_v2:MET_fb_frequency

Data Type: decimal

Display As: float

FB: Impressions

API Name: impressions

NinjaCat System ID: reach_local_v2:MET_fb_impressions

Data Type: integer

FB: Inline Link Clicks

API Name: inline_link_clicks

NinjaCat System ID: reach_local_v2:MET_fb_inline_link_clicks

Data Type: integer

FB: Lead Gen - Other

API Name: leadgen.other

NinjaCat System ID: reach_local_v2:MET_fb_leadgen_other

Data Type: integer

FB: Leads

API Name: leads

NinjaCat System ID: reach_local_v2:MET_fb_leads

Data Type: integer

FB: Like

API Name: like

NinjaCat System ID: reach_local_v2:MET_fb_like

Data Type: integer

FB: Link Click

API Name: link_click

NinjaCat System ID: reach_local_v2:MET_fb_link_click

Data Type: integer

FB: Page Engagement

API Name: page_engagement

NinjaCat System ID: reach_local_v2:MET_fb_page_engagement

Data Type: integer

FB: Post

API Name: post

NinjaCat System ID: reach_local_v2:MET_fb_post

Data Type: integer

FB: Post Engagement

API Name: post_engagement

NinjaCat System ID: reach_local_v2:MET_fb_post_engagement

Data Type: integer

FB: Post Reaction

API Name: post_reaction

NinjaCat System ID: reach_local_v2:MET_fb_post_reaction

Data Type: integer

FB: Reach

API Name: reach

NinjaCat System ID: reach_local_v2:MET_fb_reach

Data Type: integer

FB: Social Clicks

API Name: social_clicks

NinjaCat System ID: reach_local_v2:MET_fb_social_clicks

Data Type: integer

FB: Social Impressions

API Name: social_impressions

NinjaCat System ID: reach_local_v2:MET_fb_social_impressions

Data Type: integer

FB: Social Reach

API Name: social_reach

NinjaCat System ID: reach_local_v2:MET_fb_social_reach

Data Type: integer

FB: Spend

API Name: spend

NinjaCat System ID: reach_local_v2:MET_fb_spend

Data Type: decimal

Display As: currency

FB: Video - AVG % Watched Actions

API Name: video_avg_percent_watched_actions

NinjaCat System ID: reach_local_v2:MET_fb_video_avg_percent_watched_actions

Data Type: decimal

Display As: percent

FB: Website Clicks

API Name: website_clicks

NinjaCat System ID: reach_local_v2:MET_fb_website_clicks

Data Type: integer

Geo: Clicks

API Name: clicks

NinjaCat System ID: reach_local_v2:MET_gf_clicks

Data Type: integer

Geo: Impressions

API Name: impressions

NinjaCat System ID: reach_local_v2:MET_gf_impressions

Data Type: integer

Geo: Spend

API Name: spend

NinjaCat System ID: reach_local_v2:MET_gf_spend

Data Type: decimal

Display As: currency

Geo: Walk-ins

API Name: walk_ins

NinjaCat System ID: reach_local_v2:MET_gf_walk_ins

Data Type: integer

Impressions

API Name: impressions

NinjaCat System ID: reach_local_v2:MET_impressions

Data Type: integer

Aggregates To: MET_IMPRESSIONS

Keywords: Clicks

API Name: clicks

NinjaCat System ID: reach_local_v2:MET_kw_clicks

Data Type: integer

Keywords: Impressions

API Name: impressions

NinjaCat System ID: reach_local_v2:MET_kw_impressions

Data Type: integer

Lead: Calls

API Name: calls

NinjaCat System ID: reach_local_v2:MET_ld_calls

Data Type: integer

Lead: Chats

API Name: chats

NinjaCat System ID: reach_local_v2:MET_ld_chats

Data Type: integer

Lead: Emails

API Name: emails

NinjaCat System ID: reach_local_v2:MET_ld_emails

Data Type: integer

Leads

API Name: leads

NinjaCat System ID: reach_local_v2:MET_leads

Data Type: integer

Aggregates To: MET_LEADS

Lead: Web Events

API Name: web_events

NinjaCat System ID: reach_local_v2:MET_ld_web_events

Data Type: integer

Search Activity: CPC

NinjaCat System ID: reach_local_v2:MET_sa_cpc

Data Type: integer

Formula: reach_local_v2:MET_sa_spend / reach_local_v2:MET_sa_clicks

Search Activity: CTR

NinjaCat System ID: reach_local_v2:MET_sa_ctr

Data Type: integer

Formula: reach_local_v2:MET_sa_clicks / reach_local_v2:MET_sa_impressions

Search: Calls

API Name: calls

NinjaCat System ID: reach_local_v2:MET_sa_calls

Data Type: integer

Search: Clicks

API Name: clicks

NinjaCat System ID: reach_local_v2:MET_sa_clicks

Data Type: integer

Search: Emails

API Name: emails

NinjaCat System ID: reach_local_v2:MET_sa_emails

Data Type: integer

Search: Impressions

API Name: impressions

NinjaCat System ID: reach_local_v2:MET_sa_impressions

Data Type: integer

Search: Leads

API Name: leads

NinjaCat System ID: reach_local_v2:MET_sa_leads

Data Type: integer

Search: Spend

API Name: spend

NinjaCat System ID: reach_local_v2:MET_sa_spend

Data Type: decimal

Display As: currency

Search: Web Events

API Name: web_events

NinjaCat System ID: reach_local_v2:MET_sa_web_events

Data Type: integer

Spend

API Name: spend

NinjaCat System ID: reach_local_v2:MET_spend

Data Type: decimal

Display As: currency

Aggregates To: MET_COST

YouTube: Clicks

API Name: clicks

NinjaCat System ID: reach_local_v2:MET_yt_clicks

Data Type: integer

YouTube: CPC

NinjaCat System ID: reach_local_v2:MET_yt_cpc

Data Type: integer

Formula: reach_local_v2:MET_yt_spend / reach_local_v2:MET_yt_clicks

YouTube: CPM

NinjaCat System ID: reach_local_v2:MET_yt_cpm

Data Type: integer

Formula: 1000 * reach_local_v2:MET_yt_spend / reach_local_v2:MET_yt_impressions

YouTube: CTR

NinjaCat System ID: reach_local_v2:MET_yt_ctr

Data Type: integer

Formula: reach_local_v2:MET_yt_clicks / reach_local_v2:MET_yt_impressions

YouTube: Impressions

API Name: impressions

NinjaCat System ID: reach_local_v2:MET_yt_impressions

Data Type: integer

YouTube: Spend

API Name: spend

NinjaCat System ID: reach_local_v2:MET_yt_spend

Data Type: decimal

Display As: currency

YouTube: Views

API Name: views

NinjaCat System ID: reach_local_v2:MET_yt_views

Data Type: integer

YouTube: VTR

NinjaCat System ID: reach_local_v2:MET_yt_vtr

Data Type: integer

Formula: reach_local_v2:MET_yt_views / reach_local_v2:MET_yt_impressions

Updated 6 months ago