Pivot table for marketing data: analyse raw exports fast

A pivot table is an interactive table that lets you group, filter and compare raw marketing data without writing a single formula. You export your data from GA4, your ad platform or your CRM into Excel or Google Sheets, and within a few clicks you can see what is happening per channel, campaign or period. TL;DR: for most SME analyses you do not need an expensive dashboard platform, a pivot table is enough. In this article you will learn what a pivot table is, how to build one and how to use it to see what really leads to customers.

What exactly is a pivot table?

A pivot table takes a long, messy list of data and summarises it the way you choose. Imagine you have an export of a thousand rows with sessions, channels, campaigns and conversions. On its own, that list tells you nothing. A pivot table turns it into an overview in seconds, for example the total number of leads per channel.

Data is often called the new oil, but raw data only has value once you can read it (Wired). That is where the pivot table comes in. It helps you summarise, analyse and present large datasets in an understandable format, as Microsoft also describes in its own documentation.

For B2B that is extra useful. Your traffic is smaller than a webshop’s, your sales cycles are longer and every signal counts. Good data analysis therefore does not start with an expensive platform, but with slicing the data you already have in a smart way. If you would like this fully set up and connected to your goals, our data analytics approach can help you with that.

Which marketing data do you put into a pivot table?

Practically any export where each row contains one event or record will work. The most useful sources for B2B:

• GA4: sessions, users and conversions per channel, source or landing page.
• Ad platforms: impressions, clicks, costs and conversions per campaign (Google Ads, LinkedIn Ads).
• Your CRM: leads, deals and revenue per source, period or account manager.
• Email: opens, clicks and sign-ups per campaign.

The golden rule: make sure the first row has clear column headers and that every row underneath is one single measurement. No merged cells, no empty rows in between. The cleaner the export, the faster your pivot table will be correct.

How do you build a pivot table step by step?

It works almost identically in Excel and Google Sheets. Here is the step-by-step plan in Excel.

1. Export and paste your data. Pull your CSV from GA4 or your ad platform and open it in a blank worksheet. Make sure the column headers are at the top.
2. Check the columns. Are amounts showing as plain numbers instead of currency? Select the cells and pick the right format under the Home tab. Delete empty rows and columns.
3. Select your data. Highlight all cells including the headers. You do not have to include every column, only what you want to analyse.
4. Insert the pivot table. Go to the Insert tab and click PivotTable. Let it open in a new worksheet, that keeps things tidy.
5. Drag the fields. You get four zones: filters, columns, rows and values. Put “Channel” under rows and “Conversions” under values, for instance.
6. Choose the calculation. By default Excel adds up (sum). Want an average or a count? Click the value field and adjust the setting.

Done. Where you first had a thousand rows, you now see one line per channel with the matching totals, including a grand total. Want to look at it per month instead of per channel next? Untick the one field and drag “Month” into the rows. The numbers recalculate immediately, you do not have to start over.

How do you use a pivot table to see what leads to customers?

This is where the difference between collecting data and using data lies. It is tempting to look at the big numbers: which page got the most visitors, which post the most likes. But those are vanity metrics. For your business, what counts is what leads to leads and revenue.

So set up your pivot table to answer that question. Concretely:

• Channel versus conversions, not sessions. Put your channels in the rows and your conversions in the values. Optionally add a column with your conversion rate per channel. Then you see not which channel is the busiest, but which channel delivers the most.
• Campaign versus costs and leads. Combine costs and conversions per campaign. A campaign with lots of clicks but few leads costs you money without results.
• Period versus revenue. Compare months or quarters to see whether a change in your approach had any effect.

Then filter with intent. Show only paid channels, or only one campaign, and watch how the numbers shift. Just as with setting up your marketing KPIs, the rule is: measure what brings you closer to a customer, not what happens to score well on a screen. An honest analysis also dares to conclude that a channel delivers nothing.

Do you need a dashboard or an expensive tool?

Honest answer: usually not, certainly not as a smaller team. A pivot table in Excel or Google Sheets covers the vast majority of the analyses an SME needs. You can group, filter, compare and even add a chart. For a monthly review of your channels that is more than enough.

A marketing dashboard or a paid platform only becomes interesting once you rebuild the same analysis every week, once several people need to look at it at the same time, or once you want to connect your sources automatically. Until then, a tool like that mostly costs you money and setup time without giving you better decisions. Start small. As soon as you notice that exporting manually is holding you back, that is the signal to scale up.

How do you present the result?

Numbers in a table convince no one in a meeting. A pivot chart turns your analysis into a visual in a few clicks. Click inside your pivot table, go to the Analyze tab and choose PivotChart. A clustered column chart works well for putting channels or months side by side.

Keep it simple: one clear message per chart. Good data visualisation makes a trend visible at a glance, so your conversation is about the numbers instead of about reading them.

Frequently asked questions

Does a pivot table work in Google Sheets too? Yes. Select your data, go to Insert and choose Pivot table. The zones have slightly different names, but the principle is identical to Excel.

How much data can a pivot table handle? For most SME exports that is not an issue. Only at hundreds of thousands of rows will you notice Excel slowing down; at that point a database or dashboard makes more sense.

Do I need to know formulas? No. That is exactly its strength. You drag fields and pick a calculation, the tool does the maths for you.

How often should I refresh my pivot table? With a new export you right-click the table and choose Refresh, or you paste fresh data into the same range. For B2B, a monthly round is usually enough.

Does this replace GA4 or my ad platform? No, it complements them. You use the export from those tools and slice it your way, separate from the standard reports.

Get started with your own data

A pivot table is one of the fastest ways to get a grip on your marketing data, and you do not need an expensive platform for it. Start with one export, group by channel or campaign, and steer on what leads to customers. Would you like us to set up your tracking, analysis and reporting so you base decisions on numbers instead of gut feeling?

Book your free intake