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

[Bug] Spend is off due to Performance Max campaigns #31

Closed leinemann closed 1 year ago

leinemann commented 2 years ago

Is there an existing issue for this?

Describe the issue

Hi there, we've started using Performance Max campaigns and noticed that they don't show up in the google ads reports. They are captured in the new API but not picked up by this package as the they don't appear in the AD_STATS table which is the basis for other joins.

I'm wondering if there have been any considerations made around this already?
Currently our marketing spend is off by the difference of the spend on Performance Max campaigns.

many thanks, Christoph.

Relevant error log or model output

No response

Expected behavior

performance max campaign show up alongside other campaigns. Spend on campaign matches what is shown in google portal.

dbt Project configurations

1.1

Package versions

latest

What database are you using dbt with?

snowflake

dbt Version

1.1

Additional Context

No response

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

fivetran-joemarkiewicz commented 2 years ago

Hi @leinemann thanks so much for opening this issue.

This is actually a consideration we have been discussing as a team internally. At the moment you are correct that the package is built from the ad_stats table which a number of ads do not fall under. However, we have found that there are other source tables (like campaign_stats) where we have found some of these missing ads!

Fortunately enough, our team is in the process of adding more reporting functionality to our Ad packages and these types of considerations is one of them! Over the next two months we will be adding more flexibility to the packages and plan to account for these types of ads. I will be sure to keep you posted here as we build more of this functionality out.

It would be great as well if you would be willing to test any changes out to see if we capture all the ads on your end!

leinemann commented 2 years ago

This is great news, thank you @fivetran-joemarkiewicz ! I discovered a performance_max table that contained spot-on the according campaign data. For our case that fitted in well as we only use the conversions as pass-through-metric. But unfortunately our approach doesn't lent itself to be contributed back here as it would not work with other pass-through-metrics. I'm very much looking forward to a bigger evolution that will allow for those other campaign types and by all means I'd be very happy to help testing and can't wait to return back to the open source version of the package again :-)

fivetran-joemarkiewicz commented 2 years ago

@leinemann that sounds great!! I will actually be working on the Google Ads upgrades in this coming sprint. I will post back here with details for you to test once it is ready 😄

fivetran-joemarkiewicz commented 1 year ago

Hi @leinemann the latest version of the Google Ads package should address the PMax campaign discrepancy you noted above. Using the google_ads__campaign_report should include the spend you are looking for!

As such, I will close this issue. However, please feel free to reopen if you feel there is more discussion to be had.