
Period
Campaign Name
Ad Set Name
Ad Name
Cost
Impressions
Reach
Link Clicks
Page Likes
Post Shares
Post Comments
Post Reactions
Website Leads
Website Purchases
Website Purchases Conversion Value
- Total Cost
- Total People Reached
- Cost per People Reached
- Total Impressions
- CPM (Cost per 1'000 impressions)
- CTR (Click-Through-Rate)
- Total Link Clicks
- CPC (Cost per Click)
- Total Social Interactions
- CPA (Cost per Action)
- Social Interaction per Impression
- Total Page Likes
- Total Post Shares
- Total Post Comments
- Total Post Reactions
- Page Likes per Impression
- Post Shares per Impression
- Post Comments per Impression
- Post Reactions per Impression
- Total Website Leads
- CPL (Cost per Lead)
- LTR (Lead-Through-Rate)
- Total Website Purchases
- Total Website Purchases Value
- Avg Purchase Value
- Total Margin
- ROI %
Required Attributes
To get your Facebook Ads dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):
- Period Report Start Date (Date used for time-series analysis)
- Campaign Name Campaign Name
- Ad Set Name Ad Set Name
- Ad Name Ad Name
- Cost The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule
- Impressions The number of times that your adverts were on-screen
- Reach The number of people who saw your adverts at least once. Reach is different to impressions, which may include multiple views of your adverts by the same people.
- Link Clicks The number of clicks on links within the ad that led to destinations or experiences, on or off Facebook
- Page Likes The number of likes of your Facebook Page attributed to your ads
- Post Shares The number of shares of your adverts. People can share your adverts or posts on their own or friends' Timelines, in groups and on their own Pages.
- Post Comments The number of comments on your adverts
- Post Reactions The number of reactions on your ads. The reactions button on an ad allows people to share different reactions to its content: like, love, haha, wow, sad or angry.
- Website Leads The number of lead events tracked by the pixel on your website and attributed to your adverts
- Website Purchases The number of purchase events tracked by the pixel on your website and attributed to your adverts
- Website Purchases Conversion Value The total value of website purchases for products belonging to a catalogue segment used in a campaign
KPIs
Your FACEBOOK ADS dashboard will contain 27 KPIs
- Total CostThe estimated total amount of money you've spent on your campaign, ad set or ad during its schedule
- Total People ReachedThe number of people who saw your adverts at least once. Reach is different to impressions, which may include multiple views of your adverts by the same people.
- Cost per People ReachedAverage Cost per People Reach
- Total ImpressionsThe number of times that your adverts were on-screen
- CPM (Cost per 1'000 impressions)Average Cost per 1'000 impressions
- CTR (Click-Through-Rate)Click Through Rate: Total Link Clicks / Total Impressions
- Total Link ClicksThe number of clicks on links within the ad that led to destinations or experiences, on or off Facebook
- CPC (Cost per Click)Average Cost per Click
- Total Social InteractionsTotal Social Interactions: Page Likes, Post Shares, Post Comments and Post Reactions
- CPA (Cost per Action)Average Cost per Social Interaction
- Social Interaction per ImpressionAverage Social Interactions per Impression
- Total Page LikesThe number of likes of your Facebook Page attributed to your ads
- Total Post SharesThe number of shares of your adverts. People can share your adverts or posts on their own or friends' Timelines, in groups and on their own Pages.
- Total Post CommentsThe number of comments on your adverts
- Total Post ReactionsThe number of reactions on your ads. The reactions button on an ad allows people to share different reactions to its content: like, love, haha, wow, sad or angry.
- Page Likes per ImpressionAverage Page Likes per Impression
- Post Shares per ImpressionAverage Post Shares per Impression
- Post Comments per ImpressionAverage Post Comments per Impression
- Post Reactions per ImpressionAverage Post Reactions per Impression
- Total Website LeadsThe number of lead events tracked by the pixel on your website and attributed to your adverts
- CPL (Cost per Lead)Average Cost per Website Lead
- LTR (Lead-Through-Rate)Lead Through Rate: Total Website Leads / Total Link Clicks
- Total Website PurchasesThe number of purchase events tracked by the pixel on your website and attributed to your adverts
- Total Website Purchases ValueThe total value of website purchases for products belonging to a catalogue segment used in a campaign
- Avg Purchase ValueAverage Value per Purchase
- Total MarginTotal Margin
- ROI %Total Return on Investment
Dashboard Pages & Data Visualizations
Your Facebook Ads dashboard will contain 11 pages
Cockpit
Facebook Ads Cockpit
Facebook Ads Top Performers
Campaign Performance
Facebook Ads Campaign Performance
Facebook Ads: 1 - Awareness
Facebook Ads: 2 - Engagement
Facebook Ads: 3 - Conversion
Facebook Ads Investment Efficiency
Creating your FACEBOOK ADS dashboard Step-by-Step
You want to get a clear understanding on your Facebook Ads results? You want to build a Tableau dashboard to better understand your Facebook Ads data?
Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Facebook Ads data in less than 5 minutes!
1st STEP: Create the initial Tableau workbook file
Create a Tableau workbook in which you map your Facebook Ads data (whether it comes from: ERP, database, Excel, CSV file...)
You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):
2nd STEP: Upload your Tableau workbook file
On LinPack-for-Tableau.com, select 'create dashboard from template: Facebook Ads' and upload your Tableau workbook (note: your data is NOT uploaded).
3rd STEP: Map your attributes
Map the attributes of your workbook on the attributes of the template.
Finally, click 'Confirm & Download'... and your Facebook Ads dashboard is already downloading :-)
Open the Tableau workbook file you received, it will automatically reconnect to your data sources.
Your Facebook Ads dashboard is now ready to be used or customized!