validations

[fivetran-jamie]

PR Overview

This PR will address the following Issue/Feature: https://github.com/fivetran/dbt_microsoft_ads_source/issues/30 by way of including https://github.com/fivetran/dbt_microsoft_ads_source/pull/31

This PR will result in the following new package version:

v0.8.0 -- breaking change upstream

Please provide the finalized CHANGELOG entry which details the relevant changes included in this PR:

See parallel upstream release of source package.

PR #32 includes the following updates:

Under the Hood

• Updated the PR Templates for package maintainers to our most up-to-date standards.
• Added consistency validation test for the microsoft_ads__campaign_report table (to be used only by maintainers).

PR Checklist

Basic Validation

Please acknowledge that you have successfully performed the following commands locally:

• [x] dbt run –full-refresh && dbt test
• [x] dbt run (if incremental models are present) && dbt test

Before marking this PR as "ready for review" the following have been applied:

• [x] The appropriate issue has been linked, tagged, and properly assigned.
• [x] All necessary documentation and version upgrades have been applied.
• [x] docs were regenerated (unless this PR does not include any code or yml updates).
• [x] BuildKite integration tests are passing.
• [x] Detailed validation steps have been provided below.

Detailed Validation

Please share any and all of your validation steps:

see consistency test added

If you had to summarize this PR in an emoji, which would it be?

🧪