Hi all,
I am wondering if anyone has an analytics template that they use for taking the excel raw file data from Vanilla Analytics into something that is shareable with stakeholders that you would be able to share?
Thanks!
Hey @lorimorrisroe -- on the strategic services team, one of the things we do is prepare reports based on client KPIs -- we've used a number of ways to express these reports based on actual KPIs being reported, and the customer.
I find powerpoint easier for complex data sets since it works so nicely with excel, and I find Canva better for infographic style eye catching high level data (perfect for execs!), but updating the data much more manual...
Curious what kinds of data you are tracking, and what kind of audience you are targeting -- I might have a template I can anonymize and share!
We've done an HL Vanilla Connect session on Canva in general,, could be interesting to do a vanilla analytics -> excel -> powerpoint demo or a Canva session specifically on making reports... hmmm..... 🧐
Hi @Shauna !
That would be excellent. Currently using excel/ppt but it is a bit manual. Primarily we're tracking engagement, registrations, page views, visits, etc. Pretty simple but you get the idea that when pulling it into raw excel, it becomes manual to do each chart individually.
Appreciate your reply!
Hey @lorimorrisroe sorry it took me a while to circle back here!
Yeah, excel/pptx as well as canva are all pretty manual, unfortunately. That being said, if you've got some good looking templates, pulling in that data (albeit manually) can become pretty automatic.
Here are some quick canva examples:
https://www.canva.com/design/DAFUrBk7qkw/o4Wbo8NcrW8xzYaRGI12Ow/edit?utm_content=DAFUrBk7qkw&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton
https://www.canva.com/design/DAFUrDo7BmM/RRJglKSMle-kjHlXUWMWww/edit?utm_content=DAFUrDo7BmM&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton
Canva is prettier, but def more manual than excel/pptx.
Hey @Shauna - really appreciate the share! These look great!
⭐️ Got something cool to share? Have a victory in your community and want to show off your accomplishments with fellow community builders? 🙋 Got questions? Bring your community, tactical and random questions and get answers from peers and Vanilla experts! 🗓 Join our very own @ShannonHudebine and @IsabelleK, and a group of…
Join our AI Study Group for Community Managers. At each session we'll discuss what group members are experimenting with and learning, how we're using AI in our communities, and help one another problem solve. The group meets monthly, and is open to any community professionals interested in the topic of AI. Hosted by our…
Hey Vanilla friends 👋 Join @Branwyn T and @Kirstie as they explore the new options available in the analytics API to bulk export and download analytics data - perfect for setting up PowerBI dashboards and using AI tools to better understand your site’s ROI! Have any questions you want to ensure we cover? Add them to this…
