Data Blending in Looker Studio: Joins, Metrics and the Traps in Between
How a blend really works — aggregate first, join second — what each of the five join types does, why one extra dimension can multiply every number, and why summing a metric across several properties needs the field renamed before the arithmetic can be trusted.