Introduction

Datasources and destinations

Fields listing for Piwik

Events
Field IDevents
TypeNUMBER
Data Typemetric
Consent Form Impressions
Field IDconsent_form_impressions
TypeNUMBER
Data Typemetric
Consent Form Clicks
Field IDconsent_form_clicks
TypeNUMBER
Data Typemetric
Consents First
Field IDconsents_first
TypeNUMBER
Data Typemetric
Consents Changed
Field IDconsents_changed
TypeNUMBER
Data Typemetric
Consents Full
Field IDconsents_full
TypeNUMBER
Data Typemetric
Consents Any
Field IDconsents_any
TypeNUMBER
Data Typemetric
Consents None
Field IDconsents_none
TypeNUMBER
Data Typemetric
Consents No Decision
Field IDconsents_no_decision
TypeNUMBER
Data Typemetric
Consents Analytics
Field IDconsents_analytics
TypeNUMBER
Data Typemetric
Consents AB Testing Personalization
Field IDconsents_ab_testing_personalization
TypeNUMBER
Data Typemetric
Consents Conversion Tracking
Field IDconsents_conversion_tracking
TypeNUMBER
Data Typemetric
Consents Marketing Automation
Field IDconsents_marketing_automation
TypeNUMBER
Data Typemetric
Consents Remarketing
Field IDconsents_remarketing
TypeNUMBER
Data Typemetric
Consents User Feedback
Field IDconsents_user_feedback
TypeNUMBER
Data Typemetric
Custom Consent 1
Field IDconsents_custom_1
TypeNUMBER
Data Typemetric
Page Views
Field IDpage_views
TypeNUMBER
Data Typemetric
Unique Page Views
Field IDunique_page_views
TypeNUMBER
Data Typemetric
Entries
Field IDentries
TypeNUMBER
Data Typemetric
Exits
Field IDexits
TypeNUMBER
Data Typemetric
Bounces
Field IDbounces
TypeNUMBER
Data Typemetric
Sessions
Field IDsessions
TypeNUMBER
Data Typemetric
Visitors
Field IDvisitors
TypeNUMBER
Data Typemetric
Returning Visitors Rate
Field IDreturning_visitors_rate
TypePERCENT
Data Typemetric
Users
Field IDusers
TypeNUMBER
Data Typemetric
Visitor IPs
Field IDvisitor_ips
TypeNUMBER
Data Typemetric
Outlinks
Field IDoutlinks
TypeNUMBER
Data Typemetric
Unique Outlinks
Field IDunique_outlinks
TypeNUMBER
Data Typemetric
Downloads
Field IDdownloads
TypeNUMBER
Data Typemetric
Unique Downloads
Field IDunique_downloads
TypeNUMBER
Data Typemetric
Searches
Field IDsearches
TypeNUMBER
Data Typemetric
Unique Searches
Field IDunique_searches
TypeNUMBER
Data Typemetric
Custom Events
Field IDcustom_events
TypeNUMBER
Data Typemetric
Unique Custom Events
Field IDunique_custom_events
TypeNUMBER
Data Typemetric
Content Impressions
Field IDcontent_impressions
TypeNUMBER
Data Typemetric
Unique Content Impressions
Field IDunique_content_impressions
TypeNUMBER
Data Typemetric
Content Interactions
Field IDcontent_interactions
TypeNUMBER
Data Typemetric
Unique Content Interactions
Field IDunique_content_interactions
TypeNUMBER
Data Typemetric
Orders
Field IDecommerce_conversions
TypeNUMBER
Data Typemetric
Product Detail Views
Field IDproduct_detail_views
TypeNUMBER
Data Typemetric
Cart Additions
Field IDcart_additions
TypeNUMBER
Data Typemetric
Cart Removals
Field IDcart_removals
TypeNUMBER
Data Typemetric
Cart To Detail Rate
Field IDcart_to_detail_rate
TypePERCENT
Data Typemetric
Order To Detail Rate
Field IDorder_to_detail_rate
TypePERCENT
Data Typemetric
Total Quantity
Field IDtotal_quantity
TypeNUMBER
Data Typemetric
Abandoned Carts
Field IDecommerce_abandoned_carts
TypeNUMBER
Data Typemetric
Unique Purchases
Field IDunique_purchases
TypeNUMBER
Data Typemetric
Entry Rate
Field IDentry_rate
TypePERCENT
Data Typemetric
Exit Rate
Field IDexit_rate
TypePERCENT
Data Typemetric
Exit Rate Events
Field IDexit_rate_events
TypePERCENT
Data Typemetric
Bounce Rate
Field IDbounce_rate
TypePERCENT
Data Typemetric
Bounce Rate Events
Field IDbounce_rate_events
TypePERCENT
Data Typemetric
Content Interaction Rate
Field IDcontent_interaction_rate
TypePERCENT
Data Typemetric
Ecommerce Conversion Rate
Field IDecommerce_conversion_rate
TypePERCENT
Data Typemetric
Cart abandonment rate
Field IDabandoned_cart_rate
TypePERCENT
Data Typemetric
Events Per Session
Field IDevents_per_session
TypeNUMBER
Data Typemetric
Goal Conversions
Field IDgoal_conversions
TypeNUMBER
Data Typemetric
Unique Goal Conversions
Field IDunique_goal_conversions
TypeNUMBER
Data Typemetric
Goal Conversion Rate
Field IDgoal_conversion_rate
TypePERCENT
Data Typemetric
Visitor ID
Field IDvisitor_id
TypeTEXT
Data Typedimension
User ID
Field IDuser_id
TypeTEXT
Data Typedimension
Cookie ID
Field IDcookie_id
TypeTEXT
Data Typedimension
Visitor Returning
Field IDvisitor_returning
TypeTEXT
Data Typedimension
Visitor Session Number
Field IDvisitor_session_number
TypeNUMBER
Data Typedimension
Visitor Days Since Last Session
Field IDvisitor_days_since_last_session
TypeNUMBER
Data Typedimension
Visitor Days Since First Session
Field IDvisitor_days_since_first_session
TypeNUMBER
Data Typedimension
Visitor Days Since Order
Field IDvisitor_days_since_order
TypeNUMBER
Data Typedimension
Session Total Events
Field IDsession_total_events
TypeNUMBER
Data Typedimension
Session Total Time
Field IDsession_total_time
TypeNUMBER
Data Typedimension
Session Total Page Views
Field IDsession_total_page_views
TypeNUMBER
Data Typedimension
Session Total Outlinks
Field IDsession_total_outlinks
TypeNUMBER
Data Typedimension
Session Total Downloads
Field IDsession_total_downloads
TypeNUMBER
Data Typedimension
Session Total Site Searches
Field IDsession_total_site_searches
TypeNUMBER
Data Typedimension
Session Total Custom Events
Field IDsession_total_custom_events
TypeNUMBER
Data Typedimension
Session Total Content Impressions
Field IDsession_total_content_impressions
TypeNUMBER
Data Typedimension
Session Total Content Interactions
Field IDsession_total_content_interactions
TypeNUMBER
Data Typedimension
Session Total Goal Conversions
Field IDsession_total_goal_conversions
TypeNUMBER
Data Typedimension
Session Total Ecommerce Conversions
Field IDsession_total_ecommerce_conversions
TypeNUMBER
Data Typedimension
Session Total Abandoned Carts
Field IDsession_total_abandoned_carts
TypeNUMBER
Data Typedimension
Session Total Product Detail Views
Field IDsession_total_product_detail_views
TypeNUMBER
Data Typedimension
Session Total Cart Additions
Field IDsession_total_cart_additions
TypeNUMBER
Data Typedimension
Session Total Cart Removals
Field IDsession_total_cart_removals
TypeNUMBER
Data Typedimension
Session Unique Page Views
Field IDsession_unique_page_views
TypeNUMBER
Data Typedimension
Session Unique Outlinks
Field IDsession_unique_outlinks
TypeNUMBER
Data Typedimension
Session Unique Downloads
Field IDsession_unique_downloads
TypeNUMBER
Data Typedimension
Session Unique Searches
Field IDsession_unique_searches
TypeNUMBER
Data Typedimension
Session Unique Custom Events
Field IDsession_unique_custom_events
TypeNUMBER
Data Typedimension
Session Unique Content Impressions
Field IDsession_unique_content_impressions
TypeNUMBER
Data Typedimension
Session Unique Content Interactions
Field IDsession_unique_content_interactions
TypeNUMBER
Data Typedimension
Session Goals
Field IDsession_goals
TypeTEXT
Data Typedimension
Session Goal UUIDs
Field IDsession_goal_uuids
TypeTEXT
Data Typedimension
Session Ecommerce Status
Field IDsession_ecommerce_status
TypeTEXT
Data Typedimension
Source
Field IDsource
TypeTEXT
Data Typedimension
Medium
Field IDmedium
TypeTEXT
Data Typedimension
Source / Medium
Field IDsource_medium
TypeTEXT
Data Typedimension
Keyword
Field IDkeyword
TypeTEXT
Data Typedimension
Channel
Field IDreferrer_type
TypeTEXT
Data Typedimension
Channel ID
Field IDreferrer_id
TypeNUMBER
Data Typedimension
Channel URL
Field IDreferrer_url
TypeTEXT
Data Typedimension
Campaign Name
Field IDcampaign_name
TypeTEXT
Data Typedimension
Campaign ID
Field IDcampaign_id
TypeTEXT
Data Typedimension
Campaign Content
Field IDcampaign_content
TypeTEXT
Data Typedimension
Campaign Gclid
Field IDcampaign_gclid
TypeTEXT
Data Typedimension
Operating System
Field IDoperating_system
TypeTEXT
Data Typedimension
Operating System Version
Field IDoperating_system_version
TypeTEXT
Data Typedimension
Browser Engine
Field IDbrowser_engine
TypeTEXT
Data Typedimension
Browser Name
Field IDbrowser_name
TypeTEXT
Data Typedimension
Browser Version
Field IDbrowser_version
TypeTEXT
Data Typedimension
Browser Language ISO639
Field IDbrowser_language_iso639
TypeTEXT
Data Typedimension
Browser Fingerprint
Field IDbrowser_fingerprint
TypeNUMBER
Data Typedimension
Device ID
Field IDdevice_id
TypeNUMBER
Data Typedimension
Device Type
Field IDdevice_type
TypeTEXT
Data Typedimension
Device Brand
Field IDdevice_brand
TypeTEXT
Data Typedimension
Device Brand Code
Field IDdevice_brand_code
TypeTEXT
Data Typedimension
Device Model
Field IDdevice_model
TypeTEXT
Data Typedimension
Resolution
Field IDresolution
TypeTEXT
Data Typedimension
Resolution Width
Field IDresolution_width
TypeNUMBER
Data Typedimension
Resolution Height
Field IDresolution_height
TypeNUMBER
Data Typedimension
Plugin PDF
Field IDplugin_pdf
TypeBOOLEAN
Data Typedimension
Plugin Flash
Field IDplugin_flash
TypeBOOLEAN
Data Typedimension
Plugin Java
Field IDplugin_java
TypeBOOLEAN
Data Typedimension
Plugin Director
Field IDplugin_director
TypeBOOLEAN
Data Typedimension
Plugin Quicktime
Field IDplugin_quicktime
TypeBOOLEAN
Data Typedimension
Plugin Realplayer
Field IDplugin_realplayer
TypeBOOLEAN
Data Typedimension
Plugin Windows Media
Field IDplugin_windowsmedia
TypeBOOLEAN
Data Typedimension
Plugin Gears
Field IDplugin_gears
TypeBOOLEAN
Data Typedimension
Plugin Silverlight
Field IDplugin_silverlight
TypeBOOLEAN
Data Typedimension
Plugin Cookie
Field IDplugin_cookie
TypeBOOLEAN
Data Typedimension
Location Continent ISO Code
Field IDlocation_continent_iso_code
TypeCONTINENT_CODE
Data Typedimension
Location Continent Name
Field IDlocation_continent_name
TypeCONTINENT
Data Typedimension
Location Country Name
Field IDlocation_country_name
TypeCOUNTRY
Data Typedimension
Location Country Code
Field IDlocation_country_code
TypeCOUNTRY_CODE
Data Typedimension
Location Subdivision 1 Code
Field IDlocation_subdivision_1_code
TypeREGION_CODE
Data Typedimension
Location Subdivision 1 Name
Field IDlocation_subdivision_1_name
TypeREGION
Data Typedimension
Location Subdivision 2 Code
Field IDlocation_subdivision_2_code
TypeREGION_CODE
Data Typedimension
Location Subdivision 2 Name
Field IDlocation_subdivision_2_name
TypeREGION
Data Typedimension
Location City Code
Field IDlocation_city_code
TypeCITY_CODE
Data Typedimension
Location City Name
Field IDlocation_city_name
TypeCITY
Data Typedimension
Location Metro Code
Field IDlocation_metro_code
TypeMETRO_CODE
Data Typedimension
Location Metro Name
Field IDlocation_metro_name
TypeMETRO
Data Typedimension
Latitude
Field IDlocation_latitude
TypeNUMBER
Data Typedimension
Longitude
Field IDlocation_longitude
TypeNUMBER
Data Typedimension
Location Provider
Field IDlocation_provider
TypeTEXT
Data Typedimension
Location Organization
Field IDlocation_organization
TypeTEXT
Data Typedimension
Session Exit URL
Field IDsession_exit_url
TypeTEXT
Data Typedimension
Session Exit Title
Field IDsession_exit_title
TypeTEXT
Data Typedimension
Session Entry URL
Field IDsession_entry_url
TypeTEXT
Data Typedimension
Session Entry Title
Field IDsession_entry_title
TypeTEXT
Data Typedimension
Session Second URL
Field IDsession_second_url
TypeTEXT
Data Typedimension
Session Second Title
Field IDsession_second_title
TypeTEXT
Data Typedimension
Is Bounce
Field IDis_bounce
TypeBOOLEAN
Data Typedimension
Event Type ID
Field IDevent_id
TypeNUMBER
Data Typedimension
Session ID
Field IDsession_id
TypeNUMBER
Data Typedimension
Is Exit
Field IDis_exit
TypeBOOLEAN
Data Typedimension
Is Entry
Field IDis_entry
TypeBOOLEAN
Data Typedimension
Event Type
Field IDevent_type
TypeTEXT
Data Typedimension
Event URL
Field IDevent_url
TypeTEXT
Data Typedimension
Event Title
Field IDevent_title
TypeTEXT
Data Typedimension
Outlink URL
Field IDoutlink_url
TypeTEXT
Data Typedimension
Download URL
Field IDdownload_url
TypeTEXT
Data Typedimension
Search Keyword
Field IDsearch_keyword
TypeTEXT
Data Typedimension
Search Category
Field IDsearch_category
TypeTEXT
Data Typedimension
Search Results Count
Field IDsearch_results_count
TypeNUMBER
Data Typedimension
Custom Event Category
Field IDcustom_event_category
TypeTEXT
Data Typedimension
Custom Event Action
Field IDcustom_event_action
TypeTEXT
Data Typedimension
Custom Event Name
Field IDcustom_event_name
TypeTEXT
Data Typedimension
Custom Event Value
Field IDcustom_event_value
TypeNUMBER
Data Typedimension
Content Name
Field IDcontent_name
TypeTEXT
Data Typedimension
Content Piece
Field IDcontent_piece
TypeTEXT
Data Typedimension
Content Target
Field IDcontent_target
TypeTEXT
Data Typedimension
Previous Event URL
Field IDprevious_event_url
TypeTEXT
Data Typedimension
Previous Event Title
Field IDprevious_event_title
TypeTEXT
Data Typedimension
Next Event URL
Field IDnext_event_url
TypeTEXT
Data Typedimension
Next Event Title
Field IDnext_event_title
TypeTEXT
Data Typedimension
Event Index
Field IDevent_index
TypeNUMBER
Data Typedimension
Page View Index
Field IDpage_view_index
TypeNUMBER
Data Typedimension
Time On Page
Field IDtime_on_page
TypeNUMBER
Data Typedimension
Page Generation Time
Field IDpage_generation_time
TypeNUMBER
Data Typedimension
Goal ID
Field IDgoal_id
TypeTEXT
Data Typedimension
Goal UUID
Field IDgoal_uuid
TypeTEXT
Data Typedimension
Goal Revenue
Field IDgoal_revenue
TypeNUMBER
Data Typedimension
Lost Revenue
Field IDlost_revenue
TypeNUMBER
Data Typedimension
Order ID
Field IDorder_id
TypeTEXT
Data Typedimension
Item Count
Field IDitem_count
TypeNUMBER
Data Typedimension
Revenue
Field IDrevenue
TypeNUMBER
Data Typedimension
Revenue Subtotal
Field IDrevenue_subtotal
TypeNUMBER
Data Typedimension
Revenue Tax
Field IDrevenue_tax
TypeNUMBER
Data Typedimension
Revenue Shipping
Field IDrevenue_shipping
TypeNUMBER
Data Typedimension
Revenue Discount
Field IDrevenue_discount
TypeNUMBER
Data Typedimension
Timing DOM Interactive
Field IDtiming_dom_interactive
TypeNUMBER
Data Typedimension
Timing Event End
Field IDtiming_event_end
TypeNUMBER
Data Typedimension
Consent Source
Field IDconsent_source
TypeTEXT
Data Typedimension
Consent Form Button
Field IDconsent_form_button
TypeTEXT
Data Typedimension
Consent Scope
Field IDconsent_scope
TypeTEXT
Data Typedimension
Consent Action
Field IDconsent_action
TypeTEXT
Data Typedimension
Consent Type Analytics
Field IDconsent_type_analytics
TypeBOOLEAN
Data Typedimension
Consent Type AB Testing Personalization
Field IDconsent_type_ab_testing_personalization
TypeBOOLEAN
Data Typedimension
Consent Type Conversion Tracking
Field IDconsent_type_conversion_tracking
TypeBOOLEAN
Data Typedimension
Consent Type Marketing Automation
Field IDconsent_type_marketing_automation
TypeBOOLEAN
Data Typedimension
Consent Type Remarketing
Field IDconsent_type_remarketing
TypeBOOLEAN
Data Typedimension
Consent Type User Feedback
Field IDconsent_type_user_feedback
TypeBOOLEAN
Data Typedimension
Consent Type Custom 1
Field IDconsent_type_custom_1
TypeBOOLEAN
Data Typedimension
Event Custom Dimension 1
Field IDevent_custom_dimension_1
TypeTEXT
Data Typedimension
Event Custom Dimension 2
Field IDevent_custom_dimension_2
TypeTEXT
Data Typedimension
Event Custom Dimension 3
Field IDevent_custom_dimension_3
TypeTEXT
Data Typedimension
Event Custom Dimension 4
Field IDevent_custom_dimension_4
TypeTEXT
Data Typedimension
Event Custom Dimension 5
Field IDevent_custom_dimension_5
TypeTEXT
Data Typedimension
Event Custom Dimension *
Field IDevent_custom_dimension_*
TypeTEXT
Data Typedimension
Event Custom Variable Key 1
Field IDevent_custom_variable_key_1
TypeTEXT
Data Typedimension
Event Custom Variable Value 1
Field IDevent_custom_variable_value_1
TypeTEXT
Data Typedimension
Event Custom Variable Key 2
Field IDevent_custom_variable_key_2
TypeTEXT
Data Typedimension
Event Custom Variable Value 2
Field IDevent_custom_variable_value_2
TypeTEXT
Data Typedimension
Event Custom Variable Key 3
Field IDevent_custom_variable_key_3
TypeTEXT
Data Typedimension
Event Custom Variable Value 3
Field IDevent_custom_variable_value_3
TypeTEXT
Data Typedimension
Event Custom Variable Key 4
Field IDevent_custom_variable_key_4
TypeTEXT
Data Typedimension
Event Custom Variable Value 4
Field IDevent_custom_variable_value_4
TypeTEXT
Data Typedimension
Event Custom Variable Key 5
Field IDevent_custom_variable_key_5
TypeTEXT
Data Typedimension
Event Custom Variable Value 5
Field IDevent_custom_variable_value_5
TypeTEXT
Data Typedimension
Event Custom Variable Key *
Field IDevent_custom_variable_key_*
TypeTEXT
Data Typedimension
Event Custom Variable Value *
Field IDevent_custom_variable_value_*
TypeTEXT
Data Typedimension
Session Custom Dimension 1
Field IDsession_custom_dimension_1
TypeTEXT
Data Typedimension
Session Custom Dimension 2
Field IDsession_custom_dimension_2
TypeTEXT
Data Typedimension
Session Custom Dimension 3
Field IDsession_custom_dimension_3
TypeTEXT
Data Typedimension
Session Custom Dimension 4
Field IDsession_custom_dimension_4
TypeTEXT
Data Typedimension
Session Custom Dimension 5
Field IDsession_custom_dimension_5
TypeTEXT
Data Typedimension
Session Custom Dimension *
Field IDsession_custom_dimension_*
TypeTEXT
Data Typedimension
Session Custom Variable Key 1
Field IDsession_custom_variable_key_1
TypeTEXT
Data Typedimension
Session Custom Variable Value 1
Field IDsession_custom_variable_value_1
TypeTEXT
Data Typedimension
Session Custom Variable Key 2
Field IDsession_custom_variable_key_2
TypeTEXT
Data Typedimension
Session Custom Variable Value 2
Field IDsession_custom_variable_value_2
TypeTEXT
Data Typedimension
Session Custom Variable Key 3
Field IDsession_custom_variable_key_3
TypeTEXT
Data Typedimension
Session Custom Variable Value 3
Field IDsession_custom_variable_value_3
TypeTEXT
Data Typedimension
Session Custom Variable Key 4
Field IDsession_custom_variable_key_4
TypeTEXT
Data Typedimension
Session Custom Variable Value 4
Field IDsession_custom_variable_value_4
TypeTEXT
Data Typedimension
Session Custom Variable Key 5
Field IDsession_custom_variable_key_5
TypeTEXT
Data Typedimension
Session Custom Variable Value 5
Field IDsession_custom_variable_value_5
TypeTEXT
Data Typedimension
Session Custom Variable Key *
Field IDsession_custom_variable_key_*
TypeTEXT
Data Typedimension
Session Custom Variable Value *
Field IDsession_custom_variable_value_*
TypeTEXT
Data Typedimension
Local Hour
Field IDlocal_hour
TypeNUMBER
Data Typedimension
Product Name
Field IDproduct_name
TypeTEXT
Data Typedimension
Product SKU
Field IDproduct_sku
TypeTEXT
Data Typedimension
Product Brand
Field IDproduct_brand
TypeTEXT
Data Typedimension
Product Variant
Field IDproduct_variant
TypeTEXT
Data Typedimension
Product Price
Field IDproduct_price
TypeNUMBER
Data Typedimension
Product Quantity
Field IDproduct_quantity
TypeNUMBER
Data Typedimension
Product Revenue
Field IDproduct_revenue
TypeNUMBER
Data Typedimension
Product Category
Field IDproduct_category
TypeTEXT
Data Typedimension
Product Category 1
Field IDproduct_category1
TypeTEXT
Data Typedimension
Product Category 2
Field IDproduct_category2
TypeTEXT
Data Typedimension
Product Category 3
Field IDproduct_category3
TypeTEXT
Data Typedimension
Product Category 4
Field IDproduct_category4
TypeTEXT
Data Typedimension
Product Category 5
Field IDproduct_category5
TypeTEXT
Data Typedimension
Product Dimension 1
Field IDproduct_dimension1
TypeTEXT
Data Typedimension
Product Dimension 2
Field IDproduct_dimension2
TypeTEXT
Data Typedimension
Product Dimension 3
Field IDproduct_dimension3
TypeTEXT
Data Typedimension
Product Dimension 4
Field IDproduct_dimension4
TypeTEXT
Data Typedimension
Product Dimension 5
Field IDproduct_dimension5
TypeTEXT
Data Typedimension
Product Dimension *
Field IDproduct_dimension*
TypeTEXT
Data Typedimension
Product Count
Field IDproduct_count
TypeNUMBER
Data Typedimension
Redirections Time
Field IDredirections_time
TypeNUMBER
Data Typedimension
Domain Lookup Time
Field IDdomain_lookup_time
TypeNUMBER
Data Typedimension
Server Connection Time
Field IDserver_connection_time
TypeNUMBER
Data Typedimension
Server Response Time
Field IDserver_response_time
TypeNUMBER
Data Typedimension
Page Rendering Time
Field IDpage_rendering_time
TypeNUMBER
Data Typedimension
IPv4 Address
Field IDipv4_address
TypeTEXT
Data Typedimension
IPv6 Address
Field IDipv6_address
TypeTEXT
Data Typedimension
Website Name
Field IDwebsite_name
TypeTEXT
Data Typedimension
Product Name Array
Field IDproducts.name
TypeTEXT
Data Typedimension
Product SKU Array
Field IDproducts.sku
TypeTEXT
Data Typedimension
Product Price Array
Field IDproducts.price
TypeTEXT
Data Typedimension
Product Quantity Array
Field IDproducts.quantity
TypeTEXT
Data Typedimension
Product Revenue Array
Field IDproducts.revenue
TypeTEXT
Data Typedimension
Product Brand Array
Field IDproducts.brand
TypeTEXT
Data Typedimension
Product Variant Array
Field IDproducts.variant
TypeTEXT
Data Typedimension
Product Category Array
Field IDproducts.category
TypeTEXT
Data Typedimension
Product Category 1 Array
Field IDproducts.category1
TypeTEXT
Data Typedimension
Product Category 2 Array
Field IDproducts.category2
TypeTEXT
Data Typedimension
Product Category 3 Array
Field IDproducts.category3
TypeTEXT
Data Typedimension
Product Category 4 Array
Field IDproducts.category4
TypeTEXT
Data Typedimension
Product Category 5 Array
Field IDproducts.category5
TypeTEXT
Data Typedimension
Product Dimension 1 Array
Field IDproducts.dimension1
TypeTEXT
Data Typedimension
Product Dimension 2 Array
Field IDproducts.dimension2
TypeTEXT
Data Typedimension
Product Dimension 3 Array
Field IDproducts.dimension3
TypeTEXT
Data Typedimension
Product Dimension 4 Array
Field IDproducts.dimension4
TypeTEXT
Data Typedimension
Product Dimension 5 Array
Field IDproducts.dimension5
TypeTEXT
Data Typedimension
Product Dimension * Array
Field IDproducts.dimension*
TypeTEXT
Data Typedimension
Year Month Day
Year Month Day such as 20240401.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field IDweek
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Day of the week
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the year
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension