Composite metrics of arbitrary complexity, and no special cases
Example. You can define Cost per Sale (CPS) as Cost / Sales.
Read post →The Bright Analytics blog.
Thoughts about marketing analytics, the role of the semantic layer, the challenges of building an analytics platform, the risks & rewards of AI, platform updates and other geeky topics.
How to Build a Single Source of Truth for Marketing Analytics
It's a catch-all for clarity, alignment and trust. The CFO and the social media exec working from the same numbers, derived the same way, from the same raw…
Read post →Cost per Incremental Reach: The KPI Ad Platforms Won't Give You
Impressions tell you your ads are delivering. Reach tells you how many people saw them. But neither tells you whether you're still reaching new people - or…
Read post →What is CRC32? Why is it useful?
Have you heard about CRC32? It's a lightweight hashing algorithm originally designed to detect errors in data transmission. In SQL, we can use CRC32 to quickly…
Read post →Common Table Expressions (CTEs)
A Common Table Expression, or CTE, is a way to create a temporary, named result set within a SQL query. Think of it as a short-lived, virtual table that exists…
Read post →The 'Modern Data Stack' : is it all it's cracked up to be?
The promise of the modern data stack is a seductive one: pick the best tools for each job, plug them together, and watch the insights flow.
Read post →Track Your Organic Search Rankings with AccuRanker
If you're using AccuRanker to track the performance of your SEO work — or keep an eye on your competitors — you can now bring that data straight into Bright…
Read post →GA4's 'Engaged Sessions' is a terrible KPI
GA4's 'Engaged Sessions' is a terrible KPI and potentially a very misleading way to measure engagement.
Read post →Salesforce API for Bright Analytics
Salesforce is one of the most popular and powerful CRMs in the market.
Read post →Two Factor Authentication & Single Sign-On Support
Bright Analytics supports 2 Factor Authentication for all user accounts.
Read post →Making the most of your marketing data
Businesses are generating more and more data at an ever-increasing velocity, sometimes resulting in hundreds of data sets circulating within multiple…
Read post →