{"id":732,"date":"2020-05-13T11:00:00","date_gmt":"2020-05-13T11:00:00","guid":{"rendered":"https:\/\/www.traverse-events.com\/blog\/?p=732"},"modified":"2020-10-30T11:29:39","modified_gmt":"2020-10-30T11:29:39","slug":"super-easy-post-press-trip-instagram-reporting-with-google-sheets","status":"publish","type":"post","link":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-post-press-trip-instagram-reporting-with-google-sheets\/","title":{"rendered":"Super Easy Reporting for your Instagram posts with Google Sheets"},"content":{"rendered":"\n

So you’ve just finished a big campaign, your posts on Instagram have some great engagement. Time to grab a cup of tea and put your feet up right?<\/span><\/strong><\/p>\n\n\n\n

Well, no… time to get your own social media reporting in order!<\/p>\n\n\n\n

Brands and PR\u2019s are always impressed if bloggers\/Instagrammers are prepared with the right information when asked for campaign stats and even more so when they haven\u2019t asked!<\/p>\n\n\n\n

If you\u2019re on the ball you can even set this up before you start a campaign and update it as you go to minimise the work needed when you get home (take a look at this great post on getting work done on a press trip by Monica from The Travel Hack<\/a>).<\/p>\n\n\n\n

Collecting stats manually can take ages, going through all your posts and taking down likes and comments. If you don\u2019t have enough cash to splash on a fancy bit social media analytics software, there is an easier way to gather your basic but ever changing, dynamic stats from your Instagram account.<\/p>\n\n\n\n

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

There’s a lot of information you can gleam from meta tags on web pages, so we’ll be using some really simple formulas in Google Sheets to pull the information. 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\n\n\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\n\n\n

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

Instagram Post Data<\/h3>\n\n\n\n

Firstly, paste your first Instagram post URL into cell A2 if you have headings across row 1.

See screenshot: Grab the Instagram posts URL from your browsers address bar and paste it into cell A2 of your Google Sheet.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Grab the meta data description<\/h4>\n\n\n\n

So first up you can grab some meta data from your Instagram post page which contains the likes and comment counts. Paste the following formula into the formula field for cell B2. Once you click off the cell you should see the field populated with the meta description field.<\/p>\n\n\n

=IMPORTXML(A2,”\/\/meta[@name=’description’]\/@content”)<\/div><\/blockquote>\n\n\n
\"\"<\/a><\/div><\/div><\/div>\n\n\n\n

Extract the Likes<\/h4>\n\n\n\n

Once you have the meta description in cell B2 you can use regexextract<\/strong> to find and extract the Likes. Copy and paste the following into cell C2.<\/p>\n\n\n

=iferror(IFS(REGEXMATCH(B2,”m Likes”),value(regexextract(B2,”(\\w+.?.?)(?:m)”))*1000000,REGEXMATCH(B2,”k Likes”),value(regexextract(B2,”(\\w+.?.?)(?:k)”))*1000,REGEXMATCH(B2,” Likes”),value(regexextract(B2,”\\w+.?[0-9]?[0-9]?[0-9]?”)),B2>1,B2),”Error”)<\/div><\/blockquote>\n\n\n
\"\"<\/div><\/div><\/div><\/div>\n\n\n\n

Extract the Comments<\/h4>\n\n\n\n

Secondly, use the following formula to find and extract the comment count. Copy and paste the following formula into the formula field for cell C3.<\/p>\n\n\n

=iferror( if(regexmatch(B2,”k Comments”),value(regexextract(B2,”Likes, ([0-9]+\\W?[0-9]?)(?:k?) C”))*1000,value(regexextract(B2,”Likes, (\\w+.?[0-9]?[0-9]?[0-9]?) C”))),”Error”<\/div><\/blockquote>\n\n\n
\"\"<\/a><\/div><\/div><\/div>\n\n\n\n

Then you’re all set, you can start adding your Instagram posts as you publish them or in one go once the trips over. You can download the spreadsheet or keep it live and updating whilst you share it with your client (brand or PR).<\/p>\n\n\n

\"Google<\/div><\/div><\/div><\/div>\n\n\n\n
<\/div>\n\n\n\n
\n\n\n\n

Download your own Google Sheets workbook<\/h3>\n\n\n\n

UPDATE October 2020<\/strong>: Unfortunately Instagram has updated and doesn’t now reveal about likes and comments, so we are unable to use these formulas for reporting. <\/p>\n\n\n\n

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

So you’ve just finished a big campaign, your posts on Instagram have some great engagement. Time to grab a cup of tea and put your feet up right? Well, no… time to get your own social media reporting in order! Brands and PR\u2019s are always impressed if bloggers\/Instagrammers are prepared with the right information when […]<\/p>\n","protected":false},"author":2,"featured_media":739,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-732","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-tos"],"yoast_head":"\nSuper Easy Reporting for your Instagram posts 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-post-press-trip-instagram-reporting-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 Reporting for your Instagram posts with Google Sheets - Traverse Blog\" \/>\n<meta property=\"og:description\" content=\"So you’ve just finished a big campaign, your posts on Instagram have some great engagement. Time to grab a cup of tea and put your feet up right? Well, no… time to get your own social media reporting in order! Brands and PR\u2019s are always impressed if bloggers\/Instagrammers are prepared with the right information when […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-post-press-trip-instagram-reporting-with-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Traverse Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-13T11:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-30T11:29:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.traverse-events.com\/blog\/wp-content\/uploads\/2018\/09\/instagram-on-phone-v1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2121\" \/>\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=\"3 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-post-press-trip-instagram-reporting-with-google-sheets\/\",\"url\":\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-post-press-trip-instagram-reporting-with-google-sheets\/\",\"name\":\"Super Easy Reporting for your Instagram posts with Google Sheets - Traverse Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.traverse-events.com\/blog\/#website\"},\"datePublished\":\"2020-05-13T11:00:00+00:00\",\"dateModified\":\"2020-10-30T11:29:39+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-post-press-trip-instagram-reporting-with-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-post-press-trip-instagram-reporting-with-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-post-press-trip-instagram-reporting-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 Reporting for your Instagram posts 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 Reporting for your Instagram posts 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-post-press-trip-instagram-reporting-with-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"Super Easy Reporting for your Instagram posts with Google Sheets - Traverse Blog","og_description":"So you’ve just finished a big campaign, your posts on Instagram have some great engagement. Time to grab a cup of tea and put your feet up right? Well, no… time to get your own social media reporting in order! Brands and PR\u2019s are always impressed if bloggers\/Instagrammers are prepared with the right information when […]","og_url":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-post-press-trip-instagram-reporting-with-google-sheets\/","og_site_name":"Traverse Blog","article_published_time":"2020-05-13T11:00:00+00:00","article_modified_time":"2020-10-30T11:29:39+00:00","og_image":[{"width":2121,"height":1414,"url":"https:\/\/www.traverse-events.com\/blog\/wp-content\/uploads\/2018\/09\/instagram-on-phone-v1.jpg","type":"image\/jpeg"}],"author":"Paul Dow","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Paul Dow","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-post-press-trip-instagram-reporting-with-google-sheets\/","url":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-post-press-trip-instagram-reporting-with-google-sheets\/","name":"Super Easy Reporting for your Instagram posts with Google Sheets - Traverse Blog","isPartOf":{"@id":"https:\/\/www.traverse-events.com\/blog\/#website"},"datePublished":"2020-05-13T11:00:00+00:00","dateModified":"2020-10-30T11:29:39+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-post-press-trip-instagram-reporting-with-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-post-press-trip-instagram-reporting-with-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.traverse-events.com\/blog\/how-tos\/super-easy-post-press-trip-instagram-reporting-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 Reporting for your Instagram posts 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\/732","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=732"}],"version-history":[{"count":57,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/posts\/732\/revisions"}],"predecessor-version":[{"id":2976,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/posts\/732\/revisions\/2976"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/media\/739"}],"wp:attachment":[{"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/media?parent=732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/categories?post=732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.traverse-events.com\/blog\/wp-json\/wp\/v2\/tags?post=732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}