Google Ads is an advertising platform where individuals or businesses can create ads that target specific audiences on Google's search engine or partner websites. Advertisers bid on keywords that they want their ads to show for, and users can click on the ads to learn more or make a purchase.
Two Options for Data Import
To maximize the benefits of the CMO Dashboard and see the full picture of your expenses, you can extract data from Google Ads using Fully managed Pipeline Google Ads→Google BigQuery by OWOX or the native Data Transfer connector.
In this article, we will find out what is more suitable for you and which of the options is better to choose.
Comparison Table
| OWOX | Data Transfer | |
|---|---|---|
| Who does the setup? | Client or OWOX team | Client |
| Responsible for import? | OWOX BI | Client |
| Can download historical data? | Yes, unlimited | Yes, but with limitations on the speed* of receiving this data |
| Is it possible to separate data from different Ad accounts into different tables? | Yes, each table will have the respective Ads Account suffix | Yes, but you need to create separate Data Transfers for each Ads Account |
| Are new Ad accounts automatically pulled up for import? |
No, need to create a new Pipeline | Yes |
| Is there a limit to the number of concurrent transfers? |
No, unlimited | Yes, can become an issue for more than 20 accounts |
| Are data imports consistently executed according to the scheduled timeline? |
Yes, data imports are initiated precisely following the designated schedule. | No, can be delayed by several hours |
Advantages of Choosing the OWOX Fully Managed Pipeline
- Setup Assistance: OWOX will help you set up the pipeline and ensure you receive all your data on time and in full.
- Support: If there are any errors, data discrepancies, or missing data, you can get help from OWOX Support.
- Cost Efficiency: The OWOX BI pipeline provides all the data you need for reporting without unnecessary storage costs.
- Automatic Updates: Any changes in the data structure from the service API are automatically reflected in subsequent transformations.
Limitations of Choosing Data Transfer
- Client Responsibility: You will need to handle data import configuration, connection setup, and status monitoring.
- Independent Troubleshooting: Any data-related issues must be addressed on your own.
- Import Limits: Data Transfer allows importing up to 300 days of data simultaneously, with each day imported in 30-minute intervals. Importing a year’s worth of data can take about 7 days.
- Scalability Issues: This can be problematic for many accounts with extensive dates to backfill or multiple reports needed.
- Potential Delays: Scheduled transfers may not run immediately and can be delayed by several hours, especially with many accounts.
To learn more about the data schema of the OWOX BI pipeline, you can refer to this article.
If you need further assistance, feel free to contact our support team at bi@owox.com.
0 Comments