# Pivot tables
### **Pivot tables**
You may want to see or export crosstabs of one outcome, user feature, or design feature, by another. Sometimes you just want to see these quickly, but this might also be a way to extract the 'raw data' you wish to analyze elsewhere.
1. **Start new pivot table**
~~From within Ads Manager~~ From 'ads reporting' (3 Aug 2022 updated interface)\
Click "Create Report" --> Pivot table
**2. As before, make sure you've selected the right date range, and (redo) any relevant filters**
Here I add a filter for 'campaign name **'** contains 'general'. Because I'm specifically trying to pull down some information on 'which video people saw' in this group (which needs a special setting to access... as noted below)
**3. "Customize pivot table" – "Breakdowns" ...** the things you want this to disaggregate across (sums and averages within groups)
* the 'campaigns', the 'ad names'
* timing, demographics
* Drill down to "Custom breakdowns", "Dynamic Creative Asset", to get it broken down by the text linked to the ads:
{% hint style="warning" %}
**However**, some breakdowns are not compatible with other breakdowns (maybe for privacy reasons?)\
\
For example, if I tick 'Gender' I cannot have it broken down by 'Image, video, and slideshow', at least in the present case ... (perhaps because it narrows down too few observations?)
 \
{% endhint %}
**4. "Customize pivot table" – "Metrics"**
Select the things you want reported, and deselect things that are not interesting or irrelevant to this case (like 'website purchases') or numbers that can be easily computed on your own
Normally, I'd suggest leaving out the redundant 'Cost per Result' but it's probably good to have as at least one sanity and data check.
Other stuff like 'video play time' could sometimes be very relevant, but I'll leave it out for now
I added a few features I thought might be interesting or useful. Was anyone drawn in to pledge? When did each campaign start/end (doublecheck)? How many *unique* link clicks?\
\
**5. (Optional) Conditional formatting**
This could also be helpful if you are using the Ads Manager tools *in situ*, but obviously this has no value for downloading.
**6. Save report for later use, share**
If you think the report is useful in-situ, you can also share a link
**7. Export the data**
As in [Facebook ads interface](/untitled/marketing-and-testing-opportunities-tools-tips/collecting-data-trial-outcomes/facebook-meta-ads-interface.md#extracting-simple-results)...
(or consider direct import into R using tools like the `rfacebookstat` package)
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://globalimpact.gitbook.io/untitled/marketing-and-testing-opportunities-tools-tips/collecting-data-trial-outcomes/facebook-meta-ads-interface/pivot-tables.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.