Questions this template answers
- How are spend, cpc, and cpm trending?
- Which year & week values contribute most to spend?
- Where should the team investigate or optimize Facebook Ads performance?
Claude.ai & MCP supported — another step towards a more powerful AdzviserRead Me
+
Free Facebook Ads Weekly Campaign Performance Report Template for Google Sheets
A Facebook Ads weekly campaign performance report for Google Sheets — track spend, CPC, CPM, impressions, post engagements, CTR, and clicks over the last 12 weeks, with a week-on-week trend chart and a top-15 campaign breakdown by ad set.
Get the template →
What You Can Learn from This Facebook Ads Template
Use the report to answer practical performance questions with the fields and breakdowns already included in this template.
Best for
- Paid media managers
- Performance marketers
- Marketing agencies
Template setup
- 10 preselected metrics
- 6 reporting dimensions
- Google Sheets editable spreadsheet
- Live Facebook Ads data through Adzviser
Metrics & Dimensions
The Facebook Ads metrics and dimensions this template is pre-built with — no manual setup needed.
Metrics
Spend
CPC
CPM
Impressions
Post Engagements
CTR%
Clicks (All)
Link Clicks
Website Custom Conversions
Cost Per Website Custom Conversion
Dimensions
Date Range
Year & Week
Campaign Name
Ad Set Name
Account Currency
Campaign Objective
Setup guide
How to Get Started
Set up your Facebook Ads Google Sheets template in three simple steps.
1
Sign up for Adzviser
Create your account and start your 14-day trial for just $0.99. Cancel anytime. Start your trial →
2
Connect Facebook Ads
Link your account through secure authentication and select the data you want to report on. Explore the Facebook Ads connector →
3
Copy the template
Open the template in Google Sheets, connect Adzviser, and customize it to your needs. Learn about Google Sheets →
Related Templates
Explore more templates for Facebook Ads or Google Sheets.
Facebook Ads Weekly Campaign Performance FAQs
This template is prebuilt with 10 metrics and 6 dimensions, along with the charts, tables, formulas, or controls shown in the preview. The Metrics & Dimensions section above lists the exact fields included in this version.
Make a copy of the spreadsheet, connect Facebook Ads to an Adzviser workspace, enter the exact workspace name in the adzviserQuery worksheet, and run Refresh all queries from the Adzviser add-on. Open the Facebook Ads connector guide →
Yes. Connect the accounts to your Adzviser workspace, then select or query the accounts needed for the report. For agency workflows, you can also keep a separate copy per client so access, filters, and branding stay independent.
Use Refresh all queries for an on-demand update, or add an automatic refresh trigger from the Adzviser add-on's Schedule tab. Google Sheets triggers can run daily, weekly, or monthly. See refresh instructions →
Yes. You can change formulas, charts, pivot tables, formatting, queries, and tabs. Keep imported column names and ranges stable—or update anything that references them—so later refreshes continue feeding the report correctly.
Confirm that you copied the file, installed the Adzviser add-on, connected Facebook Ads, and entered the exact workspace name expected by adzviserQuery. Run Refresh all queries and review any error shown in the add-on sidebar.
Yes. The template itself is free to copy and customize in your own account. You need an Adzviser account when you want to replace its sample data with a live Facebook Ads connection and keep that data refreshed. See Adzviser pricing →
