Facebook Analytics Pivot Table (Cross-Tables)

Uncover hidden insights in Facebook data with customizable pivot tables for instant cross-dimensional analysis.

Ceyhun Enki Aksan
Ceyhun Enki Aksan Entrepreneur, Maker

Important Rules:

  1. Maintain the original formatting (markdown, HTML tags, links, etc.)
  2. Keep technical terms and proper nouns as appropriate
  3. Preserve code blocks and technical syntax exactly
  4. Maintain the same tone and style
  5. Only output the translated text, no explanations or comments

Let’s continue with Facebook Analytics to explore how we can summarize application data by different metrics and dimensions, as much as the applications allow (pivot table)[(../pivot-table-nedir)].

It’s worth noting upfront that Facebook Analytics presents data in a form different from the conventional view and functionality—by transferring data into rows and columns—and this process is referred to as Splits1.

tip

You may find support requests related to Tag Management here.

Facebook Analytics - Splits
Facebook Analytics - Splits

Navigate to the relevant page by following the steps: Facebook Analytics > Actions > Splits. Upon arrival, you will notice that no split has been pre-defined. Along with a few key points to pay attention to, we can create our first summary table using the Create Split option.

Facebook Analytics Splits

Splits (summary table) is a Facebook Analytics reporting method that helps us understand how users/customers who visit our website, app, or other products use them. Data obtained based on up to three parameters (e.g., by channel, age or gender demographics, or by session traffic source) is presented as a summary table in the section below. You will observe that the table shrinks as you select each split. This process is supported by all statistical entities (e.g., Pixel, app, or group).

Facebook Analytics Splits
Facebook Analytics Splits

Anyone with access to Facebook Analytics can create a breakdown using the Breakdowns feature. However, only Administrators and Developers can save these breakdowns or edit and delete saved breakdowns. By clicking on the fields designated as breakdowns, you can select new events or parameters for these operations.

Facebook Analytics Breakdowns
Facebook Analytics Breakdowns

In the above example image, we’re breaking down the Page Views event by Traffic Source, City, and Gender. When creating a breakdown, you must first select either Predefined Events or Custom Events. Then, you can display data using Event Properties and Session Properties as the breakdown criteria. With the second and third selections, you’ll add the parameters you’ve defined as columns in the table. Additionally, you can specify that the defined columns be expressed numerically or as percentages. Don’t forget to save the created breakdowns under your permissions, pin them to the dashboard, and/or export them as CSV files.

Breakdowns and Filters

Once we’ve defined our breakdowns and created our table, after listing our data within the columns, we can now search within specific columns to filter our data. You can filter your data. Simply enter the search term you’d like to use in the search field located at the top of the table.

Facebook Analytics Breakdowns
Facebook Analytics Breakdowns

In addition to searching, you can narrow down your data using the filter field with internet parameters, demographic data, app and device information, events, and many other data fields.

In my article on Facebook Pixel and Standard Events, I discussed event tracking and usage. Thanks to event breakdowns, we can list the data we collect through events in tabular format and analyze answers to our questions by rows and columns.

Footnotes

  1. Creating and Managing Breakdowns. Facebook Analytics