[Feature] expand default LEAD columns

[fivetran-jamie]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

currently, we include all columns we find in stg_marketo__lead, but we only ensure that the following fields are included in the table: ['id', 'created_at', 'updated_at', 'email', 'first_name', 'last_name', '_fivetran_synced']. These are the only fields we include in the get_lead_columns() macro.

However, there are quite a few more default fields for the LEAD table, which are outlined here.

Some of these fields will be necessary for our upcoming Customer360 work, namely:

• phone
• main_phone
• mobile_phone
• company
• inferred_company
• address_lead
• address
• city
• state
• state_code (not in this doc but we have it internally?)
• country
• country_code (not in this doc but we have it internally?)
• postal_code
• billing_street
• billing_city
• billing_state
• billing_state_code (not in this doc but we have it internally?)
• billing_country
• billing_country_code (not in this doc but we have it internally?)
• billing_postal_code
• inferred_city
• inferred_state_region
• inferred_country
• inferred_postal_code
• inferred_phone_area_code
• anonymous_ip
• unsubscribed
• email_invalid
• do_not_call

In the off chance that a user does not have the above, I'd like to ensure that the customer360 package runs successfully. Thus, let's add these columns to the get_lead_columns macro and to this line and document them in yml.

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• Yes.
• Yes, but I will need assistance and will schedule time during your office hours for guidance.
• No.

Anything else?

No response