Skip to main content

Data References

Introduction​

The Reference section serves as your comprehensive documentation library for data provided by Data and Measurement. This is where the data team, and stakeholders can find detailed specifications and field definitions.

Whether you're building custom reports, setting up new campaigns, or need to understand the underlying data structure, this section is a great starting point.

What You'll Find Here​

Complete Data Specifications​

  • Documented fields across different advertising platforms
  • Detailed data type definitions and source mappings

Reference Documentation Structure​

📖 Comprehensive Field Library​

Your complete guide to every data field in Big Query

What's Inside:

  • Analytics Properties - Google Analytics 4 and Universal Analytics field mappings
  • Campaign Dimensions - Platform-specific campaign structure and hierarchy
  • Performance Metrics - All measurement fields including impressions, clicks, conversions
  • Custom Calculations - Thrive-specific derived metrics and KPIs

🛠️ Standard Fields and thier Transformation Logic​

What's Inside:

  • Currency Standardization - Multi-currency normalization (850+ transformations)
  • Campaign Status Logic - How platform statuses are unified
  • Geographic Mapping - Location data standardization across platforms
  • Time Zone Handling - UTC conversions and local time calculations
  • Data Type Casting - String, numeric, and date field processing
  • Quality Assurance Rules - Validation and cleansing procedures

Perfect For:

  • Understanding data transformations
  • Troubleshooting discrepancies
  • Building custom calculations
  • Data quality validation

Search & Discovery Tips​

  • Use Field Search: Type field names in the search bar to find specific documentation
  • Metric Categories: Browse by metric type (impressions, conversions, revenue, etc.)

Contributing to Documentation​

Found an error or need additional documentation? Here's how to help:

  • Field Clarifications: Email data team with specific field questions
  • Missing Documentation, Error Reporting, Enhancement Requests : Request new field documentation via support ticket

Reference Index​