Skip to main content

Hi all,

I set up a BigQuery connection to ingest custom event data into our Amplitude project. I can see the ingestion is running correctly, and the event counts on the BQ Connection show the expected number of events (19k for 8/29/2023):
 

 

However, when building a segmentation chart for the same event, the count for event totals is much lower:
 

 

Is this a configuration issue somewhere? I would expect the event totals in my segmentation chart to match the number of ingested events by day in the BQ connection screen. TIA for any assists!

Hi @Lane Perry 

Depending on your ingestion configuration, it could be the case that for a given day ingestion takes place for not only the events which occurred on that calendar day, but also previous days. e.g it looks like Aug 18th ingested all your events from the previous days ( ingestion count for Aug 1 - Aug 17 seems to be zero ). Similar thing could have occurred for Aug 29th. You can try verifying this by looking at some raw events in Amplitude and comparing their server upload time and client event time.

Reply


Terms & ConditionsCookie settings