Warehousing: BigQuery Setup Instructions
This page will guide you through enabling the BigQuery integration for the first time. Requirements. In order to successfully to set up your BigQuery integration, you will need: A Google Cloud Platfo…
Updated
Getting Started
Rockerbox Overview & Core Concepts
What we are Solving For
Building Your Foundational Dataset
Core Data Types
Tracking Your Conversion Activity
Tracking Your Marketing Activity
Marketing Touchpoints - How We Track
Rockerbox Tracking by Vendor
Deduplicating Events
Building a Path to Conversion - Mobile
Can I track purchases on the Tiktok or Meta shop?
Ingesting Your Spend
Attribution Methodology
Attribution Overview
Attribution types in Rockerbox
What is De-duplication?
Direct Traffic
Why performance in Rockerbox looks different
Attribution Windows ("Lookback Window")
Multi-Touch Attribution Model
Mapping Your Data
Onboarding Overview
Onboarding Requirements
What to Expect - Onboarding
Key Stages of Onboarding
What to Expect - Post Onboarding
Rockerbox Training
Rockerbox Support
Maintaining Rockerbox
Launching New Channels and Partners
Maintaining consistent naming conventions
Migrating to a Shopify Headless Site Build
Adding & Removing Users
Maintaining Vendor Integrations
Finding Your Account ID (Pixel Source Name)
FAQ
Privacy
FAQs
Tracking Marketing Touchpoints
Parameters, Pixels, and Batch Spend Reports
How does Rockerbox handle campaign name changes?
What are synthetic events?
Can I use my own custom UTMs instead of Rockerbox tracking parameters?
Excluding Parameters from GA
Should I be concerned with my URL length?
Discrepancies
Discrepancies between internal data and Rockerbox data
What is Deduplication? Why do Platforms take Full Credit?
Why are conversion counts in Facebook different than Rockerbox?
Rockerbox last touch vs. GA last touch
Discrepancies between Ad Platforms and Rockerbox
Accounting for 3rd Party Purchases (ex. Amazon, Etsy)
Tracking On-Site Activity
Returns- Ingesting and Understanding the Impact
If I have webhooks, can I turn off the onsite pixel?
My website uses a Single-Page Application (SPA) framework? Will that work with Rockerbox?
Will the Rockerbox pixel code slow down my website?
When does the Rockerbox cookie expire?
UI Access
Use Case FAQ
How to normalize performance for "walled gardens"
Impact of iOS14 Changes on Broader Marketing (Agnostic of Rockerbox)
How to exclude certain spend or marketing touchpoints from Rockerbox reporting
Understanding strong ROAS or CPA for bottom funnel channels
How to normalize historical in-platform reporting pre-Rockerbox
Can I use a Conversion Event as a Marketing Event for another Conversion?
Why would a retargeting vendor get 1st touch credit?
Direct Mail Spend Amortization
Conversion Discrepancy
Partners & Integrations
Rockerbox Core Integrations
Paid Search
Paid Social
Facebook / META (Auto Append)
Facebook (Manual Append)
Pinterest - Viewthrough Integration
Snapchat
TikTok
TikTok (Manual Append)
Display
Ecommerce Platforms
Customer Data Platforms (CDPs)
Tag Managers
Rockerbox Premium Integrations
Affiliate
Direct Mail
Linear TV & OTT
Simulmedia Linear
Bliss Point Media OTT/Linear
Eicoff Linear TV
Tatari OTT & Linear
MMSI
Marketing Architects (Linear)
Comcast Linear TV
Hulu
ID Media
TargetSpot
Direct Avenue
StackAdapt (OTT)
TV Scientific
Simulmedia OTT
Streaming Audio & Podcasts
Data Warehouses
Display & Native
Taboola
DCM Tags
Using DCM Tags
PowerInbox
The Trade Desk
LiveIntent View Feature
Display & Video 360 (DV360)
AcuityAds (Illumin)
AdForm
MediaMath
AdRoll
MediaAlpha
Outbrain
StackAdapt (Display)
Xandr (AppNexus)
RTB House
LiveIntent
Quantcast
Hivewyre
Fastg8
Adelphic
Zeta Global
Yahoo DSP (formerly Verizon Oath)
Wunderkind
AdTheorent
Amobee
AdMedia
Paid Search
Call Centers
Post Purchase Survey
Mobile Measurement Partners (MMPs)
Marketing Partner Integrations
MNTN
Setup and Technical Documentation
Conversion Events
Conversion Events Overview
Historical Conversion Data
In-App Conversion Events
Advanced Conversion Events
Online Conversion Events
General Conversion Tracking
Exclusions
Custom Tracking Domain (CNAME)
Custom Tracking Domain (CNAME) Overview
In Segment - Custom Tracking Domain (CNAME)
Turn Off Cloudflare Proxy
Standard Conversion Data Formats
Verifying Conversion Pixels are Firing
BugSnag
Identify Calls
Ingesting Address Data
Conversion Tracking Methods
Conversion Event Breakouts
Conversion QA
Retail Data
Marketing Activity
How Rockerbox Tracks Your Marketing Channels
Linear TV
Customer Service
Direct Mail
OTT
Podcasts & Streaming Audio
Non-Paid & Organic
Synthetic Events
Hard to Track Channels
Post Purchase Surveys
Post Purchase Surveys Overview
Sending Rockerbox Survey Data
Recommendations for Survey Response Options
How to organize and map survey responses
Amazon DSP: UTM tracking
Overview of Tracking "Hard to Track" Channels
Allowed Domains
How Rockerbox Attributes Touchpoint Credit
Promo Codes
Spend
API Integrations
AdWords Manager Accounts
Spend: API Integrations
Re-Authenticating Accounts
Facebook Ads Account
Outbrain: Requesting API Access
Reddit: Requesting API Access
Microsoft Advertising Account (Bing)
Google Error: "This app is blocked"
Deleting an Authenticated Account
Updating Facebook Permissions during authentication
Historical Data
Rockerbox Data Exports
Report Types and Use Cases
Buckets Breakdown Report
Platform Performance Report
Attributed Performance Report
Attributed Performance Report Overview
Attributed Performance Report - Primary Use Cases
Schema: Attributed Performance Report
Reporting: Report Types & Use Cases
Exporting Reports from the UI (Standard Exports)
Google Sheets Data Sync
Data Warehousing
Data Warehousing Overview
Warehousing: Technical Overview
Warehousing: Adding Datasets
Warehousing: Sync Status
What is Data Warehousing?
Warehousing: Buckets Breakdown Changelog Monitoring
Setup Instruction per Data Warehouse
Snowflake
Redshift
Warehousing: Redshift Setup Instructions
Step 1: Redshift Data Warehouse Setup
Step 2: Redshift Data Warehouse Setup
Step 3: Redshift Data Warehouse Setup
Step 4: Redshift Data Warehouse Setup
Big Query
Warehousing: Getting Started
Data Schemas
Data Warehouse Schemas Overview
Platform Performance Schemas
Schema: Data Warehouse - Platform Performance - Facebook
Schema: Data Warehouse - Platform Performance - Google
Schema: Data Warehouse - Platform Performance - LinkedIn
Schema: Data Warehouse - Platform Performance - Bing
Schema: Data Warehouse - Platform Performance - Pinterest
Schema: Data Warehouse - Platform Performance - TikTok
Schema: Data Warehouse - Platform Performance - Snapchat
Rockerbox Dataset Schemas
Data Warehouse Use Case Library
Rockerbox UI
Data (Collect, Track and Exports)
Dashboard
Attribution
Cross Channel Report
Cross-Channel Attribution Report
Custom Credit Allocation
Time Period Comparison
Modifying Reporting Columns in the UI
Channel Performance
Journeys
MMM
Marketing Mix Modeling
MMM - Implementation Timeline
MMM - Guidelines for Feature Selection
MMM Feature Metrics - Spend, Impressions, or Clicks
MMM - Including Non-Spend Features
Model Fit for MMM
Bayesian Methodology
Setting Priors
MMM - Marketing Performance
MMM - Channel Overview
MMM - Scenario Planner
MMM - Model Comparison
Benchmarks
Use Case Guides
Priority Use Cases
In Channel Optimizations
Seeing Performance on Channel and Placement Level
Daily Tactical Optimizations in Rockerbox
Weekly Tactical Optimizations in Rockerbox
Setting a de-duplicated Performance target in Rockerbox
Comparing Platform-Reported Performance to Rockerbox De-duplicated Performance
Measuring Channel Heavy-ups (Increased spend) & Resulting impact to CPA/ROAS (Diminishing returns)
Comparing Performance across Time Periods
How to tell whether your prospecting channel is working
Evaluating TOF performance
Determining Optimal Spend by Channel
Determining optimal budget allocation in Rockerbox
How to leverage time to convert and payback periods to determine where to cut spend
When to use multipliers when leveraging Rockerbox for financial forecasting & budgeting
New Channel Testing
Understanding User Path to Conversion
Identifying the role of each channel across the funnel
How to Quantify the Impact of an increase in Branding spend on Demand driven channels
Understanding the Impact of each channel
Understanding Influencer Impact
Channel Overlap Use Cases
Budgeting & Forecasting
Financial Forecasting & Budgeting with Rockerbox
Planning and budgeting against baseline performance
Understanding User Behavior Across Rockerbox Views
Tips & Guides
Cadence of Rockerbox Use
Your Holiday Guide
Tips for Performance Recap Analysis
Tips for leveraging Rockerbox to understand performance during an Economic downturn
Tips for Handling Spend Heavy Ups and Pacing
Preparing for a sale in Rockerbox
Leveraging MTA with MMM
Evaluating a New Product Launch in Rockerbox
Preparing for a sale in Rockerbox (Full)
Rockerbox for Agencies
Rockerbox for Marketing Partners
All Categories > Rockerbox Data Exports > Data Warehousing > Setup Instruction per Data Warehouse > Big Query
Big Query
1 article