search

fivetran / dbt_google_ads

Fivetran data transformations for Google Ads built using dbt.
https://fivetran.github.io/dbt_google_ads/
Apache License 2.0
13 stars 29 forks source link

[Feature] Add PMAX campaigns to url report #51

Closed hansottowirtz closed 11 months ago

hansottowirtz commented 1 year ago

Is there an existing feature request for this?

Describe the Feature

PMAX campaigns don't have ad groups and ads, but would it be possible to add them to the url report?

Describe alternatives you've considered

For now we have custom logic to add the spend of the PMAX campaigns to the spend of the url report.

Are you interested in contributing this feature?

Anything else?

No response

fivetran-jamie commented 1 year ago

Hi there @hansottowirtz thanks for opening this! Could you possibly share some of the logic you use to add PMAX campaigns into the url report? Code or just a high-level explanation would be much appreciated

Also, I don't know much about PMAX campaigns, but why join them into the url report instead of the campaign-level report?

fivetran-jamie commented 1 year ago

Talked more about this with the team and they noted that in investigating this previous issue, we found that PMAX campaigns are only served at the campaign level and therefore can't be reflected in the URL, ad, or adgroup reports (at least not without muddying the model grain).

So i am thinking that this may not be possible, unless we are missing something or Google has changed things in the past year 😞 @hansottowirtz

fivetran-jamie commented 11 months ago

going to close this out for now but please feel free to reopen if you'd like to continue discussing!