Use the Google Search Ads 360 data source connector to pull all your ad data to a single location from all of your accounts to have full visibility of the campaign's success and costs.
For a full list of metrics and dimensions available in our Google Search Ads 360 data source connector, take a look at our Google Search Ads 360 documentation.
Once you've connected to Google Search Ads 360, you're ready to create your first query in Google Sheets, Looker Studio (formerly Data Studio), or Excel.
Try these queries
See the following use cases for examples on how to use the metrics and dimensions.
See impressions, clicks, and cost
Take a look at how many impressions and clicks your ad has got and how much it cost. In this example, we explore the data for the ongoing month.
The "Impressions" metric shows the total number of impressions. The "Clicks" metric shows the aggregate clicks. The "Cost" metric shows the aggregate cost paid to engine accounts.
For best results in Looker Studio, use the time series chart type.
- Set the date range to This month to date.
- Select the Impressions, Clicks, and Cost metrics.
- Select the Date dimension to split the query results by date.
See cost per campaign
View the cost of your campaigns this week.
The "Cost" metric shows the aggregate cost paid to engine accounts.
For best results in Looker Studio, use the table chart type.
- Set the date range to This week.
- Select the Cost metric.
- Select the Campaign dimension to split the query results by campaign name.
See Floodlight activities
Explore the Floodlight activities for your ads in the past 28 days.
The "Actions" metric shows the total number of DFA actions.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last 28 days.
- Select the Actions metric.
- Select the Date and Floodlight activity dimensions to split the query results by date and Floodlight activity.
Set up scheduled refreshes for your reports
You can set up scheduled refreshes for your reports created in Google Sheets and Excel. Follow the instructions on how to create and manage scheduled reports in Google Sheets and how to set up scheduled report triggers in Excel.
In Looker Studio, you can have a copy of your report emailed to you and important stakeholders at regular intervals.
More resources
You might also be interested in: