# Quora Ads schema ERD

Table and field reference for the Fivetran Quora Ads connector.

## Table & Field Reference

### lead_gen_form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| name | Unknown |  |

### ad_set

| Column | Type | Keys |
| --- | --- | --- |
| end_date | String | PK |
| id | Unknown | PK |
| start_date | String | PK |
| account_id | Unknown | FK |
| campagin_id | Unknown | FK |
| bid_amount | Unknown |  |
| campaign_id | Unknown |  |
| click | Unknown |  |
| cost_per_lead | Unknown |  |
| cpc | Unknown |  |
| ctr | Unknown |  |
| form_completion_rate | Unknown |  |
| impression | Unknown |  |
| leads_generated | Unknown |  |
| name | Unknown |  |
| spend | Unknown |  |
| status | Unknown |  |

### ad

| Column | Type | Keys |
| --- | --- | --- |
| end_date | String | PK |
| id | Unknown | PK |
| start_date | String | PK |
| account_id | Unknown | FK |
| ad_set_id | Unknown | FK |
| campaign_id | Unknown | FK |
| bid_amount | Unknown |  |
| click | Unknown |  |
| cost_per_lead | Unknown |  |
| form_completion_rate | Unknown |  |
| impression | Unknown |  |
| leads_generated | Unknown |  |
| name | Unknown |  |
| spend | Unknown |  |
| status | Unknown |  |

### recent_leads_collected_for_lead_gen_form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| ad_id | Unknown | FK |
| form_id | Unknown | FK |
| creation_time | Unknown |  |
| field_data_business_email | Unknown |  |
| field_data_city | Unknown |  |
| field_data_company_name | Unknown |  |
| field_data_company_size | Unknown |  |
| field_data_country | Unknown |  |
| field_data_first_name | Unknown |  |
| field_data_job_title | Unknown |  |
| field_data_last_name | Unknown |  |
| field_data_phone_number | Unknown |  |
| field_data_state | Unknown |  |
| field_data_user_email | Unknown |  |
| field_data_zipcode | Unknown |  |
| form_name | Unknown |  |

### account_detail

| Column | Type | Keys |
| --- | --- | --- |
| end_date | String | PK |
| id | Unknown | PK |
| start_date | String | PK |
| account_currency | Unknown |  |
| account_name | Unknown |  |
| click | Unknown |  |
| conversion_add_payment_info | Unknown |  |
| conversion_add_to_cart | Unknown |  |
| conversion_add_to_wishlist | Unknown |  |
| conversion_app_install | Unknown |  |
| conversion_complete_registration | Unknown |  |
| conversion_generate_lead | Unknown |  |
| conversion_generic | Unknown |  |
| conversion_initiate_checkout | Unknown |  |
| conversion_purchase | Unknown |  |
| conversion_rate_add_payment_info | Unknown |  |
| conversion_rate_add_to_cart | Unknown |  |
| conversion_rate_add_to_wishlist | Unknown |  |
| conversion_rate_app_install | Unknown |  |
| conversion_rate_complete_registration | Unknown |  |
| conversion_rate_generate_lead | Unknown |  |
| conversion_rate_generic | Unknown |  |
| conversion_rate_initiate_checkout | Unknown |  |
| conversion_rate_purchase | Unknown |  |
| conversion_rate_search | Unknown |  |
| conversion_search | Unknown |  |
| cost_per_lead | Unknown |  |
| cpc | Unknown |  |
| ctr | Unknown |  |
| form_completion_rate | Unknown |  |
| impression | Unknown |  |
| leads_generated | Unknown |  |
| spend | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| end_date | String | PK |
| id | Unknown | PK |
| start_date | String | PK |
| account_id | Unknown | FK |
| campaign_name | Unknown |  |
| click | Unknown |  |
| conversion_add_payment_info | Unknown |  |
| conversion_add_to_cart | Unknown |  |
| conversion_add_to_wishlist | Unknown |  |
| conversion_app_install | Unknown |  |
| conversion_complete_registration | Unknown |  |
| conversion_generate_lead | Unknown |  |
| conversion_generic | Unknown |  |
| conversion_initiate_checkout | Unknown |  |
| conversion_purchase | Unknown |  |
| conversion_rate_add_payment_info | Unknown |  |
| conversion_rate_add_to_cart | Unknown |  |
| conversion_rate_add_to_wishlist | Unknown |  |
| conversion_rate_app_install | Unknown |  |
| conversion_rate_complete_registration | Unknown |  |
| conversion_rate_generate_lead | Unknown |  |
| conversion_rate_generic | Unknown |  |
| conversion_rate_initiate_checkout | Unknown |  |
| conversion_rate_purchase | Unknown |  |
| conversion_rate_search | Unknown |  |
| conversion_search | Unknown |  |
| cost_per_lead | Unknown |  |
| cpc | Unknown |  |
| daily_budget | Unknown |  |
| form_completion_rate | Unknown |  |
| impression | Unknown |  |
| leads_generated | Unknown |  |
| lifetime_budget | Unknown |  |
| spend | Unknown |  |
| status | Unknown |  |

## Relationships

- lead_gen_form(account_id) → account_detail(id)
- ad_set(account_id) → account_detail(id)
- ad_set(campagin_id) → campaign(id)
- ad(campaign_id) → campaign(id)
- ad(ad_set_id) → ad_set(id)
- ad(account_id) → account_detail(id)
- recent_leads_collected_for_lead_gen_form(form_id) → lead_gen_form(id)
- recent_leads_collected_for_lead_gen_form(ad_id) → ad(id)
- recent_leads_collected_for_lead_gen_form(account_id) → account_detail(id)
- campaign(account_id) → account_detail(id)