Assistance Needed with Modifying Existing Social Media Data Analysis Template
Hello everyone,
I wanted to use this dashboard for social media that I found here: https://docs.google.com/spreadsheets/d/1tAOpd_89rWFc0Flr6iIoqYor69WzaCDAbGNzVsLBwVE/edit#gid=1491016518.
However, I'm trying to tally the posts not by the days of the week (Monday, Tuesday, Wednesday, etc.) and group them by the number of weeks (how much I've posted per week) but by month, from November 2023 to October 2024, to know annually how much we have posted. I would like to visualize this data in the charts (exactly as it is now, but with the criteria I want). I would also like, just as it is in the template now, to break down by month and then annually the type of posts (TEXT, IMAGE, VIDEO) and platform (Fb, X, etc). It's not essential to know the exact publication date (e.g., 1/11/2023), although I would still like to insert it in the table in a new column, but not for reporting purposes to the company.
The problem is that I tried to do it with the template, but I couldn't. I don't think I have the skills, but I tried until I gave up and asked for someone's help.
Could someone help me?
Thank you very much!
Answers
-
If you are building this out in Google sheets/docs/etc., you are probably going to want to look for a Google sheets specific forum as opposed to a Smartsheet forum.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives