Etlworks includes a built-in connector for Google AdWords, allowing you to extract campaign, ad group, and performance data using AdWords Query Language (AWQL). You can load this data into any destination, such as a database, file, or API.
To get started, you’ll need a Google AdWords account and must authorize access using OAuth2.
What You Can Do
-
Extract marketing data from Google AdWords using AWQL.
-
Load AdWords data into any destination supported by Etlworks.
-
Automate reporting and analytics by scheduling Flows.
Prerequisites
To work with Google AdWords API, you must have a Google AdWords account.
Step-by-Step: Create an ETL Flow with Google AdWords
Step 1: Create a Google AdWords Connection
Go to Connections, click +, and search for Google AdWords.
Step 2: Enter AWQL Query
Enter AWQL query in AWQL Query field.
Step 3: Optional. Test AdWords query in Explorer
1. Go to Explorer
2. Expand the AdWord connection to see the data
Step 4: Create a Destination Connection
Create a Connection to the system where you want to load AdWords data (e.g., SQL Server, S3, etc.).
Step 5: Create a Flow
1. Go to Flows, click +, and search for Well-known API to your destination (e.g., Well-known API to database).
2. Select the appropriate Flow type.
Step 6: Add a Transformation
1. Add a new transformation to the Flow.
2. Select your Google AdWords Connection as the source and your destination Connection as the target.
3. Click MAPPING and configure Source SQL using AWQL, if needed.
4. Add field-level mapping or transformations as necessary.
Step 7: Test and Run
1. Test the transformation.
2. Save and run the Flow manually or on a schedule.