Possible fields for date_present

#1

Hello all,

i use windsor.ai to import Bing Ads into Power BI. I have a question concerning the date_present field in the URL:

https://connectors.windsor.ai/bing?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv

I would like to load all dates from 01.01.2020 until today in a dynamic way.

date_preset=last_2years is possible but there is no date_preset=last_3years. I could say &date_from=2020-01-01 but that is not dynamic. After 10 years i would import all dates from 10 years.

How could I solve that problem in the URL? Is it maybe possible to say TODAY - last_3years for the date_present field?

Many thanks.

Best Regards.

#2

You could try to
https://connectors.windsor.ai/bing?api_key=[your API key]&date_from=2020-01-01&date_to=2024-01-01&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv
This should solve your problem.

#3

@matt But that is not dynamic. After 2024-01-01 i would see no data.

#4

Now it should also work to just use https://connectors.windsor.ai/bing?api_key=[your API key]&date_from=2020-01-01&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv