delete from GoogleApiReportTemp.dbo.Api_CustomerDetail
delete from GoogleApiReportTemp.dbo.Api_Campaign 
delete from GoogleApiReportTemp.dbo.Api_Adgroup 
delete from GoogleApiReportTemp.dbo.Api_AdgroupAd 
delete from GoogleApiReportTemp.dbo.Api_KeyWord 
delete from GoogleApiReportTemp.dbo.Api_Searchterm 
delete from GoogleApiReportTemp.dbo.Api_Video 
delete from GoogleApiReportTemp.dbo.Api_Geographic 

delete from  GoogleApiReportTemp.dbo.GA_accountperformancereport
delete from  GoogleApiReportTemp.dbo.GA_CampaignPerformanceReport 
delete from  GoogleApiReportTemp.dbo.GA_AdgroupPerformanceReport 
delete from  GoogleApiReportTemp.dbo.GA_AdPerformanceReport 
delete from  GoogleApiReportTemp.dbo.GA_KeywordsPerformanceReport  
delete from  GoogleApiReportTemp.dbo.GA_SearchQueryPerformanceReport 
delete from  GoogleApiReportTemp.dbo.GA_VideoPerformanceReport   
delete from  GoogleApiReportTemp.dbo.GA_GeoPerformanceReport 


insert into GoogleApiReport.dbo.Api_CustomerDetail select * from GoogleApiReportTemp.dbo.Api_CustomerDetail where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.Api_Campaign select * from GoogleApiReportTemp.dbo.Api_Campaign where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.Api_Adgroup select * from GoogleApiReportTemp.dbo.Api_Adgroup where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.Api_AdgroupAd  select * from GoogleApiReportTemp.dbo.Api_AdgroupAd  where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.Api_KeyWord select * from GoogleApiReportTemp.dbo.Api_KeyWord where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.Api_Searchterm select * from GoogleApiReportTemp.dbo.Api_Searchterm where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.Api_Video select * from GoogleApiReportTemp.dbo.Api_Video where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.Api_Geographic  select * from GoogleApiReportTemp.dbo.Api_Geographic  where date between '2020-09-14' and '2020-09-15'

insert into GoogleApiReport.dbo.GA_accountperformancereport select * from GoogleApiReportTemp.dbo.GA_accountperformancereport where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.GA_CampaignPerformanceReport  select * from GoogleApiReportTemp.dbo.GA_CampaignPerformanceReport  where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.GA_AdgroupPerformanceReport  select * from GoogleApiReportTemp.dbo.GA_AdgroupPerformanceReport  where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.GA_AdPerformanceReport  select * from GoogleApiReportTemp.dbo.GA_AdPerformanceReport  where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.GA_KeywordsPerformanceReport select * from GoogleApiReportTemp.dbo.GA_KeywordsPerformanceReport where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.GA_SearchQueryPerformanceReport  select * from GoogleApiReportTemp.dbo.GA_SearchQueryPerformanceReport  where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.GA_VideoPerformanceReport   select * from GoogleApiReportTemp.dbo.GA_VideoPerformanceReport   where date between '2020-09-14' and '2020-09-15'
insert into GoogleApiReport.dbo.GA_GeoPerformanceReport    select * from GoogleApiReportTemp.dbo.GA_GeoPerformanceReport    where date between '2020-09-14' and '2020-09-15'


delete from GoogleApiReport.dbo.Api_CustomerDetail where date between '2020-09-21' and '2020-09-26'
delete from GoogleApiReport.dbo.Api_Campaign where date between '2020-09-21' and '2020-09-26'
delete from GoogleApiReport.dbo.Api_Adgroup where date between '2020-09-21' and '2020-09-26'
delete from GoogleApiReport.dbo.Api_AdgroupAd where date between '2020-09-21' and '2020-09-26'
delete from GoogleApiReport.dbo.Api_KeyWord where date between '2020-09-21' and '2020-09-26'
delete from GoogleApiReport.dbo.Api_Searchterm where date between '2020-09-21' and '2020-09-26'
delete from GoogleApiReport.dbo.Api_Video where date between '2020-09-21' and '2020-09-26'
delete from GoogleApiReport.dbo.Api_Geographic where date between '2020-09-21' and '2020-09-26'

delete from  GoogleApiReport.dbo.GA_accountperformancereport where date between '2020-09-21' and '2020-09-26'
delete from  GoogleApiReport.dbo.GA_CampaignPerformanceReport where date between '2020-09-21' and '2020-09-26'
delete from  GoogleApiReport.dbo.GA_AdgroupPerformanceReport where date between '2020-09-21' and '2020-09-26'
delete from  GoogleApiReport.dbo.GA_AdPerformanceReport where date between '2020-09-21' and '2020-09-26'
delete from  GoogleApiReport.dbo.GA_KeywordsPerformanceReport  where date between '2020-09-21' and '2020-09-26'
delete from  GoogleApiReport.dbo.GA_SearchQueryPerformanceReport where date between '2020-09-21' and '2020-09-26'
delete from  GoogleApiReport.dbo.GA_VideoPerformanceReport   where date between '2020-09-21' and '2020-09-26'