[Bug] need to aggregate across budget_association_status daily campaign report

[fivetran-jamie]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

Customers are seeing uniqueness tests failing on stg_microsoft_ads__campaign_daily_report because the of the budget_association_status column, which we don't include (nor should we necessarily).

if a campaign's budget ends mid-day, there will be 2 records for it in the table. Keeping these records separate doesn't provide any value really and fans out the supposedly daily-grain data. We should sum the metrics up!

I would also suggest checking if any other report tables have this budget_association_status column, and if so, we should aggregate across it to the appropriate grain

Relevant error log or model output

stg_microsoft_ads__campaign_daily_report's test fails

Expected behavior

stg_microsoft_ads__campaign_daily_report's test passes

dbt Project configurations

na

Package versions

na

What database are you using dbt with?

bigquery

dbt Version

na

Additional Context

https://getdbt.slack.com/archives/C01D1R2JLLA/p1665394622925879

Are you willing to open a PR to help address this issue?

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

[fivetran-joemarkiewicz]

Closing this issue as PR #23 resolves the original issue identified in this bug report.