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: