Marketing · Some setup
Build one marketing dashboard from Analytics and Ads
Pulling numbers from several Google tools into a spreadsheet every week is slow and easy to get wrong. A shared dashboard updates itself, so everyone looks at the same figures.
Software used
Has a free plan
Has a free plan
Google Ads
What happens
When
Data arrives in Google Analytics and Google Ads, as it does all the time.
Then
- Looker Studio reads both sources.
- The dashboard shows traffic, conversions and ad spend side by side.
- Anyone with the link sees the latest numbers.
How the tools connect
With a built-in integration. Looker Studio lists Google Analytics as an integration on its website.
Set it up
In Looker Studio, create a report and add Google Analytics as a data source.
Add Google Ads as a second source.
Start with a few charts that answer real questions, such as cost per conversion by campaign.
Share it with view access and set a scheduled email if people prefer their inbox.
Menus change, so these steps say what to do rather than where to click. Each company's help pages have the current screens.
Watch out for
- Analytics and Ads count conversions differently, so totals rarely match exactly. Note which one each chart uses.
Track these tools in My stack
Add the software you pay for and see which automations you can set up with it.
Ideas for my stackRelated automations
Marketing · Easy · Built-in integration
See which Google searches bring visitors
Analytics shows what visitors do, and Search Console shows what they searched for. Linking them puts search queries next to behaviour, so you know which topics are worth writing more about.
Marketing · Easy · Built-in integration
Keep your newsletter list in step with your CRM
When the CRM and email tool hold different lists, people get emails they unsubscribed from or miss ones they asked for. Syncing keeps one source of truth.
Marketing · Easy · Built-in integration
Email customers based on what they bought
Sending everyone the same email wastes your best customers' attention. With purchase data in the email tool, you can send follow-ups, restock news and thank-yous to the right people.