Tracking

Influencer

All influencer have to report regularly how their posting have performed. For that they have to send a screenshot of the post with the data. We are tracking:

• Date
• Campaign Source
• Topic
• Product-line
• Ambassador
• Followers/Fans at post_Date
• Channel
• Place
• Paid
• Non Paid
• Instagram Feed
• Instagram Story
• Other
• Costs
• Impressions / Page Views
• Reach / Page Visits
• Likes
• Comments
• Saves
• Clicks (Link)
• Video-Views
• Shares
• Replies
• Tap forward
• Tap back
• Skip
• Exit
• Sticker Taps to profile
• Link Material

Engagement Rate

• Avg. audience reach ratio

But since we don't have a connector for influencer data at the moment, we need to write the data into a table. To use the table:

• Open the template gallery https://docs.google.com/spreadsheets/u/0/?tgif=d&ftv=1.
• Scroll down to "Interactive".
• Click "PSL_Data_Ambassadors".
• Enjoy

This table can be used with the free google sheet connector with google data studio.

Pintrest

Pintrest automatically tracks. and safes the data. Those data can be connected to google data studio via supermetrics connectors or the socialbakers connector.

Socialbakers:

• Pintrest Metrics

Supermetrics:

• Organic Data Field Reference
• Public Data Field Reference

To define which connector works best for your client, you have to see, which one fits the individual requirements best.

Instagram

Instagram automatically tracks and safes the data. Those data can be connected to google data studio via supermetrics connectors or the socialbakers connector.

Socialbakers:

• Instagram Metrics

Supermetrics:

• Insights Data Field Reference
• Public Data Field Reference

Instagram Stories

Since the instagram story data is only available for 24h via the connectors, we need to write the data into a table. To use the table:

• Open the template gallery https://docs.google.com/spreadsheets/u/0/?tgif=d&ftv=1.
• Scroll down to "Interactive".
• Click "PSL_Data_IG-Stories".
• Enjoy

This table can be used with the free google sheet connector with google data studio.

Facebook

Facebook automatically tracks and safes the data. Those data can be connected to google data studio via supermetrics connectors or the socialbakers connector.

Socialbakers:

• Facebook Metrics

Supermetrics:

• Insights Data Field Reference
• Public Data Field Reference

Facebook Ad Manager

Facebook automatically tracks and safes the data. Those data can be connected to google data studio via supermetrics connectors or the socialbakers connector.

Socialbakers:

• Facebook Metrics

Supermetrics:

• Insights Data Field Reference
• Public Data Field Reference

YouTube

YouTube automatically tracks and safes the data. Those data can be connected to google data studio via the free connectors.

LinkedIn

To track Linkedin we use socialbakers. To connect Linkedin to google data studio we are also using the socialbakers connector. We got the following data tracked:

• Linkedin Metrics

Website

For website tracking, we are using Google Analytics 3 and 4 or Matomo. Please always create and integrate always a Google Analytics 3 and a Google Analytics 4 property for each app/website.

SEO/SEA

For SEO we are using SEMRush.

Amazon

Amazon automatically tracks:

• Date
• Views
• Sales
• Units
• Orders
• Sales/Orders
• Units/Orders
• Visitors
• Views/Visitors
• Sales/Visitors
• and many more ...

But since we don't have a connector for Amazon at the moment, we need to write the data into a table. To use the table:

• Open the template gallery https://docs.google.com/spreadsheets/u/0/?tgif=d&ftv=1.
• Scroll down to "Interactive".
• Click "PSL_Data_Amazon".
• Enjoy

This table can be used with the free google sheet connector with google data studio.

Link

To track a link to your website, you need either Google Analytics or Matomo. Than you create a link with all parameter needed for the tracking. Available are:

• Website URL, the full website URL (e.g. https://www.example.com).*
• Campaign Source, the referrer: (e.g. google, newsletter).*
• Campaign Medium, marketing medium: (e.g. cpc, banner, email).*
• Campgain Name, product, promo code, or slogan (e.g. spring_sale).*
• Campaign Term, identify the paid keywords.
• Campaign Content, use to differentiate ads.

*Those are medatory.

To generate the trackable link you can go to Google Campaign URL Builder for single URLs or use the table for more than one. To use the table:

1. Open the template gallery https://docs.google.com/spreadsheets/u/0/?tgif=d&ftv=1.
2. Scroll down to "Interactive".
3. Click "PSL_Data_Campaign-URL".
4. Enjoy

With the campaign-URL you can track single banners, CTAs in mailings, and so on. After you implemented those trackable links, you can see from with source exactly is your website traffic coming from. Which teaser within the e-mail was more convincing, had the most clicks.

Banner

See how to track a Link above.

E-Mail

If you want to track your e-mail performance you have to implement trackable links for the CTA within the e-mail content. For that see "Link" above. Most mailing provider only track:

• Date
• Subject
• Sent
• Delivered
• Bounce (Hard)
• Blocked Rate
• Bounce (Soft)
• Bounced Rate
• Openers (Total)
• Openers (Unique)
• Clicked
• Unique Clicked
• Unsubscribed
• Spam
• Spam Rate

But since we don't have a connector for the mailing provider at the moment, we need to write the data into a table. To use the table:

• Open the template gallery https://docs.google.com/spreadsheets/u/0/?tgif=d&ftv=1.
• Scroll down to "Interactive".
• Click "PSL_Data_Mailings".
• Enjoy

This table can be used with the free google sheet connector with google data studio.

What mailing tools are we using?

Name	Link
sendinblue	https://app.sendinblue.com/account/login
Mailjet	https://app.mailjet.com/
Hybris	Depends on client