Query multiple Google Analytics view ids using googleAnalyticsR v4 API package

Question

I want to use the new googleAnalyticsR package to extract Google Analytics data using the v4 API.

The documentation (http://code.markedmondson.me/googleAnalyticsR/v4.html) demonstrates the execution of a query using one ga_id, but not using multiple view ids. There is another R package called GAR which permits the execution of multiple view id in a single Google Analytics query, but the googleAnalyticsR package includes v4 API features. I attempted to query multiple view ids using ga_id <- c('viewId','viewId'), but the query returns an error. Is there a way to query multiple view ids using googleAnalyticsR v4 API?

You cannot do that in a single request because that is limitation of Analytics Reporting API V4 only. — dikesh
– dikesh, Commented Feb 11, 2017 at 4:59
Thanks dikesh. I was hoping maybe that maybe there was a way to query multiple ids as described with API v3 in (analyticsforfun.com/2015/05/…) — MDeniz
– MDeniz, Commented Feb 11, 2017 at 12:22
I understand but no API allows querying multiple view ids in single request. You have to run the loop to fire multiple queries and in each iteration pass the different view ids. — dikesh
– dikesh, Commented Feb 11, 2017 at 15:45
Its actually quicker in googleAnalyticsR to query multiple IDs via the v3 library as you can do as you demonstrate c(1234,2344,etc) but v4 doesn't allow batching outside one ID, so if you need v4 features you need to stick with a loop as the answer given below. — MarkeD
– MarkeD, Commented Feb 28, 2017 at 10:11

Petr Havlik · Accepted Answer · 2017-02-12 16:14:50Z

4

This probably isn't supported in API directly, but given you are using R, this could be very easily achieved using FOR loops. Below is an example where I am querying multiple GA views (1 view = 1 language version of the site):

viewId <- c(6006393, 79777098, 79781440, 79981805, 75315234, 78174757, 76630182, 79447058)    

ga_data_final <- data.frame()

for (i in viewId) {
  ga_data_temp <- 
    google_analytics_4(i, #=This is a (dynamic) ViewID parameter
                       date_range = c("2014-01-01",
                                      "2016-08-15"), 
                       metrics = c("sessions"), 
                       dimensions = c("yearMonth",
                                      "source",
                                      "medium"),
                       max = -1)
  ga_data_temp$viewId <- i
  ga_data_final <- rbind(ga_data_final, ga_data_temp)
}

The code above retrieves:

1 metric: number of sessions
3 dimensions: yearMonth, Source, Medium

It's using 2 dataframes - the master one is created as empty before FOR loop starts. Every FOR cycle pulls rows for 1 view (temporarily stored in ga_data_temp) and once finished, appends them to the master dataframe (ga_data_final).

Hope this helps.

edited Feb 12, 2017 at 16:14

answered Feb 12, 2017 at 15:44

Petr Havlik

3,3171 gold badge22 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

MDeniz Over a year ago

Thanks Peter Havlik. This approach worked very well.

Petr Havlik Over a year ago

Great to hear - would you mind accepting / upvoting the answer?

MDeniz Over a year ago

I tried to upvote, but my upvote does not register since my reputation is less than 15.

MDeniz Over a year ago

I think I've now accepted. Thanks again for the answer. It was very helpful.

Petr Havlik Over a year ago

Thanks, much appreciated!

Collectives™ on Stack Overflow

Query multiple Google Analytics view ids using googleAnalyticsR v4 API package

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related