I'm using the keyword_view report and am fetching the last 30 days worth of keyword information using the query:
SELECT
customer.id,
metrics.cost_micros, metrics.ctr, metrics.impressions, metrics.clicks,
ad_group.id,
ad_group.name, campaign.final_url_suffix,
campaign.id,
campaign.name,
ad_group.campaign, ad_group.final_url_suffix, ad_group_criterion.keyword.match_type,
ad_group_criterion.keyword.text, ad_group_criterion.final_urls, ad_group_criterion.final_url_suffix,
ad_group_criterion.display_name, ad_group_criterion.criterion_id, segments.date
FROM
keyword_view
WHERE
segments.date BETWEEN 'START_DATE' AND 'END_DATE'
ORDER BY
segments.date ASC,
campaign.name ASC,
ad_group.name ASC,
ad_group_criterion.keyword.text ASC,
ad_group_criterion.keyword.match_type ASC
I'm finding that any currently active keyword is giving us a final_url value for any historical data.
Any keyword that is marked as deleted (today) is not giving us a final_url value for any historical data.