# Impression mining - report preparation

**URL:** <https://gov.indexcoop.com/t/impression-mining-report-preparation/3040>\
**Category:** Miscellaneous\
**Created:** [28 October 2021 00:56 UTC](https://gov.indexcoop.com/t/impression-mining-report-preparation/3040 "2021-10-28T00:56:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elmit](https://yyz1.discourse-cdn.com/flex027/user_avatar/gov.indexcoop.com/elmit/32/1222_2.png) [@Elmit](https://gov.indexcoop.com/u/Elmit)\
**Post date:** [28 October 2021 00:56 UTC](https://gov.indexcoop.com/t/impression-mining-report-preparation/3040/1 "2021-10-28T00:56:54Z")

</div>

I use Linux for all my desktops, notebooks, and servers. This way is also working for Mac.  
My Twitter account is “ELMIT”.

For all my Tweets I use the hashtag “#INDEX”.

1. [https://analytics.twitter.com/user/ELMIT/tweets](https://analytics.twitter.com/user/ELMIT/tweets)  
Go to tab Tweets, select Last 7 days from Monday to Sunday  
Click Export by tweet

2. open a terminal and type in:

```auto
head -n1 tweetxxxxx.csv > 1.csv
grep -i INDEX tweetxxxxx.csv >> 1.csv
wc 1.csv # because I am impatient to know how many tweets I did for Index
# the first number reveals the number of tweets for Index

```

1. open Libreoffice:

```auto
LibreOffice --calc 1.csv

```

1. go to the last data row and type in column D:

```auto
Total:

```

1. move the next column E:

```auto
sum(e2:eXX) replace XX with the previous line number

```

Remember that number, it is the number of impressions

1. save the file similar to the original filename from Twitter. I add “-filtered” before “.csv”

2. download the form from the discord channel impression-mining and fill it out, use the numbers of impressions we found in step 5. and the file name decided in step 6.