Retrieve the list of publishers by video from the excel export

If you want to have an excel list with the list of publishers for each video, as well as the associated statistics, just follow these steps

1. Download the excel file : go to the "Statistics" tab of your administration (if you have live and VOD statistics, please choose "Live statistics" or "VOD statistics") then click on the "Export stats" button

   Open

   

2. Choose the desired data then a start and end date, then upload your file by clicking on "Export".

   Open

   

3. Open your file with excel. Each line corresponds to a different user who has seen a video. So if video A has been seen 5 times, by 3 different users, it will appear 3 times (and the sum of its "views" column will be 5).

4. Create a new column wherever you want in your excel sheet.

5. Locate the letter of the column where the metadata is located (here "T") and enter the following formula in the second row of your new column (of course, replace "T2" with the correct value; for example U2 if "metadata" is in column "U") :

   =GAUCHE(DROITE(T2;NBCAR(T2)+1-SI(ESTNUM(TROUVE("publisher_external_portal";T2));TROUVE("publisher_external_portal";T2);TROUVE("publisher_external_email";T2)));TROUVE(",";DROITE(T2;NBCAR(T2)+1-SI(ESTNUM(TROUVE("publisher_external_portal";T2));TROUVE("publisher_external_portal";T2);TROUVE("publisher_external_email";T2))))-1)

    

6. Double click on the bottom right corner of your cell to apply this formula to the bottom of the page

   Open

   

7. You will end up with a column containing the publisher's email.

   Open

   

Note: if the value starts with "publisher_external_email", it means that the administrator published it from the Momindum Cloud administration or from the Maker; if you see "publisher_external_portal", it means that the user published his video from the MyCorpTV portal