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 %
11 dashboard pages
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
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 Performers
Facebook Ads Top Performers
Get an instant understanding of your top Facebook Ads performers: current, mid and long term performance
Top 4 KPIs Trends (MTD/YTD)
Top 4 KPIs Trends (MTD/YTD)
Visualize how your Performance is evolving (Month-to-Date and Year-to-Date)
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
Historical Performance
Historical Performance
Visualize how the performance of your Facebook Ads campaigns evolve across time
Behavioral Analytics
Facebook Ads Adhoc Analysis
Facebook Ads Adhoc Analysis
Perform simple ad-hoc analysis on your Facebook Ads data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)
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).
74 Dashboard Templates
- Predefined (and customizable) KPIs
- Predefined DataViz
▶ Transverse Functions
.svg?0661)
.svg?0399)
.svg?0428)
▶ Specific to a Business Sector
▶ Specific to a Data Source
▶ TRIAL Templates
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!
