Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature that added ad squad & campaign in the ad report #33

Open
wants to merge 10 commits into
base: main
Choose a base branch
from

Conversation

fivetran-avinash
Copy link
Contributor

@fivetran-avinash fivetran-avinash commented Feb 12, 2025

PR Overview

This PR will address the following Issue/Feature: [#31] contribution via @JeremyDOwens

This PR will result in the following new package version: 0.8.0

Added new fields, leading to a schema change.

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

This release introduces the following updates:

Breaking Changes

  • Adds ad squad and campaign details to the snapchat_ads__ad_report model, so that they can eventually be incorporated in the dbt_ad_reporting package for the ad_reporting__ad_report model. (#33)
  • Fields added include:
    • ad_squad_id
    • ad_squad_name
    • campaign_id
    • campaign_name

Under The Hood

  • Updated the tests to include ad_squad_id and campaign_id in snapchat.yml for snapchat_ads__ad_report and snapchat_ads__url_report to more closely align with other ad reporting packages. (#33)
  • Added integrity test to ensure the snapchat_ads__ad_report maintains the same row grain count for ad_id and date_day betweens the source and end models. (#33)

Documentation

  • Added Quickstart model counts to README. (#30)
  • Corrected references to connectors and connections in the README. (#30)
  • Updated snapchat.yml with new above field additions. (#33)

Contributors

PR Checklist

Basic Validation

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

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

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

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

Detailed Validation

Please share any and all of your validation steps:

Validated that these fields were brought through to the end model, as well as ensured new tests passed

Screenshot 2025-02-14 at 1 13 09 PM Screenshot 2025-02-14 at 3 04 53 PM

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

🦑

@fivetran-avinash fivetran-avinash self-assigned this Feb 12, 2025
fivetran-avinash and others added 3 commits February 12, 2025 00:57
…ad-to-ad-report

Feature: Add ad_squad and campaign to ad report
@fivetran-avinash fivetran-avinash linked an issue Feb 12, 2025 that may be closed by this pull request
4 tasks
Copy link
Contributor

@fivetran-joemarkiewicz fivetran-joemarkiewicz left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM with a few small notes

CHANGELOG.md Outdated
Comment on lines 6 to 10
- Fields added include:
- `ad_squad_id`
- `ad_squad_name`
- `campaign_id`
- `campaign_name`
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Can you consolidate this into the one bullet above. "Fields added include:" doesn't need to be a separate bullet. But I would like the separate fields to be their own sub bullets still.

@@ -1,5 +1,5 @@
name: 'snapchat_ads'
version: '0.6.2'
version: '0.8.0'
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Yikes, looks like we missed updating this in the last release.

profile: 'integration_tests'
config-version: 2

vars:
vars:
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Whitespace removal

Suggested change
vars:
vars:

Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

While you're making a new test, can you also update the consistency tests to ensure the conversions is included moving forward.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

[Feature] Include Campaign and Ad Squad in Ad Report
3 participants