You are here:
Create a Google Ads Data Stream in Marketing Cloud Intelligence
To manage ads on Google Ads, create a Google ads data stream.
Required Editions
| User Permissions Needed | |
|---|---|
| To create an API data stream: | Admin |
To create a Google Ads API data stream, you need a valid username and password with API permissions for each account you want to pull data for.
- On the Connect and Mix tab, expand Data Streams.
- Click Add New.
- Select the Google Ads connector.
- In the General section, select the account that you want to pull data for.
- To add a data source authentication, click Add New and enter your Google Ads credentials.
- Set the time period for the initial data fetch. You can process data up to the past 180 days.
-
In the Extended Properties section, set the applicable properties.
-
To add breakdowns for a higher level of granularity, from the Location
Breakdown dropdown, select the breakdown.
You can select only one type of location breakdown per Google Ads API data stream. Each selection pulls the previous listed dataset. For example, if you select Region, the data stream retrieves both Country and Region. If you select DMA/Metro, the data stream retrieves Country, Region, and DMA/Metro.
If you select a location breakdown, AdWords Gmail measurements and impression share measurements (Search Impr. share, Search Lost IS (rank), and Search Exact match IS) aren’t pulled.
-
To retrieve keyword data, select Get Keyword Level Data. These
fields are added:
Keyword ID Keyword Match type Search exact match IS Final URLs Quality score Ad relevance Expected clickthrough rate Landing page experience -
To retrieve conversion data, select Get Conversions Data. These
fields are added and mapped to the Conversion Tag data stream type:
Conversion tracking purpose Conversion action name Conversions Total conv. Value View-through conv. -
To retrieve ad data, select Get Creative Level Data. This
measurement isn’t available if you select a location breakdown. The following fields are
added:
Ad ID Ad Name Ad Type Destination Url Description Line 1 Description Line 2 Display Url Creative Final Urls Labels Expanded or responsive ad description HeadlinePart1 HeadlinePart2 Creative_displayurl_path1 (Path1) Creative_displayurl_path2 (Path2) - To pull device data and add the Device dimension, select Get Device Level Data.
- To pull universal app campaign data, select Get Universal App Campaigns. Universal app campaign data is retrieved only at the campaign level. The UACadgroup_CAMPAIGN KEY/NAME is created for the Media Buy Key field, and the Creative Key field is given a Default value.
- To pull audience data, select Get Custom Audience Data.
- To add data from Performance Max for Google Ads, select Get Performance Max Campaigns Data.
-
To add breakdowns for a higher level of granularity, from the Location
Breakdown dropdown, select the breakdown.
- To change the mapping, click Mapping. To access the mapping at any stage, from the Create New Stream page, clickMap to Model.
- To define advanced settings, at the bottom of the screen, select Advanced Settings.
- Click Create.
-
Quality check your data.
- Create a report in the Google Ads platform for the required date.
- Process the relevant data stream in Marketing Cloud Intelligence filtered to the same date range.
- Create an identical report or pivot table in Marketing Cloud Intelligence with the same date range, dimensions, and measurements.
- Compare the measurement totals to make sure that they’re aligned.
