Icon

Gads_​roas_​rest

ROAS calculator using Google Ads API
1) Fetching Data from Google Ads API POST Request node configuration:Connection settings: URL with your Customer ID: https://googleads.googleapis.com/v10/customers/${CUSTOMER_ID}/googleAds:searchStream Request Body: Google Ads Query to obtain your desired data.Request Headers: Developer token, Login-customer-id (aka Google ads Manager Account ID), andan Authorization token. 2) Company Revenues by Google Ads campaign 4) Ouput to different sources 3) Joining and calculating ROASMath node formula to calculate ROAS:round(($revenues_last_30days$/$cost$)*100,0) The purpose of this Workflow is to fetch data (cost) from your Google Adwords account using the Google Ads API and combine it with your company data to calculate ROAS, aka Return On Ad Spend (a veryuseful KPI). Before you start you will need:From your Google Ads Account: Login Customer ID + Developer TokenFrom your Google Cloud Console Project: OAuth Client ID + Client SecretFrom https://developers.google.com/oauthplayground/ generate a temporary Access TokenFor more information see the workflow metadata. Find it here: View -> Description URL creatorInteracting with Google Ads APIDB connectionJoin Costs from GAdswith your company RevenuesCalculate ROASAuthenticate your accountwithin GoogleAppend your data to an Excel fileCreate a Tableau sourceUpload your Company RevenuesFrom an Excel FileAppending new data to a specific sheetFeed your DB table with ROAS dataTranforming you data Table Creator POST Request PostgreSQLConnector Joiner Math Formula GoogleAuthentication Google SheetsConnection Excel Writer Tableau Writer Excel Reader Google SheetsUpdater DB Insert Json to Table 1) Fetching Data from Google Ads API POST Request node configuration:Connection settings: URL with your Customer ID: https://googleads.googleapis.com/v10/customers/${CUSTOMER_ID}/googleAds:searchStream Request Body: Google Ads Query to obtain your desired data.Request Headers: Developer token, Login-customer-id (aka Google ads Manager Account ID), andan Authorization token. 2) Company Revenues by Google Ads campaign 4) Ouput to different sources 3) Joining and calculating ROASMath node formula to calculate ROAS:round(($revenues_last_30days$/$cost$)*100,0) The purpose of this Workflow is to fetch data (cost) from your Google Adwords account using the Google Ads API and combine it with your company data to calculate ROAS, aka Return On Ad Spend (a veryuseful KPI). Before you start you will need:From your Google Ads Account: Login Customer ID + Developer TokenFrom your Google Cloud Console Project: OAuth Client ID + Client SecretFrom https://developers.google.com/oauthplayground/ generate a temporary Access TokenFor more information see the workflow metadata. Find it here: View -> Description URL creatorInteracting with Google Ads APIDB connectionJoin Costs from GAdswith your company RevenuesCalculate ROASAuthenticate your accountwithin GoogleAppend your data to an Excel fileCreate a Tableau sourceUpload your Company RevenuesFrom an Excel FileAppending new data to a specific sheetFeed your DB table with ROAS dataTranforming you data Table Creator POST Request PostgreSQLConnector Joiner Math Formula GoogleAuthentication Google SheetsConnection Excel Writer Tableau Writer Excel Reader Google SheetsUpdater DB Insert Json to Table

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: diego.rodriguez
Created at: 2022-04-28
On NodePit since: 2022-05-09
Last update: 2024-11-17
Created with KNIME version: v4.5.2
Tags: MarketingGoogleGoogle APIApiAdwords

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!