How Do I Retrieve Traffic Sources for Each YouTube Video?

[Stuart McGarrity]

Hi,

I'd like to retrieve traffic source data for all videos in our YouTube channel.

In the supplied spreadsheet, YouTube worksheet complex example, I can specify the channel profile and "insightTrafficSourceType" as a dimension...

A MORE COMPLEX DATA QUERY
Splitting metrics by dimensions
Video ID	TOTALS_gdHSFcXvkN6O3NXvif0-pA
Metrics	views
Start date	1/1/2014
End date	3/31/2014
Dimensions	insightTrafficSourceType
Pivot dimensions
Filters
Advanced segment
Sort	TRUE
Settings	include_headers
Max results	100
Max categories	20

And it works:

insightTrafficSourceType	Views
YT_SEARCH	70885
NO_LINK_OTHER	33646
RELATED_VIDEO	27728
EXT_URL	24831
PLAYLIST	19853
YT_CHANNEL	13303
NO_LINK_EMBEDDED	12096
GOOGLE_SEARCH	6162
SUBSCRIBER	5221
ANNOTATION	1222
YT_OTHER_PAGE	462
EXT_APP	101
PROMOTED	2

However, I assumed I could add another dimension of "video"...

Video ID	TOTALS_gdHSFcXvkN6O3NXvif0-pA
Metrics	views
Start date	1/1/2014
End date	3/31/2014
Dimensions	video&insightTrafficSourceType
Pivot dimensions
Filters
Advanced segment
Sort	TRUE
Settings	include_headers
Max results	100
Max categories	20

but it does not work.

Error: 400 badRequest The query is not supported. Check the documentation at https://developers.google.com/youtube/analytics/v1/available_reports for a list of supported queries.

Any tips as how to do this?

I got it working before by specifying a multiple comma separated video profile names but is is very cumbersome.

Thanks,

Stuart

[Mikael Thuneberg]

At the moment, specifying all video IDs in the query is the only way, due to the way the YouTube API is structured.

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at http://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/eed6f0e0-4731-4cde-b9b7-dc92c27f3e8f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Stuart McGarrity]

Thanks Mikael.