University > Looker Studio Course > How to > How to historicize Post data for organic social media connectors?

How to historicize Post data for organic social media connectors?

You are creating a Looker Studio report to analyze your post on TikTok or LinkedIn, but when you try to modify the period, the data does not change.

It is normal behavior! Posts on social media are not historicized.

But we have a solution to "fake" by extracting data to a Google Sheet with the "Post Created Date" and linking this Google Sheet to Looker Studio.

This is what we will cover here.

Extract your data on Google Sheet :

First, follow this link to get our Google Sheets Add-on and install it.

In a new sheet, go to Extensions -> Catchr - data connector -> Launch.

(If the Catchr menu does not appear in Extensions, close it, wait a few seconds, and re-open it.)

We will now create the request to bring your data into Looker Studio:

Click on Add new.
Select your platform (click on the platform name to select it. Click on the + to add a new platform on Catchr.
Select your account.
Select your metrics related to the post.
Select your dimensions. For TikTok, you should at least get the Created Time and Title (don't take the Cover Image; TikTok dynamically changes the link, which will mess with the automatic import). For LinkedIn, you should get the Post Created Date and Post Title.
Select a time range (it does not matter what you choose. The system will try to get all the posts).
Skip the filter selector.
Select the two options: Combine and update rows and Format date for Looker Studio. The first one will update the metrics of every post. The second one will format the date so Looker Studio can understand it.
Add a schedule to automatically run this request daily (so you do not have to return and launch it to update your data).

[optimize output image] — Configure your request on Google Sheets.

‍

check that you selected the A1 cell and click on Get Data.
Depending on your number of posts, displaying the table can take a few minutes.
Once done, it should look like this (for example, with a TikTok account).

Post data imported from TiktTok on Google Sheets

Now, we must go to Looker Studio to link Google Sheets and Looker.

Create your Looker Studio report:

Create your Google Sheets data source:

From the Looker Studio home page:

Click on Create -> Data Source
In the connector list, pick the Google Sheets connector.
Select your Google Sheets and sheet. Do not change the options.
Click on Connect.

Create a Google Sheets data source on Looker Studio

‍

You created your data source. If everything went fine, your field Created Time or Post Created Date is on type Date.

Create your report:

Click Create Report at the top right to create a new report associated with this data source.

We will now create a table with our Posts data and add a date control field to display only posts posted during the selected period:

Click on Add a chart.
Select Table, and place it on the canvas.
In dimensions, Select Created Date and Title for TikTok or Post Created Date and Post Title for LinkedIn.
In metrics, add the post metrics you selected.
In Date Range Dimensions, select Created Time or Post Created Date (this is the crucial step; if not filled, the date selector won't work on the table).

Now add a date selector:

Click on Add a control.
Select Date Range Control and place it in the canvas.

Create a table and a date selector and use it on Looker!

‍

Try it! Your table should vary depending on the period selected.

Do not hesitate to ask for our help on the chat. We will answer and help you!

Quick-step to histroicize social media Post on Looker Studio:

Import data into Looker Studio with the post-created date information.
Create a Google Sheets data source in Looker Studio with your new Google Sheets.
Create your table and put the post-created date field in the Date Range Dimensions area.

More function to use with Looker Studio

SECOND

Mastering the SECOND Function in Looker Studio: Extraction, Usage, Examples, and Limitations

REGEXP_REPLACE

Mastering the Advanced REGEXP_REPLACE Function in Looker Studio for Effective Data Transformation and Cleanup

COUNT_DISTINCT

Looker Studio function : COUNT_DISTINCT

MAX

Mastering the Use of MAX Function in Looker Studio for Enhanced Business Data Analysis and Insights

DATETIME

Understanding the DATETIME Function in Looker Studio: Syntax, Functionality, and Essential Tips

Become a Looker Studio expert
for free

Learn all the secrets of data analysis and create beautiful and effective dashboards thanks to our 30-second video courses! Join Catchr's community on YouTube.

Get more video lessons

All your data on Looker Studio

Build Looker Studio dashboard easily with your marketing data from all platforms and track your essential KPIs! No-code integration.

Start free trial now!

Optimize your data analysis

Get free Looker Studio dashboard template among a large collection of +50 stunning template! Elevate your data visualization.

Get free templates!

Johan Chemin

Customer Success Manager & Looker Studio Expert

I design powerful dashboards that enable you to effectively analyze your marketing data. I also provide comprehensive lessons on mastering your BI tools. Feel free to contact me for assistance with these areas.

How to historicize Post data for organic social media connectors?

Extract your data on Google Sheet :

Create your Looker Studio report:

Quick-step to histroicize social media Post on Looker Studio:

More function to use with Looker Studio

Product
‍

Ressources
‍

Company
‍

Template
‍

Templates Categories

Integrations
‍

How to historicize Post data for organic social media connectors?

Extract your data on Google Sheet :

Create your Looker Studio report:

Quick-step to histroicize social media Post on Looker Studio:

More function to use with Looker Studio

Product‍

Ressources‍

Company‍

Template‍

Templates Categories

Integrations‍

Product
‍

Ressources
‍

Company
‍

Template
‍

Integrations
‍