Received ga:adwordsCriteriaID does not match Geo Target CSV file

51 views
Skip to first unread message

Ольга Ведерникова

unread,
Jan 28, 2020, 3:49:46 AM1/28/20
to AdWords API and Google Ads API Forum
Hello. I am collecting data in Power BI using the R script. https://github.com/selesnow/RGA
Tell me, what am I doing wrong?

sample code:

Ads = Table.AddColumn(
        Groups, "GA_ads_data", each try R.Execute("
            setwd('" & AccessPath & "')
            library('RGA')

            client_id     <- '" & ClientId & "'
            client_secret <- '" & ClientSecret & "'
            profile_id    <- '" & [ids] & "'

            rga_auth <- authorize(
                client.id     = client_id, 
                client.secret = client_secret 
            )

            gaData <- get_ga(
                profileId     = profile_id,
                start.date    = '" & BegDate & "',
                end.date      = '" & EndDate & "',
                dimensions    = 'ga:date,ga:adwordsCriteriaID,ga:adDistributionNetwork,ga:adwordsAdGroupID,ga:adwordsCreativeID,ga:keyword',
                metrics       = 'ga:adCost',
                samplingLevel = 'HIGHER_PRECISION',
                max.results   = 15000,
                token         = rga_auth
            )
        "){[Name="gaData"]}[Value] otherwise null
    )


Received by adwordsCriteriaID: 21659804743, 503999, ...

Tell me what to do.

Google Ads API Forum Advisor Prod

unread,
Jan 29, 2020, 2:36:56 PM1/29/20
to ovl.ved...@gmail.com, adwor...@googlegroups.com

Hi,

Thank you for reaching out to us. I see your issue is dealing with our Google Analytics API. Could you please reach out to them here, as they are better equipped to assist you with your concern?

Thank you,
Bryan, Google Ads API Team



ref:_00D1U1174p._5001USx2Q6:ref
Reply all
Reply to author
Forward
0 new messages