[Feature] Create `search_report` model with new `SEARCH_KEYWORD_STATS` and/or `SEARCH_TERM_STATS` tables
Opened this issue · 1 comments
fivetran-jamie commented
Is there an existing feature request for this?
- I have searched the existing issues
Describe the Feature
In September we added theSEARCH_KEYWORD_STATS and/or SEARCH_TERM_STATS pre-built reports, which are selected by default in the connector schema. I haven't looked at the ERD or data too closely, but at first glance it seems like we can leverage these reports to create a google_ads__search_report model. Ideally, this would passed to the downstream ad_reporting__search_report end model
How would you implement this feature?
Transform these tables similarly to all the other _stats tables. Not sure what the difference between search terms and search keywords are, but I wonder if we'll union/join these two together and add a type field that is either keyword or term
Describe alternatives you've considered
No response
Are you interested in contributing this feature?
- Yes.
- Yes, but I will need assistance.
- No.
Anything else?
No response
fivetran-jamie commented
there's also the new click_stats and LANDING_PAGE_STATS tables