We want to create a dashboard containing search and social media trends insights.
Each panel on the dashboard will be one trending topic or keyword. Check ExplodingTopics attached as a reference.
Data collection:
- Leverage social media APIs and Search APIs such as Serpr (or similar) - Need a basic admin UI or location where we can input keyword queries, topics or keyword clusters for which trend data will be returned via API. - Raw data from API to be returned to Google Sheet. - Google sheet data to populate line charts in a no-code platform like Softr (or similar) to which we can provide external user logins.
We need a way to choose which charts ‘go to’ the interface for external viewability and which ones do not. This can be controlled either in G sheet or the no-code platform admin.
Other notes:
- Since the goal is to show trends and not just google search volume, we would like a way to show some charts as blended charts that combine both social and search data returned via APIs. - In the no-code interface we’d like option to add text and images (basic rich text functions) to each trend panel when it is expanded. - Small secondary bar charts under each trend panel that show which channels the trend is happening on (eg. Google, Youtube, TikTok etc).
Please send any questions or clarifications needed.
