fivetran / fivetran/dbt_google_ads
[Feature] Incorporate placement data into campaign and ad group end models
- 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.