[Feature] Consider rerouting advertiser_id

[fivetran-reneeli]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

Currently in the following models, advertiser_id is brought in a relatively roundabout way:

pinterest_ads__pin_promotion_report
pinterest_ads__url_report
pinterest_ads__ad_group_report

Now that ad group history and pin promotion history source tables contain advertiser_id, it may make more sense to bring it in through those tables as opposed to from the advertiser_history table, since advertiser_history is joined in a more roundabout way than x_report and x_history.

Once we have data to validate this, we should consider making this change.

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