Get Adwords campaign id information on Firebase Analytics

[Jerry Wee]

Hi Team,

We are using Firebase for our App, and has linked our Google AdWords and Big Query.

Now we have exported the Google Analytics for Firebase data to Big Query. In the Big Query‘s analytics dataset, about an event's Campaign information, we can just get the Campaign's name from 'traffic_source.name' field. But can not get the Campaign's id from any field. 

How can we get the Campaign id information?

Thanks,

Jerry