Build a Pivot From Transaction Grain

before-after step-trail try-feedback A click-level source table repeats campaign budget on every click row, making Pivot table budget totals explode. Declare grain, separate facts by grain, then pivot additive measures only The visible shortcut is to keep campaign budget beside each click because it is convenient for filtering, but the pivot treats every repeated budget value as another amount to sum. Declare source grain Write "one row = one ad click" above the clean source table. This sentence tells you which measures can safely sum. Click cost can sum; campaign budget cannot sum at click grain without special handling. Move…

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in