Google Ads is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web users.
Sprinkle now supports Google Ads as a data source. So, if you are running multiple campaigns across Google Ads, Sprinkle serves as a single source of truth for all the campaigns. In order to add Google Ads as a Data Source, the user can click on Data Sources and then on the ‘+’ sign. Upon clicking on the ‘+’ sign a list of data sources appears. The user needs to select Google Ads in this case and name the data source.
Once the datasource is selected and named, the user will need to enter the** Developer Token** and also the Client Id. The Developer Token can be used to target any Google Ads account and download reports by using OAuth2 authentication.
For details on how to generate Developer Token, click here.
Next to Developer Token, the user needs to enter the Client Id. For getting the Client Id, the user needs to sign up for the AdWords API access through the **Manager Account. **Next, the user needs to sign in and navigate to the following path. TOOLS & SETTINGS > SETUP > API Center.The API Center option will appear only for Google Ads Manager Accounts. For more details click here.
Client Customer Id is referred to the account the user is targeting and this could be found at the top right corner near to Account Id.
Once the Developer Token and Client Id details are filled, the user needs to Reauthorize Google.
Once the connection is established, users can go to Datasets and select the table type as per their choice. Sprinkle offers three kinds of tables. They are campaign Data, Reports and Query.
If the user selects campaign Data, then it shows a drop down to select the table name. The table name could be Ad_Group or Campaign.
If the user selects reports, then need to select the report in the Table Name field from the drop down.
At the last, if the user selects a Query then it is required to select the name of the dataset and write the AWQL in the box provided. This will enable the user to deep dive into the Adwords campaign that he might be running.