RGoogleAnalytics error message: Your query matched 0 results.....

[arielp1]

I try to extract data from several accounts in one script.
few account has data and few empty, the problem is when no data i get an error message and the script stop to run.

Error message:
Your query matched 0 results. Please verify your query using the Query Feed Explorer and re-run it.
Error in GetDataFeed(query.uri) :
no loop for break/next, jumping to top level

How to fix it and skip the empty account without stop the script.

My script:

lastday <- Sys.Date() - 1
daystorun <- as.numeric(round(difftime(Sys.Date(), '2016-07-01'), digit=0))

for(i in 1:daystorun){
start.date <- as.character(lastday - daystorun + i)
end.date <- start.date
view.id <- paste("ga:",v,sep="")
query.list <- Init(start.date = start.date,
end.date = start.date,
dimensions = "ga:date, ga:medium, ga:source, ga:campaign",
metrics = "ga:users",
#max.results = 10000,
sort = "-ga:date",
filters = "ga:medium==XXXXX;ga:campaign=@xxxxxx;ga:source==XXXXXX",
table.id = view.id)

ga.query <- QueryBuilder(query.list)
ga.data <- GetReportData(ga.query, oauth_token, paginate_query = F)
ga.data["viewID"] <- paste(v)
df<-rbind(df,ga.data)
print(paste(start.date,"_",view.id))
}
}

[andreifoldes]

I have the same issue unfortunately.

[dikesh]

This issue is resolved. Please try installing RGoogleAnalytics package using devtools.

devtools::install_github("Tatvic/RGoogleAnalytics")

[james-faulkes]

Hi there, I am having a similar issue running queries in a loop based on arielp1's post #34

for (v in idsvector){
  start.date <- "2018-04-01"
  end.date <- "2018-04-02"
  view.id <- paste("ga:",v,sep="") #the View ID parameter need to have "ga:" in front of the ID 
  
  sourcequery.list <- Init(
    start.date = start.date,
    end.date =  end.date,
    dimensions = "ga:channelGrouping,ga:campaign,ga:source,ga:medium,ga:date",
    metrics = "ga:sessions,ga:bounces",
    table.id = view.id,
    max.results = 9999999
  )
  ga.sourcequery <- QueryBuilder(sourcequery.list)
  data <- GetReportData(ga.sourcequery, token, paginate_query = F, split_daywise = F)
  data$Property <- view.id
  df<-rbind(df,data)

The first profile passes but the second errors and throws the script out
Error message:

Status of Query:
The API returned 771 results
Error in rep(xi, length.out = nvar) : 
  attempt to replicate an object of type 'closure'

[githubqqqqq]

I still have this error after installing it using devtools. Below is my code. It works without the filter but when I include the filter, it generates the error:
"Your query matched 0 results. Please verify your query using the Query Feed Explorer and re-run it.Error in GetDataFeed(query.uri) :
no loop for break/next, jumping to top level"

I tried it with Query Feed Explorer and it returned correct results. I'm using R3.4.0 through RStudio. Is there anything else I need to try? Thank you!

##########Code###############
startdt<-"2018-06-01"
enddt<-"2018-06-01"
dimensions<-"ga:eventCategory,ga:eventAction,ga:eventLabel"
dimensions<-"ga:eventCategory,ga:eventAction"
metrics<-"ga:totalEvents"
viewID<-'ga:00000000'
query.list <- Init(start.date = startdt,
end.date = enddt,
dimensions = dimensions,
metrics = metrics,
filters = "ga:eventCategory==XXXXXX",
max.results = 1000,
table.id = viewID)
ga.query <- QueryBuilder(query.list)
output<-GetReportData(ga.query, oauth_token)

[jdeboer]

I would recommend using try or tryCatch to wrap the call and handle the exception. try and tryCatch are functions built-in to base R and they straight-forward to use - please refer to the help pages in R on how to use these.