# feedback trend analysis
## Metadata

- Canonical URL: https://6ducklearn.com/skills/feedback-trend-analysis/
- Markdown URL: https://6ducklearn.com/skills/feedback-trend-analysis/index.md
- Product: skills
- Category: data-processing
- Tags: curated, google-workspace, customer-feedback, support, analytics
- Updated: 2026-07-14T03:00:00.357428+00:00
## Summary
Analyse trends and patterns in a customer feedback spreadsheet using Gemini. Trigger when you need to surface insights from raw feedback data, spot categories with rising complaint volume, or investigate customer sentiment shifts over time.
## Content
> **Attribution:** Prepared by 6DuckLearn. Inspired by [Google Workspace with Gemini Prompting Guide 101 (2025)](https://workspace.google.com).

## When to use this

You're a customer support specialist or manager with a spreadsheet of raw feedback and you need to quickly identify which categories are spiking, why customer outreach is increasing, and where to focus the team's attention.

## What you'll get

A structured analysis of feedback trends by category and time period — including the top patterns, notable increases in contact volume, and likely root causes worth investigating.

## Prompt template

Use this in the **Gemini app** (upload the spreadsheet file):

```
I am a customer support specialist. Using the attached spreadsheet, identify trends and patterns in [customer feedback] by [category] over [time period]. Highlight areas where [customer outreach] has increased significantly and investigate potential reasons.
```

**Fill in the variables:**
- `[customer feedback]` — describe the feedback type (e.g. "product reviews", "support ticket notes", "post-purchase survey responses")
- `[category]` — how you want grouping done (e.g. "product line", "issue type", "agent team", "region")
- `[time period]` — the date range to analyse (e.g. "Q1 2025", "the last 90 days", "January–March vs April–June")
- `[customer outreach]` — the metric to highlight (e.g. "repeat contacts", "escalations", "refund requests")

## Customisation tips

- Attach the spreadsheet directly in the Gemini app — it reads column headers automatically, so clean header names improve output quality
- Add *"Rank the top 3 categories by volume"* to get a prioritised list
- Specify the output format: *"Present your findings as a bullet-point executive summary followed by a table"*
- If the sheet covers multiple products or regions, mention which ones to focus on

## Iteration suggestions

After Gemini responds:
1. **Simplify policies that address top issues** → use `return-policy-simplification` to turn complex policy text into clear customer steps
2. **Create self-service content** → use `self-service-blog-from-policy` to turn the findings into a blog post
3. **Design a follow-up survey** → use `post-call-survey-questions` to capture structured data on the issues uncovered

## Related skills in this workflow

| Step | Skill | What it does |
|------|-------|--------------|
| 1 → You are here | `feedback-trend-analysis` | Analyse trends in feedback spreadsheet |
| 2 | `return-policy-simplification` | Simplify return policy into 5 clear steps |
| 3 | `self-service-blog-from-policy` | Turn policies into self-service blog post |
| 4 | `post-call-survey-questions` | Create post-call survey questions |
| 5 | `self-service-email-template` | Email template for self-service resources |
| 6 | `dissatisfied-customer-followup` | Request follow-up call with unhappy customers |

## Related Skills

- [dissatisfied customer followup](https://6ducklearn.com/skills/dissatisfied-customer-followup/index.md): Request a follow-up call with a customer who left negative feedback — acknowledge their concern and offer concrete resolutions. Trigger when you need to close the loop with an unhappy customer via Gmail.
- [post call survey questions](https://6ducklearn.com/skills/post-call-survey-questions/index.md): Generate post-call customer satisfaction survey questions that measure call effectiveness, issue resolution, and likelihood to recommend. Trigger when setting up CSAT or NPS surveys after support interactions.
- [return policy simplification](https://6ducklearn.com/skills/return-policy-simplification/index.md): Simplify a complex return policy document into 5 clear sequential steps customers can follow. Trigger when you have dense policy text and need to transform it into scannable, actionable customer-facing instructions.
- [self service blog from policy](https://6ducklearn.com/skills/self-service-blog-from-policy/index.md): Turn support policy documents into a short self-service blog post covering return, refund, and store credit policies. Trigger when you want customers to resolve common issues without contacting an agent.
- [self service email template](https://6ducklearn.com/skills/self-service-email-template/index.md): Draft a customer email that highlights self-service resources and a blog link for common support issues. Trigger when you want to proactively deflect support contacts by pointing customers to help content.
- [gemini customer feedback analysis](https://6ducklearn.com/skills/gemini-customer-feedback-analysis/index.md): Analyze feedback trends from spreadsheets, simplify return policies, create self-service content, and run voice-of-customer surveys