Stackoverflow #67888711

main.py

fields = ["campaign.id", "segments.device"]

query = """
        SELECT {fields}
        FROM campaign 
        WHERE segments.date = '{date}'
        LIMIT 10
""".format(
  fields=",".join([str(f) for f in fields]),
  date="210611",
)

response = ga_service.search_stream(
  customer_id=customer_id,
  query=query,
)

for batch in response:
    for row in batch.results:
        for field in fields_list:
            print("{field}: {value}".format(
              field=field,
              value=row[field],
            ))