hevo + looker studio is driving me crazy. attribution is a complete mess.

trying to stitch together our meta ads data, hubspot pipeline, and stripe billing to see actual ROI per campaign. we piped everything into bigquery using hevo and built a looker studio dashboard but the data just doesn't match up. standard google attribution is garbage. are platforms like hockeystack or anytrack actually worth the premium price for B2B multi-touch attribution?