Blog

Insights and updates from the Nexus team

Metric Definitions Should be Maintained in DBT

Metric Definitions Should be Maintained in DBT

Your data dictionary (or semantic layer) should live in dbt — defined once, compiled to metadata on every build, and never maintained in a separate tool.

Kevin McLaughlin
11 min read

How We Handled Sensitive Salesforce Data Without Pulling It Into the Warehouse

A financial services client needed to check if Social Security Numbers existed in Salesforce without ever moving them into the data warehouse. Here is how we solved it.

Kevin McLaughlin
4 min read

Send Complete Conversion Data to Facebook CAPI and Google Ads from the Data Warehouse

How we track offline conversions for Facebook CAPI, Google Ads Enhanced Conversions, and other marketing platforms using the data warehouse and reverse ETL — and why it's the right approach.

Kevin McLaughlin
8 min read

Get Marketing Attribution Data in Your CRM with Google Tag Manager

How to use Google Tag Manager to capture landing page URLs, referrers, and UTM parameters in hidden form fields — so every form submission carries full attribution data into your CRM.

Kevin McLaughlin
14 min read

Dbt-Nexus - Data Beyond Dashboards

How to structure your data warehouse with dbt-nexus to actually help you close sales and speed up custom support.

Kevin McLaughlin
12 min read

Google Tag Manager and Datalayer Flow

How the datalayer works with Google Tag Manager

Kevin McLaughlin
1 min read

Storing Google Ads GCLID in Google Analytics

How and why to store the Google Ad’s “Google Click Identifier” in Google Analytics.

Kevin McLaughlin
4 min read

Add Google Analytics Client Ids to Form Submissions

How to link your Google Analytics and form data together by submitting Client IDs with form submissions using Google Tag Manager.

Kevin McLaughlin
4 min read

What Are APIs

and why they matter even if you’re not a programmer.

Kevin McLaughlin
7 min read

The Six Sins of CRMs

Six major pitfalls to avoid Customer Relationship Management hell.

Kevin McLaughlin
5 min read

Tracking Thank You Page Conversions in Google Analytics

A better way to track destination goals in Google Analytics

Kevin McLaughlin
6 min read

Filtering Out Your Hits From Google Analytics

The best way for Google Analytics teams and consultants to filter out their own data.

Kevin McLaughlin
5 min read

Track Content Taxonomies with a Google Tag Manager Custom Template

Track taxonomies like categories and tags in Google Analytics with this Google Tag Manager custom template.

Kevin McLaughlin
6 min read

Capture wpForms in GTM

How to detect and capture wpForm submits and data with Google Tag Manager

Kevin McLaughlin
5 min read