Create a Google Ads Data Stream
Create a data stream to start the data flow from your Google Ads source to Data 360.
-
In Data Cloud, on the Data Streams tab, click New.
-
Under Other Sources, select Google Ads, and then click Next.
-
Select the Google Ads connection.
-
On the Available Objects tab, select the object to import.
Each object can be used one time per connection.
-
In the Source field, enter the Google Ads connection you selected.
-
Click Next.
-
Under Data Lake Object, select the data lake object (DLO) for the selected object, or create a new DLO.
For example, if you select the Campaign Level Audience View object, select Campaign Level Audience View from the dropdown list.
-
Review the automatically assigned data type.
-
For each empty mapping field, select the corresponding data lake object field from the dropdown list.
After you map a field, Data 360 removes it from the list and you can’t select it again.
When mapping the Event Date field, enter a date and time. The data type changes to DateTime.
-
Click Next.
-
Select the refresh mode.
FIELD DESCRIPTION Full Refresh All existing data is deleted and replaced daily with the current data. Enter the data stream details. Incremental Only new data is added to the dataset. Your table must have a primary key and a datetime column to determine the date and time a row was last modified. For Record Modified Date-time, select the field to tag records that have changed. Optionally, identify the column to flag for soft deletes. -
Enter the data stream details.
-
Select a start date and end date to import data.
If you don’t select a start date and end date, the connector initially imports 180 days of historical data before the current date. After the initial import, the connector imports data from 7 days before the current date.
-
Set the frequency to daily, and then set a time.
-
Click Deploy.
-
Repeat these steps for each object that you want to import.
When the Last run status is successful, review the number of processed records and the total number of loaded records.