The first step is to create an Ads Manager report containing the fields to import into the tool. For this example, I’ll build a report containing the Month, Campaign ID, Ad Set ID, Platform, and several metrics.
There are many BI tools. Popular options include Looker (part of Google Cloud), Tableau, and Sisense, although all tools are generally similar in concept.
Once the file is uploaded, click “Visualize” to create the analysis.
Data from a Meta Ads report can also be exported and uploaded to a BI tool.
QuickSight added commas to the Campaign ID. But we can remove them to show the ID as it appears in Meta. To do this, hover over the Campaign ID in the field list. Click the ellipse to open the menu and select “Format.”
Clicking on Campaign ID in the left menu labeled “Fields list” will instantly produce a chart of the Meta Ads campaigns.
Add a New Dataset
The result is a comprehensive, interactive dashboard with easy-to-digest insights.
Once the file is uploaded, click “Visualize” to create the analysis. Importing the data could take a moment or two.
QuickSight starts the analysis with an “AutoGraph” that will assign a visualization as you select fields from the list on the left menu. But one could manually add a visualization from the “Visual types” section in the lower-left portion of the interface.
It is worth mentioning that QuickSight can load data into server memory — using what it calls “Super-fast, Parallel, In-memory Calculation Engine” or SPICE — for fast data computations. The feature is more important for direct connections.
QuickSight generated a comprehensive, interactive visualization of Meta Ads data.
When clicks are added to the visualization, one can easily ascertain that one campaign is producing many more clicks than the others.
Thus we can already see an advantage of using a BI tool. The Meta report was in a table view. It contained the same campaign data, but that data is much easier to digest as visualized in QuickSight.
QuickSight can connect to databases. Hence I could have accessed a Meta Ads API to add performance info to a database, such as Redshift or MySQL. Instead, I’ll upload the CSV file.
Clicking “Amount spent” from the field list adds a new bar showing the cost of each Meta Ads campaign.
QuickSight is part of Amazon Web Services. Amazon built the tool to solve its own business intelligence and data visualization needs. Staff throughout the company reportedly now use the tool as do 100,000 external folks.
Business intelligence tools help companies analyze and act on internal and external data. A good BI tool can import data from multiple sources — ecommerce software, ad platforms, selling channels — to produce tables and charts with insights for better decisions.
The Next Step
Clicking on Campaign ID in the left menu will instantly produce a chart of the Meta Ads campaigns.