Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Request additional custom reports from the Google Ads connector

lee heesun User

hello

I have been using Fivtran products well.

There is one additional part required.
The url of the asset.

It is not extracted by Ad Group Asset Report.

You need to extract the data of Google Ads Asset.
Reference: https://developers.google.com/google-ads/api/fields/v14/asset_query_builder

I would like to receive a report of the contents tested with the query builder above through the Google Ads Connector.

The image url cannot be extracted unless it is the above method.

Request to add this feature.

thank you

Please sign in to leave a comment.

Comments

5 comments

Date Votes
  • Official comment
    Drew Fivetranner

    Hi, Drew from the product team here.

    Could you share more about the specific configuration of the request you need? Dimensions and Metrics?

    Is there a reason that the custom report feature of the connector does not solve your needs currently?

  • lee heesun User

    It seems that the same explanation was given a long time ago or twice by e-mail.

    I can't explain clearly, so it's going to be a bit long.

    SELECT customer.id (http://customer.id/), asset.id (http://asset.id/), asset.image_asset.file_size, asset.image_asset.full_size.height_pixels, asset.image_asset.full_size.url, asset.image_asset.full_size.width_pixels, asset.source, asset.type FROM asset

    There is no Customer Report running the above query.

    What I need is the asset.image_asset.full_size.url column.

     

    Perhaps in the ERD, it will be the position in the picture below.

     

    Facebook Ads provides an image URL for each ad unit.

    Google supports Asset Resource IDs, but there are no tables that can be joined to each other.

     


    Is my explanation good enough?

  • Drew Fivetranner

    Ah, I understand. You would like a table to represent this endpoint: https://developers.google.com/google-ads/api/reference/rpc/v14/Asset

    This could be used in conjunction with AdGroupAsset to link up assets with the ad groups they are related to.

    It looks like AdGroupAdAssetView is only applicable to certain types of ads so might not be optimal.

    Would that solve your needs?

  • lee heesun User

    No, AdGroupAdAssetView doesn't solve the problem...

     


    Anything that should come out as a URL is not extracted.

     


    Can't you add that asset table?

  • lee heesun User

    My content is behind.

    There are different functions that take a long time to solve this part...?