blob: e0bc3c9f8534eb628d3d591b5a8f0104bdf46317 [file] [log] [blame]
:py:mod:`tests.system.providers.google.ads.example_ads`
=======================================================
.. py:module:: tests.system.providers.google.ads.example_ads
.. autoapi-nested-parse::
Example Airflow DAG that shows how to use GoogleAdsToGcsOperator.
Module Contents
---------------
.. py:data:: ENV_ID
.. py:data:: PROJECT_ID
.. py:data:: DAG_ID
:annotation: = example_google_ads
.. py:data:: BUCKET_NAME
.. py:data:: CLIENT_IDS
:annotation: = ['1111111111', '2222222222']
.. py:data:: GCS_OBJ_PATH
:annotation: = folder_name/google-ads-api-results.csv
.. py:data:: GCS_ACCOUNTS_CSV
:annotation: = folder_name/accounts.csv
.. py:data:: QUERY
:annotation: = Multiline-String
.. raw:: html
<details><summary>Show Value</summary>
.. code-block:: text
:linenos:
SELECT
segments.date,
customer.id,
campaign.id,
ad_group.id,
ad_group_ad.ad.id,
metrics.impressions,
metrics.clicks,
metrics.conversions,
metrics.all_conversions,
metrics.cost_micros
FROM
ad_group_ad
WHERE
segments.date >= '2020-02-01'
AND segments.date <= '2020-02-29'
.. raw:: html
</details>
.. py:data:: FIELDS_TO_EXTRACT
:annotation: = ['segments.date.value', 'customer.id.value', 'campaign.id.value', 'ad_group.id.value',...
.. py:data:: create_bucket
.. py:data:: test_run