The Bright Analytics Blog

Marketing analytics blog covering everything from the challenges of delivering transformation projects, getting the most from data platform APIs, and technical tips and SQL tricks.

Composite metrics of arbitrary complexity, and no special cases

the proliferation and variation of marketing data means that without a single source of truth there is chaos.

How to Build a Single Source of Truth for Marketing Analytics

Cost per Incremental Reach: The KPI Ad Platforms Won’t Give You

an image of library books on a shelf.

Technical Tips & Tricks

What is CRC32? Why is it useful?

a drawing of a programmer looking at lots of complications data visualisations

Technical Tips & Tricks

Common Table Expressions (CTEs)

The ‘Modern Data Stack’ : is it all it’s cracked up to be?

Track Your Organic Search Rankings with AccuRanker

Two Factor Authentication & Single Sign-On Support

Salesforce API for Bright Analytics

screenshot of GA4 reporting interface

GA4’s ‘Engaged Sessions’ is a terrible KPI

Making the most of your marketing data