Google Ads data source

Learn how to set up a Google Ads data source and then move this data to one of the data destinations supported by Coupler.io 

1. Set up your data source
2. Transform your data with Coupler.io
3. Set up your data destination
4. Update your data automatically on schedule

1. Set up Google Ads integration

The below instruction covers setting up an integration with Google Ads from scratch.

To set up an integration from a pre-set dashboard template, visit our Dashboard examples and reporting templates page.

1.1. Select an application: Google Ads

1.2. Connect your Google Ads account

• Click "Sign in with Google".
• Log in to the Google account. 
• Provide needed consent: 

1.3. Choose your Ad account(s) from the multi-select drop-down 

1.4. Select the Report type

1.5. Set up reports' advanced settings

Start date - Define the start date of the period that should be covered in your report. By default, the start date is set to 30 days ago. Supported date format YYYY-MM-DD (e.g. 2023-06-01). This field supports macros. Learn more.

End date - Define the end date of the period that should be covered in your report. The default end date is today. Supported date format YYYY-MM-DD (e.g. 2023-06-30). This field supports macros. Learn more.

Split data by periods - Specify the periods to split your report data. You can select several options: 

• Date
• Day of week
• Month
• Quarter
• Week
• Year

Metric values in your report will be split by all combinations of selected periods - e.g. for Quarter + Year - each row in the report will contain metrics for Q1 2023, Q2 2023, Q3 2023, etc.

2. Transform your data with Coupler.io

With Coupler.io's Preview and Transformation block, you can:

• Preview your data for accuracy.
• Manage columns by hiding, or rearranging key data.
• Apply filters and sorting to focus on relevant information.
• Add formula-based fields for enhanced metrics.
• Combine datasets using data union and join features for a comprehensive analysis.

For a detailed guide on how to utilize these features, follow this link to our comprehensive tutorial.

3. Set up your data destination

Continue setting up the integration depending on the system you want to import data to. Select your tool from the list of supported data destinations and follow the relevant setup guide.

4. Update your data automatically on schedule

Turn on "Automatic data refresh" in the data flow so your data remains up-to-date in the destination without requiring manual updates. 

You can schedule data imports at specific intervals (e.g., hourly, daily, weekly) and/or days, allowing you to have up-to-date information available for analysis, reporting, or decision-making. This automation enhances efficiency and ensures your reports or dashboards are always populated with the latest data.

For a detailed guide on how to utilize this feature, follow this link to our comprehensive tutorial.