Skip to content

Certifications Help

All the help for your certification.

  • Google Ads Certifications
    • Google Ads Display Certification
    • Google Ads Video Certification
    • Google Ads Search Certification
    • Google Shopping Certification
    • Google Ads – Measurement Certification
    • Google Ads Apps Assessment Answers
    • Google Ads Fundamentals Certification
  • Google Analytics
    • Advanced Google Analytics
    • Google Analytics 360
    • Google Analytics Individual Qualification
    • Analytics for Power Users
    • Introduction to Data Studio
    • Google Tag Manager Fundamentals
  • Hootsuite
    • Hootsuite Platform
    • Hootsuite Social Marketing
  • SEMrush
    • Competitor Analysis With SEMrush Exam
    • SEMrush Advertising Toolkit
    • SEMrush Affiliate Program Terms
    • SEMrush Content Marketing Toolkit
    • SEMrush for Digital Agencies Certification
    • SEMrush Keyword Research
    • SEMrush On Page and Technical SEO
    • SEMrush PPC Fundamentals
    • SEMrush SEO Toolkit
    • SEMrush Social Media Toolkit
    • Backlink Management Exam
    • Advanced Competitive Research
    • Competitor Analysis With SEMrush Exam
    • Management-Reporting And Collaboration Test
    • Mobile-International- And Local SEO Test
    • Content Marketing Fundamentals
  • HubSpot
    • HubSpot CMS for Developers Certification
    • HubSpot Frictionless Sales Certification
    • HubSpot Marketing Software Certification
    • HubSpot Sales Management Training: Strategies for Developing a Successful Modern Sales Team Certification
    • HubSpot Sales Software Certification
    • HubSpot Service Hub Software Certification
    • Inbound Certification
    • Inbound Marketing Certification
    • Inbound Sales Certification
    • Email Marketing Certification
    • Social Media Certification
    • Content Marketing Certification
    • Sales Enablement Certification
    • Inbound Sales Certification
    • Growth-Driven Design Certification
  • Other
    • Bing Accreditation Exam
    • Twitter Video Ad Badge Assessment
    • Yandex
      • Yandex Direct
      • Yandex Metrica
    • Jamboards
      • Deploying Jamboards Assessment
      • Selling Jamboards Assessment
    • Klipfolio
      • Klipfolio Expert
      • Klipfolio Partner
    • Academy Ads
      • Android
        • Android Enterprise Associate
        • Android Enterprise Professional
      • Google Marketing Platform
        • Campaign Manager Certification
        • Creative Certification
        • Display & Video 360
        • Search Ads 360
      • Google My Business Basics
      • Waze
        • Waze Ads Advanced Assessment
        • Waze Ads Fundamentals Assessment
      • Youtube
        • YouTube Asset Monetization
        • YouTube Channel Growth
        • YouTube Content Ownership
        • YouTube Creative Essentials
        • YouTube Music Assessment
      • Other Certification
        • DoubleClick Billing Basics Assessment
        • DoubleClick Campaign Manager Assessment
        • DoubleClick Search Campaign Management Assessment
        • Doubleclick Studio Assessment
        • Mobile in DoubleClick Bid Manager Basics Assessment
        • Optimize performance in DoubleClick Search Assessment
        • Bid Manager Optimization Assessment
        • Scaled Partner Management Exam
    • Google Educator
      • Google Educator Level 1
      • Google Educator Level 2
  • Digital
    • Digital Garage Final Exam
    • Digital Garage Quiz
    • Digital Sales Certification
  • Google Smart
    • Measurement – Smart Assessment
    • Performance – Smart Assessment
    • Platforms – Smart Assessment
    • Video – Smart Assessment

