Use the Google Campaign Manager 360 data source connector to pull data — such as campaign details, placement data, search volumes, and creatives — from all of your accounts in a single location to have full visibility of campaign success and spending.
For a full list of metrics and dimensions available in our Google Campaign Manager 360 data source connector, take a look at our Google Campaign Manager 360 documentation.
Once you’ve connected to Google Campaign Manager 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 set up queries.
See video impressions, views, and costs
Take a look at how many times your video was seen and how much the campaign cost you. In this example, we explore this data for the last 28 days.
The "DBM cost (account currency)" metric shows the amount spent in account currency. The "Impressions" metric shows how many times your ad was shown. The "Video completions" metric shows how many times the video was fully played. The "Video First quartile completions" metric shows how many times the first quarter of the video was watched.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last 28 days.
- Select the DMB cost (account currency), Impressions, Video completions, and Video First quartile completions metrics.
- Select the Date dimension to split the query results by date.
See conversions and activity
Explore the conversions and actions your ad's audience has taken last week.
The "Conversions" metric shows the number of conversions.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last week.
- Select the Conversions metric.
- Select the Activity and Date dimensions to split the query results by activity and date.
See impressions, clicks, and conversions
Get data on impressions and clicks of your ad, as well as the conversion that follows. In this example, we pull data for the ongoing month.
The "Impressions" metric shows the number of times your ad was shown. The "Clicks" metric shows the number of clicks. The "Conversions" metric shows the number of conversions for the ad.
For best results in Looker Studio, use the time series chart type.
- Set the date range to Month to date.
- Select the Clicks and Impressions metrics.
- Select the Date dimension to split the query results by date.
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: