{"id":875,"date":"2018-10-08T11:11:15","date_gmt":"2018-10-08T11:11:15","guid":{"rendered":"https:\/\/www.traverse-events.com\/blog\/?p=875"},"modified":"2018-10-08T11:21:19","modified_gmt":"2018-10-08T11:21:19","slug":"super-easy-press-trip-reporting-for-youtube-with-google-sheets","status":"publish","type":"post","link":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/","title":{"rendered":"Super Easy Press Trip Reporting for YouTube with Google Sheets"},"content":{"rendered":"

I recently wrote a quick post about easily gathering your figures from Instagram after a campaign. It went down so well that I had to write another one, but this time all about grabbing stats from YouTube.<\/span><\/strong><\/p>\n

So if you’ve just finished a campaign or even before (take a look at this great post on getting work done on a press trip by Monica from The Travel Hack<\/a>), you can set up this spread sheet to dynamically collect your views from your YouTube views. That’s right, they’ll be updating as the views increase.<\/p>\n

Brands and PR\u2019s are alway love it if bloggers\/YouTubers are prepared with the right information when they request those campaign stats, so it’s always good to be prepared.<\/p>\n

Going back to your videos on YouTube and collecting views can be a pain, plus they’re always changing. You don’t even need to spend money on fancy social media analytics, just follow the really really simple instructions below and you’ll have a super useful spreadsheet for your campaign stats!<\/p>\n

Here\u2019s how you do it!<\/strong><\/p>\n

Using some really simple formulas in Google Sheets it’s fairly simple to pull information about the views on a YouTube video. The beauty of this is that once you’ve set it up the Google Sheet will automatically grab the latests stats, so if your likes or comments increase you’ll have the most up to date information.<\/p>\n

If you’re not technical or have never worked with formulas etc, don’t worry you can get by with a bit of cut and pasting.<\/p>\n

Start with a new Google Sheet, create it.<\/p>\n

YouTube Video Data<\/h3>\n

Firstly, paste your first YouTube video URL into cell A2 if you have headings across row 1.<\/p>\n

Grab the videos views<\/h4>\n

You can grab some meta data from your YouTube video page which contains the view counts. Paste the following formula into the formula field for cell B2, and that is it! Simple!<\/p>\n

=<\/span>Regexreplace<\/span>(<\/span>IMPORTXML<\/span>(A<\/span>2<\/span>,<\/span>“\/\/div[@class=’watch-view-count’]”<\/span>)<\/span>,<\/span>“views”<\/span>,<\/span>“”<\/span>)<\/span><\/div><\/blockquote>\n
\"youtube<\/div><\/div><\/div><\/div>\n

You can view and make your own copy of the spreadsheet right here<\/a>.<\/p>\n

There’s also some more awesome formulas and ways to get data from different platforms on Ben Collins’s blog<\/a>… If you are keen to dig a bit deeper!<\/p>\n

Hope this was helpful to some of you, any feedback just leave me a comment below!<\/p>\n","protected":false},"excerpt":{"rendered":"

I recently wrote a quick post about easily gathering your figures from Instagram after a campaign. It went down so well that I had to write another one, but this time all about grabbing stats from YouTube. So if you’ve just finished a campaign or even before (take a look at this great post on […]<\/p>\n","protected":false},"author":2,"featured_media":884,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-875","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-tos"],"yoast_head":"\nSuper Easy Press Trip Reporting for YouTube with Google Sheets - Traverse Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Super Easy Press Trip Reporting for YouTube with Google Sheets - Traverse Blog\" \/>\n<meta property=\"og:description\" content=\"I recently wrote a quick post about easily gathering your figures from Instagram after a campaign. It went down so well that I had to write another one, but this time all about grabbing stats from YouTube. So if you’ve just finished a campaign or even before (take a look at this great post on […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Traverse Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-08T11:11:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-08T11:21:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.traverse-events.com\/blog\/wp-content\/uploads\/2018\/10\/yotube-mobile-min.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2120\" \/>\n\t<meta property=\"og:image:height\" content=\"1414\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Paul Dow\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Dow\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/\",\"url\":\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/\",\"name\":\"Super Easy Press Trip Reporting for YouTube with Google Sheets - Traverse Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.traverse-events.com\/blog\/#website\"},\"datePublished\":\"2018-10-08T11:11:15+00:00\",\"dateModified\":\"2018-10-08T11:21:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.traverse-events.com\/blog\/#\/schema\/person\/558040eaa2f6d94a9c5e7f52631c4748\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.traverse-events.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Super Easy Press Trip Reporting for YouTube with Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.traverse-events.com\/blog\/#website\",\"url\":\"https:\/\/www.traverse-events.com\/blog\/\",\"name\":\"Traverse Blog\",\"description\":\"Highlight outstanding digital content and talented content creators\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.traverse-events.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.traverse-events.com\/blog\/#\/schema\/person\/558040eaa2f6d94a9c5e7f52631c4748\",\"name\":\"Paul Dow\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.traverse-events.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/868014d388142b02185d84dbb776e38ce4e4b62d45e0b85726b701aa33b3c191?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/868014d388142b02185d84dbb776e38ce4e4b62d45e0b85726b701aa33b3c191?s=96&d=mm&r=g\",\"caption\":\"Paul Dow\"},\"description\":\"Paul is co-founder\/director at Traverse and also a long term travel blogger at www.travmonkey.com. His new project is all about learning to surf and leave the stresses of the city behind at www.surfandunwind.com as well as his new project crowdsourcing airport information indepartures.com.\",\"sameAs\":[\"https:\/\/www.travmonkey.com\"],\"url\":\"https:\/\/www.traverse-events.com\/blog\/author\/travmonkey\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Super Easy Press Trip Reporting for YouTube with Google Sheets - Traverse Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"Super Easy Press Trip Reporting for YouTube with Google Sheets - Traverse Blog","og_description":"I recently wrote a quick post about easily gathering your figures from Instagram after a campaign. It went down so well that I had to write another one, but this time all about grabbing stats from YouTube. So if you’ve just finished a campaign or even before (take a look at this great post on […]","og_url":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/","og_site_name":"Traverse Blog","article_published_time":"2018-10-08T11:11:15+00:00","article_modified_time":"2018-10-08T11:21:19+00:00","og_image":[{"width":2120,"height":1414,"url":"https:\/\/www.traverse-events.com\/blog\/wp-content\/uploads\/2018\/10\/yotube-mobile-min.jpg","type":"image\/jpeg"}],"author":"Paul Dow","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Paul Dow","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/","url":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/","name":"Super Easy Press Trip Reporting for YouTube with Google Sheets - Traverse Blog","isPartOf":{"@id":"https:\/\/www.traverse-events.com\/blog\/#website"},"datePublished":"2018-10-08T11:11:15+00:00","dateModified":"2018-10-08T11:21:19+00:00","author":{"@id":"https:\/\/www.traverse-events.com\/blog\/#\/schema\/person\/558040eaa2f6d94a9c5e7f52631c4748"},"breadcrumb":{"@id":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-press-trip-reporting-for-youtube-with-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.traverse-events.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Super Easy Press Trip Reporting for YouTube with Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/www.traverse-events.com\/blog\/#website","url":"https:\/\/www.traverse-events.com\/blog\/","name":"Traverse Blog","description":"Highlight outstanding digital content and talented content creators","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.traverse-events.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.traverse-events.com\/blog\/#\/schema\/person\/558040eaa2f6d94a9c5e7f52631c4748","name":"Paul Dow","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.traverse-events.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/868014d388142b02185d84dbb776e38ce4e4b62d45e0b85726b701aa33b3c191?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/868014d388142b02185d84dbb776e38ce4e4b62d45e0b85726b701aa33b3c191?s=96&d=mm&r=g","caption":"Paul Dow"},"description":"Paul is co-founder\/director at Traverse and also a long term travel blogger at www.travmonkey.com. His new project is all about learning to surf and leave the stresses of the city behind at www.surfandunwind.com as well as his new project crowdsourcing airport information indepartures.com.","sameAs":["https:\/\/www.travmonkey.com"],"url":"https:\/\/www.traverse-events.com\/blog\/author\/travmonkey\/"}]}},"_links":{"self":[{"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/posts\/875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/comments?post=875"}],"version-history":[{"count":14,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/posts\/875\/revisions"}],"predecessor-version":[{"id":903,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/posts\/875\/revisions\/903"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/media\/884"}],"wp:attachment":[{"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/media?parent=875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/categories?post=875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/tags?post=875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}