Facebook Ads Insights Time Increment Issue

Data Productivity Cloud
1

Hi All,

 

I'm trying to send my Facebook ads insight data to BigQuery using Matillion Data Loader.

However, it seems something is wrong with the time increment. I'm trying to send "Last 3 days" of Facebook ad action data separately.

 

For example, since today is January 11th, I want 3 separate data as follows:

start-date: 2023-01-09, end-date: 2023-01-09

start-date: 2023-01-10, end-date: 2023-01-10

start-date: 2023-01-11, end-date:2023-01-11

 

To achieve this, as you can see in the screenshot, the data preset is set to "Last 3 days" and the "Time Increment" is set to 1. but only start-date:2023-01-11, end-date:2023-01-11

is shown in BigQuery.

 

Also, If I set my data preset to yesterday, and the time increment to 1, it only shows 2023-01-11 date which is today not yesterday. Can someone please help? Thanks

2

Hi @sewoong​ and thanks for posting.

I have a couple of questions if that's okay? Could you confirm for me that you have the data from before the 11th? Could you also send the downloaded log of the finished pipeline to me too? You can send it via PM if you'd prefer. Once I can send this information back to the team they'll be able to take a further look.

Thanks so much,

Claire