How to query smart goals from the Google analytics export in Bigquery?

Question

In my GA account, I have a smart goal set up. I have got the GA raw data export in BQ. I have already written a query to get goals which are either destination or event-based. Now I want to query the smart goal. As the smart goal does not have any specific definition, I need help with how we can query this data. Thanks!

Answer 1

Create a segment on GA for smart goals.

• Advanced > Conditions > Filter sessions to include smart goal completes per session > 0

Add the segment on BQ and export.