Providea workbookcontaining at least15 attributes
Geta ready-to-use,best-in-marketFACEBOOK ADS dashboard
Facebook Ads Home
Facebook Ads Home
Get a Home Page for your Facebook Ads dashboard
Facebook Ads Cockpit
Facebook Ads Cockpit
Get an overview on the performance of your Facebook Ads campaigns
Facebook Ads Campaign Performance
Facebook Ads Campaign Performance
Get an overview of the performance of each Facebook Ads camapign
Facebook Ads: 1 - Awareness
Facebook Ads: 1 - Awareness
Visualize your efficiency in developing brand awareness on Facebook
15 required attributes
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
27 KPIs
- 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 %
15 dashboard pages
- Facebook Ads Home
- Facebook Ads Cockpit
- Facebook Ads Campaign Performance
- Facebook Ads: 1 - Awareness
- Facebook Ads: 2 - Engagement
- Facebook Ads: 3 - Conversion
- Facebook Ads Top KPIs Breakdown
- Facebook Ads Investment Efficiency
- Facebook Ads Top KPIs Trends
- Facebook Ads Performance Cockpit
- Facebook Ads Digital Impact
- Facebook Ads Top Contributors (6 KPIs)
- Facebook Ads Trends Analysis
- Facebook Ads Segmentation Analysis
- Facebook Ads Pareto Analysis
Detailed presentation of the FACEBOOK ADS dashboard
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
and 15 dashboard pages
Home
Facebook Ads Home
Facebook Ads Home
Get a Home Page for your Facebook Ads dashboard
Cockpit
Facebook Ads Cockpit
Facebook Ads Cockpit
Get an overview on the performance of your Facebook Ads campaigns
Facebook Ads Top KPIs Breakdown
Facebook Ads Top KPIs Breakdown
Get a transverse view on your top 6 Facebook Ads KPIs, split by the dimension of your choice
Facebook Ads Top KPIs Trends
Facebook Ads Top KPIs Trends
Visualize how your Facebook Ads KPIs are evolving (Month-to-Date, Year-to-Date)
Facebook Ads Performance Cockpit
Facebook Ads Performance Cockpit
Visualize the performance on your top 4 Facebook Ads KPIs, how this performance evolves over time and who contributes to this performance
Facebook Ads Top Contributors (6 KPIs)
Facebook Ads Top Contributors (6 KPIs)
Instant overview of your Facebook Ads top 6 KPIs split by the dimension you selected.
Campaign Performance
Facebook Ads Campaign Performance
Facebook Ads Campaign Performance
Get an overview of the performance of each Facebook Ads camapign
Facebook Ads: 1 - Awareness
Facebook Ads: 1 - Awareness
Visualize your efficiency in developing brand awareness on Facebook
Facebook Ads: 2 - Engagement
Facebook Ads: 2 - Engagement
Visualize your efficiency in engaging with your target audience on Facebook
Facebook Ads: 3 - Conversion
Facebook Ads: 3 - Conversion
Visualize your efficiency in converting your ads to actual business on Facebook
Facebook Ads Investment Efficiency
Facebook Ads Investment Efficiency
Visualize the efficiency of your investment on Facebook Ads
Facebook Ads Digital Impact
Facebook Ads Digital Impact
Visualize how the performance of your Facebook Ads campaigns evolves across time
Trends Analytics
Facebook Ads Trends Analysis
Facebook Ads Trends Analysis
Visualize the evolution of any of your Facebook Ads KPIs: Trends, Performance & Year over Year
Distribution Analytics
Facebook Ads Segmentation Analysis
Facebook Ads Segmentation Analysis
Visualize the value of any of your Facebook Ads KPIs, split by the dimension you selected (market share analysis)
Facebook Ads Pareto Analysis
Facebook Ads Pareto Analysis
Perform a Pareto Analysis on any of your Facebook Ads KPIs: the 80/20 rule.
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):
-
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
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).
Dashboard Template
- Predefined (and customizable) KPIs
- Predefined DataViz
Transverse Functions
Sales Planning
Digital Marketing
Social Media
Procurement
Finance
Profit & Loss
Balance Sheet
Supply Chain
Quality & Production
General Services
Service Desk / Call Center
Project Management
Sentiment Analysis
Classification
Specific to a Business Sector
Retail
Healthcare
Medical Visits
Fundraising
Education
Insurance
Banking
Telecommunications
Start-up
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!
