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

Community

Connector Improvement: Google Ads - Custom reports - without segments to get zero-metric data

Answered
Marton Nagy User

Dear Fivetran team,

We have a hard deadline to migrate from Adverity to Fivetran by the end of September 2024, however we cannot because of the required segments on the Google Ads Custom reports.

There are 4 datastreams we have on Adverity that are affected, listed here in the table:

Name

Report Type

Resource Lvl.

Attributes

ZERO_IMPRESSIONS_AD_GROUP_AD_STATE_ADVERITY_ADWORDS

Custom

Ad group ad

Ad group id, Ad group, Ad group state, Campaign, Campaign id, Campaign State, Ad state

ZERO_IMPRESSIONS_AD_GROUP_ADVERITY_ADWORDS

Custom

Ad group bid modifier

Currency, Client name, Ad group ID, Ad group, AD group state, Ad group type, Campaign, Campaign ID, Campaign state, Default max. CPC

ZERO_IMPRESSIONS_CAMPAIGN_ADVERITY_ADWORDS

Custom

Campaign Criterion

Campaign Criterion bid modifier, Campaign ID, Campaign, Campaign state, Start date, End date, Base campaign ID

ZERO_IMPRESSIONS_KW_PERFORMANCE_ADVERITY_ADWORDS

Custom

Keyword View

Client name, Ad group ID, Ad group state, Campaign ID, Campaign, Campaign State, Ad group CPC bid, Ad group Criterion Keyword text, Ad group Criterion ID, Ad Group Criterion Status, Ad Group Criterion Serving status, Ad Group Criterion effective CPC bid source, Ad group Criterion Keyword match type, Ad Group Criterion Quality score, Ad Group Criterion is negative, Bid strategy type (campaign)



Google Ads API only returns zero-metric data if we omit segments, source: https://developers.google.com/google-ads/api/docs/reporting/zero-metrics

Getting these reports without segments is essential for us, so that we can get zero-impression data. Fivetran forbids this behavior, by forcing us to use segments, to be able to perform incremental updates. We want to opt out of this behavior, so we can get our zero-impression data.

We request that the Fivetran Google Ads custom reports be made possible to create without any segments, so we can recreate our zero impression data streams.

Of course, any other solution you could provide to allow downloading the zero impression data we download currently with the above listed Adverity Custom reports would suffice as well.

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Lucas Alexander Fivetranner
    • Edited

    Hi Marton,

    Luke from the Product team. Thanks for submitting this feature request. 

    I want to ensure I understand your requirements and use case. What do you use these reports for? Is it to detect keywords, campaigns, etc. that have zero impressions so that your Marketing team can pause/remove them? You also didn't list any metrics, in the table you shared. Are you only including impressions or are there other metrics in these reports?

    Google's docs are a bit vague on this topic. In the same document you linked, they state "Rows whose selected metrics are all zero won't be returned": https://developers.google.com/google-ads/api/docs/reporting/zero-metrics#rows_returned. This is written below the section you referenced, stating "Zero metrics are always excluded when segmenting a report, provided all selected metrics are zero". That suggests that even if segments aren't used, rows where metrics are all zero will be filtered. The confusing part is that the example query in this final section includes segments.date. 

    So I want to confirm: with Adverity you receive rows when all metrics in the table are equal to zero and segments aren't used?

    Thanks in advance for your input!

  • Marton Nagy User

    Hi Lucas,

    Thanks for your reply. 

    Most importantly, yes, we do receive lots of rows with Adverity with these configs. And Google Ads API also returns rows for such queries. So, please test it yourself as well, as that is more definite then the Google API documentation that is up for interpretation. We also use these data streams every day for years.

    Yes, in part we use this data to tell if the resource is enabled or paused, even if it has no impressions.

    We leave the metrics settings field empty on Adverity. Here is a screenshot of the config of one of our zero impression data streams:

    Please, reach out to me if there is any more info we can provide!

  • Marton Nagy User

    Hi, can we get an update about this? 

    Again, this is something that Google Ads API returns data for and Adverity returns data for, but Fivetran does not. We would only like to ask for data available normally.

    Thanks,

     

    Marton