Posts tagged with api

I'm writing a code to load data from Google Ads api to BigQuery table by using Cloud Functions, the process query a table called ad_group_ad but i'm struggling when trying to validate if there's duplicated rows at my destination.

By reading the docs I was expecting to find some attribute used to identifier a column or a group of columns that represents the table key. May this question seem obviously but i ain't having progress when trying to google this.

Is there a way to identifies if there's is duplicated rows? I'm not using any group by instruction when collecting, just a simple select like the example below:

SELECT     segments.ad_network_type,     campaign.name,     ad_group.name,     ad_group.id,     so     on,     and,     so,     forth FROM ad_group_ad WHERE segments.date = ? 

I am using Adwords API. But the support for Adwords will end in 2022. I want to migrate to new Google Ads API. I want to know the equivalent of AD_PERFORMANCE_REPORT(which was in Adwords) in Google Ads.

For example, the equivalent for KEYWORD_PERFORMANCE_REPORT is keyword_view.

I tried to find it a lot but couldn't get it.

Thanks in advance.

I've been tasked to extract the period comparison data from Google Ads. At the moment a user can select a comparison date period in the ads.google.com UI, to see percentage growth of their ads, from one period to another.

I'd like to extract these comparison percentages from their API.

Does anyone know if this is even possible, or do I have to calculate them myself?

I've read through the API docs, but I'm afraid I missed something.

image of google ads ui