Posts under category Google

We have been running GA4 and Google Ads on our website for a while now. However, the GA4 data appears not to be available in Google Ads even though the accounts are linked. For example, we can see 'All user' data in GA4, but the automatically imported GA4 audience 'All users' is not being filled (it does have some users, but that is probably from when we use UA). I have installed the GA4 tag through GTM, and it is working as GA4 data gets filled.

GA4: Linked account

GA4: All users

GAds: GA4 All users in Ads

I have cross checked all links, property codes etc and all do match with the corresponding account, but unfortunately the data is not being imported. Also, when I create a new audience in GA4, the data is not available in Google Ads. When I configure the Google Ads remarketing/conversion tag in our GTM, the audience does get filled.

Am I missing something?

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