Social Media Marketers now look at their Facebook ads demographic reporting in a Google sheet which displays the age and gender reporting script which automatically setup your data into a pyramid graph!

Steps to do it:

The tool works as a Google Sheet Add on.

Go to Chrome Web Store Page and click Add to Chrome.

After installation, there is a need to authorize it with google account. Once done, it will appear in the add ons menu bar when you create a new spreadsheet. After this, you will need to connect it with Facebook which you can do by opening the addon’s sidebar. Fill your account ID over there(Business Manager>Add Account Settings) & click to Download to fetch the data in the spreadsheet.

What the Data Contains?

The spreadsheet data contains Impressions, click & spend data for active campaigns of last 7 days filtered by gender & Age.

How to Make a Pyramid Graph?

To make the graph, you need to copy the name of campaign from column A & Paste under the pyramid graph section of the sidebar. Pick the stats which you want to see the graph (clicks, impression, spend, CTR or CPC) & click create.

The Graph is ready. You can also save the image of that graph & you can create as many reports you want for various campaigns.

Check out the sample of Pyramid Graph Attached Below:

Image source:searchengineland