function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
hechtichechtic 

Best practices for importing daily data - Fields or Lists or ?

I am trying to import google analytics data (date, page views, visitors) on a daily basis, and want past data available for reporting / dashboards (kind of like historical invoices).

 

What are the best practices around doing this?

 

I created a custom object and custom fields, but it seems like that will be overwritten daily, and won't give me a nicely formatted excel-style list with columns.

 

Is there a way to create a custom related list, or should I create custom fields within the activity lists and use those?

 

My longer term plan is to have a number of different custom metrics, imported daily, so I want to start off correctly.

 

thanks in advance.

kevoharakevohara

What I would do is create a custom object with fields for the data elements you want to track.  It sounds like you have already done this.  Then I would simply create a new record on that object for each day.  That way you can have list views and create trending reports.

 

You could also use scheduled Apex to call the Google Analytics web service on a shedule to retrieve the data you need on a daily basis.