# \[GUIDE\] How to Set Up a beautiful FREE Social Media Analytics/Reports Dashboard **URL:** \ **Category:** Instagram Marketing\ **Created:** [August 19, 2017, 7:13pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557 "2017-08-19T19:13:07Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![MPRules](https://mpsocial.com/user_avatar/mpsocial.com/mprules/32/552_2.png) [@MPRules](https://mpsocial.com/u/MPRules)\ **Post date:** [August 21, 2017, 7:44am UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/21 "2017-08-21T07:44:49Z")
> [@dma0245](#): > > Would be very nice! Is google data studio better? I am searching for 1 provider​😬 ---
**Author:** ![jimmy](https://mpsocial.com/user_avatar/mpsocial.com/jimmy/32/12270_2.png) [@jimmy](https://mpsocial.com/u/jimmy)\ **Post date:** [August 21, 2017, 4:30pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/22 "2017-08-21T16:30:08Z")
Sweet! Just checked it out. Only CON that I quickly noticed: It’s not free, you have to pay for the Supermetrics for google drive, 61.25/mo -Which is not bad if you have A LOT of accounts. Pro: You don’t need to connect with the IG account. So if you’re not strapped for cash, this might be a better solution. Also, you can use google sheets as insights in Dasheroo, in case you like their UI better or something. So Supermetrics \> Google Sheets \> Dasheroo is definitely possible. P.S. Thanks for pointing out that datastudio is open now, I remember looking into it a while back and i think it was like invite only or something which seems like it has freshly opened since it’s still in beta. ---
**Author:** ![dma0245](https://mpsocial.com/user_avatar/mpsocial.com/dma0245/32/28521_2.png) [@dma0245](https://mpsocial.com/u/dma0245)\ **Post date:** [August 23, 2017, 1:00pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/23 "2017-08-23T13:00:33Z")
> [@dma0245](#): > > And i will ask dasheroo more info about how they connect to ig and how bigger companys work with that safety issue! > > Thanks for idea! Answer from Dasheroo…Ofcourse they say it’s safe for having many clients. Prices: ![](https://mpsocial.com/uploads/default/original/2X/f/f195bbe24dc08381322ded4d760ab7cf8635c30c.jpg) ---
**Author:** ![MPRules](https://mpsocial.com/user_avatar/mpsocial.com/mprules/32/552_2.png) [@MPRules](https://mpsocial.com/u/MPRules)\ **Post date:** [August 23, 2017, 1:59pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/24 "2017-08-23T13:59:10Z")
200$~ monthly for just 120 accs Pfff… But it would be very nice to have 1 acc and add here all ig accounts. So i can see best average post time/days. Like this​👇 ![](https://mpsocial.com/uploads/default/original/2X/7/78997838a2249231137413921d5473b175e328a1.jpg) I wish MP had something like this​😞 ---
**Author:** ![jimmy](https://mpsocial.com/user_avatar/mpsocial.com/jimmy/32/12270_2.png) [@jimmy](https://mpsocial.com/u/jimmy)\ **Post date:** [August 23, 2017, 3:44pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/25 "2017-08-23T15:44:31Z")
I think what people seem to miss that unless you’re running a very geo targeted campaign, your best time to post is every time because your audience will be all over the country or world. So it’s ALWAYS 5PM somewhere. I think rather than trying to figure out when to make THE perfect post just post consistently and you will hit the best times just be proxy. I personally like to post 6-8 times per day spread evenly through out the day. Posting a lot can also get you in more hashtags. ---
**Author:** ![jimmy](https://mpsocial.com/user_avatar/mpsocial.com/jimmy/32/12270_2.png) [@jimmy](https://mpsocial.com/u/jimmy)\ **Post date:** [August 23, 2017, 3:47pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/26 "2017-08-23T15:47:03Z")
Also, “BEST” times doesnt mean that the other times are “BAD”… Sure you might get 12% engagement during the best time but the other times you get 10%, that it’s still good. It’s not like it drops from 12% ER to 1% ER. The difference could be marginal. ---
**Author:** ![daverawcus](https://mpsocial.com/user_avatar/mpsocial.com/daverawcus/32/635_2.png) [@daverawcus](https://mpsocial.com/u/daverawcus)\ **Post date:** [August 23, 2017, 4:33pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/27 "2017-08-23T16:33:27Z")
was going to tag you in this after reading your thread the other day about needing affordable stats software ---
**Author:** ![wortime](https://mpsocial.com/user_avatar/mpsocial.com/wortime/32/30775_2.png) [@wortime](https://mpsocial.com/u/wortime)\ **Post date:** [August 23, 2017, 4:54pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/28 "2017-08-23T16:54:30Z")
Thanks @daverawcus I do follow it. I am currently looking into this and a few others. I also think @sevy was going to create a guide on how to use the new Google Data Studio to create custom reports! ---
**Author:** ![MPRules](https://mpsocial.com/user_avatar/mpsocial.com/mprules/32/552_2.png) [@MPRules](https://mpsocial.com/u/MPRules)\ **Post date:** [August 27, 2017, 2:27am UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/29 "2017-08-27T02:27:50Z")
Btw can i see with Dasheroo best posting time? ---
**Author:** ![jimmy](https://mpsocial.com/user_avatar/mpsocial.com/jimmy/32/12270_2.png) [@jimmy](https://mpsocial.com/u/jimmy)\ **Post date:** [August 27, 2017, 5:01pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/30 "2017-08-27T17:01:05Z")
Not through their Instagram connection, I did email them about it. Maybe they’ll add it soon. ---
**Author:** ![sevy](https://mpsocial.com/user_avatar/mpsocial.com/sevy/32/20477_2.png) [@sevy](https://mpsocial.com/u/sevy)\ **Post date:** [October 19, 2017, 4:53pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/31 "2017-10-19T16:53:49Z")
guys, sorry about the delay I’m out of time recently, I know that I already promised to do a tutorial about this, but I send a message for elysian11 with a little of help, and I think that the message can clarify how you guys can do a good report. Let me try to explain the basics. You have two options, 1. Use supermetrics, it’s a bit easy: sign up to try: [https://supermetrics.com/product/supermetrics-for-data-studio/](https://supermetrics.com/product/supermetrics-for-data-studio/) Click and follow the steps in the Google data studio, you’ll need a little knowledge about the google data studio, but the ux/ui is good, so you will not have a problem. 2. Use the google sheets, you will need a little knowledge on excel functions, basically in the functions: importXML, importHTML (read this: [https://www.quicksprout.com/the-advanced-guide-to](https://www.quicksprout.com/the-advanced-guide-to) - seo-chapter-5 /) You need to extract all the data you need from instagram and put in a google sheets After that, connect your google data studio by pulling data from the sheet The problem and the secret in these two methods is that the data in the google sheets is not dynamic (they do not update automatically), so you need a little work to run it smoothly, you need to create a script with a trigger in the google sheets (read this: [https://support.geckoboard.com/hc/en-us/articles/206260188-Use-Google-Sheets-ImportHTML-function-to-display-data-in-Geckoboard#how\_to\_configure\_automatic\_updates](https://support.geckoboard.com/hc/en-us/articles/206260188-Use-Google-Sheets-ImportHTML-function-to-display-data-in-Geckoboard#how_to_configure_automatic_updates)) After that, you have good dynamic data that you can use to create your google data studio, with a little bit of design and maths, and so on… to further transform your reports. For google data studio: [https://www.youtube.com/watch?v=C1w-yuTDUeM](https://www.youtube.com/watch?v=C1w-yuTDUeM) @dma0245 Danny, maybe this can be of help for you ---
**Author:** ![dma0245](https://mpsocial.com/user_avatar/mpsocial.com/dma0245/32/28521_2.png) [@dma0245](https://mpsocial.com/u/dma0245)\ **Post date:** [October 19, 2017, 4:57pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/32 "2017-10-19T16:57:21Z")
Will check! Many thanks! ---
**Author:** ![odegucci](https://mpsocial.com/user_avatar/mpsocial.com/odegucci/32/39012_2.png) [@odegucci](https://mpsocial.com/u/odegucci)\ **Post date:** [March 3, 2018, 11:50pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/33 "2018-03-03T23:50:51Z")
Hey there sevy! YOU’RE AWESOME!! Doing this now! What “url” do you replace in the script? Also, correct me if I’m wrong but technically you don’t need the google studio version of supermetrics unless your goal is to share reports with clients, right? ---
**Author:** ![aprilegabriele](https://mpsocial.com/user_avatar/mpsocial.com/aprilegabriele/32/733_2.png) [@aprilegabriele](https://mpsocial.com/u/aprilegabriele)\ **Post date:** [March 6, 2018, 1:55pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/34 "2018-03-06T13:55:34Z")
This is amazing Sevy. I’m trying to do it but I’m not able to identify the correct Xpaths to scrape data from Instagram… Can you give some other advice please? Thanks a lot in advance! ---
**Author:** ![sevy](https://mpsocial.com/user_avatar/mpsocial.com/sevy/32/20477_2.png) [@sevy](https://mpsocial.com/u/sevy)\ **Post date:** [March 6, 2018, 2:20pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/35 "2018-03-06T14:20:59Z")
Hi guys, this week I’ll give a little more information about this (more details about how you can scrap the data or create the script, or share a little bit of my dashboard), and if you have problems yet, we can do a quick meeting on skype for me to show u @aprilegabriele @odegucci @dma0245 ---
**Author:** ![aprilegabriele](https://mpsocial.com/user_avatar/mpsocial.com/aprilegabriele/32/733_2.png) [@aprilegabriele](https://mpsocial.com/u/aprilegabriele)\ **Post date:** [March 6, 2018, 2:24pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/36 "2018-03-06T14:24:08Z")
You are very very kind my friend, I appreciate it 🙂 ---
**Author:** ![dma0245](https://mpsocial.com/user_avatar/mpsocial.com/dma0245/32/28521_2.png) [@dma0245](https://mpsocial.com/u/dma0245)\ **Post date:** [March 6, 2018, 2:26pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/37 "2018-03-06T14:26:46Z")
Thanks! But i have to pass:( It seems that i am a noob to much for this stuff… So i am using the paid version of @MojoJojo his anaytics now. Good luck and thanks for the offer! DAnny ---
**Author:** ![aprilegabriele](https://mpsocial.com/user_avatar/mpsocial.com/aprilegabriele/32/733_2.png) [@aprilegabriele](https://mpsocial.com/u/aprilegabriele)\ **Post date:** [March 14, 2018, 9:43am UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/38 "2018-03-14T09:43:15Z")
I’m still interested 🙂 ---
**Author:** ![LeoGab1](https://mpsocial.com/letter_avatar_proxy/v4/letter/l/8edcca/32.png) [@LeoGab1](https://mpsocial.com/u/LeoGab1)\ **Post date:** [July 3, 2018, 11:42am UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/39 "2018-07-03T11:42:03Z")
is this still working? ---
**Author:** ![francescovaglia](https://mpsocial.com/user_avatar/mpsocial.com/francescovaglia/32/21852_2.png) [@francescovaglia](https://mpsocial.com/u/francescovaglia)\ **Post date:** [July 3, 2018, 4:15pm UTC](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557/40 "2018-07-03T16:15:15Z")
If you’re looking for an analytics tool with a dashboarding system check [OwlStat](https://www.owlstat.com) 😁 @LeoGab1 [Previous page](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557.md?page=1) [Next page](https://mpsocial.com/t/guide-how-to-set-up-a-beautiful-free-social-media-analytics-reports-dashboard/23557.md?page=3)