Klipfolio Partner

  • If a Klipfolio partner wants to build a template Facebook dashboard, import to his client accounts and have it show their specific Facebook data, is this the correct order of operations for the import procedure? 1.Create the custom company properties first 2.Set their valid values 3.Import the dashboard
  • True or False? Klipfolio only offers dedicated Connectors (ie., for Google Analytics, Salesforce, Twitter, etc.) for services included in the Klip Gallery.
  • Consider the following screen grab. The output format of the date pickers are set to Unix format. How can you use the filter actions to filter the bar/line chart?
  • Which of the following statements are true? Select ALL that apply.
  • Which of the following statements are true regarding data sources in Klipfolio? Select ALL that apply.
  • Consider the following scenario. A user can change the default start day of the week when using DATE_STARTOF function when the unit parameter chosen is “day of week” or “week”.
  • Which non-date functions could be used to find dates in a given date range?
  • Which one of the following are not considered a best practice?
  • Consider the following scenario. You’re building a table component showing dates in the current month in column 1 and corresponding sessions for each day in column 2 (from web traffic data from Google Analytics). In your Google Analytics datasource, you also have the channel grouping for your sessions (per day) and you wish to only show data coming from organic sources. However, you do not wish to have a visible column in your table that shows the channel grouping. How would you use filter actions to show only dates and sessions corresponding to organic traffic in your table? Select the best practice option.
  • Which of the following date formats can be sorted in a chronological order?
  • You’ve written MAPFLAT function as follows to paginate 10 pages of a dynamic datasource: MAPFLAT( CUMULATIVE(REPEAT(1,10)), “api_page_no”, @A:A). The api query that returns @A:A correpsonds to https://somebaseurl.com/endpoint?parameter1=value1¶meter2=value2 &page={props.api_page_no}. From this api’s documentation, you find out that page number in the query must be of the format “page=1” NOT “page=1.0”. What function is missing within your formula to ensure it executes the pagination correctly?
  • DJ The Tassmanian is working on a Klip that lists his upcoming shows with a dynamic datasource and sees the following message: “A problem occurred while loading the datasource. Please try reloading the page.” He suspects that there is a bad dynamic datasource instance causing this error message. What is the process he should take to verify this?
  • Elvira has a Klip which is utilizing a variable; however, it does not display on the dashboard. What is the most likely cause of this?
  • All of Klipfolio’s Date/Time functions return the results in dd/MM/yyyy format by default.
  • For the following label component: with these properties: What would formulas X and Y give you? X:!Label Y:&Label
  • Abdul has built a pie chart Klip which shows the number of sessions per Google Analytics channel. He wants to only show the channels which have more than 100 sessions in the pie chart. Abdul can achieve this using filter actions as follows: select the filter option for the values component of the pie chart; if a group action is applied to the labels, make sure the values have the correction aggregation method; set a condition filter to select values that are greater than 100 and check to see that the values in view option is selected.
  • True or False? Once a variable is saved it becomes available to everyone in the Klipfolio Account?
  • The DATERANGE function can be used to populate an X-axis with all the dates between a given start and an end date.
  • True or False? It is better to hard code dates instead of using relative date range expressions?
  • If you want to change the data in a Klip based on a variable then the variable needs to be in which parameter of the SWITCH function?
  • Which of the following general statements are true? Select ALL that apply.
  • Which of the following formulas is the best option for SUM’ing a set of values held in Column A of multiple Dynamic Data Source instances? NOTE: The possible values for the Dynamic property is in Column B of a 2nd data source.
  • Keely has five Klips in dashboard 1 and wants to move three of them to dashboard 2. She can drag and drop the three Klips from dashboard 1 to dashboard 2.
  • Which of the following are types of user input controls? Select ALL that apply.
  • Formulas referenced by !REF are fully recalculated; therefore, no performance saving is gained when using !REF.
  • What is the default aggregation method for the third parameter of GROUPBY() function?
  • Which of the following are legitimate ways to share a Klipfolio Dashboard? Select ALL that apply.
  • Shima is creating a Klip and wants to have a dynamic datasource whose query is identical to an existing static datasource. She should not change the parameters of the existing static datasource to dynamic ones or duplicate the static datasource and replace the parameter values with variables (i.e. {props.}). Instead, she should create a brand new dynamic datasource.
  • Kalyani is the owner of a start-up interior design firm and she likes to keep track of her home accessory purchases using Excel. She has built a Klip with a table component to show her most recent home accessory purchases, and wants this Klip to refresh as she updates her Excel file. Where can Kalyani store her file such that it refreshes automatically within Klipfolio and updates her Klip?
  • Consider the following scenario: You have a table Klip where column 1 has the following data ARRAY(“b,a,a,a,b,b,b,c,c”) with a group action applied. What will you see if you make a formula reference (!column 1) and a results reference (&column 1) to column 1?
  • Josephine from accounting is writing a formula using the SELECT( ) function. She wants to select payroll data to match the following conditions: the paydates must fall within the current year and the employee type must be equal to full time. However, it is only possible to have one condition in the SELECT( ) function.
  • Igor created a multi-component Klip yesterday, which contained 3 gauges and 1 table. Today, he removed the table component from the Klip but after reviewing it, he wants to revert to the original version of the Klip. Igor can revert back to a previously saved version of the Kilp by going to the “View Recent Revisions” options from the drop-down menu on the top right corner of the Klip editor.
  • Consider the following array of data: ARRAY(“Apple”,”Orange”,”EggPlant”,”Apple”,”Zucchini”,”Carrot”,”Orange” ,”EggPlant”,”Kale”,”Bananas”). What function would you use to replace “EggPlant” with “Brinjal” AND “Kale” with “SomeGreenThing”?
  • True or False? Changing the scope of a variable from a smaller scope to a larger scope requires that you take several steps including removing, and then re-adding, the dashboard in question.
  • Consider the following scenario: Tass is creating a dynamic datasource where he needs to pass variable values to “start-date” and “end-date” parameters of the query. He can pass the variable values under the “Query Parameters” section of the connector as follows:
  • Given the following datasource of reservations, …we want to create a table with column A being the name, and column B being the number of tables. However, sometimes the name is missing for the reservation, and we need to make sure that column A is not misaligned to column B. What formula would we use to do this?
  • When deleting a dashboard in Klipfolio, which of the following statements are true?
  • True or False? You can apply multiple filtering conditions to a component using hidden data.
  • What is the correct syntax for putting a variable inside of a datasource query? (ie: a dynamic datasource)
  • Meggan’s ad agency has a Klipfolio partner account, which has 20 client accounts under it. In the parent account, Group A consists of users who can access the client selection and sign into a client as admin. An admin of Meggan’s ad agency can set sharing settings such that Group A users can only see 10 clients under the client selection.
  • Adam has an Excel datasource set up in his Klipfolio account. Column 1 of the datasource contains the names of new customers in the past month and Adam suspects that the entries of this column have leading and trailing blanks. What is the best function that Adam should use to remove the leading and trailing blanks?
  • In the data source shown below (which is a JSON data source), is “inferredCountry” a ​following-sibling​, or a ​preceding-sibling​to “timestampCustomer”?
  • How do you define a variable in the second parameter of a MAP/MAPFLAT function?
  • You can pass the timezone as a parameter to the NOW( ) function.
  • Which of the following statements accurately describes the Klip Editor?
  • Consider the following: You have a JSON datasource and you wish to select a node which has a number as a name. You can accomplish this by either using * in place of the number in the xpath to get all the contents of the node or using /*[name(.)=’number’] in place of the number in the xpath to get the data under a specific node.
  • Consider the following scenario: You’re the owner of a paint shop and you’re making a Klip that has a table showing the number of one-gallon paint cans customers have purchased. You want to show the 10 customers that purchased the most of amount of paint cans. If you use the “Top” filter action on the column showing the number of paint cans, you need to apply the sort action first.
  • You have a table Klip set up and want to remove the header row of your data. You can do this by using the “Exclude” feature of the filter action on one column and SLICE function in the other column.
  • Which of the following “units” of time can be included in the DATE_STARTOF function? Select ALL that apply.
  • Dylan is using a big screen tv to display 10 dashboards in his Klipfolio account. He wants to have more time to review a dashboard before it switches to the next one. He can achieve this by changing the dashboard switching option under his account settings.
  • Keely is building a bar/line chart with dates in the X-axis, the input format of the dates is yyyy-MM-dd and Keely has set the output format to MMM dd, yy. If she uses a results reference to the X-axis in another component, it will show dates in yyyy-MM-dd format.
  • True or False: Full Screen Mode in Klipfolio allows you to automatically cycle through specific dashboards at a time interval that you choose.
  • You wish to refer to the “All” option from the user input control in a formula. What is the correct syntax that should be used in this case?
  • An admin of an account has access to the authentication tokens of all users, whether they were shared or not.
  • Rupert has a 12 MB Excel file that he wants to upload to Klipfolio. He can do this by using the Klipfolio API.
  • What are some constructs you can use to help solve the issue where the JSON data source does not have values for all elements and therefore the data does not line up correctly in the Klip? Select ALL that apply.
  • Match the Klipfolio Date and Time Functions below with the common use case where you would use them.
  • True or False? Bar/Line Charts cannot show negative values.

Search Question

Latest Updated

  • Sylvia Wants To Create A My Google Business Account For Her 3 Retail Locations. How Can Sylvia Verify Each Location In Google My Business?
  • When Measuring Offline Conversions With TrueView For Action, A Store Visit Is Counted When A User Watches 10 Seconds Of An Ad And Then Visits A Store Within How Many Days?
  • How Do Shopping Ads Help Improve The Quality Of Leads Over Standard Text Ads?
  • Google Ads Follow The Media Rating Council’s Standards For Viewability. What’s Required For An Ad To Be Counted As A Viewable Impression?
  • YouTube And Google Video Solutions Are Specifically Tuned To Your Business’ Marketing Objectives. They Can Increase Awareness By Keeping Your Brand At The Top Of Customers’ Minds. They Can Boost Consideration By Inviting Customers To Engage With Your Brand During High-Intent Moments. What Other Marketing Objective Can YouTube And Google Video Solutions Fulfill?
© 2020 Certifications Help