Retrieving Klaviyo profiles associated with specific lists from BigQuery tables

Summary

The user is looking for guidance on how to retrieve Klaviyo profiles associated with specific lists from BigQuery tables.


Question

Hi <#C021JANJ6TY|>,

I have fetched Klaviyo data through Airbyte and loaded it into BigQuery tables.
Now, I need to retrieve all profiles and its data that are associated with specific lists present in Klaviyo.

Could anyone guide me on how I can achieve this from BigQuery tables? Are there any specific joins or filters I should apply to get profiles for particular lists?

Thanks in advance for your help!



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["klaviyo-data", "bigquery-tables", "profiles", "specific-lists", "joins", "filters"]