The Scenario
You are a product analyst. The new quarter starts Monday and you need to present a platform and geographic breakdown of the user base at the kickoff meeting. The head of product wants: how is the user base split across iOS, Android, and Web, and which countries are the top five in each platform?
The data is in Amplitude's User Composition view. The kickoff workbook needs a stacked bar chart and a supporting breakdown table in the Analytics tab.
The slow version:
- Open Amplitude, navigate to User Composition, select platform, export CSV
- Go back, switch to country dimension, export a second CSV
- Open the Excel workbook, go to the Analytics tab, paste both exports
- Reconcile the column structures by hand because the two CSVs have different shapes
- Build the stacked bar chart manually
- It is Sunday night and the kickoff is at 9 AM Monday.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to Amplitude's User Composition API and writes both breakdowns into the Analytics tab in the structure you actually need for the chart.
Open the SheetXAI sidebar and type:
Fetch the user composition breakdown by platform from Amplitude for the last 30 days. Write platform name into column A and user percentage into column B of the Analytics tab. Then fetch the user composition breakdown by country and write the top 10 countries into columns D and E with country name and user percentage. Add header rows for both tables.
SheetXAI calls the Amplitude API twice, lands both tables in the right columns of the Analytics tab, and adds headers. Your stacked bar chart and supporting table are ready.
What You Get
Two clean breakdown tables in the Analytics tab:
- Columns A–B — platform breakdown: iOS, Android, Web with user percentages for the last 30 days
- Columns D–E — top 10 countries by user percentage for the same period
- Headers on both tables
The percentages are from the actual Amplitude user composition data. If 52% of your users are on iOS, that is what column B says.
The stacked bar chart builds from the platform table. The geographic table is the supporting data for the meeting.
What If the Data Is Not Quite Ready
User composition breakdowns often need more shaping than a simple pull. SheetXAI handles the complexity in the same prompt.
When you want the composition split by both platform and country in a cross-tab
The head of product wants platform distribution within each country, not just overall totals.
Fetch user composition from Amplitude for the last 30 days, broken down by both platform and country. Write the result as a pivot-style cross-tab into the Analytics tab with countries in column A and one column per platform (iOS, Android, Web) showing user percentage for that country-platform combination.
When you want to compare Q1 and Q2 composition side by side
The kickoff meeting asks whether the platform mix shifted versus last quarter.
Fetch user composition by platform from Amplitude for Q1 2025 and Q2 2025 separately. Write platform names in column A of the Analytics tab, Q1 percentages in column B, and Q2 percentages in column C. Add a fourth column D showing the change (Q2 minus Q1) for each platform.
When you only want users who are paying subscribers
The product team cares about the paying user base, not all users.
Fetch user composition by platform from Amplitude for the last 30 days, filtered to users with plan_type equal to 'paid'. Write platform name in column A of the Analytics tab and paying-user percentage in column B. Add a note in cell D1 that this reflects paying subscribers only.
When you need the platform breakdown, geographic breakdown, a quarter-over-quarter delta, and a written summary all in one pass
The kickoff workbook needs the tables and a paragraph the head of product can read from.
Fetch user composition by platform from Amplitude for Q1 2025 and Q2 2025. Write the Q1 and Q2 percentages and Q2-minus-Q1 delta for each platform into columns A–D of the Analytics tab. Fetch the top 10 countries by user percentage for Q2 2025 and write them in columns F–G. Then write a two-sentence summary in cell I1 identifying which platform grew the most quarter over quarter and which country moved up the most in the top 10.
The pattern: both breakdowns, the delta columns, and the written summary all happen in one prompt. The kickoff workbook is ready before Sunday night.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull Amplitude user composition breakdowns with whatever dimensions and time ranges the meeting requires. The Amplitude integration is included in every plan. For related workflows, see how to pull event segmentation trends or the Amplitude in Excel overview.