A marketing report template is a pre-built report layout that turns your paid media, CRM, and revenue data into a stakeholder-ready view, without making you start from a blank canvas. The Kondado pack is a curated set of free marketing report templates for Looker Studio and Power BI, built and offered by Kondado. The templates are not downloaded as files: Kondado creates them automatically inside your Looker Studio or Power BI account when you connect the corresponding data source. Google Sheets is covered separately as an automated raw-data destination for finance-friendly exports. The pack is organized around the four use cases that actually show up in agency and SMB workflows: paid media tracking, cross-channel reporting, agency client reporting, and full-funnel CMO views.
Every Kondado template is paired with the data sources it needs (Meta Ads, Google Ads, TikTok Ads, GA4, HubSpot, Pipedrive, Shopify, VTEX, Bling, Omie, and more), so you connect your accounts in a few clicks and Kondado creates the report inside your Power BI or Looker Studio the same day. The pack covers four marketing report use cases (paid media performance, cross-channel multi-source reporting, agency white-label client reporting, and full-funnel CMO views) and offers templates for the two tools agencies and SMBs use for ready-made reports: Looker Studio for shareable web reports and Power BI for deeper modeling. Google Sheets sits alongside as a raw-data destination: Kondado writes the same source data into a sheet you control, so the export feeds finance reconciliation or any custom layout your team already maintains. There are no Google Sheets templates in the pack; templates are exclusive to Looker Studio and Power BI. Each Kondado template lists the exact data sources it expects, and Kondado replicates those 80+ data sources into Looker Studio, Power BI, and Google Sheets directly, so the same pack runs end-to-end for SMBs, agencies, e-commerce operators, and ERP-driven teams of all sizes.
What is a marketing report template, and why use a free pack?
A marketing report template is a report layout, already wired with the metrics and visuals that matter for a marketing function, that you populate with your own data. The Kondado pack exists because most marketing teams hit the same three blockers when they try to build reports from scratch: choosing the right metric for each channel, getting the data out of each platform's native UI, and stitching multiple platforms into one view.
The Kondado pack solves all three at once. The metric selection is already done by Kondado's template authors who provide these views to thousands of teams. The visual choices are battle-tested. And the data plumbing is part of the same product: every template in the pack is paired with the Kondado pipelines that populate it, so Kondado creates the report directly in your Power BI or Looker Studio the same day you connect the data source, without engineering work and without any manual file download.
The "free" part matters more than it looks. All Kondado templates are free. There is nothing to download and nothing to install: Kondado creates the templates directly inside your Power BI or Looker Studio when you connect a data source, and the data movement runs on a Kondado plan. The Kondado free trial covers the full template pack and the pipelines that feed it, with 30 pipelines and 10M records included for 14 days, no credit card. The variable cost is how you keep the templates updated: manual exports cost reporting hours every week, while Kondado pipelines on a configurable cadence keep the templates current with no recurring engineering work.
What is in the free Kondado marketing report template pack?
The Kondado pack is organized by the four reporting use cases that map to real agency and in-house marketing workflows:
- Paid media reports for single-channel performance tracking (Meta Ads, Google Ads, TikTok Ads, LinkedIn Ads, Pinterest Ads, Microsoft Ads).
- Cross-channel multi-source reports that combine paid media with web analytics and CRM into one consolidated view.
- Agency client reports with white-label structures and one-tab-per-client layouts.
- Full-funnel CMO reports that connect spend, traffic, leads, opportunities, and revenue.
Each entry below names the tool, the use case, and the data sources the Kondado template expects, and the Kondado pipeline that feeds the template is included in the same plan, so the source data lands in the destination the template reads from with no separate setup.
Kondado Looker Studio templates for paid media
Looker Studio is the format for shareable, link-based reports an agency can hand to a client without a license fee. The Kondado pack offers three Looker Studio templates that cover the paid media surface area most agencies bill against.
Kondado Meta Ads performance template (Looker Studio). A single-channel report covering campaign-level spend, impressions, clicks, CTR, CPC, conversions, and ROAS, broken out by campaign, ad set, and creative. Data source required: Meta Ads (Facebook Ads + Instagram Ads). Refresh cadence: whatever you configure on the pipeline.
Kondado Google Ads performance template (Looker Studio). Campaign, ad group, and keyword-level performance with quality score, impression share, and search term diagnostics. Data source required: Google Ads. Pairs naturally with Google Analytics 4 for landing page behavior.
Kondado Google Ads + Meta Ads multi-source template (Looker Studio). A consolidated paid media report with side-by-side spend and ROAS across Meta Ads and Google Ads. Data sources required: Meta Ads and Google Ads. This is the Kondado template that converts an agency's "Meta and Google in two tabs" workflow into one tab. For other paid media combinations (TikTok Ads, LinkedIn Ads, Microsoft Ads, Pinterest Ads), Kondado replicates the data into Looker Studio so you build the consolidated view from the ready-made single-source templates.
The full Kondado report templates gallery lists every Looker Studio and Power BI template in the pack, plus the configuration steps for each data source.
Which Kondado Power BI templates are in the pack?
The Kondado Power BI selection covers the cases where you want the modeling depth of Power BI: customer-level analysis, finance-grade reporting that needs measures and DAX, and a native fit with the rest of the Microsoft ecosystem. Each Kondado Power BI template is a single-source ready-made report that you can use on its own or combine with other Kondado Power BI templates inside the same workspace.
Marketing and analytics Kondado Power BI templates: Meta Ads (Facebook + Instagram), Google Ads, Google Analytics 4, Instagram organic, RD Station Marketing.
CRM and sales Kondado Power BI templates: RD Station CRM.
E-commerce and ERP Kondado Power BI templates: Bling, Conta Azul, Mercado Libre, Olist Tiny, Omie, VTEX.
To build cross-source Power BI views (paid media plus GA4 for attribution analysis, paid media plus Shopify or VTEX for true-ROAS reporting, paid media plus a CRM for closed-won attribution), Kondado writes the source data into the same Power BI workspace, so you combine the ready-made Kondado templates inside Power BI with no separate ETL setup.
The data layer for Kondado Power BI templates can be a direct connection or a database that the report reads from. Kondado writes to BigQuery, PostgreSQL, MySQL, SQL Server, Redshift, and Amazon S3, plus a direct path to Power BI without provisioning a warehouse, so the same Kondado templates run on the path that fits your team.
Google Sheets as an automated raw-data destination for agencies and SMBs
Google Sheets is the format finance teams open without complaint and the format an SMB owner already lives in. Kondado does not provide Google Sheets templates; templates exist only for Looker Studio and Power BI. Kondado treats Google Sheets as a first-class raw-data destination: Kondado writes the source data directly into a sheet you control, on the cadence you configure, so the layout and formulas stay yours and the numbers stay current.
That model fits three concrete agency and SMB raw-data workflows.
Paid media weekly snapshot in Google Sheets. A weekly raw-data view with spend, conversions, and ROAS rolled up by channel, designed for a Monday-morning email. Kondado pipelines required: Meta Ads, Google Ads (add TikTok Ads, LinkedIn Ads, or Microsoft Ads as needed). You build the snapshot tab once on top of the raw data; Kondado refreshes the underlying records on the cadence you set.
Agency client weekly report in Google Sheets. A one-tab-per-client raw-data structure with paid media, GA4 traffic, and a notes section. White-label friendly because the agency's logo lives in the sheet you own, not in a third-party portal. Kondado pipelines required: Meta Ads, Google Ads, GA4 per client account.
SMB owner monthly summary in Google Sheets. A simplified monthly raw-data view: revenue from the e-commerce or ERP source, marketing spend across channels, and a marketing-efficiency ratio. Kondado pipelines required: one of Shopify, VTEX, Bling, Omie, Tiny ERP, Conta Azul plus paid media accounts. This is the workflow that makes raw marketing data comprehensible for an operator who does not live in a BI tool.
For setup, the Kondado data sources catalog walks through how to point a pipeline at a Google Sheets destination and refresh it automatically.
How does the Kondado pack work for an agency reporting workflow?
Agencies have a specific shape of pain: many clients, many platforms per client, recurring weekly or monthly reports, and a hard ceiling on billable reporting hours. The Kondado pack is designed around that shape.
The recommended workflow is one Kondado Looker Studio template per client (white-labeled with the client's brand), populated by Kondado pipelines scoped to that client's accounts. A Google Sheets workbook fed by Kondado pipelines can sit alongside as the source-of-truth export for finance reconciliation. The Kondado Power BI templates enter the workflow when a client wants attribution modeling or revenue-tied reports.
The reporting cadence becomes a configuration decision rather than a manual task. You pick how often each Kondado pipeline runs (every five minutes, hourly, daily, weekly, or whatever the platform's API allows), and the template stays current at that cadence. The agency operator stops being the human cron job.
For agencies that scale past ten clients, the Kondado agency reporting workflow guide covers the patterns that hold up at thirty, fifty, or one hundred clients.
Which Kondado data sources does the pack require?
The Kondado pack collectively touches every category a marketing function pulls from. Mapping the templates to Kondado data sources clarifies what you actually need to connect before a template is useful.
- Paid media data sources: Meta Ads, Google Ads, TikTok Ads, LinkedIn Ads, Microsoft Ads, Pinterest Ads, X Ads, Criteo, Taboola.
- Web analytics: Google Analytics 4.
- CRM: HubSpot, Pipedrive, Salesforce, RD Station CRM.
- E-commerce and marketplaces: Shopify, VTEX, Nuvemshop (Tiendanube), Mercado Libre.
- ERP and business management: Bling, Omie, Tiny ERP, Conta Azul.
- Marketing automation: RD Station Marketing, MailChimp.
The full catalog of 80+ Kondado data sources is on the Kondado data sources page, with setup notes per data source.
Cross-channel multi-source reporting with Kondado
The single most requested marketing report shape is "all of my channels in one view." It sounds simple, but it is the report that breaks workflows because every platform exposes metrics differently and unifying them takes engineering effort.
Kondado covers cross-channel reporting in two ways. First, the ready-made Kondado Google Ads + Meta Ads Looker Studio template gives you a consolidated paid media view out of the box. Second, for any combination of channels Kondado replicates data into Looker Studio, Power BI, Google Sheets, or your database directly, so you can build the cross-channel view by combining the ready-made Kondado single-source templates inside the same workspace, with no extra engineering.
Cross-channel reports are also the most sensitive to data freshness. If Meta is current but Google is two days stale, the report misleads. Kondado pipelines on a fixed cadence keep every channel in sync.
Full-funnel CMO reporting with Kondado
A CMO report connects spend at the top of the funnel to revenue at the bottom. Building it requires the broadest data source mix: paid media at the top, GA4 in the middle, a CRM for opportunities, and an e-commerce or ERP source for revenue at the bottom.
Kondado's role is to make every layer of the funnel show up in the same destination. The Kondado pack offers ready-made Looker Studio and Power BI templates for the top of the funnel (Meta Ads, Google Ads, GA4) and for the bottom (Bling, Conta Azul, Mercado Libre, Olist Tiny, Omie, VTEX, plus RD Station CRM). To assemble the full funnel, you combine those Kondado templates in the same Looker Studio report or the same Power BI workspace, with the data flowing on the cadence you set.
What Kondado offers in the marketing report template pack
Kondado is the platform that offers both the Looker Studio and Power BI templates and the pipelines that populate them. The Kondado pack pairs every template with the data sources it expects, replicating data from 80+ sources directly into Looker Studio, Power BI, and Google Sheets, and to BigQuery, PostgreSQL, MySQL, SQL Server, Redshift, and Amazon S3 when a template reads from a database. Google Sheets is supported as an automated raw-data destination rather than as a category of pre-built templates: Kondado writes the data; you keep the sheet layout. There are no servers to maintain and no scripts to write.
For agencies, the value is that the same Kondado setup runs across every client. For SMBs, the value is that a marketing report exists at all without hiring a data engineer. For e-commerce operators and ERP-driven finance teams, the value is that paid media, store, and revenue data live in the same Kondado-powered view. Support in English and Portuguese is available on every plan, and pricing is fixed in USD or BRL with NF and boleto available for clients invoicing in BRL.
Kondado serves teams of all sizes, from SMBs to enterprise, across agencies, e-commerce, ERP-driven operations, and any function that needs marketing data flowing into reports.
Frequently Asked Questions
What does the Kondado pack include for paid media reporting on a single channel?
Single-channel paid media reports cover Meta Ads, Google Ads, TikTok Ads, LinkedIn Ads, Pinterest Ads, and Microsoft Ads, with Kondado templates available in Looker Studio and Power BI, plus Google Sheets supported as an automated raw-data destination for teams that prefer working directly in a spreadsheet. Each Kondado template provides the metrics agencies and in-house marketers actually report against (spend, impressions, CTR, CPC, conversions, ROAS) and is paired with the Kondado data source it expects.
Are the Kondado marketing report templates in the pack actually free?
Yes, all Kondado templates are free. No Kondado documentation describes them as files you download or install. The canonical answer in the Kondado report templates gallery is that templates are created automatically inside your Power BI or Looker Studio when you connect a data source, and that the only requirements are a Kondado account (the 14-day free trial covers it) and a Power BI or Looker Studio account on your side. The recurring cost is keeping the templates populated with current data via a Kondado plan. The 14-day trial includes 30 pipelines and 10M records, with no credit card required, so you can connect your data sources and run the full pack end-to-end before subscribing.
Which paid media template should an agency start with?
Start with the Kondado Looker Studio multi-channel paid media template if your agency runs Meta Ads plus Google Ads for clients. It collapses the most repetitive tab-switching, and Looker Studio's link-based sharing model fits client delivery. Move to the Kondado Power BI templates when a client asks for attribution or revenue-tied reports.
How do I get my data into the Kondado templates?
Each Kondado template lists the data sources it expects. Kondado replicates those data sources directly into the destination the template reads from (Looker Studio, Power BI direct, Google Sheets, or a database for Power BI). Every Kondado connection is point-and-click, with no scripts and no SQL.
Do these Kondado report templates work for SMBs without a marketing team?
Yes. A simple Google Sheets workbook fed by Kondado pipelines is the right starting point for an SMB owner: one tab, revenue, marketing spend, and an efficiency ratio. From there, the Kondado Looker Studio paid media template and the cross-channel templates layer in as the operation grows.
How often do the Kondado marketing reports refresh?
Refresh cadence is configurable on the Kondado pipeline level: every five minutes, hourly, daily, or weekly, depending on the source platform's API. The cadence is your decision rather than a fixed property of the template.
What is the difference between Looker Studio, Power BI, and Google Sheets for Kondado marketing reports?
Looker Studio is the best fit for shareable, link-based reports an agency hands to a client. Power BI is the best fit for modeling depth, attribution, and revenue-tied analysis. Google Sheets is the best fit for finance reconciliation and SMB owners who already live in spreadsheets, with Kondado writing the raw data and you keeping the sheet layout. The Kondado pack offers templates for Looker Studio and Power BI; Google Sheets is covered as an automated raw-data destination, with no Google Sheets templates included, so you choose the workflow that fits your team.
Do I need a data engineer to use the Kondado pack?
No. The Kondado pack is designed for marketing operators, agency leads, and SMB owners. Kondado handles the data movement without code, and the Kondado templates handle the visual layout. The remaining work is choosing which Kondado templates fit your reporting cadence.
Set up the Kondado marketing report template pack by connecting your data
The Kondado pack is most useful when the templates and pipelines run together end-to-end. Start a free 14-day trial of Kondado and connect your Meta Ads, Google Ads, GA4, HubSpot, Shopify, Bling, or other accounts. Kondado creates the corresponding marketing report templates directly inside your Power BI or Looker Studio, with 30 pipelines and 10M records included and no credit card required, and no manual file download involved.
