Supermetrics Support Forum

Instagram followers

Hi, I am running several social media handles for clients and I would like to use Supermetrics to automate part of my reporting process.


Is there a way to automatically calculate the growth in the number of Instagram fans or can the simple connector only give me the number of fans at the time of the data pull?

______

I am using Google Data Studio to build the report. 


1 person likes this idea
  • Hi Mathieu,


    I don't know of a way to do this using just Supermetrics, but it should be possible using an Array Formula.  Let's say your daily followers is in column C, and you have headers for your data.  In cell D3, you can write the following.


    =ArrayFormula(IF(C3:C<>"",C3:C-C2:C,""))


    What this will do is check if the cell contains a value. If it does, it will minus the previous value from the current value to provide a delta. If the cell is blank, it will return a blank value.


    1 person likes this
Login to post a comment