how should I know about the amount of data?

[Anonymous]

hi all,

I would like to make a chart show how many keywords per campaign. 

also the keywords performance by campaign

i am currently work in digital ads company.

Campaign	impressions	clicks	ctr	cost
A	100000	100	1%	100
B	100000	100	1%	100
C	100000	100	1%	100
D	100000	100	1%	100
E	100000	100	1%	100

Campaign	Ads group	keywords	impressions	clicks	ctr	cost
A	A1	133	5000	50	1%	50
A	A1	223	5000	50	1%	50
A	A2	1234	5000	50	1%	50
A	A2	5234	5000	50	1%	50
B	B3	54634	5000	50	1%	50
B	B3	23313	5000	50	1%	50
B	B3	454	5000	50	1%	50

[amitchandak]

@Anonymous , Not very clear. The first table can act Master. As long as the campaign is unique there. 

[parry2k]

@Anonymous can you explain what you are trying to achieve?

[Anonymous]

i would to analysis how many keywords is in the campaign A and campaign B.

Also, i would like to analysis how is the performance of keywords in the campaign A only

[dax]

Hi @Anonymous ,

You could set relationship between two tables, then design chart like below

If you want to see only company A, you could set [Campaign] in Filter.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

May i know how can i analysis the keywords data in Campaign A. For example, the impression and clicks of those keywords in campaign A.

[amitchandak]

If first one is master take campaign name from there or from the second table in a visual

count(Table2[keywords]) or distinctcount(Table2[keywords])

You can use slicer to visual level filter or filter in Calculation.