tiktok面经 | tiktok vo | tiktok DS | tiktok一亩三分地 | Tiktok SDE

tiktok面经

最近的tiktok面经,我们一起来看看近期的tiktok面试真题吧,这次的真题讲解课堂来啦。

Welcome, everyone. Today’s agenda involves exploring a comprehensive dataset related to advertiser activities. We will begin by dissecting its composition before discussing each question that arises from it in detail

TABLE STRUCTURE

At TTAMWAM we maintain a table named ttam_logger for recording events associated with ad creation. Below are the columns with their descriptions:

  1. date: The date of the event, used for data partitioning.
  2. timestamp: The precise time when the event occurred.
  3. advertiser_id: A unique identifier assigned to each advertiser.
  4. event: Describes the type of event (e.g., enter, next, back, submit).
  5. page: Indicates the specific page where the event occurred (e.g., objective, adgroup, creative).

SAMPLE DATA

The table like this:

table

QUESTIONS AND ANALYSIS

Q1: How many submissions were made on January 1st, 2022?

  • To determine this, we’ll filter the data for entries dated 20220101 with the event labeled ‘submit,’ and then tally the number of such occurrences.

Q2: To determine this, we’ll filter the data for entries dated 20220101 with the event labeled ‘submit,’ and then tally the number of such occurrences.?

  • First, determine the total number of submit events recorded during the week.
  • Next, calculate the total number of unique sessions, considering each unique combination of advertiser_id and date.
  • The submit rate is then computed as the ratio of submit events to the total number of unique sessions.

Q3: How many advertisers who submitted this week (20220108 ~ 20220114) also submitted last week (20220101 ~ 20220107)?

  • We compile lists of advertisers who submitted during the first and second weeks respectively, then identify the common entries between these two lists.

Q4: How much time did an advertiser spend on the website on a given day?

  • We calculate the time difference between the first and last event timestamps for each advertiser daily..

Let’s break these down step-by-step:

Q1: TOTAL NUMBER OF SUBMITS ON 20220101

To address this, a straightforward SQL query can be employed:

solved sql

This will provide you with the number of submit events occurring on the specified date..

Q2: OVERALL SUBMIT RATE FOR THE WEEK OF 20220108 ~ 20220114

First, we should find the count of submits in the week,So we can write the follow sql:

solved sql

Then, Determine the count of distinct sessions, where each session represents a unique combination of advertiser_id and date:

solved sql

Determine the submit rate by dividing the number of submits by the number of sessions.

Q3: ADVERTISERS WHO SUBMITTED IN BOTH WEEKS

To start, locate the list of advertisers who submitted in the initial week.:

solved sql

Next, find the list for the second week:

second week sql

Lastly, determine the intersection of these two lists:

sql

Q4: TIME SPENT ON THE WEBSITE ON A GIVEN DAY

For every advertiser per day, determine the earliest and latest timestamps.:

sql

Afterwards, calculate the time interval between the first and last event for each advertiser daily. The exact approach may differ based on your SQL environment and can be detailed in a later step.

By following these procedures, you’ll accurately address each question. If you have more questions or need clarification, please feel free to ask!

After availing our interview assistance service, the candidate cleared this round of interviews successfully. We eagerly anticipate tackling the next set of interview questions with you!

If you’re interested in our services, please feel free to reach out to us anytime for a consultation.

If you need our help with TikTok’s OA, please feel free to contact us.

经过我们的Tiktok面试辅助服务,候选人顺利通过了本轮面试,我们一起期待下一次的面试题目吧~

如果您对我们的服务感兴趣,随时留言咨询我们。

author avatar
azn7u2@163.com

Leave a Reply

Your email address will not be published. Required fields are marked *