Monday morning often starts with the same routine. Someone exports a CSV from Google Ads and another from Meta Ads, builds a report in GA4, pulls the pipeline numbers from the CRM, pastes everything into a spreadsheet and fixes the formulas before sending it to the team. An automated marketing reporting dashboard replaces that routine with one report that refreshes on a schedule.
Two public studies put a size on the problem. Airtable's research, published in March 2021, found the average marketing leader loses a day and a half of work every week to manual, operational tasks. A PHD and WARC study of 1,721 senior brand marketers, published in September 2021, found more than 88 per cent say they spend most of their time on reporting tasks such as tracking performance, building competitive analyses and producing audience insights. Both are from 2021. We went looking for a newer public figure on reporting time alone and could not find a credible one, so the sums below use an assumption you can replace with your own number.
The dashboard itself is built in Google's Data Studio, which was called Looker Studio until Google renamed it in April 2026. Data Studio reads GA4 and Google Ads directly. Make covers the sources Google has no connector of its own for, such as Meta Ads and most CRMs, by writing their numbers into a Google Sheet every morning.
Why the Monday spreadsheet eats two days a month
Say the Monday routine takes four hours. Over a month that is about 16 hours, or two working days. At a $75,000 salary, an hour of work is roughly $36, so 16 hours a month is about $580 in labour. For an agency billing at $150 an hour, the same 16 hours is $2,400 a month in unbillable time. Swap in your own hours and rate, because the four hours is our assumption.
The tools cost little. Google's pricing page says Data Studio is available at no charge for creators and report viewers, and Make's free plan includes 1,000 credits a month. Which tool carries which source decides whether the free plan is enough, so it helps to see the routes before building anything.
| Source | How it reaches Data Studio | What it costs |
|---|---|---|
| GA4 | Data Studio's Google Analytics connector | No charge |
| Google Ads | Data Studio's Google Ads connector | No charge |
| Meta Ads | Make's Facebook Insights app writes rows to a Google Sheet, and Data Studio reads the Sheet | Make credits |
| CRM | Make's app for your CRM writes deals to a Google Sheet, and Data Studio reads the Sheet | Make credits |
GA4 and Google Ads need no automation at all, which leaves Make with the two sources in the bottom rows.
What an automated marketing reporting dashboard needs
Before we start, make sure you have these ready:
- A Google account (for Data Studio and GA4 access)
- A Make account (the free plan covers a daily refresh when rows are written in bulk, as step 2 shows)
- Access to your GA4 property with viewer permissions
- API access to your ad platforms (Google Ads, Meta Ads) or CRM
- About three hours for a first build, by our estimate
Connect GA4 to Data Studio as your data foundation
Log in to Data Studio and create a new blank report. In the data source picker, select Google Analytics 4. You will be prompted to choose your GA4 property and set a date range.
For the date range, set it to "Last 28 days" as a default. This gives you a rolling window that always shows the most recent complete four weeks. Add a comparison date range so you can see week-over-week or month-over-month changes without building two separate charts.
Name your data source something clear, like "GA4 - Marketing Dashboard." Data Studio saves it as a reusable data source so you can add it to other reports later. Add Google Ads the same way, through its own connector.
GA4 is the record of website and app traffic, and starting from it means every traffic metric in the dashboard comes from one source.
Pull Meta Ads data into a Google Sheet with Make
In Make, create a new scenario and schedule it to run once a day. Meta Ads is the example here, and a CRM follows the same shape in step 5.
The scenario has three modules, named as Make listed them on 14 November 2026:
- Schedule: once a day at 6am
- Module 1: Facebook Insights, Get Insights, which returns insights for the selected ad, ad set, ad account or campaign
- Module 2: Array aggregator, which collects the campaign rows into one bundle
- Module 3: Google Sheets, Bulk Add Rows (Advanced), which appends all the rows in one step
The aggregator is there because of how Make bills. Make Academy says a module uses one credit each time it performs an operation, so Add a Row runs once for every campaign the report returns. By our count, the two builds compare like this for one source:
| How the scenario writes rows | Credits per run | Credits in a 30-day month |
|---|---|---|
| Get Insights, then Add a Row once for each of 20 campaigns | 21 | 630 |
| Get Insights, Array aggregator, then one Bulk Add Rows | 3 | 90 |
Two sources built the first way use about 1,260 credits a month and exceed the free plan's 1,000. Built the second way they use about 180.
Make also has a GA4 app with Generate a Report and Generate a Pivot Report modules. You only need it if you want GA4 numbers in the same Sheet as the ad data, because Data Studio already reads GA4 directly.
Keep each scenario to one data flow, with one scenario for Meta and another for your CRM. That makes troubleshooting easier when one platform changes its API.
Build the Data Studio dashboard with key metrics
Back in Data Studio, add each data source you created, which means GA4, Google Ads and the Google Sheet where Make writes your Meta Ads data.
Start with these core panels:
- Scorecard row at the top: Sessions, New Users, Conversions, Total Revenue, Cost, ROAS. Each as a single-number card with a comparison arrow showing change from the previous period.
- Time series chart: Daily sessions and conversions over the last 28 days. Two lines so you can see if traffic and conversions are moving together.
- Source breakdown: Bar chart showing sessions by channel (organic, paid, social, email, direct). Helps you see which channels are driving traffic without digging into GA4.
- Campaign performance table: List of active campaigns with clicks, cost, conversions, and CPA. Sortable so you can quickly find the worst performers.
- Pipeline overlay: If you add CRM data later, a gauge chart showing pipeline value influenced by marketing versus total pipeline.
Use Data Studio's built-in calculated fields for ROAS and CPA so the dashboard computes these automatically. ROAS = Revenue / Cost is a one-line formula field. If you are weighing whether to build this yourself or buy a reporting tool, our breakdown of marketing automation costs compares the build versus buy maths.
Schedule Make to refresh and distribute automatically
Once the dashboard looks right, set up the automation schedule. In Make, set your reporting scenario to run once daily at 6am. Google's data freshness page says a Google Sheets source can refresh as often as every 15 minutes and that Google Ads and Google Analytics data refreshes every 12 hours, so the 6am rows reach the report the same morning. GA4's help centre adds that processing can take 24 to 48 hours, so the latest day's GA4 numbers can still change.
Add a final module to your Make scenario that sends a link to the dashboard to a Slack channel or email distribution list. Now every morning at 6:15am, your team gets a message with the latest dashboard link.
Data Studio can also send a PDF of the report on a delivery schedule. Set it to email a snapshot every Monday morning, and stakeholders get the numbers in their inbox without opening Data Studio.
Make also lists a Looker Studio app, still under the old name. Its actions manage who can access a report and reply to data requests that Data Studio sends to Make. For a daily refresh the Google Sheet is the simpler route, and it is the one this guide uses.
Add CRM data for pipeline context
Pull deal data from your CRM into Make using a CRM integration module. Map deal stages, amounts and close dates, then write them to a second Google Sheet with the same aggregator and Bulk Add Rows steps.
Add a new data source in Data Studio for that Sheet. Create a scorecard that shows pipeline value influenced by marketing campaigns. Add a funnel chart showing deals by stage, broken down by source channel.
The dashboard then shows spend, traffic and the pipeline that followed in one place, which is usually the first thing stakeholders ask about.
What Monday looks like after the build
You open your email around 7am and the dashboard link is already there. As an illustration, the scorecards might show sessions up 12 per cent week over week, CPA down 8 per cent and $48,000 of pipeline influenced for the month. One campaign shows a CPA spike, so you flag it for the team and spend the morning on that campaign.
The hours that used to go into exporting and pasting are free for the campaigns themselves.
If you want to take this further, the same pipeline can feed into attribution modelling, alerting you when spend spikes without a corresponding pipeline bump. We have written about unified ad reporting with Make, Google and Meta and social campaign reporting with Airtable, Make and GA4 that extends this approach to specific use cases.
Frequently asked questions
Is Data Studio (formerly Looker Studio) free?
Yes. Google's pricing page says Data Studio is available at no charge for creators and report viewers. Data Studio Pro, which adds Google Cloud support and team content management, costs US$9 per user per project per month. The Google Analytics, Google Ads and Google Sheets connectors used in this guide are Google's own.
Does Make offer a free plan?
Yes. Make's free plan includes 1,000 credits a month. By our count, a scenario that runs once a day and writes its rows with one Bulk Add Rows step uses 3 credits a run, about 90 a month for each source. The same scenario using Add a Row for 20 campaigns uses 21 credits a run, about 630 a month, so two sources built that way exceed the free plan.
Can I connect multiple ad platforms to one dashboard?
Yes. Each platform becomes a separate data source in Data Studio. Google Ads connects directly, and Make has apps for other ad platforms, including Facebook Insights for Meta Ads. Add each one as its own data source and build scorecards that total across channels.
How often should the dashboard refresh?
For most teams, once a day is enough. Data Studio refreshes Google Ads and Google Analytics data every 12 hours and can refresh a Google Sheets source as often as every 15 minutes, so a 6am Make run reaches the report the same morning. GA4 processing can take 24 to 48 hours, so the latest day's numbers can still change.
What metrics should I track first?
Start with five that stakeholders commonly ask for, which are sessions, cost per acquisition, return on ad spend, conversion rate and pipeline influenced. Add more once the team knows which ones it uses.