Connector Improvement: Viewing Rows By Account
CompletedHi There,
I believe an excellent feature request would be to provide, at the account level, how many rows specific accounts are using up. This would particularly useful for the google analytics reports (there is presently a feature request open on this that is similar, but has been sitting for a while). Accounts is a general name, some connectors may have one account with multiple advertisers, in this case, seeing the advertiser ID would be useful.
As it stands, Google Analytics doesn't have the ability to see the account ID's, only the view and property IDs. If we were able to make the Account ID and name a primary key in all reports for GA, it would help tremendously with organizing data and determining usage at the account level.
For usage, he same goes for the other connectors as well. If at all possible, depending on the connector, adding either the advertiser_ID, or the account ID, to the Fivetran audit for each connector would make a world of difference.
-
Official comment
Hi Collin, Drew from the Product Team here.
Our Google Analytics 4 connector now supports the Admin API and has a metadata schema including a PROPERTY and ACCOUNT table. Using these, you should be able to get account information joined to reports.
Please sign in to leave a comment.
Comments
1 comment