Extract the Ad Network and Device segments for Google Ads Performance Reports
We want to add two new segments on the extracted Performance Reports for Google Ads:
- Ad Network (
AdNetworkType1
, XML Attribute:network
) - Device (XML Attribute:
device
)
Both will be added to:
- Ad Performance Report (
AD_PERFORMANCE_REPORT
) - Keywords Performance Report (
KEYWORDS_PERFORMANCE_REPORT
)
Due to conflicting with some attributes and metrics, already extracted, the following will be removed from both Performance reports:
- AveragePageviews (XML Attribute:
pagesSession
) - AverageTimeOnSite (XML Attribute:
avgSessionDurationSeconds
) - BounceRate (XML Attribute:
bounceRate
) - ClickAssistedConversionValue (XML Attribute:
clickAssistedConvValue
) - ClickAssistedConversions (XML Attribute:
clickAssistedConv
) - ClickAssistedConversionsOverLastClickConversions (XML Attribute:
clickAssistedConvLastClickConv
) - ImpressionAssistedConversionValue (XML Attribute:
imprAssistedConvValue
) - ImpressionAssistedConversions (XML Attribute:
imprAssistedConv
) - ImpressionAssistedConversionsOverLastClickConversions (XML Attribute:
imprAssistedConvLastClickConv
) - PercentNewVisitors (XML Attribute:
newSessions
)
We should also check if the following are extracted for the Keywords Performance Report:
- HistoricalCreativeQualityScore (XML Attribute:
adRelevanceHist
) - HistoricalLandingPageQualityScore (XML Attribute:
landingPageExperienceHist
) - HistoricalQualityScore (XML Attribute:
qualScoreHist
) - HistoricalSearchPredictedCtr (XML Attribute:
expectedClickthroughRateHist
)
This issue will be completed and the relevant update released in conjunction with the updates that we are going to make in the Transforms for Google Ads (dbt-tap-adwords#5 (closed)) and the Models for Google Ads (model-adwords#6 (closed))
This will be a breaking change that will require existing installations of Meltano to drop the tap_adwords
schema and extract all the data from scratch.
Edited by Yannis Roussos