{% if ads_data %}
- data_type: ads_data
  dsp: google
  volatile_days: 30
  days_offset: 35
  queries:
  - query: {{ ads_data_select }}
    query_params: {{ ads_data_select_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
  - query: {{ ads_data_insert }}
    query_params: {{ ads_data_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
- data_type: ads_data
  dsp: facebook
  volatile_days: 7
  days_offset: 10
  queries:
  - query: {{ ads_data_select }}
    query_params: {{ ads_data_select_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
  - query: {{ ads_data_insert }}
    query_params: {{ ads_data_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
- data_type: ads_data
  dsp: linkfire
  volatile_days: 3
  days_offset: 5
  queries:
  - query: {{ ads_data_select }}
    query_params: {{ ads_data_select_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
  - query: {{ ads_data_insert }}
    query_params: {{ ads_data_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
{% endif %}
{% if data_completeness %}
- data_type: data_completeness
  dsp: amazon
  days_offset: 3
  queries:
  - query: {{ data_completeness_select_and_insert }}
    query_params: {{ data_completeness_select_and_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
- data_type: data_completeness
  dsp: tiktok
  days_offset: 5
  queries:
  - query: {{ data_completeness_select_and_insert }}
    query_params: {{ data_completeness_select_and_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
- data_type: data_completeness
  dsp: spotify
  days_offset: 3
  queries:
  - query: {{ data_completeness_select_and_insert }}
    query_params: {{ data_completeness_select_and_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
- data_type: data_completeness
  dsp: youtube
  days_offset: 4
  queries:
  - query: {{ data_completeness_select_and_insert }}
    query_params: {{ data_completeness_select_and_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
- data_type: data_completeness
  dsp: apple
  days_offset: 3
  queries:
  - query: {{ data_completeness_select_and_insert }}
    query_params: {{ data_completeness_select_and_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
{% endif %}
{% if spotify_charts %}
- data_type: spotify_charts
  dsp: spotify
  volatile_days: 2
  days_offset: 4
  queries:
  - query: {{ spotify_charts_select_and_insert }}
    query_params: {{ charts_select_and_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
{% endif %}
{% if apple_charts %}
- data_type: apple_charts
  dsp: apple
  volatile_days: 2
  days_offset: 4
  queries:
  - query: {{ apple_charts_select_and_insert }}
    query_params: {{ charts_select_and_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
{% endif %}
{% if amazon_charts %}
- data_type: amazon_charts
  dsp: amazon
  volatile_days: 1
  days_offset: 2
  queries:
  - query: {{ amazon_charts_select_and_insert }}
    query_params: {{ charts_select_and_insert_params }}
    db_type: postgresql
    db_secret_key: {{ pg_api_db_secter_key }}
    propagate_result: false
{% endif %}