How are people getting Adwords data into Metabase? There are two ways we have been looking at: Connect Adwords to Google Analytics and pull data from there. It’s somewhat limited in that there are fields that aren’t coming over from Adwords into GA.
Use Stitch to pull Adwords data into BigQuery or Redshift. The downside to this is that the fields that come over are also somewhat limited. In our execution, we use Adwords OrderID as the foreign key. Stitch (currently) doesn’t support pulling that field.
Hey @samyount we use the way you mentioned with Adwords and GA but if you want all data, I recommend using Segment. You can add Adwords as a source and then a warehouse of your choice (we use Postgres).