I'm migrating from Adwords API to Google Ads API. On Adwords API we have the click_performance_report which includes keyword id and ad group ad id. However, in Google Ads API, when querying using click_view, I can't find the corresponding fields. All I see is keyword and ad group ad fields but both return resource_name and I prefer not to parse it myself in order to get the id. What's the best way to get the keyword id and ad group ad id using Google Ads API?

 library(rgoogleads)  library(gargle)  token <- token_fetch()  token gads_auth(email = 'xx@gmail.com' Authentication complete.      ad_group_report <- gads_get_report(        resource    = "ad_group",        fields      = c("ad_group.campaign",                        "ad_group.id",                        "ad_group.name",                        "ad_group.status",                        "metrics.clicks",                        "metrics.cost_micros"),        date_from   = "2021-01-08",        date_to     = "2021-01-10",        where       = "ad_group.status = 'ENABLED'",        order_by    = c("metrics.clicks DESC", "metrics.cost_micros")      ) i Multi account request ! The request you sent did not return any results, check the entered parameters and repeat the opposition. 

Why do I receive this error? I have never received it in Radwords package. Where do I mention the argument for the multiple accounts? https://cran.r-project.org/web/packages/rgoogleads/rgoogleads.pdf

I have a Google Ads account which has a single Smart Campaign and multiple usual campaigns. Also I've set up a data transfer to Google BigQuery. When I try to compare BigQuery data using the query

SELECT sum(Cost) FROM `project.dataset.AccountBasicStats_XXXXXX`  where Date between '2021-12-01' and '2021-12-31' 

the query result shows a less cost than I see in the Google Ads interface for the same time period. The difference is equal to the spend of my smart campaign. To check this, I've tried the queries:

SELECT * FROM `project.dataset.CampaignBasicStats_XXXXXX`  where Date between '2021-12-01' and '2021-12-31' AND CampaignId = {ID of my smart campaign} SELECT * FROM `project.dataset.CampaignStats_XXXXXX`  where Date between '2021-12-01' and '2021-12-31' AND CampaignId = {ID of my smart campaign} 

The both give me no results.

Is it true that BigQuery data transfer discards the data of smart campaigns? What are other ways to get statistics for them?

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 = ?