Google Analytics - No State Filter

  • 46Views
  • Last Post 2 weeks ago
0
votes
Benjamin Tabares Jr posted this 3 weeks ago

Hi,

Is there a workaround to import only the recently inserted and/or updated records from Google Analytics?

Unlike other sources, there's no State Filter (i.e. Inserted, Updated) and it just duplicates the data to the destination.

 Thanks,

Benj

 

Order By: Standard | Newest | Votes
0
votes
Olena Romanchuk posted this 2 weeks ago

Hello Benjamin,

We recommend you to view the detailed description of our Google Analytics connector here

Google Analytics supports the filtering by date. Date field is treated specially in filters - you can either use it once with a between condition, or use >/>= and </<= operators once. But in this case you will need to update the filtering conditions manually.

As we can see you are importing the Google Analytics data to SQL Azure database. You can try to use Replication with Incremental updates for your use case. Skyvia queries changed data from Google Analytics by the Date field and in this case you can get the updated data every day.

Best regards,

Olena

Technical Support Engineer


 

0
votes
Benjamin Tabares Jr posted this 2 weeks ago

Thanks, Olena.

I'll try it on my end.

 

Regards,

Benj

 

0
votes
Olena Romanchuk posted this 2 weeks ago

Hello Benjamin,

Please inform us about the result and do not hesitate to contact us, in case of any questions.
We look forward to your reply.

Best regards,
Olena
Technical Support Engineer

Close