Hey all, first time working with the Google ads API through Mixed
Analytics. Use case is that I'm trying to pull data on a daily basis to
feed into a historical record of Google Ads performance data.
What I've done at this point is to export the historical data from Google
Ads Manager platform from a certain date, and have set up the API call to
pull for "where segments.date during yesterday". But checking the daily
data over the past few days, there are metrics that come in later on
(whether impressions or conversions) so the data that was pulled into the
sheet is now "under-reporting".
My understanding is that this happens because of the 7-day attribution
window. Question: Is there a better suggested way to set up the API call to
account for this?
I'm also open to other suggestions, as I'm not fully aware of the
limitations and don't know what the typical best practice is for Ad
reporting or data pulling 😅
For context, here's the request body for the API call.
{"query": " SELECT campaign.id, campaign.name, segments.date,
metrics.cost_micros, metrics.impressions, metrics.clicks,
metrics.interactions, metrics.conversions, metrics.all_conversions,
metrics.all_conversions_value, metrics.bounce_rate,
metrics.search_impression_share, metrics.top_impression_percentage,
metrics.absolute_top_impression_percentage,
metrics.search_top_impression_share,
metrics.search_absolute_top_impression_share,
metrics.search_budget_lost_impression_share,
metrics.search_budget_lost_absolute_top_impression_share,
metrics.search_rank_lost_impression_share,
metrics.search_rank_lost_absolute_top_impression_share,
metrics.search_budget_lost_top_impression_share,
metrics.search_rank_lost_top_impression_share FROM campaign WHERE
segments.date DURING YESTERDAY "
}
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/6833a1b4-faa9-4f9e-8401-cd8c294f99e0n%40googlegroups.com.
