fivetran / fivetran/dbt_google_ads

[Feature] Incorporate placement data into campaign and ad group end models

Open
#74 0 comments 0 reactions 0 assignees View on GitHub
type:enhancement
Dominant language
No language data
Stars
27
Forks
33
PR merge metrics
No merged PRs in 30d

Description

### Is there an existing feature request for this?

- [x] I have searched the existing issues

### Describe the Feature

[Placement URL is a web address that identifies where a Google ad is displayed on a page,](https://developers.google.com/google-ads/api/fields/v18/ad_group_criterion#ad_group_criterion.placement.url) and that data can be used to improve targeting and exposure web campaigns. Adding this data to our ad group and campaign models could provide enriched information on ad campaign targeting success.

We'd love to hear from customers whether adding placement info to our ad group and campaign models! Let us know in the comments.

### How would you implement this feature?

I'd bring in both the `ad_group_criterion_history` and `campaign_criterion_history` models which both contain `placement_url`. Then we can join on `ad_group_id` and `campaign_id` (as well as various date filters available to us) to bring that placement url further upstream, in the hopes that we can eventually create an ad reporting rollup placement model.

### Describe alternatives you've considered

_No response_

### Are you interested in contributing this feature?

- [x] Yes.
- [ ] Yes, but I will need assistance.
- [ ] No.

### Anything else?

_No response_

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.